APPS.MSD_SALES_OPERATION_PLAN dependencies on MSD_SOP_COLLAPSED_BOM_COMP

Line 1612: delete msd_sop_collapsed_bom_comp

1608: --RETURN;
1609: END;
1610: */
1611: LOG_MESSAGE('Deleting the Collapsed BOM Data from table MSD_SOP_COLLAPESD_BOM_COMP');
1612: delete msd_sop_collapsed_bom_comp
1613: where demand_plan_id = p_demand_plan_id; --where sop_plan_id = p_demand_plan_id;
1614:
1615:
1616: lb_instance_id := NULL;

Line 1649: INSERT INTO msd_sop_collapsed_bom_comp

1645:
1646: if c_collapsed_bom%ROWCOUNT > 0 then
1647:
1648: FORALL j IN lb_instance_id.FIRST..lb_instance_id.LAST
1649: INSERT INTO msd_sop_collapsed_bom_comp
1650: ( SR_INSTANCE_ID,
1651: DEMAND_PLAN_ID, --SOP_PLAN_ID,
1652: SR_ASSEMBLY_PK,
1653: SR_COMPONENT_PK,

Line 2244: delete msd_sop_collapsed_bom_comp

2240: LOG_MESSAGE('***********************************************************************');
2241:
2242:
2243: LOG_MESSAGE('Deleting the Collapsed BOM Data from table MSD_SOP_COLLAPESD_BOM_COMP');
2244: delete msd_sop_collapsed_bom_comp
2245: where demand_plan_id = p_demand_plan_id;
2246:
2247:
2248: lb_instance_id := NULL;

Line 2280: INSERT INTO msd_sop_collapsed_bom_comp

2276:
2277: if c_collapsed_bom%ROWCOUNT > 0 then
2278:
2279: FORALL j IN lb_instance_id.FIRST..lb_instance_id.LAST
2280: INSERT INTO msd_sop_collapsed_bom_comp
2281: ( SR_INSTANCE_ID,
2282: DEMAND_PLAN_ID,
2283: SR_ASSEMBLY_PK,
2284: SR_COMPONENT_PK,