eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_OPERATIONS_PVT dependencies on FND_API

Line 111: p_x_prd_workoper_rec.wip_entity_id = FND_API.G_MISS_NUM ) AND

107: l_job_actual_end_date;
108: CLOSE get_workorder_rec;
109:
110: IF ( ( p_x_prd_workoper_rec.wip_entity_id IS NULL OR
111: p_x_prd_workoper_rec.wip_entity_id = FND_API.G_MISS_NUM ) AND
112: l_job_wip_entity_id IS NOT NULL ) THEN
113: p_x_prd_workoper_rec.wip_entity_id := l_job_wip_entity_id;
114: END IF;
115:

Line 117: p_x_prd_workoper_rec.organization_id = FND_API.G_MISS_NUM ) THEN

113: p_x_prd_workoper_rec.wip_entity_id := l_job_wip_entity_id;
114: END IF;
115:
116: IF ( p_x_prd_workoper_rec.organization_id IS NULL OR
117: p_x_prd_workoper_rec.organization_id = FND_API.G_MISS_NUM ) THEN
118: p_x_prd_workoper_rec.organization_id := l_job_organization_id;
119: END IF;
120:
121: IF ( G_DEBUG = 'Y' ) THEN

Line 141: p_init_msg_list => FND_API.G_FALSE,

137: IF l_qa_inspection_type IS NOT NULL THEN
138: AHL_QA_RESULTS_PVT.get_qa_plan
139: (
140: p_api_version => 1.0,
141: p_init_msg_list => FND_API.G_FALSE,
142: p_commit => FND_API.G_FALSE,
143: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
144: p_default => FND_API.G_FALSE,
145: p_module_type => NULL,

Line 142: p_commit => FND_API.G_FALSE,

138: AHL_QA_RESULTS_PVT.get_qa_plan
139: (
140: p_api_version => 1.0,
141: p_init_msg_list => FND_API.G_FALSE,
142: p_commit => FND_API.G_FALSE,
143: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
144: p_default => FND_API.G_FALSE,
145: p_module_type => NULL,
146: x_return_status => l_return_status,

Line 143: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

139: (
140: p_api_version => 1.0,
141: p_init_msg_list => FND_API.G_FALSE,
142: p_commit => FND_API.G_FALSE,
143: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
144: p_default => FND_API.G_FALSE,
145: p_module_type => NULL,
146: x_return_status => l_return_status,
147: x_msg_count => l_msg_count,

Line 144: p_default => FND_API.G_FALSE,

140: p_api_version => 1.0,
141: p_init_msg_list => FND_API.G_FALSE,
142: p_commit => FND_API.G_FALSE,
143: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
144: p_default => FND_API.G_FALSE,
145: p_module_type => NULL,
146: x_return_status => l_return_status,
147: x_msg_count => l_msg_count,
148: x_msg_data => l_msg_data,

Line 157: p_x_prd_workoper_rec.scheduled_start_date <> FND_API.G_MISS_DATE AND

153: );
154: END IF;
155:
156: IF ( p_x_prd_workoper_rec.scheduled_start_date IS NOT NULL AND
157: p_x_prd_workoper_rec.scheduled_start_date <> FND_API.G_MISS_DATE AND
158: l_job_scheduled_start_date IS NOT NULL AND
159: TRUNC( p_x_prd_workoper_rec.scheduled_start_date ) = TRUNC( l_job_scheduled_start_date ) ) THEN
160: p_x_prd_workoper_rec.scheduled_start_date := l_job_scheduled_start_date;
161: IF ( p_x_prd_workoper_rec.scheduled_start_hr IS NULL OR

Line 162: p_x_prd_workoper_rec.scheduled_start_hr = FND_API.G_MISS_NUM)

158: l_job_scheduled_start_date IS NOT NULL AND
159: TRUNC( p_x_prd_workoper_rec.scheduled_start_date ) = TRUNC( l_job_scheduled_start_date ) ) THEN
160: p_x_prd_workoper_rec.scheduled_start_date := l_job_scheduled_start_date;
161: IF ( p_x_prd_workoper_rec.scheduled_start_hr IS NULL OR
162: p_x_prd_workoper_rec.scheduled_start_hr = FND_API.G_MISS_NUM)
163: THEN
164: p_x_prd_workoper_rec.scheduled_start_hr := TO_NUMBER( TO_CHAR( l_job_scheduled_start_date, 'HH24' ) );
165: END IF;
166:

Line 168: p_x_prd_workoper_rec.scheduled_start_mi = FND_API.G_MISS_NUM)

164: p_x_prd_workoper_rec.scheduled_start_hr := TO_NUMBER( TO_CHAR( l_job_scheduled_start_date, 'HH24' ) );
165: END IF;
166:
167: IF( p_x_prd_workoper_rec.scheduled_start_mi IS NULL OR
168: p_x_prd_workoper_rec.scheduled_start_mi = FND_API.G_MISS_NUM)
169: THEN
170: p_x_prd_workoper_rec.scheduled_start_mi := TO_NUMBER( TO_CHAR( l_job_scheduled_start_date, 'MI' ) );
171: END IF;
172: END IF;

Line 175: p_x_prd_workoper_rec.scheduled_end_date <> FND_API.G_MISS_DATE AND

171: END IF;
172: END IF;
173:
174: IF ( p_x_prd_workoper_rec.scheduled_end_date IS NOT NULL AND
175: p_x_prd_workoper_rec.scheduled_end_date <> FND_API.G_MISS_DATE AND
176: l_job_scheduled_end_date IS NOT NULL AND
177: TRUNC( p_x_prd_workoper_rec.scheduled_end_date ) = TRUNC( l_job_scheduled_end_date ) ) THEN
178: p_x_prd_workoper_rec.scheduled_end_date := l_job_scheduled_end_date;
179: IF ( p_x_prd_workoper_rec.scheduled_end_hr IS NULL OR

Line 180: p_x_prd_workoper_rec.scheduled_end_hr = FND_API.G_MISS_NUM)

176: l_job_scheduled_end_date IS NOT NULL AND
177: TRUNC( p_x_prd_workoper_rec.scheduled_end_date ) = TRUNC( l_job_scheduled_end_date ) ) THEN
178: p_x_prd_workoper_rec.scheduled_end_date := l_job_scheduled_end_date;
179: IF ( p_x_prd_workoper_rec.scheduled_end_hr IS NULL OR
180: p_x_prd_workoper_rec.scheduled_end_hr = FND_API.G_MISS_NUM)
181: THEN
182: p_x_prd_workoper_rec.scheduled_end_hr := TO_NUMBER( TO_CHAR( l_job_scheduled_end_date, 'HH24' ) );
183: END IF;
184:

Line 186: p_x_prd_workoper_rec.scheduled_end_mi = FND_API.G_MISS_NUM)

182: p_x_prd_workoper_rec.scheduled_end_hr := TO_NUMBER( TO_CHAR( l_job_scheduled_end_date, 'HH24' ) );
183: END IF;
184:
185: IF ( p_x_prd_workoper_rec.scheduled_end_mi IS NULL OR
186: p_x_prd_workoper_rec.scheduled_end_mi = FND_API.G_MISS_NUM)
187: THEN
188: p_x_prd_workoper_rec.scheduled_end_mi := TO_NUMBER( TO_CHAR( l_job_scheduled_end_date, 'MI' ) );
189: END IF;
190: ELSIF ( p_x_prd_workoper_rec.scheduled_end_date IS NOT NULL AND

Line 191: p_x_prd_workoper_rec.scheduled_end_date <> FND_API.G_MISS_DATE AND

187: THEN
188: p_x_prd_workoper_rec.scheduled_end_mi := TO_NUMBER( TO_CHAR( l_job_scheduled_end_date, 'MI' ) );
189: END IF;
190: ELSIF ( p_x_prd_workoper_rec.scheduled_end_date IS NOT NULL AND
191: p_x_prd_workoper_rec.scheduled_end_date <> FND_API.G_MISS_DATE AND
192: l_job_scheduled_start_date IS NOT NULL AND
193: TRUNC( p_x_prd_workoper_rec.scheduled_end_date ) = TRUNC( l_job_scheduled_start_date ) ) THEN
194: p_x_prd_workoper_rec.scheduled_end_date := l_job_scheduled_start_date;
195: IF ( p_x_prd_workoper_rec.scheduled_end_hr IS NULL OR

Line 196: p_x_prd_workoper_rec.scheduled_end_hr = FND_API.G_MISS_NUM)

192: l_job_scheduled_start_date IS NOT NULL AND
193: TRUNC( p_x_prd_workoper_rec.scheduled_end_date ) = TRUNC( l_job_scheduled_start_date ) ) THEN
194: p_x_prd_workoper_rec.scheduled_end_date := l_job_scheduled_start_date;
195: IF ( p_x_prd_workoper_rec.scheduled_end_hr IS NULL OR
196: p_x_prd_workoper_rec.scheduled_end_hr = FND_API.G_MISS_NUM)
197: THEN
198: p_x_prd_workoper_rec.scheduled_end_hr := TO_NUMBER( TO_CHAR( l_job_scheduled_start_date, 'HH24' ) );
199: END IF;
200:

Line 202: p_x_prd_workoper_rec.scheduled_end_mi = FND_API.G_MISS_NUM)

198: p_x_prd_workoper_rec.scheduled_end_hr := TO_NUMBER( TO_CHAR( l_job_scheduled_start_date, 'HH24' ) );
199: END IF;
200:
201: IF ( p_x_prd_workoper_rec.scheduled_end_mi IS NULL OR
202: p_x_prd_workoper_rec.scheduled_end_mi = FND_API.G_MISS_NUM)
203: THEN
204: p_x_prd_workoper_rec.scheduled_end_mi := TO_NUMBER( TO_CHAR( l_job_scheduled_start_date, 'MI' ) );
205: END IF;
206: END IF;

Line 209: p_x_prd_workoper_rec.actual_start_date <> FND_API.G_MISS_DATE AND

205: END IF;
206: END IF;
207:
208: IF ( p_x_prd_workoper_rec.actual_start_date IS NOT NULL AND
209: p_x_prd_workoper_rec.actual_start_date <> FND_API.G_MISS_DATE AND
210: l_job_actual_start_date IS NOT NULL AND
211: TRUNC( p_x_prd_workoper_rec.actual_start_date ) = TRUNC( l_job_actual_start_date ) ) THEN
212: p_x_prd_workoper_rec.actual_start_date := l_job_actual_start_date;
213: p_x_prd_workoper_rec.actual_start_hr := TO_NUMBER( TO_CHAR( l_job_actual_start_date, 'HH24' ) );

Line 218: p_x_prd_workoper_rec.actual_end_date <> FND_API.G_MISS_DATE AND

214: p_x_prd_workoper_rec.actual_start_mi := TO_NUMBER( TO_CHAR( l_job_actual_start_date, 'MI' ) );
215: END IF;
216:
217: IF ( p_x_prd_workoper_rec.actual_end_date IS NOT NULL AND
218: p_x_prd_workoper_rec.actual_end_date <> FND_API.G_MISS_DATE AND
219: l_job_actual_end_date IS NOT NULL AND
220: TRUNC( p_x_prd_workoper_rec.actual_end_date ) = TRUNC( l_job_actual_end_date ) ) THEN
221: p_x_prd_workoper_rec.actual_end_date := l_job_actual_end_date;
222: p_x_prd_workoper_rec.actual_end_hr := TO_NUMBER( TO_CHAR( l_job_actual_end_date, 'HH24' ) );

