1 PACKAGE mtl_related_items_cust_ref_pkg AUTHID CURRENT_USER AS
2 /* $Header: INVTRICS.pls 120.0 2011/03/08 20:11:50 mshirkol noship $ */
3
4 PROCEDURE INSERT_ROW (
5 P_PLN_INFO_ID IN NUMBER
6 ,P_INVENTORY_ITEM_ID IN NUMBER
7 ,P_ORGANIZATION_ID IN NUMBER
8 ,P_RELATED_ITEM_ID IN NUMBER
9 ,P_RELATIONSHIP_TYPE_ID IN NUMBER
10 ,P_CUSTOMER_ID IN NUMBER
11 ,P_SITE_USE_ID IN NUMBER
12 ,P_START_DATE IN DATE
13 ,P_END_DATE IN DATE
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
20 PROCEDURE LOCK_ROW(
21 P_PLN_INFO_ID IN NUMBER
22 ,P_INVENTORY_ITEM_ID IN NUMBER
23 ,P_ORGANIZATION_ID IN NUMBER
24 ,P_RELATED_ITEM_ID IN NUMBER
25 ,P_RELATIONSHIP_TYPE_ID IN NUMBER
26 ,P_CUSTOMER_ID IN NUMBER
27 ,P_SITE_USE_ID IN NUMBER
28 ,P_START_DATE IN DATE
29 ,P_END_DATE IN DATE);
30
31 PROCEDURE UPDATE_ROW(
32 P_PLN_INFO_ID IN NUMBER
33 ,P_INVENTORY_ITEM_ID IN NUMBER
34 ,P_ORGANIZATION_ID IN NUMBER
35 ,P_RELATED_ITEM_ID IN NUMBER
36 ,P_RELATIONSHIP_TYPE_ID IN NUMBER
37 ,P_CUSTOMER_ID IN NUMBER
38 ,P_SITE_USE_ID IN NUMBER
39 ,P_START_DATE IN DATE
40 ,P_END_DATE IN DATE
41 ,P_LAST_UPDATE_DATE IN DATE
42 ,P_LAST_UPDATED_BY IN NUMBER
43 ,P_LAST_UPDATE_LOGIN IN NUMBER);
44
45 PROCEDURE DELETE_ROW(
46 P_PLN_INFO_ID IN NUMBER
47 ,P_INVENTORY_ITEM_ID IN NUMBER
48 ,P_ORGANIZATION_ID IN NUMBER
49 ,P_RELATED_ITEM_ID IN NUMBER
50 ,P_RELATIONSHIP_TYPE_ID IN NUMBER
51 ,P_CUSTOMER_ID IN NUMBER
52 ,P_SITE_USE_ID IN NUMBER);
53
54 END MTL_RELATED_ITEMS_CUST_REF_PKG;