PACKAGE: APPS.AMS_RELATED_ITEMS_PKG

Source

1 PACKAGE AMS_RELATED_ITEMS_PKG AUTHID CURRENT_USER as
2 /* $Header: amstrits.pls 115.3 2002/11/11 22:05:47 abhola ship $ */
3 -- Start of Comments
4 -- Package name     : AMS_RELATED_ITEMS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           p_INVENTORY_ITEM_ID    NUMBER,
12           p_ORGANIZATION_ID    NUMBER,
13           p_RELATED_ITEM_ID    NUMBER,
14           p_RELATIONSHIP_TYPE_ID    NUMBER,
15           p_RECIPROCAL_FLAG    VARCHAR2,
16           p_LAST_UPDATE_DATE    DATE,
17           p_LAST_UPDATED_BY    NUMBER,
18           p_CREATION_DATE    DATE,
19           p_CREATED_BY    NUMBER,
20           p_LAST_UPDATE_LOGIN    NUMBER,
21           p_REQUEST_ID    NUMBER,
22           p_PROGRAM_APPLICATION_ID    NUMBER,
23           p_PROGRAM_ID    NUMBER,
24           p_PROGRAM_UPDATE_DATE    DATE);
25 
26 PROCEDURE Update_Row(
27           p_INVENTORY_ITEM_ID    NUMBER,
28           p_ORGANIZATION_ID    NUMBER,
29           p_RELATED_ITEM_ID    NUMBER,
30           p_RELATIONSHIP_TYPE_ID    NUMBER,
31           p_RECIPROCAL_FLAG    VARCHAR2,
32           p_LAST_UPDATE_DATE    DATE,
33           p_LAST_UPDATED_BY    NUMBER,
34           p_CREATION_DATE    DATE,
35           p_CREATED_BY    NUMBER,
36           p_LAST_UPDATE_LOGIN    NUMBER,
37           p_REQUEST_ID    NUMBER,
38           p_PROGRAM_APPLICATION_ID    NUMBER,
39           p_PROGRAM_ID    NUMBER,
40           p_PROGRAM_UPDATE_DATE    DATE);
41 
42 PROCEDURE Lock_Row(
43           p_INVENTORY_ITEM_ID    NUMBER,
44           p_ORGANIZATION_ID    NUMBER,
45           p_RELATED_ITEM_ID    NUMBER,
46           p_RELATIONSHIP_TYPE_ID    NUMBER,
47           p_RECIPROCAL_FLAG    VARCHAR2,
48           p_LAST_UPDATE_DATE    DATE,
49           p_LAST_UPDATED_BY    NUMBER,
50           p_CREATION_DATE    DATE,
51           p_CREATED_BY    NUMBER,
52           p_LAST_UPDATE_LOGIN    NUMBER,
53           p_REQUEST_ID    NUMBER,
54           p_PROGRAM_APPLICATION_ID    NUMBER,
55           p_PROGRAM_ID    NUMBER,
56           p_PROGRAM_UPDATE_DATE    DATE);
57 
58 PROCEDURE Delete_Row(
59           p_INVENTORY_ITEM_ID    NUMBER,
60           p_ORGANIZATION_ID    NUMBER,
61           p_RELATED_ITEM_ID     NUMBER,
62           p_RELATIONSHIP_TYPE_ID    NUMBER,
63           p_RECIPROCAL_FLAG    VARCHAR2,
64           p_LAST_UPDATE_DATE    DATE,
65           p_LAST_UPDATED_BY    NUMBER,
66           p_CREATION_DATE    DATE,
67           p_CREATED_BY    NUMBER,
68           p_LAST_UPDATE_LOGIN    NUMBER,
69           p_REQUEST_ID    NUMBER,
70           p_PROGRAM_APPLICATION_ID    NUMBER,
71           p_PROGRAM_ID    NUMBER,
72           p_PROGRAM_UPDATE_DATE    DATE);
73 
74 End AMS_RELATED_ITEMS_PKG;