[Home] [Help]
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;