APPS.DDR_EMD_UTIL dependencies on DDR_B_RTL_SL_ADDTNL_MSRS

Line 537: EXECUTE IMMEDIATE 'TRUNCATE TABLE ddr.ddr_b_rtl_sl_addtnl_msrs';

533: x_return_status := NULL;
534: -- Truncate the table
535: IF p_complete_refresh THEN --{
536: IF v_user = 'APPS' THEN --{
537: EXECUTE IMMEDIATE 'TRUNCATE TABLE ddr.ddr_b_rtl_sl_addtnl_msrs';
538: ELSE
539: EXECUTE IMMEDIATE 'TRUNCATE TABLE ddr_b_rtl_sl_addtnl_msrs';
540: END IF; --}
541: END IF; --}

Line 539: EXECUTE IMMEDIATE 'TRUNCATE TABLE ddr_b_rtl_sl_addtnl_msrs';

535: IF p_complete_refresh THEN --{
536: IF v_user = 'APPS' THEN --{
537: EXECUTE IMMEDIATE 'TRUNCATE TABLE ddr.ddr_b_rtl_sl_addtnl_msrs';
538: ELSE
539: EXECUTE IMMEDIATE 'TRUNCATE TABLE ddr_b_rtl_sl_addtnl_msrs';
540: END IF; --}
541: END IF; --}
542:
543: -- Start processing sales records

Line 791: INSERT INTO ddr_b_rtl_sl_addtnl_msrs(rtl_org_cd

787: -- Populate measure10 --}
788:
789: IF MOD(v_rec_count,ddr_emd_util.c_batch_size) = 0 THEN --{
790: FORALL i IN 1..v_rec_count
791: INSERT INTO ddr_b_rtl_sl_addtnl_msrs(rtl_org_cd
792: ,org_bsns_unit_id
793: ,mfg_sku_item_id
794: ,rtl_sku_item_id
795: ,day_cd

Line 848: INSERT INTO ddr_b_rtl_sl_addtnl_msrs(rtl_org_cd

844:
845: --CLOSE sales_records;
846:
847: FORALL i IN 1..v_rec_count
848: INSERT INTO ddr_b_rtl_sl_addtnl_msrs(rtl_org_cd
849: ,org_bsns_unit_id
850: ,mfg_sku_item_id
851: ,rtl_sku_item_id
852: ,day_cd