[Home] [Help]
PACKAGE: APPS.EAM_NETWORK_ASSETS_PVT
Source
1 PACKAGE EAM_NETWORK_ASSETS_PVT AUTHID CURRENT_USER as
2 /* $Header: EAMVNWKS.pls 115.2 2002/11/22 22:55:40 aan noship $ */
3 -- Start of comments
4 -- API name : EAM_NETWORK_ASSETS_PVT
5 -- Type : Private
6 -- Function :
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN P_API_VERSION IN NUMBER REQUIRED
10 -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
11 -- DEFAULT = FND_API.G_FALSE
12 -- P_COMMIT IN VARCHAR2 OPTIONAL
13 -- DEFAULT = FND_API.G_FALSE
14 -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
15 -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
16 -- P_ROWID IN OUT VARCHAR2 REQUIRED
17 -- P_NETWORK_ASSOCIATION_ID IN OUT NUMBER REQUIRED
18 -- P_ORGANIZATION_ID IN NUMBER REQUIRED
19 -- P_NETWORK_OBJECT_TYPE IN NUMBER REQUIRED
20 -- P_NETWORK_OBJECT_ID IN NUMBER REQUIRED
21 -- P_MAINTENANCE_OBJECT_TYPE IN NUMBER REQUIRED
22 -- P_MAINTENANCE_OBJECT_ID IN NUMBER REQUIRED
23 -- P_INVENTORY_ITEM_ID IN NUMBER REQUIRED
24 -- P_SERIAL_NUMBER IN VARCHAR2 REQUIRED
25 -- P_START_DATE_ACTIVE IN DATE OPTIONAL
26 -- P_END_DATE_ACTIVE IN DATE OPTIONAL
27 -- P_LAST_UPDATE_DATE IN DATE REQUIRED
28 -- P_LAST_UPDATED_BY IN NUMBER REQUIRED
29 -- P_CREATION_DATE IN DATE REQUIRED
30 -- P_CREATED_BY IN NUMBER REQUIRED
31 -- P_LAST_UPDATE_LOGIN IN NUMBER REQUIRED
32 -- P_ATTRIBUTE_CATEGORY IN VARCHAR2 OPTIONAL
33 -- P_ATTRIBUTE1 IN VARCHAR2 OPTIONAL
34 -- P_ATTRIBUTE2 IN VARCHAR2 OPTIONAL
35 -- P_ATTRIBUTE3 IN VARCHAR2 OPTIONAL
36 -- P_ATTRIBUTE4 IN VARCHAR2 OPTIONAL
37 -- P_ATTRIBUTE5 IN VARCHAR2 OPTIONAL
38 -- P_ATTRIBUTE6 IN VARCHAR2 OPTIONAL
39 -- P_ATTRIBUTE7 IN VARCHAR2 OPTIONAL
40 -- P_ATTRIBUTE8 IN VARCHAR2 OPTIONAL
41 -- P_ATTRIBUTE9 IN VARCHAR2 OPTIONAL
42 -- P_ATTRIBUTE10 IN VARCHAR2 OPTIONAL
43 -- P_ATTRIBUTE11 IN VARCHAR2 OPTIONAL
44 -- P_ATTRIBUTE12 IN VARCHAR2 OPTIONAL
45 -- P_ATTRIBUTE13 IN VARCHAR2 OPTIONAL
46 -- P_ATTRIBUTE14 IN VARCHAR2 OPTIONAL
47 -- P_ATTRIBUTE15 IN VARCHAR2 OPTIONAL
48 -- P_REQUEST_ID IN NUMBER DEFAULT NULL OPTIONAL
49 -- P_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT NULL OPTIONAL
50 -- P_PROGRAM_ID IN NUMBER DEFAULT NULL OPTIONAL
51 -- P_PROGRAM_UPDATE_DATE IN DATE DEFAULT NULL
52 -- OUT X_RETURN_STATUS OUT VARCHAR2(1)
53 -- X_MSG_COUNT OUT NUMBER
54 -- X_MSG_DATA OUT VARCHAR2(2000)
55 --
56 -- Version Current version 115.0
57 --
58 -- Notes : Note text
59 --
60 -- End of comments
61
62
63 PROCEDURE INSERT_ROW(
64 P_API_VERSION IN NUMBER,
65 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
66 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
67 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68 P_ROWID IN OUT NOCOPY VARCHAR2,
69 P_NETWORK_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
70 P_ORGANIZATION_ID NUMBER,
71 P_NETWORK_OBJECT_TYPE NUMBER,
72 P_NETWORK_OBJECT_ID NUMBER,
73 P_MAINTENANCE_OBJECT_TYPE NUMBER,
74 P_MAINTENANCE_OBJECT_ID NUMBER,
75 P_NETWORK_ITEM_ID NUMBER,
76 P_NETWORK_SERIAL_NUMBER VARCHAR2,
77 P_INVENTORY_ITEM_ID NUMBER,
78 P_SERIAL_NUMBER VARCHAR2,
79 P_START_DATE_ACTIVE DATE,
80 P_END_DATE_ACTIVE DATE,
81 P_LAST_UPDATE_DATE DATE,
82 P_LAST_UPDATED_BY NUMBER,
83 P_CREATION_DATE DATE,
84 P_CREATED_BY NUMBER,
85 P_LAST_UPDATE_LOGIN NUMBER,
86 P_ATTRIBUTE_CATEGORY VARCHAR2,
87 P_ATTRIBUTE1 VARCHAR2,
88 P_ATTRIBUTE2 VARCHAR2,
89 P_ATTRIBUTE3 VARCHAR2,
90 P_ATTRIBUTE4 VARCHAR2,
91 P_ATTRIBUTE5 VARCHAR2,
92 P_ATTRIBUTE6 VARCHAR2,
93 P_ATTRIBUTE7 VARCHAR2,
94 P_ATTRIBUTE8 VARCHAR2,
95 P_ATTRIBUTE9 VARCHAR2,
96 P_ATTRIBUTE10 VARCHAR2,
97 P_ATTRIBUTE11 VARCHAR2,
98 P_ATTRIBUTE12 VARCHAR2,
99 P_ATTRIBUTE13 VARCHAR2,
100 P_ATTRIBUTE14 VARCHAR2,
101 P_ATTRIBUTE15 VARCHAR2,
102 P_REQUEST_ID NUMBER DEFAULT NULL,
103 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
104 P_PROGRAM_ID NUMBER DEFAULT NULL,
105 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
106 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
107 X_MSG_COUNT OUT NOCOPY NUMBER,
108 X_MSG_DATA OUT NOCOPY VARCHAR2);
109
110
111
112 PROCEDURE LOCK_ROW(
113 P_API_VERSION IN NUMBER,
114 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
115 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
116 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117 P_ROWID VARCHAR2,
118 P_NETWORK_ASSOCIATION_ID NUMBER,
119 P_ORGANIZATION_ID NUMBER,
120 P_NETWORK_OBJECT_TYPE NUMBER,
121 P_NETWORK_OBJECT_ID NUMBER,
122 P_MAINTENANCE_OBJECT_TYPE NUMBER,
123 P_MAINTENANCE_OBJECT_ID NUMBER,
124 P_NETWORK_ITEM_ID NUMBER,
125 P_NETWORK_SERIAL_NUMBER VARCHAR2,
126 P_INVENTORY_ITEM_ID NUMBER,
127 P_SERIAL_NUMBER VARCHAR2,
128 P_START_DATE_ACTIVE DATE,
129 P_END_DATE_ACTIVE DATE,
130 P_ATTRIBUTE_CATEGORY VARCHAR2,
131 P_ATTRIBUTE1 VARCHAR2,
132 P_ATTRIBUTE2 VARCHAR2,
133 P_ATTRIBUTE3 VARCHAR2,
134 P_ATTRIBUTE4 VARCHAR2,
135 P_ATTRIBUTE5 VARCHAR2,
136 P_ATTRIBUTE6 VARCHAR2,
137 P_ATTRIBUTE7 VARCHAR2,
138 P_ATTRIBUTE8 VARCHAR2,
139 P_ATTRIBUTE9 VARCHAR2,
140 P_ATTRIBUTE10 VARCHAR2,
141 P_ATTRIBUTE11 VARCHAR2,
142 P_ATTRIBUTE12 VARCHAR2,
143 P_ATTRIBUTE13 VARCHAR2,
144 P_ATTRIBUTE14 VARCHAR2,
145 P_ATTRIBUTE15 VARCHAR2,
146 P_REQUEST_ID NUMBER DEFAULT NULL,
147 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
148 P_PROGRAM_ID NUMBER DEFAULT NULL,
149 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
150 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
151 X_MSG_COUNT OUT NOCOPY NUMBER,
152 X_MSG_DATA OUT NOCOPY VARCHAR2);
153
154
155 PROCEDURE UPDATE_ROW(
156 P_API_VERSION IN NUMBER,
157 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
158 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
159 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160 P_ROWID VARCHAR2,
161 P_NETWORK_ASSOCIATION_ID NUMBER,
162 P_ORGANIZATION_ID NUMBER,
163 P_NETWORK_OBJECT_TYPE NUMBER,
164 P_NETWORK_OBJECT_ID NUMBER,
165 P_MAINTENANCE_OBJECT_TYPE NUMBER,
166 P_MAINTENANCE_OBJECT_ID NUMBER,
167 P_NETWORK_ITEM_ID NUMBER,
168 P_NETWORK_SERIAL_NUMBER VARCHAR2,
169 P_INVENTORY_ITEM_ID NUMBER,
170 P_SERIAL_NUMBER VARCHAR2,
171 P_START_DATE_ACTIVE DATE,
172 P_END_DATE_ACTIVE DATE,
173 P_LAST_UPDATE_DATE DATE,
174 P_LAST_UPDATED_BY NUMBER,
175 P_LAST_UPDATE_LOGIN NUMBER,
176 P_ATTRIBUTE_CATEGORY VARCHAR2,
177 P_ATTRIBUTE1 VARCHAR2,
178 P_ATTRIBUTE2 VARCHAR2,
179 P_ATTRIBUTE3 VARCHAR2,
180 P_ATTRIBUTE4 VARCHAR2,
181 P_ATTRIBUTE5 VARCHAR2,
182 P_ATTRIBUTE6 VARCHAR2,
183 P_ATTRIBUTE7 VARCHAR2,
184 P_ATTRIBUTE8 VARCHAR2,
185 P_ATTRIBUTE9 VARCHAR2,
186 P_ATTRIBUTE10 VARCHAR2,
187 P_ATTRIBUTE11 VARCHAR2,
188 P_ATTRIBUTE12 VARCHAR2,
189 P_ATTRIBUTE13 VARCHAR2,
190 P_ATTRIBUTE14 VARCHAR2,
191 P_ATTRIBUTE15 VARCHAR2,
192 P_REQUEST_ID NUMBER DEFAULT NULL,
193 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
194 P_PROGRAM_ID NUMBER DEFAULT NULL,
195 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
196 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
197 X_MSG_COUNT OUT NOCOPY NUMBER,
198 X_MSG_DATA OUT NOCOPY VARCHAR2);
199
200
201 END EAM_NETWORK_ASSETS_PVT;