APPS.POS_SUPPLIER_ITEM_CAPACITY_PKG dependencies on PO_SUPPLIER_ITEM_CAPACITY

Line 25: insert into po_supplier_item_capacity

21: IS
22:
23: BEGIN
24:
25: insert into po_supplier_item_capacity
26: (CAPACITY_ID,
27: ASL_ID,
28: USING_ORGANIZATION_ID,
29: FROM_DATE,

Line 38: po_supplier_item_capacity_s.nextval,

34: LAST_UPDATE_LOGIN,
35: CREATION_DATE,
36: CREATED_BY)
37: values (
38: po_supplier_item_capacity_s.nextval,
39: to_number(p_asl_id),
40: -1,
41: to_date(p_from_date, 'YYYY-MM-DD'),
42: to_date(p_to_date, 'YYYY-MM-DD'),

Line 74: UPDATE po_supplier_item_capacity

70:
71: sourcedate := to_date(p_from_date, 'YYYY-MM-DD');
72: destdate := to_date(p_to_date, 'YYYY-MM-DD');
73:
74: UPDATE po_supplier_item_capacity
75: SET
76: FROM_DATE = sourcedate,
77: TO_DATE = destdate,
78: CAPACITY_PER_DAY = p_capacity_per_day,

Line 101: DELETE from po_supplier_item_capacity

97: IS
98:
99: BEGIN
100:
101: DELETE from po_supplier_item_capacity
102: WHERE
103: asl_id = To_number(p_asl_id) AND capacity_id = p_capacity_id;
104:
105: EXCEPTION WHEN OTHERS THEN