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