APPS.WIP_RES_USAGE_VALIDATE dependencies on WIP_JOB_DTLS_INTERFACE

Line 20: from wip_job_dtls_interface wjdi

16:
17: procedure derive_usages(p_group_id in number, p_wip_entity_id in number, p_organization_id in number) is
18: cursor c_usage_rows is
19: select resource_seq_num, parent_seq_num, operation_seq_num, resource_id_new, rowid
20: from wip_job_dtls_interface wjdi
21: where group_id = p_group_id
22: and process_phase = wip_constants.ml_validation
23: and process_status in (wip_constants.running,
24: wip_constants.warning)

Line 46: update wip_job_dtls_interface wjdi

42: and operation_seq_num = cur_row.operation_seq_num
43: and resource_id = cur_row.resource_id_new
44: and parent_resource_seq = cur_row.parent_seq_num;
45:
46: update wip_job_dtls_interface wjdi
47: set resource_seq_num = l_res_seq
48: where rowid = cur_row.rowid;
49:
50: end if;

Line 117: from wip_job_dtls_interface wjdi

113:
114: procedure validate_seq_num(p_group_id in number, p_wip_entity_id in number, p_organization_id in number) is
115: cursor c_invalid_rows is
116: select interface_id
117: from wip_job_dtls_interface wjdi
118: where group_id = p_group_id
119: and process_phase = wip_constants.ml_validation
120: and process_status in (wip_constants.running,
121: wip_constants.warning)

Line 148: update wip_job_dtls_interface wjdi

