OM – Defaulting Rules

CREATE OR REPLACE PACKAGE BODY XXOE_DEFAULT_PVT
AS
  FUNCTION GET_TAX_CODE_CZ(
      p_database_object_name IN VARCHAR2 ,
      p_attribute_code       IN VARCHAR2)
    RETURN VARCHAR2
  IS
    v_org_id    NUMBER:=mo_global.get_current_org_id;
    v_tax_code oe_order_lines_all.tax_code%TYPE;
    v_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
    v_lines_rec OE_AK_ORDER_LINES_V%ROWTYPE;
  BEGIN
    v_header_rec := ONT_HEADER_Def_Hdlr.g_record;
    v_lines_rec  := ONT_LINE_DEF_HDLR.g_record;
    -- Warunki
    -- Organizacja: XXX_ORG
    -- Typ ZS: XXX_ZS_TYPE
    -- Indeks: XXXX-1303-800
    IF (v_org_id  ='83' AND v_header_rec.ORDER_TYPE_ID='1028' AND v_lines_rec.inventory_item_id='3097893') THEN
      v_tax_code:='XXX_TAX';
      RETURN v_tax_code;
    END IF;
    RETURN NULL;
  EXCEPTION
  WHEN OTHERS THEN
    RETURN NULL;
  END GET_TAX_CODE_CZ;
END XXOE_DEFAULT_PVT;

create or replace PACKAGE BODY XXOE_DEFAULT_PVT AS FUNCTION GET_TAX_CODE_CZ( p_database_object_name IN VARCHAR2 , p_attribute_code IN VARCHAR2) RETURN VARCHAR2 IS v_org_id NUMBER:=mo_global.get_current_org_id; v_tax_code oe_order_lines_all.tax_code%type; v_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE; v_lines_rec OE_AK_ORDER_LINES_V%ROWTYPE; BEGIN v_header_rec := ONT_HEADER_Def_Hdlr.g_record; v_lines_rec := ONT_LINE_DEF_HDLR.g_record; -- Warunki -- Organizacja: XXX_ORG -- Typ ZS: XXX_ZS_TYPE -- Indeks: XXXX-1303-800 IF (v_org_id ='83' AND v_header_rec.ORDER_TYPE_ID='1028' AND v_lines_rec.inventory_item_id='3097893') THEN v_tax_code:='XXX_TAX'; RETURN v_tax_code; END IF; RETURN NULL; EXCEPTION WHEN OTHERS THEN RETURN NULL; END GET_TAX_CODE_CZ; END XXOE_DEFAULT_PVT;