Line 225: p_x_prd_workoper_rec.actual_end_date <> FND_API.G_MISS_DATE AND

221: p_x_prd_workoper_rec.actual_end_date := l_job_actual_end_date;
222: p_x_prd_workoper_rec.actual_end_hr := TO_NUMBER( TO_CHAR( l_job_actual_end_date, 'HH24' ) );
223: p_x_prd_workoper_rec.actual_end_mi := TO_NUMBER( TO_CHAR( l_job_scheduled_end_date, 'MI' ) );
224: ELSIF ( p_x_prd_workoper_rec.actual_end_date IS NOT NULL AND
225: p_x_prd_workoper_rec.actual_end_date <> FND_API.G_MISS_DATE AND
226: l_job_actual_start_date IS NOT NULL AND
227: TRUNC( p_x_prd_workoper_rec.actual_end_date ) = TRUNC( l_job_actual_start_date ) ) THEN
228: p_x_prd_workoper_rec.actual_end_date := l_job_actual_start_date;
229: p_x_prd_workoper_rec.actual_end_hr := TO_NUMBER( TO_CHAR( l_job_actual_start_date, 'HH24' ) );

Line 254: IF p_x_prd_workoper_rec.SCHEDULED_START_DATE=FND_API.G_MISS_DATE THEN

250: OPEN get_operation_rec(p_x_prd_workoper_rec.WORKORDER_OPERATION_ID);
251: FETCH get_operation_rec INTO l_old_operation_rec;
252: CLOSE get_operation_rec;
253: IF(p_module_type IS NULL OR p_module_type NOT IN ('OAF','JSP'))THEN
254: IF p_x_prd_workoper_rec.SCHEDULED_START_DATE=FND_API.G_MISS_DATE THEN
255: p_x_prd_workoper_rec.SCHEDULED_START_DATE:=NULL;
256: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_DATE IS NULL THEN
257: p_x_prd_workoper_rec.SCHEDULED_START_DATE:=l_old_operation_rec.SCHEDULED_START_DATE;
258: END IF;

Line 259: IF p_x_prd_workoper_rec.SCHEDULED_START_HR=FND_API.G_MISS_NUM THEN

255: p_x_prd_workoper_rec.SCHEDULED_START_DATE:=NULL;
256: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_DATE IS NULL THEN
257: p_x_prd_workoper_rec.SCHEDULED_START_DATE:=l_old_operation_rec.SCHEDULED_START_DATE;
258: END IF;
259: IF p_x_prd_workoper_rec.SCHEDULED_START_HR=FND_API.G_MISS_NUM THEN
260: p_x_prd_workoper_rec.SCHEDULED_START_HR:=NULL;
261: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_HR IS NULL THEN
262: p_x_prd_workoper_rec.SCHEDULED_START_HR:=l_old_operation_rec.SCHEDULED_START_HR;
263: END IF;

Line 265: IF p_x_prd_workoper_rec.SCHEDULED_START_MI=FND_API.G_MISS_NUM THEN

261: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_HR IS NULL THEN
262: p_x_prd_workoper_rec.SCHEDULED_START_HR:=l_old_operation_rec.SCHEDULED_START_HR;
263: END IF;
264:
265: IF p_x_prd_workoper_rec.SCHEDULED_START_MI=FND_API.G_MISS_NUM THEN
266: p_x_prd_workoper_rec.SCHEDULED_START_MI:=NULL;
267: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_MI IS NULL THEN
268: p_x_prd_workoper_rec.SCHEDULED_START_MI:=l_old_operation_rec.SCHEDULED_START_MI;
269: END IF;

Line 271: IF p_x_prd_workoper_rec.SCHEDULED_END_DATE=FND_API.G_MISS_DATE THEN

267: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_MI IS NULL THEN
268: p_x_prd_workoper_rec.SCHEDULED_START_MI:=l_old_operation_rec.SCHEDULED_START_MI;
269: END IF;
270:
271: IF p_x_prd_workoper_rec.SCHEDULED_END_DATE=FND_API.G_MISS_DATE THEN
272: p_x_prd_workoper_rec.SCHEDULED_END_DATE:=NULL;
273: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_DATE IS NULL THEN
274: p_x_prd_workoper_rec.SCHEDULED_END_DATE:=l_old_operation_rec.SCHEDULED_END_DATE;
275: END IF;

Line 277: IF p_x_prd_workoper_rec.SCHEDULED_END_HR=FND_API.G_MISS_NUM THEN

273: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_DATE IS NULL THEN
274: p_x_prd_workoper_rec.SCHEDULED_END_DATE:=l_old_operation_rec.SCHEDULED_END_DATE;
275: END IF;
276:
277: IF p_x_prd_workoper_rec.SCHEDULED_END_HR=FND_API.G_MISS_NUM THEN
278: p_x_prd_workoper_rec.SCHEDULED_END_HR:=NULL;
279: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_HR IS NULL THEN
280: p_x_prd_workoper_rec.SCHEDULED_END_HR:=l_old_operation_rec.SCHEDULED_END_HR;
281: END IF;

Line 283: IF p_x_prd_workoper_rec.SCHEDULED_END_MI=FND_API.G_MISS_NUM THEN

279: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_HR IS NULL THEN
280: p_x_prd_workoper_rec.SCHEDULED_END_HR:=l_old_operation_rec.SCHEDULED_END_HR;
281: END IF;
282:
283: IF p_x_prd_workoper_rec.SCHEDULED_END_MI=FND_API.G_MISS_NUM THEN
284: p_x_prd_workoper_rec.SCHEDULED_END_MI:=NULL;
285: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_MI IS NULL THEN
286: p_x_prd_workoper_rec.SCHEDULED_END_MI:=l_old_operation_rec.SCHEDULED_END_MI;
287: END IF;

Line 289: IF p_x_prd_workoper_rec.ACTUAL_START_DATE=FND_API.G_MISS_DATE THEN

285: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_MI IS NULL THEN
286: p_x_prd_workoper_rec.SCHEDULED_END_MI:=l_old_operation_rec.SCHEDULED_END_MI;
287: END IF;
288:
289: IF p_x_prd_workoper_rec.ACTUAL_START_DATE=FND_API.G_MISS_DATE THEN
290: p_x_prd_workoper_rec.ACTUAL_START_DATE:=NULL;
291: ELSIF p_x_prd_workoper_rec.ACTUAL_START_DATE IS NULL THEN
292: p_x_prd_workoper_rec.ACTUAL_START_DATE:=l_old_operation_rec.ACTUAL_START_DATE;
293: END IF;

Line 295: IF p_x_prd_workoper_rec.ACTUAL_START_HR=FND_API.G_MISS_NUM THEN

291: ELSIF p_x_prd_workoper_rec.ACTUAL_START_DATE IS NULL THEN
292: p_x_prd_workoper_rec.ACTUAL_START_DATE:=l_old_operation_rec.ACTUAL_START_DATE;
293: END IF;
294:
295: IF p_x_prd_workoper_rec.ACTUAL_START_HR=FND_API.G_MISS_NUM THEN
296: p_x_prd_workoper_rec.ACTUAL_START_HR:=NULL;
297: ELSIF p_x_prd_workoper_rec.ACTUAL_START_HR IS NULL THEN
298: p_x_prd_workoper_rec.ACTUAL_START_HR:=l_old_operation_rec.ACTUAL_START_HR;
299: END IF;

Line 301: IF p_x_prd_workoper_rec.ACTUAL_START_MI=FND_API.G_MISS_NUM THEN

297: ELSIF p_x_prd_workoper_rec.ACTUAL_START_HR IS NULL THEN
298: p_x_prd_workoper_rec.ACTUAL_START_HR:=l_old_operation_rec.ACTUAL_START_HR;
299: END IF;
300:
301: IF p_x_prd_workoper_rec.ACTUAL_START_MI=FND_API.G_MISS_NUM THEN
302: p_x_prd_workoper_rec.ACTUAL_START_MI:=NULL;
303: ELSIF p_x_prd_workoper_rec.ACTUAL_START_MI IS NULL THEN
304: p_x_prd_workoper_rec.ACTUAL_START_MI:=l_old_operation_rec.ACTUAL_START_MI;
305: END IF;

Line 307: IF p_x_prd_workoper_rec.ACTUAL_END_DATE=FND_API.G_MISS_DATE THEN

303: ELSIF p_x_prd_workoper_rec.ACTUAL_START_MI IS NULL THEN
304: p_x_prd_workoper_rec.ACTUAL_START_MI:=l_old_operation_rec.ACTUAL_START_MI;
305: END IF;
306:
307: IF p_x_prd_workoper_rec.ACTUAL_END_DATE=FND_API.G_MISS_DATE THEN
308: p_x_prd_workoper_rec.ACTUAL_END_DATE:=NULL;
309: ELSIF p_x_prd_workoper_rec.ACTUAL_END_DATE IS NULL THEN
310: p_x_prd_workoper_rec.ACTUAL_END_DATE:=l_old_operation_rec.ACTUAL_END_DATE;
311: END IF;

Line 313: IF p_x_prd_workoper_rec.ACTUAL_END_HR=FND_API.G_MISS_NUM THEN

309: ELSIF p_x_prd_workoper_rec.ACTUAL_END_DATE IS NULL THEN
310: p_x_prd_workoper_rec.ACTUAL_END_DATE:=l_old_operation_rec.ACTUAL_END_DATE;
311: END IF;
312:
313: IF p_x_prd_workoper_rec.ACTUAL_END_HR=FND_API.G_MISS_NUM THEN
314: p_x_prd_workoper_rec.ACTUAL_END_HR:=NULL;
315: ELSIF p_x_prd_workoper_rec.ACTUAL_END_HR IS NULL THEN
316: p_x_prd_workoper_rec.ACTUAL_END_HR:=l_old_operation_rec.ACTUAL_END_HR;
317: END IF;

Line 319: IF p_x_prd_workoper_rec.ACTUAL_END_MI=FND_API.G_MISS_NUM THEN

315: ELSIF p_x_prd_workoper_rec.ACTUAL_END_HR IS NULL THEN
316: p_x_prd_workoper_rec.ACTUAL_END_HR:=l_old_operation_rec.ACTUAL_END_HR;
317: END IF;
318:
319: IF p_x_prd_workoper_rec.ACTUAL_END_MI=FND_API.G_MISS_NUM THEN
320: p_x_prd_workoper_rec.ACTUAL_END_MI:=NULL;
321: ELSIF p_x_prd_workoper_rec.ACTUAL_END_MI IS NULL THEN
322: p_x_prd_workoper_rec.ACTUAL_END_MI:=l_old_operation_rec.ACTUAL_END_MI;
323: END IF;

Line 326: IF p_x_prd_workoper_rec.SCHEDULED_START_HR=FND_API.G_MISS_NUM THEN

