APPS.CSP_EXCESS_PARTS_PVT dependencies on CSP_SUP_DEM_SUB_TEMP

Line 492: insert into csp_sup_dem_sub_temp(

488: l_item_id := Null;
489: End;
490:
491: if p_called_from = 'PART_STATUS' then
492: insert into csp_sup_dem_sub_temp(
493: inventory_item_id,
494: organization_id,
495: subinventory_code,
496: planning_parameters_id,

Line 585: insert into csp_sup_dem_sub_temp(

581: l_excess := nvl(l_total_onhand,0) - nvl(l_demand,0);
582:
583: if l_excess > 0 then
584: if p_called_from = 'PART_STATUS' then
585: insert into csp_sup_dem_sub_temp(
586: inventory_item_id,
587: organization_id,
588: subinventory_code,
589: planning_parameters_id,

Line 670: insert into csp_sup_dem_sub_temp(

666: l_excess := nvl(l_onhand,0) - nvl(l_demand,0);
667:
668: if nvl(l_excess,0) > 0 then
669: if p_called_from = 'PART_STATUS' then
670: insert into csp_sup_dem_sub_temp(
671: inventory_item_id,
672: organization_id,
673: subinventory_code,
674: planning_parameters_id,

Line 1051: insert into csp_sup_dem_sub_temp(

1047: begin
1048:
1049: for d in defectives loop
1050: if p_called_from = 'PART_STATUS' then
1051: insert into csp_sup_dem_sub_temp(
1052: inventory_item_id,
1053: organization_id,
1054: subinventory_code,
1055: planning_parameters_id,