APPS.DDR_BASE_UTIL_PKG dependencies on DDR_E_PRMTN_PLN

Line 115: INSERT INTO DDR_E_PRMTN_PLN

111: AS
112: v_load_id NUMBER := NVL(p_load_id, set_load_id);
113: BEGIN
114: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
115: INSERT INTO DDR_E_PRMTN_PLN
116: (REC_ID, LOAD_ID, ERR_REASON,RTL_BSNS_UNIT_CD,
117: PRMTN_TYP,
118: PRMTN_FROM_DT,
119: PRMTN_TO_DT,

Line 240: FROM DDR_E_PRMTN_PLN

236: PRMTN_TO_DT,
237: RTL_SKU_ITEM_NBR,
238: GLBL_ITEM_ID_TYP,
239: TRANS_DT, RTL_ORG_CD
240: FROM DDR_E_PRMTN_PLN
241: GROUP BY
242: GLBL_ITEM_ID,
243: RTL_BSNS_UNIT_CD,
244: PRMTN_TYP,

Line 1300: INSERT INTO ddr_e_prmtn_pln

1296:
1297: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
1298:
1299: FOR rec IN c1 LOOP --{
1300: INSERT INTO ddr_e_prmtn_pln
1301: (crncy_cd
1302: ,glbl_item_id
1303: ,glbl_item_id_typ
1304: ,itm_typ