APPS.WIP_OPERATION_VALIDATE dependencies on WIP_JOB_DTLS_INTERFACE

Line 177: from wip_job_dtls_interface

173: p_parent_header_id number, /* Fix for Bug#3636378 */
174: p_sub_type in number) is
175: cursor c_invalid_add_rows is
176: select interface_id
177: from wip_job_dtls_interface
178: where group_id = p_group_id
179: and parent_header_id = p_parent_header_id /* Fix for Bug#3636378 */
180: and process_phase = wip_constants.ml_validation /* Bug 2751349 */
181: and process_status in (wip_constants.running, wip_constants.warning) /* Bug 2751349 */

Line 197: from wip_job_dtls_interface

193: );
194:
195: cursor c_invalid_change_rows is
196: select interface_id
197: from wip_job_dtls_interface
198: where group_id = p_group_id
199: and parent_header_id = p_parent_header_id /* Fix for Bug#3636378 */
200: and process_phase = wip_constants.ml_validation /* Bug 2751349 */
201: and process_status in (wip_constants.running, wip_constants.warning) /* Bug 2751349 */

Line 247: update wip_job_dtls_interface wjdi

243: end if;
244:
245: if(l_error_exists) then
246: if(p_sub_type = wip_job_details.wip_add) then
247: update wip_job_dtls_interface wjdi
248: set process_status = wip_constants.error
249: where group_id = p_group_id
250: and process_phase = wip_constants.ml_validation /* Bug 2751349 */
251: and process_status in (wip_constants.running, wip_constants.warning) /* Bug 2751349 */

Line 265: update wip_job_dtls_interface wjdi

261: OR count_point_type IS NULL
262: OR backflush_flag IS NULL
263: );
264: else
265: update wip_job_dtls_interface wjdi
266: set process_status = wip_constants.error
267: where group_id = p_group_id
268: and process_phase = wip_constants.ml_validation /* Bug 2751349 */
269: and process_status in (wip_constants.running, wip_constants.warning) /* Bug 2751349 */

Line 289: from wip_job_dtls_interface wjdi

285: p_organization_id in number,
286: p_sub_type in number) is
287: cursor c_invalid_rows is
288: select interface_id
289: from wip_job_dtls_interface wjdi
290: where group_id = p_group_id
291: and process_phase = wip_constants.ml_validation
292: and process_status in (wip_constants.running,
293: wip_constants.warning)

Line 327: update wip_job_dtls_interface wjdi

323: end if;
324: end loop;
325:
326: if(l_error_exists) then
327: update wip_job_dtls_interface wjdi
328: set process_status = wip_constants.error
329: where group_id = p_group_id
330: and process_phase = wip_constants.ml_validation
331: and process_status in (wip_constants.running,

Line 356: from wip_job_dtls_interface wjdi

352: p_sub_type in number) is
353: cursor c_invalid_rows is
354: select interface_id,
355: operation_seq_num
356: from wip_job_dtls_interface wjdi
357: where group_id = p_group_id
358: and process_phase = wip_constants.ml_validation
359: and process_status in (wip_constants.running,
360: wip_constants.warning)

Line 400: update wip_job_dtls_interface wjdi

396: end if;
397: end loop;
398:
399: if(l_error_exists) then
400: update wip_job_dtls_interface wjdi
401: set process_status = wip_constants.error
402: where group_id = p_group_id
403: and process_phase = wip_constants.ml_validation
404: and process_status in (wip_constants.running,

Line 435: from wip_job_dtls_interface wjdi

431: p_organization_id in number,
432: p_sub_type in number) is
433: cursor c_invalid_rows is
434: select interface_id
435: from wip_job_dtls_interface wjdi
436: where group_id = p_group_id
437: and process_phase = wip_constants.ml_validation
438: and process_status in (wip_constants.running,
439: wip_constants.warning)

Line 470: update wip_job_dtls_interface wjdi

466: end if;
467: end loop;
468:
469: if(l_error_exists) then
470: update wip_job_dtls_interface wjdi
471: set process_status = wip_constants.error
472: where group_id = p_group_id
473: and process_phase = wip_constants.ml_validation
474: and process_status in (wip_constants.running,

Line 498: from wip_job_dtls_interface

494: p_organization_id in number,
495: p_sub_type in number) is
496: cursor c_invalid_rows is
497: select interface_id
498: from wip_job_dtls_interface
499: where group_id = p_group_id
500: and process_phase = wip_constants.ml_validation
501: and process_status in (wip_constants.running,
502: wip_constants.warning)

Line 530: update wip_job_dtls_interface wjdi

526: end if;
527: end loop;
528:
529: if(l_error_exists) then
530: update wip_job_dtls_interface wjdi
531: set process_status = wip_constants.error
532: where group_id = p_group_id
533: and process_phase = wip_constants.ml_validation
534: and process_status in (wip_constants.running,

Line 556: from wip_job_dtls_interface wjdi

552: p_organization_id in number,
553: p_sub_type in number) is
554: cursor c_invalid_rows is
555: select interface_id
556: from wip_job_dtls_interface wjdi
557: where group_id = p_group_id
558: and process_phase = wip_constants.ml_validation
559: and process_status in (wip_constants.running,
560: wip_constants.warning)

