1 PACKAGE MTL_CROSS_REFERENCES_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVIDXRS.pls 120.0 2005/06/22 23:04:45 lparihar noship $ */
3
4 PROCEDURE INSERT_ROW (
5 P_SOURCE_SYSTEM_ID IN NUMBER
6 ,P_START_DATE_ACTIVE IN DATE
7 ,P_END_DATE_ACTIVE IN DATE
8 ,P_OBJECT_VERSION_NUMBER IN NUMBER
9 ,P_UOM_CODE IN VARCHAR2
10 ,P_REVISION_ID IN NUMBER
11 ,P_EPC_GTIN_SERIAL IN NUMBER
12 ,P_INVENTORY_ITEM_ID IN NUMBER
13 ,P_ORGANIZATION_ID IN NUMBER
14 ,P_CROSS_REFERENCE_TYPE IN VARCHAR2
15 ,P_CROSS_REFERENCE IN VARCHAR2
16 ,P_ORG_INDEPENDENT_FLAG IN VARCHAR2
17 ,P_REQUEST_ID IN NUMBER
18 ,P_ATTRIBUTE1 IN VARCHAR2
19 ,P_ATTRIBUTE2 IN VARCHAR2
20 ,P_ATTRIBUTE3 IN VARCHAR2
21 ,P_ATTRIBUTE4 IN VARCHAR2
22 ,P_ATTRIBUTE5 IN VARCHAR2
23 ,P_ATTRIBUTE6 IN VARCHAR2
24 ,P_ATTRIBUTE7 IN VARCHAR2
25 ,P_ATTRIBUTE8 IN VARCHAR2
26 ,P_ATTRIBUTE9 IN VARCHAR2
27 ,P_ATTRIBUTE10 IN VARCHAR2
28 ,P_ATTRIBUTE11 IN VARCHAR2
29 ,P_ATTRIBUTE12 IN VARCHAR2
30 ,P_ATTRIBUTE13 IN VARCHAR2
31 ,P_ATTRIBUTE14 IN VARCHAR2
32 ,P_ATTRIBUTE15 IN VARCHAR2
33 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2
34 ,P_DESCRIPTION IN VARCHAR2
35 ,P_CREATION_DATE IN DATE
36 ,P_CREATED_BY IN NUMBER
37 ,P_LAST_UPDATE_DATE IN DATE
38 ,P_LAST_UPDATED_BY IN NUMBER
39 ,P_LAST_UPDATE_LOGIN IN NUMBER
40 ,P_PROGRAM_APPLICATION_ID IN NUMBER
41 ,P_PROGRAM_ID IN NUMBER
42 ,P_PROGRAM_UPDATE_DATE IN DATE
43 ,X_CROSS_REFERENCE_ID OUT NOCOPY NUMBER);
44
45
46 PROCEDURE LOCK_ROW (
47 P_CROSS_REFERENCE_ID IN NUMBER
48 ,P_SOURCE_SYSTEM_ID IN NUMBER
49 ,P_START_DATE_ACTIVE IN DATE
50 ,P_END_DATE_ACTIVE IN DATE
51 ,P_OBJECT_VERSION_NUMBER IN NUMBER
52 ,P_UOM_CODE IN VARCHAR2
53 ,P_REVISION_ID IN NUMBER
54 ,P_EPC_GTIN_SERIAL IN NUMBER
55 ,P_INVENTORY_ITEM_ID IN NUMBER
56 ,P_ORGANIZATION_ID IN NUMBER
57 ,P_CROSS_REFERENCE_TYPE IN VARCHAR2
58 ,P_CROSS_REFERENCE IN VARCHAR2
59 ,P_ORG_INDEPENDENT_FLAG IN VARCHAR2
60 ,P_ATTRIBUTE1 IN VARCHAR2
61 ,P_ATTRIBUTE2 IN VARCHAR2
62 ,P_ATTRIBUTE3 IN VARCHAR2
63 ,P_ATTRIBUTE4 IN VARCHAR2
64 ,P_ATTRIBUTE5 IN VARCHAR2
65 ,P_ATTRIBUTE6 IN VARCHAR2
66 ,P_ATTRIBUTE7 IN VARCHAR2
67 ,P_ATTRIBUTE8 IN VARCHAR2
68 ,P_ATTRIBUTE9 IN VARCHAR2
69 ,P_ATTRIBUTE10 IN VARCHAR2
70 ,P_ATTRIBUTE11 IN VARCHAR2
71 ,P_ATTRIBUTE12 IN VARCHAR2
72 ,P_ATTRIBUTE13 IN VARCHAR2
73 ,P_ATTRIBUTE14 IN VARCHAR2
74 ,P_ATTRIBUTE15 IN VARCHAR2
75 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2
76 ,P_DESCRIPTION IN VARCHAR2);
77
78 PROCEDURE UPDATE_ROW (
79 P_CROSS_REFERENCE_ID IN NUMBER
80 ,P_SOURCE_SYSTEM_ID IN NUMBER
81 ,P_START_DATE_ACTIVE IN DATE
82 ,P_END_DATE_ACTIVE IN DATE
83 ,P_UOM_CODE IN VARCHAR2
84 ,P_REVISION_ID IN NUMBER
85 ,P_EPC_GTIN_SERIAL IN NUMBER
86 ,P_INVENTORY_ITEM_ID IN NUMBER
87 ,P_ORGANIZATION_ID IN NUMBER
88 ,P_CROSS_REFERENCE_TYPE IN VARCHAR2
89 ,P_CROSS_REFERENCE IN VARCHAR2
90 ,P_ORG_INDEPENDENT_FLAG IN VARCHAR2
91 ,P_REQUEST_ID IN NUMBER
92 ,P_ATTRIBUTE1 IN VARCHAR2
93 ,P_ATTRIBUTE2 IN VARCHAR2
94 ,P_ATTRIBUTE3 IN VARCHAR2
95 ,P_ATTRIBUTE4 IN VARCHAR2
96 ,P_ATTRIBUTE5 IN VARCHAR2
97 ,P_ATTRIBUTE6 IN VARCHAR2
98 ,P_ATTRIBUTE7 IN VARCHAR2
99 ,P_ATTRIBUTE8 IN VARCHAR2
100 ,P_ATTRIBUTE9 IN VARCHAR2
101 ,P_ATTRIBUTE10 IN VARCHAR2
102 ,P_ATTRIBUTE11 IN VARCHAR2
103 ,P_ATTRIBUTE12 IN VARCHAR2
104 ,P_ATTRIBUTE13 IN VARCHAR2
105 ,P_ATTRIBUTE14 IN VARCHAR2
106 ,P_ATTRIBUTE15 IN VARCHAR2
107 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2
108 ,P_DESCRIPTION IN VARCHAR2
109 ,P_LAST_UPDATE_DATE IN DATE
110 ,P_LAST_UPDATED_BY IN NUMBER
111 ,P_LAST_UPDATE_LOGIN IN NUMBER
112 ,X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER);
113
114 PROCEDURE DELETE_ROW (P_CROSS_REFERENCE_ID IN NUMBER);
115
116 PROCEDURE ADD_LANGUAGE;
117
118 END MTL_CROSS_REFERENCES_PKG;