1 PACKAGE mtl_related_items_pln_info_pkg AUTHID CURRENT_USER AS
2 /* $Header: INVTRIPS.pls 120.0 2011/03/08 20:14:57 mshirkol noship $ */
3
4 PROCEDURE INSERT_ROW (
5 P_INVENTORY_ITEM_ID IN NUMBER
6 ,P_ORGANIZATION_ID IN NUMBER
7 ,P_RELATED_ITEM_ID IN NUMBER
8 ,P_RELATIONSHIP_TYPE_ID IN NUMBER
9 ,P_SUBSTITUTION_SET IN VARCHAR2
10 ,P_PARTIAL_FULFILLMENT_FLAG IN VARCHAR2
11 ,P_START_DATE IN DATE
12 ,P_END_DATE IN DATE
13 ,P_ALL_CUSTOMERS_FLAG IN VARCHAR2
14 ,P_LAST_UPDATE_DATE IN DATE
15 ,P_LAST_UPDATED_BY IN NUMBER
16 ,P_CREATION_DATE IN DATE
17 ,P_CREATED_BY IN NUMBER
18 ,P_LAST_UPDATE_LOGIN IN NUMBER
19 ,X_PLN_INFO_ID OUT NOCOPY NUMBER);
20
21 PROCEDURE LOCK_ROW(
22 P_PLN_INFO_ID IN NUMBER
23 ,P_INVENTORY_ITEM_ID IN NUMBER
24 ,P_ORGANIZATION_ID IN NUMBER
25 ,P_RELATED_ITEM_ID IN NUMBER
26 ,P_RELATIONSHIP_TYPE_ID IN NUMBER
27 ,P_SUBSTITUTION_SET IN VARCHAR2
28 ,P_PARTIAL_FULFILLMENT_FLAG IN VARCHAR2
29 ,P_START_DATE IN DATE
30 ,P_END_DATE IN DATE
31 ,P_ALL_CUSTOMERS_FLAG IN VARCHAR2);
32
33 PROCEDURE UPDATE_ROW(
34 P_PLN_INFO_ID IN NUMBER
35 ,P_INVENTORY_ITEM_ID IN NUMBER
36 ,P_ORGANIZATION_ID IN NUMBER
37 ,P_RELATED_ITEM_ID IN NUMBER
38 ,P_RELATIONSHIP_TYPE_ID IN NUMBER
39 ,P_SUBSTITUTION_SET IN VARCHAR2
40 ,P_PARTIAL_FULFILLMENT_FLAG IN VARCHAR2
41 ,P_START_DATE IN DATE
42 ,P_END_DATE IN DATE
43 ,P_ALL_CUSTOMERS_FLAG IN VARCHAR2
44 ,P_LAST_UPDATE_DATE IN DATE
45 ,P_LAST_UPDATED_BY IN NUMBER
46 ,P_LAST_UPDATE_LOGIN IN NUMBER);
47
48 PROCEDURE DELETE_ROW(
49 P_PLN_INFO_ID IN NUMBER
50 ,P_INVENTORY_ITEM_ID IN NUMBER
51 ,P_ORGANIZATION_ID IN NUMBER
52 ,P_RELATED_ITEM_ID IN NUMBER
53 ,P_RELATIONSHIP_TYPE_ID IN NUMBER);
54
55 END MTL_RELATED_ITEMS_PLN_INFO_PKG;