Line 595: update wip_job_dtls_interface wjdi

591: end if;
592: end loop;
593:
594: if(l_error_exists) then
595: update wip_job_dtls_interface wjdi
596: set process_status = wip_constants.error
597: where group_id = p_group_id
598: and process_phase = wip_constants.ml_validation
599: and process_status in (wip_constants.running,

Line 628: from wip_job_dtls_interface wjdi

624: p_organization_id in number,
625: p_sub_type in number) is
626: cursor c_invalid_rows is
627: select interface_id
628: from wip_job_dtls_interface wjdi
629: where group_id = p_group_id
630: and process_phase = wip_constants.ml_validation
631: and process_status in (wip_constants.running,
632: wip_constants.warning)

Line 667: update wip_job_dtls_interface wjdi

663: end if;
664: end loop;
665:
666: if(l_error_exists) then
667: update wip_job_dtls_interface wjdi
668: set process_status = wip_constants.error
669: where group_id = p_group_id
670: and load_type = wip_job_details.wip_operation
671: and substitution_type = p_sub_type

Line 701: from wip_job_dtls_interface wjdi

697: p_wip_entity_id in number,
698: p_organization_id in number) is
699: cursor c_invalid_rows is
700: select interface_id, operation_seq_num
701: from wip_job_dtls_interface wjdi
702: where group_id = p_group_id
703: and process_phase = wip_constants.ml_validation
704: and process_status in (wip_constants.running,
705: wip_constants.warning)

Line 742: update wip_job_dtls_interface wjdi

738: end if;
739: end loop;
740:
741: if(l_error_exists) then
742: update wip_job_dtls_interface wjdi
743: set process_status = wip_constants.error
744: where group_id = p_group_id
745: and load_type = wip_job_details.wip_operation
746: and substitution_type = wip_job_details.wip_add

Line 770: from wip_job_dtls_interface wjdi

766: p_organization_id in number,
767: p_parent_header_id in number) is
768: cursor c_ml_invalid_rows is
769: select interface_id
770: from wip_job_dtls_interface wjdi
771: where group_id = p_group_id
772: and process_phase = wip_constants.ml_validation
773: and process_status in (wip_constants.running,
774: wip_constants.warning)

Line 795: from wip_job_dtls_interface wjdi

791: /*bug 3659006->should not check for operation FUSD,LUCD to be within job's start/completion dates */
792:
793: cursor c_wdj_invalid_rows is
794: select interface_id
795: from wip_job_dtls_interface wjdi
796: where group_id = p_group_id
797: and process_phase = wip_constants.ml_validation
798: and process_status in (wip_constants.running,
799: wip_constants.warning)

Line 858: update wip_job_dtls_interface wjdi

854: end if;
855:
856: if(l_error_exists) then
857: if(wip_job_details.std_alone = 1) then
858: update wip_job_dtls_interface wjdi
859: set process_status = wip_constants.error
860: where group_id = p_group_id
861: and process_phase = wip_constants.ml_validation
862: and process_status in (wip_constants.running,

Line 880: update wip_job_dtls_interface wjdi

876: or wjdi.last_unit_start_date > wjdi.last_unit_completion_date
877: /* bug3669728 end */
878: );
879: else
880: update wip_job_dtls_interface wjdi
881: set process_status = wip_constants.error
882: where group_id = p_group_id
883: and process_phase = wip_constants.ml_validation
884: and process_status in (wip_constants.running,

Line 918: from wip_job_dtls_interface wjdi

914: p_wip_entity_id in number,
915: p_organization_id in number) is
916: cursor c_invalid_rows is
917: select interface_id
918: from wip_job_dtls_interface wjdi
919: where group_id = p_group_id
920: and process_phase = wip_constants.ml_validation
921: and process_status in (wip_constants.running,
922: wip_constants.warning)

Line 951: update wip_job_dtls_interface wjdi

947: end if;
948: end loop;
949:
950: if(l_error_exists) then
951: update wip_job_dtls_interface wjdi
952: set process_status = wip_constants.error
953: where group_id = p_group_id
954: and process_phase = wip_constants.ml_validation
955: and process_status in (wip_constants.running,

Line 975: from wip_job_dtls_interface wjdi

971: p_organization_id in number) is
972:
973: cursor c_invalid_rows is
974: select interface_id
975: from wip_job_dtls_interface wjdi
976: where group_id = p_group_id
977: and process_phase = wip_constants.ml_validation
978: and process_status in (wip_constants.running,
979: wip_constants.warning)

Line 1029: update wip_job_dtls_interface wjdi

1025: end if;
1026: end loop;
1027:
1028: if(l_error_exists) then
1029: update wip_job_dtls_interface wjdi
1030: set process_status = wip_constants.error
1031: where group_id = p_group_id
1032: and process_phase = wip_constants.ml_validation
1033: and process_status in (wip_constants.running,