322: p_x_prd_workoper_rec.ACTUAL_END_MI:=l_old_operation_rec.ACTUAL_END_MI;
323: END IF;
324: ELSIF p_module_type = 'JSP' THEN
325: IF p_x_prd_workoper_rec.SCHEDULED_START_DATE IS NOT NULL THEN
326: IF p_x_prd_workoper_rec.SCHEDULED_START_HR=FND_API.G_MISS_NUM THEN
327: p_x_prd_workoper_rec.SCHEDULED_START_HR:=NULL;
328: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_HR IS NULL THEN
329: p_x_prd_workoper_rec.SCHEDULED_START_HR:=l_old_operation_rec.SCHEDULED_START_HR;
330: END IF;

Line 331: IF p_x_prd_workoper_rec.SCHEDULED_START_MI=FND_API.G_MISS_NUM THEN

327: p_x_prd_workoper_rec.SCHEDULED_START_HR:=NULL;
328: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_HR IS NULL THEN
329: p_x_prd_workoper_rec.SCHEDULED_START_HR:=l_old_operation_rec.SCHEDULED_START_HR;
330: END IF;
331: IF p_x_prd_workoper_rec.SCHEDULED_START_MI=FND_API.G_MISS_NUM THEN
332: p_x_prd_workoper_rec.SCHEDULED_START_MI:=NULL;
333: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_MI IS NULL THEN
334: p_x_prd_workoper_rec.SCHEDULED_START_MI:=l_old_operation_rec.SCHEDULED_START_MI;
335: END IF;

Line 339: IF p_x_prd_workoper_rec.SCHEDULED_END_HR=FND_API.G_MISS_NUM THEN

335: END IF;
336: END IF;
337:
338: IF p_x_prd_workoper_rec.SCHEDULED_END_DATE IS NOT NULL THEN
339: IF p_x_prd_workoper_rec.SCHEDULED_END_HR=FND_API.G_MISS_NUM THEN
340: p_x_prd_workoper_rec.SCHEDULED_END_HR:=NULL;
341: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_HR IS NULL THEN
342: p_x_prd_workoper_rec.SCHEDULED_END_HR:=l_old_operation_rec.SCHEDULED_END_HR;
343: END IF;

Line 344: IF p_x_prd_workoper_rec.SCHEDULED_END_MI=FND_API.G_MISS_NUM THEN

340: p_x_prd_workoper_rec.SCHEDULED_END_HR:=NULL;
341: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_HR IS NULL THEN
342: p_x_prd_workoper_rec.SCHEDULED_END_HR:=l_old_operation_rec.SCHEDULED_END_HR;
343: END IF;
344: IF p_x_prd_workoper_rec.SCHEDULED_END_MI=FND_API.G_MISS_NUM THEN
345: p_x_prd_workoper_rec.SCHEDULED_END_MI:=NULL;
346: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_MI IS NULL THEN
347: p_x_prd_workoper_rec.SCHEDULED_END_MI:=l_old_operation_rec.SCHEDULED_END_MI;
348: END IF;

Line 352: IF p_x_prd_workoper_rec.ACTUAL_START_HR=FND_API.G_MISS_NUM THEN

348: END IF;
349: END IF;
350:
351: IF p_x_prd_workoper_rec.ACTUAL_START_DATE IS NOT NULL THEN
352: IF p_x_prd_workoper_rec.ACTUAL_START_HR=FND_API.G_MISS_NUM THEN
353: p_x_prd_workoper_rec.ACTUAL_START_HR:=NULL;
354: ELSIF p_x_prd_workoper_rec.ACTUAL_START_HR IS NULL THEN
355: p_x_prd_workoper_rec.ACTUAL_START_HR:=l_old_operation_rec.ACTUAL_START_HR;
356: END IF;

Line 358: IF p_x_prd_workoper_rec.ACTUAL_START_MI=FND_API.G_MISS_NUM THEN

354: ELSIF p_x_prd_workoper_rec.ACTUAL_START_HR IS NULL THEN
355: p_x_prd_workoper_rec.ACTUAL_START_HR:=l_old_operation_rec.ACTUAL_START_HR;
356: END IF;
357:
358: IF p_x_prd_workoper_rec.ACTUAL_START_MI=FND_API.G_MISS_NUM THEN
359: p_x_prd_workoper_rec.ACTUAL_START_MI:=NULL;
360: ELSIF p_x_prd_workoper_rec.ACTUAL_START_MI IS NULL THEN
361: p_x_prd_workoper_rec.ACTUAL_START_MI:=l_old_operation_rec.ACTUAL_START_MI;
362: END IF;

Line 366: IF p_x_prd_workoper_rec.ACTUAL_END_HR=FND_API.G_MISS_NUM THEN

362: END IF;
363: END IF;
364:
365: IF p_x_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL THEN
366: IF p_x_prd_workoper_rec.ACTUAL_END_HR=FND_API.G_MISS_NUM THEN
367: p_x_prd_workoper_rec.ACTUAL_END_HR:=NULL;
368: ELSIF p_x_prd_workoper_rec.ACTUAL_END_HR IS NULL THEN
369: p_x_prd_workoper_rec.ACTUAL_END_HR:=l_old_operation_rec.ACTUAL_END_HR;
370: END IF;

Line 371: IF p_x_prd_workoper_rec.ACTUAL_END_MI=FND_API.G_MISS_NUM THEN

367: p_x_prd_workoper_rec.ACTUAL_END_HR:=NULL;
368: ELSIF p_x_prd_workoper_rec.ACTUAL_END_HR IS NULL THEN
369: p_x_prd_workoper_rec.ACTUAL_END_HR:=l_old_operation_rec.ACTUAL_END_HR;
370: END IF;
371: IF p_x_prd_workoper_rec.ACTUAL_END_MI=FND_API.G_MISS_NUM THEN
372: p_x_prd_workoper_rec.ACTUAL_END_MI:=NULL;
373: ELSIF p_x_prd_workoper_rec.ACTUAL_END_MI IS NULL THEN
374: p_x_prd_workoper_rec.ACTUAL_END_MI:=l_old_operation_rec.ACTUAL_END_MI;
375: END IF;

Line 379: IF p_x_prd_workoper_rec.DEPARTMENT_ID= FND_API.G_MISS_NUM THEN

375: END IF;
376: END IF;
377: END IF;
378:
379: IF p_x_prd_workoper_rec.DEPARTMENT_ID= FND_API.G_MISS_NUM THEN
380: p_x_prd_workoper_rec.DEPARTMENT_ID:=NULL;
381: ELSIF p_x_prd_workoper_rec.DEPARTMENT_ID IS NULL THEN
382: p_x_prd_workoper_rec.DEPARTMENT_ID:=l_old_operation_rec.DEPARTMENT_ID;
383: END IF;

Line 385: IF p_x_prd_workoper_rec.DEPARTMENT_NAME= FND_API.G_MISS_CHAR THEN

381: ELSIF p_x_prd_workoper_rec.DEPARTMENT_ID IS NULL THEN
382: p_x_prd_workoper_rec.DEPARTMENT_ID:=l_old_operation_rec.DEPARTMENT_ID;
383: END IF;
384:
385: IF p_x_prd_workoper_rec.DEPARTMENT_NAME= FND_API.G_MISS_CHAR THEN
386: p_x_prd_workoper_rec.DEPARTMENT_NAME:=NULL;
387: ELSIF p_x_prd_workoper_rec.DEPARTMENT_NAME IS NULL THEN
388: p_x_prd_workoper_rec.DEPARTMENT_NAME:=l_old_operation_rec.DEPARTMENT_NAME;
389: END IF;

Line 391: IF p_x_prd_workoper_rec.STATUS_CODE= FND_API.G_MISS_CHAR THEN

387: ELSIF p_x_prd_workoper_rec.DEPARTMENT_NAME IS NULL THEN
388: p_x_prd_workoper_rec.DEPARTMENT_NAME:=l_old_operation_rec.DEPARTMENT_NAME;
389: END IF;
390:
391: IF p_x_prd_workoper_rec.STATUS_CODE= FND_API.G_MISS_CHAR THEN
392: p_x_prd_workoper_rec.STATUS_CODE:=NULL;
393: ELSIF p_x_prd_workoper_rec.STATUS_CODE IS NULL THEN
394: p_x_prd_workoper_rec.STATUS_CODE:=l_old_operation_rec.STATUS_CODE;
395: END IF;

Line 397: IF p_x_prd_workoper_rec.STATUS_MEANING= FND_API.G_MISS_CHAR THEN

393: ELSIF p_x_prd_workoper_rec.STATUS_CODE IS NULL THEN
394: p_x_prd_workoper_rec.STATUS_CODE:=l_old_operation_rec.STATUS_CODE;
395: END IF;
396:
397: IF p_x_prd_workoper_rec.STATUS_MEANING= FND_API.G_MISS_CHAR THEN
398: p_x_prd_workoper_rec.STATUS_MEANING:=NULL;
399: ELSIF p_x_prd_workoper_rec.STATUS_MEANING IS NULL THEN
400: p_x_prd_workoper_rec.STATUS_MEANING:=l_old_operation_rec.STATUS;
401: END IF;

Line 403: IF p_x_prd_workoper_rec.OPERATION_ID= FND_API.G_MISS_NUM THEN

399: ELSIF p_x_prd_workoper_rec.STATUS_MEANING IS NULL THEN
400: p_x_prd_workoper_rec.STATUS_MEANING:=l_old_operation_rec.STATUS;
401: END IF;
402:
403: IF p_x_prd_workoper_rec.OPERATION_ID= FND_API.G_MISS_NUM THEN
404: p_x_prd_workoper_rec.OPERATION_ID:=NULL;
405: ELSIF p_x_prd_workoper_rec.OPERATION_ID IS NULL THEN
406: p_x_prd_workoper_rec.OPERATION_ID:=l_old_operation_rec.OPERATION_ID;
407: END IF;

Line 409: IF p_x_prd_workoper_rec.OPERATION_CODE= FND_API.G_MISS_CHAR THEN

405: ELSIF p_x_prd_workoper_rec.OPERATION_ID IS NULL THEN
406: p_x_prd_workoper_rec.OPERATION_ID:=l_old_operation_rec.OPERATION_ID;
407: END IF;
408:
409: IF p_x_prd_workoper_rec.OPERATION_CODE= FND_API.G_MISS_CHAR THEN
410: p_x_prd_workoper_rec.OPERATION_CODE:=NULL;
411: ELSIF p_x_prd_workoper_rec.OPERATION_CODE IS NULL THEN
412: p_x_prd_workoper_rec.OPERATION_CODE:=l_old_operation_rec.OPERATION_CODE;
413: END IF;

Line 415: IF p_x_prd_workoper_rec.OPERATION_TYPE_CODE= FND_API.G_MISS_CHAR THEN

411: ELSIF p_x_prd_workoper_rec.OPERATION_CODE IS NULL THEN
412: p_x_prd_workoper_rec.OPERATION_CODE:=l_old_operation_rec.OPERATION_CODE;
413: END IF;
414:
415: IF p_x_prd_workoper_rec.OPERATION_TYPE_CODE= FND_API.G_MISS_CHAR THEN
416: p_x_prd_workoper_rec.OPERATION_TYPE_CODE:=NULL;
417: ELSIF p_x_prd_workoper_rec.OPERATION_TYPE_CODE IS NULL THEN
418: p_x_prd_workoper_rec.OPERATION_TYPE_CODE:=l_old_operation_rec.OPERATION_TYPE_CODE;
419: END IF;