144: end if;
145: end loop;
146:
147: if(l_error_exists) then
148: update wip_job_dtls_interface wjdi
149: set process_status = wip_constants.error
150: where group_id = p_group_id
151: and process_phase = wip_constants.ml_validation
152: and process_status in (wip_constants.running,

Line 169: from wip_job_dtls_interface wjdi

165:
166: procedure validate_res_seq_num(p_group_id in number, p_wip_entity_id in number, p_organization_id in number) is
167: cursor c_invalid_rows is
168: select interface_id
169: from wip_job_dtls_interface wjdi
170: where group_id = p_group_id
171: and process_phase = wip_constants.ml_validation
172: and process_status in (wip_constants.running,
173: wip_constants.warning)

Line 210: update wip_job_dtls_interface wjdi

206: end if;
207: end loop;
208:
209: if(l_error_exists) then
210: update wip_job_dtls_interface wjdi
211: set process_status = wip_constants.error
212: where group_id = p_group_id
213: and process_phase = wip_constants.ml_validation
214: and process_status in (wip_constants.running,

Line 241: from wip_job_dtls_interface wjdi

237:
238: procedure validate_dates(p_group_id in number, p_wip_entity_id in number, p_organization_id in number) is
239: cursor c_invalid_rows is
240: select interface_id
241: from wip_job_dtls_interface wjdi
242: where group_id = p_group_id
243: and process_phase = wip_constants.ml_validation
244: and process_status in (wip_constants.running,
245: wip_constants.warning)

Line 289: update wip_job_dtls_interface wjdi

285:
286: end loop;
287:
288: if(l_error_exists) then
289: update wip_job_dtls_interface wjdi
290: set process_status = wip_constants.error
291: where group_id = p_group_id
292: and process_phase = wip_constants.ml_validation
293: and process_status in (wip_constants.running,

Line 323: from wip_job_dtls_interface wjdi

319:
320: procedure validate_assigned_units(p_group_id in number, p_wip_entity_id in number, p_organization_id in number) is
321: cursor c_invalid_rows is
322: select interface_id
323: from wip_job_dtls_interface wjdi
324: where group_id = p_group_id
325: and process_phase = wip_constants.ml_validation
326: and process_status in (wip_constants.running,
327: wip_constants.warning)

Line 355: update wip_job_dtls_interface wjdi

351: end if;
352: end loop;
353:
354: if(l_error_exists) then
355: update wip_job_dtls_interface wjdi
356: set process_status = wip_constants.error
357: where group_id = p_group_id
358: and process_phase = wip_constants.ml_validation
359: and process_status in (wip_constants.running,

Line 375: from wip_job_dtls_interface wjdi

371: procedure val_time_overlap_ri_usage(p_group_id in number, p_wip_entity_id in number, p_organization_id in number) is
372:
373: cursor c_invalid_res_inst_usage_rows is
374: select interface_id
375: from wip_job_dtls_interface wjdi
376: where group_id = p_group_id
377: and process_phase = wip_constants.ml_validation
378: and process_status in (wip_constants.running,
379: wip_constants.warning)

Line 385: from wip_job_dtls_interface wjdi2

381: and organization_id = p_organization_id
382: and load_type = wip_job_details.wip_res_instance_usage
383: and substitution_type = wip_job_details.wip_add
384: and exists (select 1
385: from wip_job_dtls_interface wjdi2
386: where wjdi2.group_id = wjdi.group_id
387: and wjdi2.wip_entity_id = p_wip_entity_id
388: and wjdi2.organization_id = p_organization_id
389: and wjdi2.operation_seq_num = wjdi.operation_seq_num

Line 414: update wip_job_dtls_interface wjdi

410: end if;
411: end loop;
412:
413: if(l_error_exists) then
414: update wip_job_dtls_interface wjdi
415: set process_status = wip_constants.error
416: where group_id = p_group_id
417: and process_phase = wip_constants.ml_validation
418: and process_status in (wip_constants.running,

Line 425: from wip_job_dtls_interface wjdi2

421: and organization_id = p_organization_id
422: and load_type = wip_job_details.wip_res_instance_usage
423: and substitution_type = wip_job_details.wip_add
424: and exists (select 1
425: from wip_job_dtls_interface wjdi2
426: where wjdi2.group_id = wjdi.group_id
427: and wjdi2.wip_entity_id = p_wip_entity_id
428: and wjdi2.organization_id = p_organization_id
429: and wjdi2.operation_seq_num = wjdi.operation_seq_num

Line 443: from wip_job_dtls_interface wjdi

439:
440: procedure val_time_overlap_res_usage(p_group_id in number, p_wip_entity_id in number, p_organization_id in number) is
441: cursor c_invalid_res_usage_rows is
442: select interface_id
443: from wip_job_dtls_interface wjdi
444: where group_id = p_group_id
445: and process_phase = wip_constants.ml_validation
446: and process_status in (wip_constants.running,
447: wip_constants.warning)

Line 453: from wip_job_dtls_interface wjdi2

449: and organization_id = p_organization_id
450: and load_type = wip_job_details.wip_res_usage
451: and substitution_type = wip_job_details.wip_add
452: and exists (select 1
453: from wip_job_dtls_interface wjdi2
454: where wjdi2.group_id = wjdi.group_id
455: and wjdi2.wip_entity_id = p_wip_entity_id
456: and wjdi2.organization_id = p_organization_id
457: and wjdi2.operation_seq_num = wjdi.operation_seq_num

Line 482: update wip_job_dtls_interface wjdi

478: end if;
479: end loop;
480:
481: if(l_error_exists) then
482: update wip_job_dtls_interface wjdi
483: set process_status = wip_constants.error
484: where group_id = p_group_id
485: and process_phase = wip_constants.ml_validation
486: and process_status in (wip_constants.running,

Line 493: from wip_job_dtls_interface wjdi2

489: and organization_id = p_organization_id
490: and load_type = wip_job_details.wip_res_usage
491: and substitution_type = wip_job_details.wip_add
492: and exists (select 1
493: from wip_job_dtls_interface wjdi2
494: where wjdi2.group_id = wjdi.group_id
495: and wjdi2.wip_entity_id = p_wip_entity_id
496: and wjdi2.organization_id = p_organization_id
497: and wjdi2.operation_seq_num = wjdi.operation_seq_num

Line 511: from wip_job_dtls_interface wjdi

507:
508: procedure validate_time_slot(p_group_id in number, p_wip_entity_id in number, p_organization_id in number) is
509: cursor c_invalid_rows is
510: select interface_id
511: from wip_job_dtls_interface wjdi
512: where group_id = p_group_id
513: and process_phase = wip_constants.ml_validation
514: and process_status in (wip_constants.running,
515: wip_constants.warning)

Line 521: from wip_job_dtls_interface wjdi2, wip_operation_resources wor

517: and organization_id = p_organization_id
518: and load_type = wip_job_details.wip_res_usage
519: and substitution_type = wip_job_details.wip_add
520: and ( not exists (select 1
521: from wip_job_dtls_interface wjdi2, wip_operation_resources wor
522: where wjdi2.group_id = wjdi.group_id
523: and wjdi2.wip_entity_id = p_wip_entity_id
524: and wjdi2.organization_id = p_organization_id
525: and wjdi2.operation_seq_num = wjdi.operation_seq_num

Line 535: from wip_job_dtls_interface wjdi2, wip_operation_resources wor

531: and wor.operation_seq_num = wjdi2.operation_seq_num
532: and wor.resource_seq_num = wjdi2.resource_seq_num
533: and wor.start_date = wjdi2.start_date)
534: or not exists (select 1
535: from wip_job_dtls_interface wjdi2, wip_operation_resources wor
536: where wjdi2.group_id = wjdi.group_id
537: and wjdi2.wip_entity_id = p_wip_entity_id
538: and wjdi2.organization_id = p_organization_id
539: and wjdi2.operation_seq_num = wjdi.operation_seq_num

Line 566: update wip_job_dtls_interface wjdi

562: end if;
563: end loop;
564:
565: if(l_error_exists) then
566: update wip_job_dtls_interface wjdi
567: set process_status = wip_constants.error
568: where group_id = p_group_id
569: and process_phase = wip_constants.ml_validation
570: and process_status in (wip_constants.running,

Line 577: from wip_job_dtls_interface wjdi2, wip_operation_resources wor

573: and organization_id = p_organization_id
574: and load_type = wip_job_details.wip_res_usage
575: and substitution_type = wip_job_details.wip_add
576: and ( not exists (select 1
577: from wip_job_dtls_interface wjdi2, wip_operation_resources wor
578: where wjdi2.group_id = wjdi.group_id
579: and wjdi2.wip_entity_id = p_wip_entity_id
580: and wjdi2.organization_id = p_organization_id
581: and wjdi2.operation_seq_num = wjdi.operation_seq_num

Line 591: from wip_job_dtls_interface wjdi2, wip_operation_resources wor

587: and wor.operation_seq_num = wjdi2.operation_seq_num
588: and wor.resource_seq_num = wjdi2.resource_seq_num
589: and wor.start_date = wjdi2.start_date)
590: or not exists (select 1
591: from wip_job_dtls_interface wjdi2, wip_operation_resources wor
592: where wjdi2.group_id = wjdi.group_id
593: and wjdi2.wip_entity_id = p_wip_entity_id
594: and wjdi2.organization_id = p_organization_id
595: and wjdi2.operation_seq_num = wjdi.operation_seq_num