APPS.POS_ASL_CAPACITY_PKG dependencies on PO_SUPPLIER_ITEM_CAPACITY

Line 818: update po_supplier_item_capacity

814: if not (l_from_date is null and l_to_date is null and
815: l_capacity_per_day is null) then
816:
817: if ((l_capacity_id <> -1) and (l_from_date is not null)) then
818: update po_supplier_item_capacity
819: set from_date = l_from_date,
820: to_date = l_to_date,
821: capacity_per_day = nvl(l_capacity_per_day, 0),
822: last_update_date = sysdate,

Line 826: insert into po_supplier_item_capacity

822: last_update_date = sysdate,
823: last_updated_by = l_user_id
824: where capacity_id = l_capacity_id;
825: else
826: insert into po_supplier_item_capacity
827: (CAPACITY_ID,
828: ASL_ID,
829: USING_ORGANIZATION_ID,
830: FROM_DATE,

Line 839: po_supplier_item_capacity_s.nextval,

835: LAST_UPDATE_LOGIN,
836: CREATION_DATE,
837: CREATED_BY)
838: values (
839: po_supplier_item_capacity_s.nextval,
840: to_number(p_asl_id),
841: -1,
842: l_from_date,
843: l_to_date,

Line 855: delete from po_supplier_item_capacity

851: end if;
852:
853: elsif (l_capacity_id <> -1) then
854:
855: delete from po_supplier_item_capacity
856: where capacity_id = l_capacity_id;
857:
858: end if; /* (l_from_date is null ) and (l_to_date is null ) and
859: (l_capacity_per_day is null) */