Line 421: IF p_x_prd_workoper_rec.OPERATION_TYPE= FND_API.G_MISS_CHAR THEN

417: ELSIF p_x_prd_workoper_rec.OPERATION_TYPE_CODE IS NULL THEN
418: p_x_prd_workoper_rec.OPERATION_TYPE_CODE:=l_old_operation_rec.OPERATION_TYPE_CODE;
419: END IF;
420:
421: IF p_x_prd_workoper_rec.OPERATION_TYPE= FND_API.G_MISS_CHAR THEN
422: p_x_prd_workoper_rec.OPERATION_TYPE:=NULL;
423: ELSIF p_x_prd_workoper_rec.OPERATION_TYPE IS NULL THEN
424: p_x_prd_workoper_rec.OPERATION_TYPE:=l_old_operation_rec.OPERATION_TYPE;
425: END IF;

Line 427: IF p_x_prd_workoper_rec.PLAN_ID= FND_API.G_MISS_NUM THEN

423: ELSIF p_x_prd_workoper_rec.OPERATION_TYPE IS NULL THEN
424: p_x_prd_workoper_rec.OPERATION_TYPE:=l_old_operation_rec.OPERATION_TYPE;
425: END IF;
426:
427: IF p_x_prd_workoper_rec.PLAN_ID= FND_API.G_MISS_NUM THEN
428: p_x_prd_workoper_rec.PLAN_ID:=NULL;
429: ELSIF p_x_prd_workoper_rec.PLAN_ID IS NULL THEN
430: p_x_prd_workoper_rec.PLAN_ID:=l_old_operation_rec.PLAN_ID;
431: END IF;

Line 433: IF p_x_prd_workoper_rec.COLLECTION_ID= FND_API.G_MISS_NUM THEN

429: ELSIF p_x_prd_workoper_rec.PLAN_ID IS NULL THEN
430: p_x_prd_workoper_rec.PLAN_ID:=l_old_operation_rec.PLAN_ID;
431: END IF;
432:
433: IF p_x_prd_workoper_rec.COLLECTION_ID= FND_API.G_MISS_NUM THEN
434: p_x_prd_workoper_rec.COLLECTION_ID:=NULL;
435: ELSIF p_x_prd_workoper_rec.COLLECTION_ID IS NULL THEN
436: p_x_prd_workoper_rec.COLLECTION_ID:=l_old_operation_rec.COLLECTION_ID;
437: END IF;

Line 439: IF p_x_prd_workoper_rec.OPERATION_DESCRIPTION= FND_API.G_MISS_CHAR THEN

435: ELSIF p_x_prd_workoper_rec.COLLECTION_ID IS NULL THEN
436: p_x_prd_workoper_rec.COLLECTION_ID:=l_old_operation_rec.COLLECTION_ID;
437: END IF;
438:
439: IF p_x_prd_workoper_rec.OPERATION_DESCRIPTION= FND_API.G_MISS_CHAR THEN
440: p_x_prd_workoper_rec.OPERATION_DESCRIPTION:=NULL;
441: ELSIF p_x_prd_workoper_rec.OPERATION_DESCRIPTION IS NULL THEN
442: p_x_prd_workoper_rec.OPERATION_DESCRIPTION:=l_old_operation_rec.DESCRIPTION;
443: END IF;

Line 445: IF p_x_prd_workoper_rec.ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR THEN

441: ELSIF p_x_prd_workoper_rec.OPERATION_DESCRIPTION IS NULL THEN
442: p_x_prd_workoper_rec.OPERATION_DESCRIPTION:=l_old_operation_rec.DESCRIPTION;
443: END IF;
444:
445: IF p_x_prd_workoper_rec.ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR THEN
446: p_x_prd_workoper_rec.ATTRIBUTE_CATEGORY:=NULL;
447: ELSIF p_x_prd_workoper_rec.ATTRIBUTE_CATEGORY IS NULL THEN
448: p_x_prd_workoper_rec.ATTRIBUTE_CATEGORY:=l_old_operation_rec.ATTRIBUTE_CATEGORY;
449: END IF;

Line 451: IF p_x_prd_workoper_rec.ATTRIBUTE1= FND_API.G_MISS_CHAR THEN

447: ELSIF p_x_prd_workoper_rec.ATTRIBUTE_CATEGORY IS NULL THEN
448: p_x_prd_workoper_rec.ATTRIBUTE_CATEGORY:=l_old_operation_rec.ATTRIBUTE_CATEGORY;
449: END IF;
450:
451: IF p_x_prd_workoper_rec.ATTRIBUTE1= FND_API.G_MISS_CHAR THEN
452: p_x_prd_workoper_rec.ATTRIBUTE1:=NULL;
453: ELSIF p_x_prd_workoper_rec.ATTRIBUTE1 IS NULL THEN
454: p_x_prd_workoper_rec.ATTRIBUTE1:=l_old_operation_rec.ATTRIBUTE1;
455: END IF;

Line 457: IF p_x_prd_workoper_rec.ATTRIBUTE2= FND_API.G_MISS_CHAR THEN

453: ELSIF p_x_prd_workoper_rec.ATTRIBUTE1 IS NULL THEN
454: p_x_prd_workoper_rec.ATTRIBUTE1:=l_old_operation_rec.ATTRIBUTE1;
455: END IF;
456:
457: IF p_x_prd_workoper_rec.ATTRIBUTE2= FND_API.G_MISS_CHAR THEN
458: p_x_prd_workoper_rec.ATTRIBUTE2:=NULL;
459: ELSIF p_x_prd_workoper_rec.ATTRIBUTE2 IS NULL THEN
460: p_x_prd_workoper_rec.ATTRIBUTE2:=l_old_operation_rec.ATTRIBUTE2;
461: END IF;

Line 463: IF p_x_prd_workoper_rec.ATTRIBUTE3= FND_API.G_MISS_CHAR THEN

459: ELSIF p_x_prd_workoper_rec.ATTRIBUTE2 IS NULL THEN
460: p_x_prd_workoper_rec.ATTRIBUTE2:=l_old_operation_rec.ATTRIBUTE2;
461: END IF;
462:
463: IF p_x_prd_workoper_rec.ATTRIBUTE3= FND_API.G_MISS_CHAR THEN
464: p_x_prd_workoper_rec.ATTRIBUTE3:=NULL;
465: ELSIF p_x_prd_workoper_rec.ATTRIBUTE3 IS NULL THEN
466: p_x_prd_workoper_rec.ATTRIBUTE3:=l_old_operation_rec.ATTRIBUTE3;
467: END IF;

Line 469: IF p_x_prd_workoper_rec.ATTRIBUTE4= FND_API.G_MISS_CHAR THEN

465: ELSIF p_x_prd_workoper_rec.ATTRIBUTE3 IS NULL THEN
466: p_x_prd_workoper_rec.ATTRIBUTE3:=l_old_operation_rec.ATTRIBUTE3;
467: END IF;
468:
469: IF p_x_prd_workoper_rec.ATTRIBUTE4= FND_API.G_MISS_CHAR THEN
470: p_x_prd_workoper_rec.ATTRIBUTE4:=NULL;
471: ELSIF p_x_prd_workoper_rec.ATTRIBUTE4 IS NULL THEN
472: p_x_prd_workoper_rec.ATTRIBUTE4:=l_old_operation_rec.ATTRIBUTE4;
473: END IF;

Line 475: IF p_x_prd_workoper_rec.ATTRIBUTE5= FND_API.G_MISS_CHAR THEN

471: ELSIF p_x_prd_workoper_rec.ATTRIBUTE4 IS NULL THEN
472: p_x_prd_workoper_rec.ATTRIBUTE4:=l_old_operation_rec.ATTRIBUTE4;
473: END IF;
474:
475: IF p_x_prd_workoper_rec.ATTRIBUTE5= FND_API.G_MISS_CHAR THEN
476: p_x_prd_workoper_rec.ATTRIBUTE5:=NULL;
477: ELSIF p_x_prd_workoper_rec.ATTRIBUTE5 IS NULL THEN
478: p_x_prd_workoper_rec.ATTRIBUTE5:=l_old_operation_rec.ATTRIBUTE5;
479: END IF;

Line 481: IF p_x_prd_workoper_rec.ATTRIBUTE6= FND_API.G_MISS_CHAR THEN

477: ELSIF p_x_prd_workoper_rec.ATTRIBUTE5 IS NULL THEN
478: p_x_prd_workoper_rec.ATTRIBUTE5:=l_old_operation_rec.ATTRIBUTE5;
479: END IF;
480:
481: IF p_x_prd_workoper_rec.ATTRIBUTE6= FND_API.G_MISS_CHAR THEN
482: p_x_prd_workoper_rec.ATTRIBUTE6:=NULL;
483: ELSIF p_x_prd_workoper_rec.ATTRIBUTE6 IS NULL THEN
484: p_x_prd_workoper_rec.ATTRIBUTE6:=l_old_operation_rec.ATTRIBUTE6;
485: END IF;

Line 487: IF p_x_prd_workoper_rec.ATTRIBUTE7= FND_API.G_MISS_CHAR THEN

483: ELSIF p_x_prd_workoper_rec.ATTRIBUTE6 IS NULL THEN
484: p_x_prd_workoper_rec.ATTRIBUTE6:=l_old_operation_rec.ATTRIBUTE6;
485: END IF;
486:
487: IF p_x_prd_workoper_rec.ATTRIBUTE7= FND_API.G_MISS_CHAR THEN
488: p_x_prd_workoper_rec.ATTRIBUTE7:=NULL;
489: ELSIF p_x_prd_workoper_rec.ATTRIBUTE7 IS NULL THEN
490: p_x_prd_workoper_rec.ATTRIBUTE7:=l_old_operation_rec.ATTRIBUTE7;
491: END IF;

Line 493: IF p_x_prd_workoper_rec.ATTRIBUTE8= FND_API.G_MISS_CHAR THEN

489: ELSIF p_x_prd_workoper_rec.ATTRIBUTE7 IS NULL THEN
490: p_x_prd_workoper_rec.ATTRIBUTE7:=l_old_operation_rec.ATTRIBUTE7;
491: END IF;
492:
493: IF p_x_prd_workoper_rec.ATTRIBUTE8= FND_API.G_MISS_CHAR THEN
494: p_x_prd_workoper_rec.ATTRIBUTE8:=NULL;
495: ELSIF p_x_prd_workoper_rec.ATTRIBUTE8 IS NULL THEN
496: p_x_prd_workoper_rec.ATTRIBUTE8:=l_old_operation_rec.ATTRIBUTE8;
497: END IF;

Line 499: IF p_x_prd_workoper_rec.ATTRIBUTE9= FND_API.G_MISS_CHAR THEN

495: ELSIF p_x_prd_workoper_rec.ATTRIBUTE8 IS NULL THEN
496: p_x_prd_workoper_rec.ATTRIBUTE8:=l_old_operation_rec.ATTRIBUTE8;
497: END IF;
498:
499: IF p_x_prd_workoper_rec.ATTRIBUTE9= FND_API.G_MISS_CHAR THEN
500: p_x_prd_workoper_rec.ATTRIBUTE9:=NULL;
501: ELSIF p_x_prd_workoper_rec.ATTRIBUTE9 IS NULL THEN
502: p_x_prd_workoper_rec.ATTRIBUTE9:=l_old_operation_rec.ATTRIBUTE9;
503: END IF;

