[Home] [Help]
PACKAGE: APPS.EAM_ASSET_ACTIVITIES_PVT
Source
1 PACKAGE EAM_ASSET_ACTIVITIES_PVT AUTHID CURRENT_USER as
2 /* $Header: EAMVASOS.pls 120.0.12020000.2 2013/01/04 06:17:08 shengywa 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_WORK_ORDER_TYPE NUMBER,
82 P_PLANNER NUMBER,
83 P_FIRM IN NUMBER,
84 P_PLANNED IN VARCHAR2,
85 P_NOTIFICATION_REQUIRED IN VARCHAR2,
86 P_CLASS_CODE VARCHAR2,
87 P_OWNING_DEPARTMENT_ID NUMBER,
88 P_TAGGING_REQUIRED_FLAG VARCHAR2,
89 P_SHUTDOWN_TYPE_CODE VARCHAR2,
90 P_LAST_UPDATE_DATE DATE,
91 P_LAST_UPDATED_BY NUMBER,
92 P_CREATION_DATE DATE,
93 P_CREATED_BY NUMBER,
94 P_LAST_UPDATE_LOGIN NUMBER,
95 P_ATTRIBUTE_CATEGORY VARCHAR2,
96 P_ATTRIBUTE1 VARCHAR2,
97 P_ATTRIBUTE2 VARCHAR2,
98 P_ATTRIBUTE3 VARCHAR2,
99 P_ATTRIBUTE4 VARCHAR2,
100 P_ATTRIBUTE5 VARCHAR2,
101 P_ATTRIBUTE6 VARCHAR2,
102 P_ATTRIBUTE7 VARCHAR2,
103 P_ATTRIBUTE8 VARCHAR2,
104 P_ATTRIBUTE9 VARCHAR2,
105 P_ATTRIBUTE10 VARCHAR2,
106 P_ATTRIBUTE11 VARCHAR2,
107 P_ATTRIBUTE12 VARCHAR2,
108 P_ATTRIBUTE13 VARCHAR2,
109 P_ATTRIBUTE14 VARCHAR2,
110 P_ATTRIBUTE15 VARCHAR2,
111 P_REQUEST_ID NUMBER DEFAULT NULL,
112 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
113 P_PROGRAM_ID NUMBER DEFAULT NULL,
114 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
115 P_TMPL_FLAG VARCHAR2,
116 P_MAINTENANCE_OBJECT_ID NUMBER,
117 P_MAINTENANCE_OBJECT_TYPE NUMBER,
118 P_CREATION_ORGANIZATION_ID NUMBER,
119 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
120 X_MSG_COUNT OUT NOCOPY NUMBER,
121 X_MSG_DATA OUT NOCOPY VARCHAR2);
122
123
124
125 PROCEDURE LOCK_ROW(
126 P_API_VERSION IN NUMBER,
127 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
128 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
129 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130 P_ROWID VARCHAR2,
131 P_ACTIVITY_ASSOCIATION_ID NUMBER,
132 P_ORGANIZATION_ID NUMBER,
133 P_ASSET_ACTIVITY_ID NUMBER,
134 P_INVENTORY_ITEM_ID NUMBER,
135 P_SERIAL_NUMBER VARCHAR2,
136 P_START_DATE_ACTIVE DATE,
137 P_END_DATE_ACTIVE DATE,
138 P_PRIORITY_CODE VARCHAR2,
139 P_ACTIVITY_CAUSE_CODE VARCHAR2,
140 P_ACTIVITY_TYPE_CODE VARCHAR2,
141 P_ACTIVITY_SOURCE_CODE VARCHAR2,
142 P_CLASS_CODE VARCHAR2,
143 P_OWNING_DEPARTMENT_ID NUMBER,
144 P_TAGGING_REQUIRED_FLAG VARCHAR2,
145 P_SHUTDOWN_TYPE_CODE VARCHAR2,
146 P_ATTRIBUTE_CATEGORY VARCHAR2,
147 P_ATTRIBUTE1 VARCHAR2,
148 P_ATTRIBUTE2 VARCHAR2,
149 P_ATTRIBUTE3 VARCHAR2,
150 P_ATTRIBUTE4 VARCHAR2,
151 P_ATTRIBUTE5 VARCHAR2,
152 P_ATTRIBUTE6 VARCHAR2,
153 P_ATTRIBUTE7 VARCHAR2,
154 P_ATTRIBUTE8 VARCHAR2,
155 P_ATTRIBUTE9 VARCHAR2,
156 P_ATTRIBUTE10 VARCHAR2,
157 P_ATTRIBUTE11 VARCHAR2,
158 P_ATTRIBUTE12 VARCHAR2,
159 P_ATTRIBUTE13 VARCHAR2,
160 P_ATTRIBUTE14 VARCHAR2,
161 P_ATTRIBUTE15 VARCHAR2,
162 P_REQUEST_ID NUMBER DEFAULT NULL,
163 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
164 P_PROGRAM_ID NUMBER DEFAULT NULL,
165 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
166 P_MAINTENANCE_OBJECT_ID NUMBER,
167 P_MAINTENANCE_OBJECT_TYPE NUMBER,
168 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
169 X_MSG_COUNT OUT NOCOPY NUMBER,
170 X_MSG_DATA OUT NOCOPY VARCHAR2);
171
172
173 PROCEDURE UPDATE_ROW(
174 P_API_VERSION IN NUMBER,
175 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
176 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
177 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178 P_ROWID VARCHAR2,
179 P_ACTIVITY_ASSOCIATION_ID NUMBER,
180 P_ORGANIZATION_ID NUMBER,
181 P_ASSET_ACTIVITY_ID NUMBER,
182 P_INVENTORY_ITEM_ID NUMBER,
183 P_SERIAL_NUMBER VARCHAR2,
184 P_START_DATE_ACTIVE DATE,
185 P_END_DATE_ACTIVE DATE,
186 P_PRIORITY_CODE VARCHAR2,
187 P_ACTIVITY_CAUSE_CODE VARCHAR2,
188 P_ACTIVITY_TYPE_CODE VARCHAR2,
189 P_ACTIVITY_SOURCE_CODE VARCHAR2,
190 P_WORK_ORDER_TYPE NUMBER,
191 P_PLANNER NUMBER,
192 P_FIRM IN NUMBER,
193 P_PLANNED IN VARCHAR2,
194 P_NOTIFICATION_REQUIRED IN VARCHAR2,
195 P_CLASS_CODE VARCHAR2,
196 P_OWNING_DEPARTMENT_ID NUMBER,
197 P_TAGGING_REQUIRED_FLAG VARCHAR2,
198 P_SHUTDOWN_TYPE_CODE VARCHAR2,
199 P_LAST_UPDATE_DATE DATE,
200 P_LAST_UPDATED_BY NUMBER,
201 P_LAST_UPDATE_LOGIN NUMBER,
202 P_ATTRIBUTE_CATEGORY VARCHAR2,
203 P_ATTRIBUTE1 VARCHAR2,
204 P_ATTRIBUTE2 VARCHAR2,
205 P_ATTRIBUTE3 VARCHAR2,
206 P_ATTRIBUTE4 VARCHAR2,
207 P_ATTRIBUTE5 VARCHAR2,
208 P_ATTRIBUTE6 VARCHAR2,
209 P_ATTRIBUTE7 VARCHAR2,
210 P_ATTRIBUTE8 VARCHAR2,
211 P_ATTRIBUTE9 VARCHAR2,
212 P_ATTRIBUTE10 VARCHAR2,
213 P_ATTRIBUTE11 VARCHAR2,
214 P_ATTRIBUTE12 VARCHAR2,
215 P_ATTRIBUTE13 VARCHAR2,
216 P_ATTRIBUTE14 VARCHAR2,
217 P_ATTRIBUTE15 VARCHAR2,
218 P_REQUEST_ID NUMBER DEFAULT NULL,
219 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
220 P_PROGRAM_ID NUMBER DEFAULT NULL,
221 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
222 P_MAINTENANCE_OBJECT_ID NUMBER,
223 P_MAINTENANCE_OBJECT_TYPE NUMBER,
224 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
225 X_MSG_COUNT OUT NOCOPY NUMBER,
226 X_MSG_DATA OUT NOCOPY VARCHAR2);
227
228
229 END EAM_ASSET_ACTIVITIES_PVT;