APPS.POS_UPDATE_CAPACITY_PKG dependencies on PO_SUPPLIER_ITEM_CAPACITY

Line 920: insert into po_supplier_item_capacity

916:
917: x_progress:='b'||to_char(l_progress);
918: l_progress:=l_progress+1;
919: if(l_status='NEW') then
920: insert into po_supplier_item_capacity
921: (CAPACITY_ID,
922: ASL_ID,
923: USING_ORGANIZATION_ID,
924: FROM_DATE,

Line 933: po_supplier_item_capacity_s.nextval,

929: LAST_UPDATE_LOGIN,
930: CREATION_DATE,
931: CREATED_BY)
932: values (
933: po_supplier_item_capacity_s.nextval,
934: l_asl_id,
935: -1,
936: l_from_date,
937: l_to_date,

Line 945: DELETE from po_supplier_item_capacity

941: l_created_by,
942: sysdate,
943: l_created_by);
944: elsif(l_status='DEL') then
945: DELETE from po_supplier_item_capacity
946: WHERE
947: asl_id = l_asl_id AND capacity_id = l_capacity_id;
948: elsif(l_status='MOD') then
949: UPDATE po_supplier_item_capacity

Line 949: UPDATE po_supplier_item_capacity

945: DELETE from po_supplier_item_capacity
946: WHERE
947: asl_id = l_asl_id AND capacity_id = l_capacity_id;
948: elsif(l_status='MOD') then
949: UPDATE po_supplier_item_capacity
950: SET
951: FROM_DATE = l_from_date,
952: TO_DATE = l_to_date,
953: CAPACITY_PER_DAY = l_cap_per_day,