Line 505: IF p_x_prd_workoper_rec.ATTRIBUTE10= FND_API.G_MISS_CHAR THEN

501: ELSIF p_x_prd_workoper_rec.ATTRIBUTE9 IS NULL THEN
502: p_x_prd_workoper_rec.ATTRIBUTE9:=l_old_operation_rec.ATTRIBUTE9;
503: END IF;
504:
505: IF p_x_prd_workoper_rec.ATTRIBUTE10= FND_API.G_MISS_CHAR THEN
506: p_x_prd_workoper_rec.ATTRIBUTE10:=NULL;
507: ELSIF p_x_prd_workoper_rec.ATTRIBUTE10 IS NULL THEN
508: p_x_prd_workoper_rec.ATTRIBUTE10:=l_old_operation_rec.ATTRIBUTE10;
509: END IF;

Line 511: IF p_x_prd_workoper_rec.ATTRIBUTE11= FND_API.G_MISS_CHAR THEN

507: ELSIF p_x_prd_workoper_rec.ATTRIBUTE10 IS NULL THEN
508: p_x_prd_workoper_rec.ATTRIBUTE10:=l_old_operation_rec.ATTRIBUTE10;
509: END IF;
510:
511: IF p_x_prd_workoper_rec.ATTRIBUTE11= FND_API.G_MISS_CHAR THEN
512: p_x_prd_workoper_rec.ATTRIBUTE11:=NULL;
513: ELSIF p_x_prd_workoper_rec.ATTRIBUTE11 IS NULL THEN
514: p_x_prd_workoper_rec.ATTRIBUTE11:=l_old_operation_rec.ATTRIBUTE11;
515: END IF;

Line 517: IF p_x_prd_workoper_rec.ATTRIBUTE12= FND_API.G_MISS_CHAR THEN

513: ELSIF p_x_prd_workoper_rec.ATTRIBUTE11 IS NULL THEN
514: p_x_prd_workoper_rec.ATTRIBUTE11:=l_old_operation_rec.ATTRIBUTE11;
515: END IF;
516:
517: IF p_x_prd_workoper_rec.ATTRIBUTE12= FND_API.G_MISS_CHAR THEN
518: p_x_prd_workoper_rec.ATTRIBUTE12:=NULL;
519: ELSIF p_x_prd_workoper_rec.ATTRIBUTE12 IS NULL THEN
520: p_x_prd_workoper_rec.ATTRIBUTE12:=l_old_operation_rec.ATTRIBUTE12;
521: END IF;

Line 523: IF p_x_prd_workoper_rec.ATTRIBUTE13= FND_API.G_MISS_CHAR THEN

519: ELSIF p_x_prd_workoper_rec.ATTRIBUTE12 IS NULL THEN
520: p_x_prd_workoper_rec.ATTRIBUTE12:=l_old_operation_rec.ATTRIBUTE12;
521: END IF;
522:
523: IF p_x_prd_workoper_rec.ATTRIBUTE13= FND_API.G_MISS_CHAR THEN
524: p_x_prd_workoper_rec.ATTRIBUTE13:=NULL;
525: ELSIF p_x_prd_workoper_rec.ATTRIBUTE13 IS NULL THEN
526: p_x_prd_workoper_rec.ATTRIBUTE13:=l_old_operation_rec.ATTRIBUTE13;
527: END IF;

Line 529: IF p_x_prd_workoper_rec.ATTRIBUTE14= FND_API.G_MISS_CHAR THEN

525: ELSIF p_x_prd_workoper_rec.ATTRIBUTE13 IS NULL THEN
526: p_x_prd_workoper_rec.ATTRIBUTE13:=l_old_operation_rec.ATTRIBUTE13;
527: END IF;
528:
529: IF p_x_prd_workoper_rec.ATTRIBUTE14= FND_API.G_MISS_CHAR THEN
530: p_x_prd_workoper_rec.ATTRIBUTE14:=NULL;
531: ELSIF p_x_prd_workoper_rec.ATTRIBUTE14 IS NULL THEN
532: p_x_prd_workoper_rec.ATTRIBUTE14:=l_old_operation_rec.ATTRIBUTE14;
533: END IF;

Line 535: IF p_x_prd_workoper_rec.ATTRIBUTE15= FND_API.G_MISS_CHAR THEN

531: ELSIF p_x_prd_workoper_rec.ATTRIBUTE14 IS NULL THEN
532: p_x_prd_workoper_rec.ATTRIBUTE14:=l_old_operation_rec.ATTRIBUTE14;
533: END IF;
534:
535: IF p_x_prd_workoper_rec.ATTRIBUTE15= FND_API.G_MISS_CHAR THEN
536: p_x_prd_workoper_rec.ATTRIBUTE15:=NULL;
537: ELSIF p_x_prd_workoper_rec.ATTRIBUTE15 IS NULL THEN
538: p_x_prd_workoper_rec.ATTRIBUTE15:=l_old_operation_rec.ATTRIBUTE15;
539: END IF;

Line 541: IF p_x_prd_workoper_rec.WORKORDER_OPERATION_ID= FND_API.G_MISS_NUM THEN

537: ELSIF p_x_prd_workoper_rec.ATTRIBUTE15 IS NULL THEN
538: p_x_prd_workoper_rec.ATTRIBUTE15:=l_old_operation_rec.ATTRIBUTE15;
539: END IF;
540:
541: IF p_x_prd_workoper_rec.WORKORDER_OPERATION_ID= FND_API.G_MISS_NUM THEN
542: p_x_prd_workoper_rec.WORKORDER_OPERATION_ID:=NULL;
543: ELSIF p_x_prd_workoper_rec.WORKORDER_OPERATION_ID IS NULL THEN
544: p_x_prd_workoper_rec.WORKORDER_OPERATION_ID:=l_old_operation_rec.WORKORDER_OPERATION_ID;
545: END IF;

Line 547: IF p_x_prd_workoper_rec.ORGANIZATION_ID= FND_API.G_MISS_NUM THEN

543: ELSIF p_x_prd_workoper_rec.WORKORDER_OPERATION_ID IS NULL THEN
544: p_x_prd_workoper_rec.WORKORDER_OPERATION_ID:=l_old_operation_rec.WORKORDER_OPERATION_ID;
545: END IF;
546:
547: IF p_x_prd_workoper_rec.ORGANIZATION_ID= FND_API.G_MISS_NUM THEN
548: p_x_prd_workoper_rec.ORGANIZATION_ID:=NULL;
549: ELSIF p_x_prd_workoper_rec.ORGANIZATION_ID IS NULL THEN
550: p_x_prd_workoper_rec.ORGANIZATION_ID:=l_old_operation_rec.ORGANIZATION_ID;
551: END IF;

Line 553: IF p_x_prd_workoper_rec.OPERATION_SEQUENCE_NUM= FND_API.G_MISS_NUM THEN

549: ELSIF p_x_prd_workoper_rec.ORGANIZATION_ID IS NULL THEN
550: p_x_prd_workoper_rec.ORGANIZATION_ID:=l_old_operation_rec.ORGANIZATION_ID;
551: END IF;
552:
553: IF p_x_prd_workoper_rec.OPERATION_SEQUENCE_NUM= FND_API.G_MISS_NUM THEN
554: p_x_prd_workoper_rec.OPERATION_SEQUENCE_NUM:=NULL;
555: ELSIF p_x_prd_workoper_rec.OPERATION_SEQUENCE_NUM IS NULL THEN
556: p_x_prd_workoper_rec.OPERATION_SEQUENCE_NUM:=l_old_operation_rec.OPERATION_SEQUENCE_NUM;
557: END IF;

Line 559: IF p_x_prd_workoper_rec.WORKORDER_ID= FND_API.G_MISS_NUM THEN

555: ELSIF p_x_prd_workoper_rec.OPERATION_SEQUENCE_NUM IS NULL THEN
556: p_x_prd_workoper_rec.OPERATION_SEQUENCE_NUM:=l_old_operation_rec.OPERATION_SEQUENCE_NUM;
557: END IF;
558:
559: IF p_x_prd_workoper_rec.WORKORDER_ID= FND_API.G_MISS_NUM THEN
560: p_x_prd_workoper_rec.WORKORDER_ID:=NULL;
561: ELSIF p_x_prd_workoper_rec.WORKORDER_ID IS NULL THEN
562: p_x_prd_workoper_rec.WORKORDER_ID:=l_old_operation_rec.WORKORDER_ID;
563: END IF;

Line 565: IF p_x_prd_workoper_rec.WIP_ENTITY_ID= FND_API.G_MISS_NUM THEN

561: ELSIF p_x_prd_workoper_rec.WORKORDER_ID IS NULL THEN
562: p_x_prd_workoper_rec.WORKORDER_ID:=l_old_operation_rec.WORKORDER_ID;
563: END IF;
564:
565: IF p_x_prd_workoper_rec.WIP_ENTITY_ID= FND_API.G_MISS_NUM THEN
566: p_x_prd_workoper_rec.WIP_ENTITY_ID:=NULL;
567: ELSIF p_x_prd_workoper_rec.WIP_ENTITY_ID IS NULL THEN
568: p_x_prd_workoper_rec.WIP_ENTITY_ID:=l_old_operation_rec.WIP_ENTITY_ID;
569: END IF;

Line 571: IF p_x_prd_workoper_rec.OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM THEN

567: ELSIF p_x_prd_workoper_rec.WIP_ENTITY_ID IS NULL THEN
568: p_x_prd_workoper_rec.WIP_ENTITY_ID:=l_old_operation_rec.WIP_ENTITY_ID;
569: END IF;
570:
571: IF p_x_prd_workoper_rec.OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM THEN
572: p_x_prd_workoper_rec.OBJECT_VERSION_NUMBER:=NULL;
573: ELSIF p_x_prd_workoper_rec.OBJECT_VERSION_NUMBER IS NULL THEN
574: p_x_prd_workoper_rec.OBJECT_VERSION_NUMBER:=l_old_operation_rec.OBJECT_VERSION_NUMBER;
575: END IF;

Line 577: IF p_x_prd_workoper_rec.LAST_UPDATE_DATE=FND_API.G_MISS_DATE THEN

573: ELSIF p_x_prd_workoper_rec.OBJECT_VERSION_NUMBER IS NULL THEN
574: p_x_prd_workoper_rec.OBJECT_VERSION_NUMBER:=l_old_operation_rec.OBJECT_VERSION_NUMBER;
575: END IF;
576:
577: IF p_x_prd_workoper_rec.LAST_UPDATE_DATE=FND_API.G_MISS_DATE THEN
578: p_x_prd_workoper_rec.LAST_UPDATE_DATE:=NULL;
579: ELSIF p_x_prd_workoper_rec.LAST_UPDATE_DATE IS NULL THEN
580: p_x_prd_workoper_rec.LAST_UPDATE_DATE:=l_old_operation_rec.LAST_UPDATE_DATE;
581: END IF;

Line 583: IF p_x_prd_workoper_rec.LAST_UPDATED_BY= FND_API.G_MISS_NUM THEN

