APPS.DDR_BASE_UTIL_PKG dependencies on DDR_E_SYND_CNSMPTN_DATA

Line 1415: INSERT INTO DDR_E_SYND_CNSMPTN_DATA

1411: BEGIN
1412:
1413: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
1414:
1415: INSERT INTO DDR_E_SYND_CNSMPTN_DATA
1416: (REC_ID, LOAD_ID, ERR_REASON,
1417: SRC_CD, PROD_KEY, MFG_ITM_HCHY_LVL,
1418: MFG_ITM_HCHY_CD, GEO_KEY, MKT_AREA_CD,MKT_AREA_TYP, RTL_ORG_HCHY_LVL,
1419: RTL_ORG_HCHY_CD, GEO_RGN_CD, GEO_SUB_RGN_CD, CHNL_TYP_CD,

Line 1519: FROM DDR_E_SYND_CNSMPTN_DATA

1515: NVL(GEO_RGN_CD,'RGN'), NVL(MFG_ITM_HCHY_LVL,'LVL'),
1516: NVL(MFG_ITM_HCHY_CD,'HCHY'), NVL(MKT_AREA_CD,'MKT'),NVL(MKT_AREA_TYP,'MKT_TYP'),
1517: NVL(RTL_ORG_HCHY_LVL,'ORG_LVL'), NVL(RTL_ORG_HCHY_CD,'ORG_HCHY'),
1518: PERIOD_END_DATE, NVL(RTL_ORG_CD,'ORG_CD'), NVL(AO_HCHY_CD,'AO_HCHY'),NVL(ACCT_CD,'ACCT_CD')
1519: FROM DDR_E_SYND_CNSMPTN_DATA
1520: GROUP BY
1521: MEASURE_SET, SRC_CD, NVL(PROD_KEY,'PROD'), NVL(GEO_KEY,'GEO'),
1522: NVL(CHNL_TYP_CD,'CHNL'), NVL(GEO_SUB_RGN_CD,'SUB'),
1523: NVL(GEO_RGN_CD,'RGN'), NVL(MFG_ITM_HCHY_LVL,'LVL'),

Line 1559: INSERT INTO ddr_e_synd_cnsmptn_data

1555:
1556: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
1557:
1558: FOR rec IN c1 LOOP --{
1559: INSERT INTO ddr_e_synd_cnsmptn_data
1560: (REC_ID, LOAD_ID, ERR_REASON, SRC_CD,
1561: RTL_ORG_HCHY_ID, RTL_ORG_HCHY_LVL, MFG_ITM_HCHY_ID,
1562: MFG_ITM_HCHY_LVL, MKT_AREA_ID, GEO_RGN_ID,
1563: GEO_SUB_RGN_ID, CHNL_TYP_CD, PERIOD_ID, TIME_HCHY_LVL,