APPS.POS_UPDATE_CAPACITY_PKG dependencies on PO_SUPPLIER_ITEM_CAPACITY

Line 866: insert into po_supplier_item_capacity

862:
863: x_progress:='b'||to_char(l_progress);
864: l_progress:=l_progress+1;
865: if(l_status='NEW') then
866: insert into po_supplier_item_capacity
867: (CAPACITY_ID,
868: ASL_ID,
869: USING_ORGANIZATION_ID,
870: FROM_DATE,

Line 879: po_supplier_item_capacity_s.nextval,

875: LAST_UPDATE_LOGIN,
876: CREATION_DATE,
877: CREATED_BY)
878: values (
879: po_supplier_item_capacity_s.nextval,
880: l_asl_id,
881: -1,
882: l_from_date,
883: l_to_date,

Line 891: DELETE from po_supplier_item_capacity

887: l_created_by,
888: sysdate,
889: l_created_by);
890: elsif(l_status='DEL') then
891: DELETE from po_supplier_item_capacity
892: WHERE
893: asl_id = l_asl_id AND capacity_id = l_capacity_id;
894: elsif(l_status='MOD') then
895: UPDATE po_supplier_item_capacity

Line 895: UPDATE po_supplier_item_capacity

891: DELETE from po_supplier_item_capacity
892: WHERE
893: asl_id = l_asl_id AND capacity_id = l_capacity_id;
894: elsif(l_status='MOD') then
895: UPDATE po_supplier_item_capacity
896: SET
897: FROM_DATE = l_from_date,
898: TO_DATE = l_to_date,
899: CAPACITY_PER_DAY = l_cap_per_day,