579: ELSIF p_x_prd_workoper_rec.LAST_UPDATE_DATE IS NULL THEN
580: p_x_prd_workoper_rec.LAST_UPDATE_DATE:=l_old_operation_rec.LAST_UPDATE_DATE;
581: END IF;
582:
583: IF p_x_prd_workoper_rec.LAST_UPDATED_BY= FND_API.G_MISS_NUM THEN
584: p_x_prd_workoper_rec.LAST_UPDATED_BY:=NULL;
585: ELSIF p_x_prd_workoper_rec.LAST_UPDATED_BY IS NULL THEN
586: p_x_prd_workoper_rec.LAST_UPDATED_BY:=l_old_operation_rec.LAST_UPDATED_BY;
587: END IF;

Line 589: IF p_x_prd_workoper_rec.CREATION_DATE=FND_API.G_MISS_DATE THEN

585: ELSIF p_x_prd_workoper_rec.LAST_UPDATED_BY IS NULL THEN
586: p_x_prd_workoper_rec.LAST_UPDATED_BY:=l_old_operation_rec.LAST_UPDATED_BY;
587: END IF;
588:
589: IF p_x_prd_workoper_rec.CREATION_DATE=FND_API.G_MISS_DATE THEN
590: p_x_prd_workoper_rec.CREATION_DATE:=NULL;
591: ELSIF p_x_prd_workoper_rec.CREATION_DATE IS NULL THEN
592: p_x_prd_workoper_rec.CREATION_DATE:=l_old_operation_rec.CREATION_DATE;
593: END IF;

Line 595: IF p_x_prd_workoper_rec.CREATED_BY= FND_API.G_MISS_NUM THEN

591: ELSIF p_x_prd_workoper_rec.CREATION_DATE IS NULL THEN
592: p_x_prd_workoper_rec.CREATION_DATE:=l_old_operation_rec.CREATION_DATE;
593: END IF;
594:
595: IF p_x_prd_workoper_rec.CREATED_BY= FND_API.G_MISS_NUM THEN
596: p_x_prd_workoper_rec.CREATED_BY:=NULL;
597: ELSIF p_x_prd_workoper_rec.CREATED_BY IS NULL THEN
598: p_x_prd_workoper_rec.CREATED_BY:=l_old_operation_rec.CREATED_BY;
599: END IF;

Line 601: IF p_x_prd_workoper_rec.LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM THEN

597: ELSIF p_x_prd_workoper_rec.CREATED_BY IS NULL THEN
598: p_x_prd_workoper_rec.CREATED_BY:=l_old_operation_rec.CREATED_BY;
599: END IF;
600:
601: IF p_x_prd_workoper_rec.LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM THEN
602: p_x_prd_workoper_rec.LAST_UPDATE_LOGIN:=NULL;
603: ELSIF p_x_prd_workoper_rec.LAST_UPDATE_LOGIN IS NULL THEN
604: p_x_prd_workoper_rec.LAST_UPDATE_LOGIN:=l_old_operation_rec.LAST_UPDATE_LOGIN;
605: END IF;

Line 704: p_operation_code <> FND_API.G_MISS_CHAR

700: --AND p_operation_id IS NULL
701: AND
702: p_operation_code IS NOT NULL
703: AND
704: p_operation_code <> FND_API.G_MISS_CHAR
705: )
706: THEN
707: OPEN c_get_wo_op(p_wo_op_id);
708: FETCH c_get_wo_op INTO l_existing_op_code;

Line 818: p_x_prd_workoper_rec.OPERATION_CODE<>FND_API.G_MISS_CHAR THEN

814: BEGIN
815: /*
816: -- Bug # 6717357 -- start
817: IF p_x_prd_workoper_rec.OPERATION_CODE IS NOT NULL AND
818: p_x_prd_workoper_rec.OPERATION_CODE<>FND_API.G_MISS_CHAR THEN
819: OPEN get_operation(p_x_prd_workoper_rec.OPERATION_CODE);
820: FETCH get_operation INTO p_x_prd_workoper_rec.OPERATION_ID;
821:
822: IF get_operation%NOTFOUND THEN

Line 854: p_x_prd_workoper_rec.department_name<>FND_API.G_MISS_CHAR THEN

850: p_x_prd_workoper_rec.OPERATION_ID := l_operation_id;
851: END IF;
852: -- Added following code for Bug # 6717357 -- End
853: IF p_x_prd_workoper_rec.department_name IS NOT NULL AND
854: p_x_prd_workoper_rec.department_name<>FND_API.G_MISS_CHAR THEN
855: OPEN get_department(p_x_prd_workoper_rec.department_name,p_x_prd_workoper_rec.organization_id);
856: FETCH get_department INTO l_dept_rec;
857:
858: IF get_department%NOTFOUND THEN

Line 870: p_x_prd_workoper_rec.OPERATION_TYPE<>FND_API.G_MISS_CHAR THEN

866: CLOSE get_department;
867: END IF;
868:
869: IF p_x_prd_workoper_rec.OPERATION_TYPE IS NOT NULL AND
870: p_x_prd_workoper_rec.OPERATION_TYPE<>FND_API.G_MISS_CHAR THEN
871: OPEN get_operation_type(p_x_prd_workoper_rec.OPERATION_TYPE);
872: FETCH get_operation_type INTO p_x_prd_workoper_rec.OPERATION_TYPE_CODE;
873:
874: IF get_operation_type%NOTFOUND THEN

Line 892: p_x_prd_workoper_rec.SCHEDULED_START_DATE <> FND_API.G_MISS_DATE THEN

888: AHL_DEBUG_PUB.debug( 'p_x_prd_workoper_rec.SCHEDULED_START_DATE : ' || to_char(p_x_prd_workoper_rec.SCHEDULED_START_DATE,'DD-MON-YY hh24:mi:ss') );
889: END IF;
890:
891: IF p_x_prd_workoper_rec.SCHEDULED_START_DATE IS NOT NULL AND
892: p_x_prd_workoper_rec.SCHEDULED_START_DATE <> FND_API.G_MISS_DATE THEN
893:
894: l_sec := TO_CHAR(p_x_prd_workoper_rec.SCHEDULED_START_DATE, 'ss');
895: IF(l_sec = '00' AND p_module_type <> 'OAF' ) THEN
896: l_sec := l_sch_start_sec;

Line 910: p_x_prd_workoper_rec.SCHEDULED_END_DATE <> FND_API.G_MISS_DATE THEN

906: END IF;
907: END IF;
908:
909: IF p_x_prd_workoper_rec.SCHEDULED_END_DATE IS NOT NULL AND
910: p_x_prd_workoper_rec.SCHEDULED_END_DATE <> FND_API.G_MISS_DATE THEN
911:
912: l_sec := TO_CHAR(p_x_prd_workoper_rec.SCHEDULED_END_DATE, 'ss');
913: IF(l_sec = '00' AND p_module_type <> 'OAF' ) THEN
914: l_sec := l_sch_end_sec;

Line 933: p_x_prd_workoper_rec.ACTUAL_START_DATE <> FND_API.G_MISS_DATE THEN

929: FETCH get_op_act_sec INTO l_act_start_sec, l_act_end_sec;
930: CLOSE get_op_act_sec;
931:
932: IF p_x_prd_workoper_rec.ACTUAL_START_DATE IS NOT NULL AND
933: p_x_prd_workoper_rec.ACTUAL_START_DATE <> FND_API.G_MISS_DATE THEN
934:
935: l_sec := TO_CHAR(p_x_prd_workoper_rec.ACTUAL_START_DATE, 'ss');
936: IF(l_sec = '00' AND p_module_type <> 'OAF' ) THEN
937: l_sec := l_act_start_sec;

Line 951: p_x_prd_workoper_rec.ACTUAL_END_DATE <> FND_API.G_MISS_DATE THEN

947: END IF;
948: END IF;
949:
950: IF p_x_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL AND
951: p_x_prd_workoper_rec.ACTUAL_END_DATE <> FND_API.G_MISS_DATE THEN
952:
953: l_sec := TO_CHAR(p_x_prd_workoper_rec.ACTUAL_END_DATE, 'ss');
954: IF(l_sec = '00' AND p_module_type <> 'OAF' ) THEN
955: l_sec := l_act_end_sec;

Line 1073: IF l_return_status = FND_API.G_TRUE THEN

1069: -- ACL Changes
1070: /*l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => p_prd_workoper_rec.workorder_id, p_ue_id => NULL,
1071: p_visit_id => NULL,
1072: p_item_instance_id => NULL);
1073: IF l_return_status = FND_API.G_TRUE THEN
1074: IF p_prd_workoper_rec.dml_operation='C' THEN
1075: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_OP_CRT_UNTLCKD');
1076: ELSIF p_prd_workoper_rec.dml_operation='U' THEN
1077: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_OP_UPD_UNTLCKD');

Line 1080: RAISE FND_API.G_EXC_ERROR;

1076: ELSIF p_prd_workoper_rec.dml_operation='U' THEN
1077: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_OP_UPD_UNTLCKD');
1078: END IF;
1079: FND_MSG_PUB.ADD;
1080: RAISE FND_API.G_EXC_ERROR;
1081: END IF;
1082: */
1083: -- rroy
1084: -- ACL Changes

Line 1087: p_prd_workoper_rec.DEPARTMENT_ID=FND_API.G_MISS_NUM THEN

1083: -- rroy
1084: -- ACL Changes
1085:
1086: IF p_prd_workoper_rec.DEPARTMENT_ID IS NULL OR
1087: p_prd_workoper_rec.DEPARTMENT_ID=FND_API.G_MISS_NUM THEN
1088: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_DEPT_ID_NULL');
1089: FND_MSG_PUB.ADD;
1090: END IF;
1091:

Line 1093: p_prd_workoper_rec.SCHEDULED_START_DATE=FND_API.G_MISS_DATE THEN

1089: FND_MSG_PUB.ADD;
1090: END IF;
1091:
1092: IF p_prd_workoper_rec.SCHEDULED_START_DATE IS NULL OR
1093: p_prd_workoper_rec.SCHEDULED_START_DATE=FND_API.G_MISS_DATE THEN
1094: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDSTART_DT_NULL');
1095: FND_MSG_PUB.ADD;
1096: ELSIF p_prd_workoper_rec.SCHEDULED_END_DATE IS NULL OR
1097: p_prd_workoper_rec.SCHEDULED_END_DATE=FND_API.G_MISS_DATE THEN

Line 1097: p_prd_workoper_rec.SCHEDULED_END_DATE=FND_API.G_MISS_DATE THEN

1093: p_prd_workoper_rec.SCHEDULED_START_DATE=FND_API.G_MISS_DATE THEN
1094: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDSTART_DT_NULL');
1095: FND_MSG_PUB.ADD;
1096: ELSIF p_prd_workoper_rec.SCHEDULED_END_DATE IS NULL OR
1097: p_prd_workoper_rec.SCHEDULED_END_DATE=FND_API.G_MISS_DATE THEN
1098: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDEND_DT_NULL');
1099: FND_MSG_PUB.ADD;
1100: ELSIF NVL(p_prd_workoper_rec.SCHEDULED_START_DATE,SYSDATE) > NVL(p_prd_workoper_rec.SCHEDULED_END_DATE,SYSDATE) THEN
1101: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDDTS_INVALID_DT');

Line 1106: p_prd_workoper_rec.ACTUAL_START_DATE <> FND_API.G_MISS_DATE AND

1102: FND_MSG_PUB.ADD;
1103: END IF;
1104:
1105: IF p_prd_workoper_rec.ACTUAL_START_DATE IS NOT NULL AND
1106: p_prd_workoper_rec.ACTUAL_START_DATE <> FND_API.G_MISS_DATE AND
1107: p_prd_workoper_rec.ACTUAL_START_DATE > SYSDATE THEN
1108: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_STRT_DT_INVALID');
1109: FND_MSG_PUB.ADD;
1110: END IF;

Line 1113: p_prd_workoper_rec.ACTUAL_START_DATE=FND_API.G_MISS_DATE) AND

1109: FND_MSG_PUB.ADD;
1110: END IF;
1111:
1112: IF (p_prd_workoper_rec.ACTUAL_START_DATE IS NULL OR
1113: p_prd_workoper_rec.ACTUAL_START_DATE=FND_API.G_MISS_DATE) AND
1114: (p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND
1115: p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL) THEN
1116: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_START_DT_NULL');
1117: FND_MESSAGE.SET_TOKEN('RECORD',p_prd_workoper_rec.operation_sequence_num,false);

Line 1114: (p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND

1110: END IF;
1111:
1112: IF (p_prd_workoper_rec.ACTUAL_START_DATE IS NULL OR
1113: p_prd_workoper_rec.ACTUAL_START_DATE=FND_API.G_MISS_DATE) AND
1114: (p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND
1115: p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL) THEN
1116: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_START_DT_NULL');
1117: FND_MESSAGE.SET_TOKEN('RECORD',p_prd_workoper_rec.operation_sequence_num,false);
1118: FND_MSG_PUB.ADD;

Line 1122: p_prd_workoper_rec.ACTUAL_START_DATE<>FND_API.G_MISS_DATE AND

1118: FND_MSG_PUB.ADD;
1119: END IF;
1120:
1121: IF p_prd_workoper_rec.ACTUAL_START_DATE IS NOT NULL AND
1122: p_prd_workoper_rec.ACTUAL_START_DATE<>FND_API.G_MISS_DATE AND
1123: p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND
1124: p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL AND
1125: p_prd_workoper_rec.ACTUAL_START_DATE > p_prd_workoper_rec.ACTUAL_END_DATE THEN
1126: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_SE_DT_INVALID');

Line 1123: p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND

1119: END IF;
1120:
1121: IF p_prd_workoper_rec.ACTUAL_START_DATE IS NOT NULL AND
1122: p_prd_workoper_rec.ACTUAL_START_DATE<>FND_API.G_MISS_DATE AND
1123: p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND
1124: p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL AND
1125: p_prd_workoper_rec.ACTUAL_START_DATE > p_prd_workoper_rec.ACTUAL_END_DATE THEN
1126: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_SE_DT_INVALID');
1127: FND_MSG_PUB.ADD;

Line 1131: p_prd_workoper_rec.ACTUAL_END_DATE <> FND_API.G_MISS_DATE AND

1127: FND_MSG_PUB.ADD;
1128: END IF;
1129:
1130: IF p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL AND
1131: p_prd_workoper_rec.ACTUAL_END_DATE <> FND_API.G_MISS_DATE AND
1132: TRUNC( p_prd_workoper_rec.ACTUAL_END_DATE ) > TRUNC( SYSDATE ) THEN
1133: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_END_DT_INVALID');
1134: FND_MSG_PUB.ADD;
1135: END IF;

Line 1143: p_prd_workoper_rec.actual_start_date <> FND_API.G_MISS_DATE AND

1139: FETCH get_wo_actual_dates INTO l_wo_actual_start_date, l_wo_actual_end_date;
1140: CLOSE get_wo_actual_dates;
1141:
1142: IF ( p_prd_workoper_rec.actual_start_date IS NOT NULL AND
1143: p_prd_workoper_rec.actual_start_date <> FND_API.G_MISS_DATE AND
1144: l_wo_actual_start_date IS NOT NULL AND
1145: p_prd_workoper_rec.actual_start_date < l_wo_actual_start_date ) THEN
1146: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_WO_ST_DT' );
1147: FND_MSG_PUB.add;

Line 1151: p_prd_workoper_rec.actual_end_date <> FND_API.G_MISS_DATE AND

1147: FND_MSG_PUB.add;
1148: END IF;
1149:
1150: IF ( p_prd_workoper_rec.actual_end_date IS NOT NULL AND
1151: p_prd_workoper_rec.actual_end_date <> FND_API.G_MISS_DATE AND
1152: l_wo_actual_end_date IS NOT NULL AND
1153: p_prd_workoper_rec.actual_end_date > l_wo_actual_end_date ) THEN
1154: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_WO_END_DT' );
1155: FND_MSG_PUB.add;

Line 1159: p_prd_workoper_rec.OPERATION_SEQUENCE_NUM=FND_API.G_MISS_NUM THEN

1155: FND_MSG_PUB.add;
1156: END IF;
1157:
1158: IF p_prd_workoper_rec.OPERATION_SEQUENCE_NUM IS NULL OR
1159: p_prd_workoper_rec.OPERATION_SEQUENCE_NUM=FND_API.G_MISS_NUM THEN
1160: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_SEQ_NULL');
1161: FND_MSG_PUB.ADD;
1162: ELSIF p_prd_workoper_rec.OPERATION_SEQUENCE_NUM <=0 THEN
1163: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_SEQ_NEGZERO');

Line 1180: p_prd_workoper_rec.WORKORDER_OPERATION_ID=FND_API.G_MISS_NUM THEN

1176: END IF;
1177:
1178: IF p_prd_workoper_rec.dml_operation='U' THEN
1179: IF p_prd_workoper_rec.WORKORDER_OPERATION_ID IS NULL OR
1180: p_prd_workoper_rec.WORKORDER_OPERATION_ID=FND_API.G_MISS_NUM THEN
1181: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_OPERID_NULL');
1182: FND_MSG_PUB.ADD;
1183: END IF;
1184: END IF;

Line 1187: p_prd_workoper_rec.ORGANIZATION_ID<>FND_API.G_MISS_NUM AND

1183: END IF;
1184: END IF;
1185:
1186: IF p_prd_workoper_rec.ORGANIZATION_ID IS NOT NULL AND
1187: p_prd_workoper_rec.ORGANIZATION_ID<>FND_API.G_MISS_NUM AND
1188: p_prd_workoper_rec.DEPARTMENT_ID IS NOT NULL AND
1189: p_prd_workoper_rec.DEPARTMENT_ID<>FND_API.G_MISS_NUM THEN
1190: OPEN validate_department(p_prd_workoper_rec.DEPARTMENT_ID,p_prd_workoper_rec.ORGANIZATION_ID);
1191: FETCH validate_department INTO l_eam_enabled_flag;

Line 1189: p_prd_workoper_rec.DEPARTMENT_ID<>FND_API.G_MISS_NUM THEN

1185:
1186: IF p_prd_workoper_rec.ORGANIZATION_ID IS NOT NULL AND
1187: p_prd_workoper_rec.ORGANIZATION_ID<>FND_API.G_MISS_NUM AND
1188: p_prd_workoper_rec.DEPARTMENT_ID IS NOT NULL AND
1189: p_prd_workoper_rec.DEPARTMENT_ID<>FND_API.G_MISS_NUM THEN
1190: OPEN validate_department(p_prd_workoper_rec.DEPARTMENT_ID,p_prd_workoper_rec.ORGANIZATION_ID);
1191: FETCH validate_department INTO l_eam_enabled_flag;
1192:
1193: IF validate_department%NOTFOUND THEN

Line 1208: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1204:
1205: PROCEDURE process_operations
1206: (
1207: p_api_version IN NUMBER := 1.0,
1208: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1209: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1210: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1211: p_default IN VARCHAR2 := FND_API.G_FALSE,
1212: p_module_type IN VARCHAR2,

Line 1209: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1205: PROCEDURE process_operations
1206: (
1207: p_api_version IN NUMBER := 1.0,
1208: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1209: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1210: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1211: p_default IN VARCHAR2 := FND_API.G_FALSE,
1212: p_module_type IN VARCHAR2,
1213: p_wip_mass_load_flag IN VARCHAR2,

Line 1210: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1206: (
1207: p_api_version IN NUMBER := 1.0,
1208: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1209: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1210: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1211: p_default IN VARCHAR2 := FND_API.G_FALSE,
1212: p_module_type IN VARCHAR2,
1213: p_wip_mass_load_flag IN VARCHAR2,
1214: x_return_status OUT NOCOPY VARCHAR2,

Line 1211: p_default IN VARCHAR2 := FND_API.G_FALSE,

1207: p_api_version IN NUMBER := 1.0,
1208: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1209: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1210: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1211: p_default IN VARCHAR2 := FND_API.G_FALSE,
1212: p_module_type IN VARCHAR2,
1213: p_wip_mass_load_flag IN VARCHAR2,
1214: x_return_status OUT NOCOPY VARCHAR2,
1215: x_msg_count OUT NOCOPY NUMBER,

Line 1245: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1241: BEGIN
1242: SAVEPOINT process_operations_PVT;
1243:
1244: -- Initialize message list IF p_init_msg_list is set to TRUE.
1245: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1246: p_api_version,
1247: l_api_name,G_PKG_NAME) THEN
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1249: END IF;

Line 1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1244: -- Initialize message list IF p_init_msg_list is set to TRUE.
1245: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1246: p_api_version,
1247: l_api_name,G_PKG_NAME) THEN
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1249: END IF;
1250:
1251: IF FND_API.to_boolean(p_init_msg_list) THEN
1252: FND_MSG_PUB.initialize;

Line 1251: IF FND_API.to_boolean(p_init_msg_list) THEN

1247: l_api_name,G_PKG_NAME) THEN
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1249: END IF;
1250:
1251: IF FND_API.to_boolean(p_init_msg_list) THEN
1252: FND_MSG_PUB.initialize;
1253: END IF;
1254:
1255: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 1255: x_return_status:=FND_API.G_RET_STS_SUCCESS;

1251: IF FND_API.to_boolean(p_init_msg_list) THEN
1252: FND_MSG_PUB.initialize;
1253: END IF;
1254:
1255: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1256:
1257: IF G_DEBUG='Y' THEN
1258: AHL_DEBUG_PUB.enable_debug;
1259: END IF;

Line 1265: IF FND_API.to_boolean(p_default) THEN

1261: IF ( G_DEBUG = 'Y' ) THEN
1262: AHL_DEBUG_PUB.debug( l_api_name || ' - Total number of Operations - ' || p_x_prd_operation_tbl.COUNT );
1263: END IF;
1264:
1265: IF FND_API.to_boolean(p_default) THEN
1266: IF p_x_prd_operation_tbl.COUNT >0 THEN
1267: FOR i in p_x_prd_operation_tbl.FIRST..p_x_prd_operation_tbl.LAST
1268: LOOP
1269:

Line 1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1312: l_msg_count:=FND_MSG_PUB.count_msg;
1313:
1314: IF l_msg_count > 0 THEN
1315: x_msg_count := l_msg_count;
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317: IF p_wip_mass_load_flag<>'Y' THEN
1318: RETURN;
1319: END IF;
1320: END IF;

Line 1327: x_return_status:=FND_API.G_RET_STS_SUCCESS;

1323:
1324: IF p_x_prd_operation_tbl.COUNT >0 THEN
1325: FOR i IN p_x_prd_operation_tbl.FIRST..p_x_prd_operation_tbl.LAST
1326: LOOP
1327: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1328:
1329: IF ( G_DEBUG = 'Y' ) THEN
1330: AHL_DEBUG_PUB.debug( l_api_name || ' - Before validate_operation' );
1331: END IF;

Line 1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1337:
1338: l_msg_count:=FND_MSG_PUB.count_msg;
1339: IF l_msg_count > 0 THEN
1340: x_msg_count := l_msg_count;
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1342: END IF;
1343:
1344: IF x_return_status=FND_API.G_RET_STS_SUCCESS THEN
1345:

Line 1344: IF x_return_status=FND_API.G_RET_STS_SUCCESS THEN

1340: x_msg_count := l_msg_count;
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1342: END IF;
1343:
1344: IF x_return_status=FND_API.G_RET_STS_SUCCESS THEN
1345:
1346: IF p_x_prd_operation_tbl(i).dml_operation='C' THEN
1347:
1348: IF ( G_DEBUG = 'Y' ) THEN

Line 1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1480: l_msg_count:=FND_MSG_PUB.count_msg;
1481:
1482: IF l_msg_count > 0 THEN
1483: x_msg_count := l_msg_count;
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485:
1486: IF p_wip_mass_load_flag='Y' THEN
1487: RAISE FND_API.G_EXC_ERROR;
1488: ELSE

Line 1487: RAISE FND_API.G_EXC_ERROR;

1483: x_msg_count := l_msg_count;
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485:
1486: IF p_wip_mass_load_flag='Y' THEN
1487: RAISE FND_API.G_EXC_ERROR;
1488: ELSE
1489: RETURN;
1490: END IF;
1491:

Line 1503: p_init_msg_list => FND_API.G_TRUE ,

1499:
1500: AHL_EAM_JOB_PVT.update_job_operations
1501: (
1502: p_api_version => 1.0 ,
1503: p_init_msg_list => FND_API.G_TRUE ,
1504: p_commit => FND_API.G_FALSE ,
1505: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1506: p_default => FND_API.G_TRUE ,
1507: p_module_type => NULL ,

Line 1504: p_commit => FND_API.G_FALSE ,

1500: AHL_EAM_JOB_PVT.update_job_operations
1501: (
1502: p_api_version => 1.0 ,
1503: p_init_msg_list => FND_API.G_TRUE ,
1504: p_commit => FND_API.G_FALSE ,
1505: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1506: p_default => FND_API.G_TRUE ,
1507: p_module_type => NULL ,
1508: x_return_status => l_return_status ,

Line 1505: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

1501: (
1502: p_api_version => 1.0 ,
1503: p_init_msg_list => FND_API.G_TRUE ,
1504: p_commit => FND_API.G_FALSE ,
1505: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1506: p_default => FND_API.G_TRUE ,
1507: p_module_type => NULL ,
1508: x_return_status => l_return_status ,
1509: x_msg_count => l_msg_count ,

Line 1506: p_default => FND_API.G_TRUE ,

1502: p_api_version => 1.0 ,
1503: p_init_msg_list => FND_API.G_TRUE ,
1504: p_commit => FND_API.G_FALSE ,
1505: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1506: p_default => FND_API.G_TRUE ,
1507: p_module_type => NULL ,
1508: x_return_status => l_return_status ,
1509: x_msg_count => l_msg_count ,
1510: x_msg_data => l_msg_data ,

Line 1517: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1513: p_material_req_tbl => l_material_tbl ,
1514: p_resource_req_tbl => l_resource_tbl
1515: );
1516:
1517: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1518: RAISE FND_API.G_EXC_ERROR;
1519: END IF;
1520: END IF; -- IF p_wip_mass_load_flag='Y' THEN
1521:

Line 1518: RAISE FND_API.G_EXC_ERROR;

1514: p_resource_req_tbl => l_resource_tbl
1515: );
1516:
1517: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1518: RAISE FND_API.G_EXC_ERROR;
1519: END IF;
1520: END IF; -- IF p_wip_mass_load_flag='Y' THEN
1521:
1522: -- R12

Line 1529: p_init_msg_list => FND_API.G_TRUE,

1525: IF l_prd_operation_tbl.COUNT > 0 THEN
1526: FOR j in l_prd_operation_tbl.FIRST..l_prd_operation_tbl.LAST LOOP
1527: AHL_COMPLETIONS_PVT.complete_operation
1528: (p_api_version => 1.0,
1529: p_init_msg_list => FND_API.G_TRUE,
1530: p_commit => FND_API.G_FALSE,
1531: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1532: p_default => FND_API.G_FALSE,
1533: x_return_status => l_return_status,

Line 1530: p_commit => FND_API.G_FALSE,

1526: FOR j in l_prd_operation_tbl.FIRST..l_prd_operation_tbl.LAST LOOP
1527: AHL_COMPLETIONS_PVT.complete_operation
1528: (p_api_version => 1.0,
1529: p_init_msg_list => FND_API.G_TRUE,
1530: p_commit => FND_API.G_FALSE,
1531: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1532: p_default => FND_API.G_FALSE,
1533: x_return_status => l_return_status,
1534: x_msg_count => l_msg_count,

Line 1531: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1527: AHL_COMPLETIONS_PVT.complete_operation
1528: (p_api_version => 1.0,
1529: p_init_msg_list => FND_API.G_TRUE,
1530: p_commit => FND_API.G_FALSE,
1531: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1532: p_default => FND_API.G_FALSE,
1533: x_return_status => l_return_status,
1534: x_msg_count => l_msg_count,
1535: x_msg_data => l_msg_data,

Line 1532: p_default => FND_API.G_FALSE,

1528: (p_api_version => 1.0,
1529: p_init_msg_list => FND_API.G_TRUE,
1530: p_commit => FND_API.G_FALSE,
1531: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1532: p_default => FND_API.G_FALSE,
1533: x_return_status => l_return_status,
1534: x_msg_count => l_msg_count,
1535: x_msg_data => l_msg_data,
1536: p_workorder_operation_id => l_prd_operation_tbl(j).workorder_operation_id,

Line 1539: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1535: x_msg_data => l_msg_data,
1536: p_workorder_operation_id => l_prd_operation_tbl(j).workorder_operation_id,
1537: p_object_version_no => l_prd_operation_tbl(j).object_version_number
1538: );
1539: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;
1542: END LOOP;
1543: END IF; -- IF l_prd_operation_tbl.COUNT > 0 THEN

Line 1540: RAISE FND_API.G_EXC_ERROR;

1536: p_workorder_operation_id => l_prd_operation_tbl(j).workorder_operation_id,
1537: p_object_version_no => l_prd_operation_tbl(j).object_version_number
1538: );
1539: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;
1542: END LOOP;
1543: END IF; -- IF l_prd_operation_tbl.COUNT > 0 THEN
1544:

Line 1546: IF FND_API.TO_BOOLEAN(p_commit) THEN

1542: END LOOP;
1543: END IF; -- IF l_prd_operation_tbl.COUNT > 0 THEN
1544:
1545:
1546: IF FND_API.TO_BOOLEAN(p_commit) THEN
1547: COMMIT;
1548: END IF;
1549:
1550: IF ( G_DEBUG = 'Y' ) THEN

Line 1559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1555: AHL_DEBUG_PUB.disable_debug;
1556: END IF;
1557:
1558: EXCEPTION
1559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1560: ROLLBACK TO process_operations_PVT;
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1562: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1563: p_count => x_msg_count,

Line 1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1557:
1558: EXCEPTION
1559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1560: ROLLBACK TO process_operations_PVT;
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1562: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1563: p_count => x_msg_count,
1564: p_data => x_msg_data);
1565: WHEN FND_API.G_EXC_ERROR THEN

Line 1562: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1558: EXCEPTION
1559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1560: ROLLBACK TO process_operations_PVT;
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1562: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1563: p_count => x_msg_count,
1564: p_data => x_msg_data);
1565: WHEN FND_API.G_EXC_ERROR THEN
1566: ROLLBACK TO process_operations_PVT;

Line 1565: WHEN FND_API.G_EXC_ERROR THEN

1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1562: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1563: p_count => x_msg_count,
1564: p_data => x_msg_data);
1565: WHEN FND_API.G_EXC_ERROR THEN
1566: ROLLBACK TO process_operations_PVT;
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1569: p_count => x_msg_count,

Line 1567: x_return_status := FND_API.G_RET_STS_ERROR;

1563: p_count => x_msg_count,
1564: p_data => x_msg_data);
1565: WHEN FND_API.G_EXC_ERROR THEN
1566: ROLLBACK TO process_operations_PVT;
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1569: p_count => x_msg_count,
1570: p_data => x_msg_data);
1571:

Line 1568: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1564: p_data => x_msg_data);
1565: WHEN FND_API.G_EXC_ERROR THEN
1566: ROLLBACK TO process_operations_PVT;
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1569: p_count => x_msg_count,
1570: p_data => x_msg_data);
1571:
1572: WHEN OTHERS THEN

Line 1574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1570: p_data => x_msg_data);
1571:
1572: WHEN OTHERS THEN
1573: ROLLBACK TO process_operations_PVT;
1574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1576: FND_MSG_PUB.add_exc_msg(p_pkg_name =>g_pkg_name,
1577: p_procedure_name =>l_api_name,
1578: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1581: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1577: p_procedure_name =>l_api_name,
1578: p_error_text => SUBSTR(SQLERRM,1,240));
1579:
1580: END IF;
1581: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1582: p_count => x_msg_count,
1583: p_data => x_msg_data);
1584:
1585: END;

Line 1606: p_date_hh24 <> FND_API.G_MISS_NUM ) THEN

1602: l_minutes := TO_CHAR(p_date, 'mi');
1603: l_date := p_date;
1604:
1605: IF ( p_date_hh24 IS NOT NULL AND
1606: p_date_hh24 <> FND_API.G_MISS_NUM ) THEN
1607: l_hour := p_date_hh24;
1608: END IF;
1609:
1610: IF ( p_date_mi IS NOT NULL AND

Line 1611: p_date_mi <> FND_API.G_MISS_NUM ) THEN

1607: l_hour := p_date_hh24;
1608: END IF;
1609:
1610: IF ( p_date_mi IS NOT NULL AND
1611: p_date_mi <> FND_API.G_MISS_NUM ) THEN
1612: l_minutes := p_date_mi;
1613: END IF;
1614:
1615: IF(p_date_ss IS NOT NULL AND

Line 1616: p_date_ss <> FND_API.G_MISS_NUM) THEN

1612: l_minutes := p_date_mi;
1613: END IF;
1614:
1615: IF(p_date_ss IS NOT NULL AND
1616: p_date_ss <> FND_API.G_MISS_NUM) THEN
1617: l_sec := p_date_ss;
1618: END IF;
1619:
1620: IF ( l_hour <> '00' OR l_minutes <> '00' OR l_sec <> '00') THEN