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.WIP_RES_INST_VALIDATIONS dependencies on WIP_CONSTANTS

Line 19: AND process_status = WIP_CONSTANTS.ERROR

15: SELECT count(*)
16: INTO x_count
17: FROM WIP_JOB_DTLS_INTERFACE
18: WHERE group_id = p_group_id
19: AND process_status = WIP_CONSTANTS.ERROR
20: AND wip_entity_id = p_wip_entity_id
21: AND organization_id = p_organization_id
22: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
23: AND substitution_type= p_substitution_type

Line 48: and wjdi.process_phase = wip_constants.ml_validation

44: cursor c_invalid_rows is
45: select interface_id
46: from wip_job_dtls_interface wjdi
47: where wjdi.group_id = p_group_id
48: and wjdi.process_phase = wip_constants.ml_validation
49: and wjdi.process_status in (wip_constants.running,
50: wip_constants.warning)
51: and wjdi.wip_entity_id = p_wip_entity_id
52: and wjdi.organization_id = p_organization_id

Line 49: and wjdi.process_status in (wip_constants.running,

45: select interface_id
46: from wip_job_dtls_interface wjdi
47: where wjdi.group_id = p_group_id
48: and wjdi.process_phase = wip_constants.ml_validation
49: and wjdi.process_status in (wip_constants.running,
50: wip_constants.warning)
51: and wjdi.wip_entity_id = p_wip_entity_id
52: and wjdi.organization_id = p_organization_id
53: and wjdi.load_type = wip_job_details.wip_res_instance

Line 50: wip_constants.warning)

46: from wip_job_dtls_interface wjdi
47: where wjdi.group_id = p_group_id
48: and wjdi.process_phase = wip_constants.ml_validation
49: and wjdi.process_status in (wip_constants.running,
50: wip_constants.warning)
51: and wjdi.wip_entity_id = p_wip_entity_id
52: and wjdi.organization_id = p_organization_id
53: and wjdi.load_type = wip_job_details.wip_res_instance
54: and wjdi.substitution_type = p_substitution_type

Line 97: set process_status = wip_constants.error

93: end loop;
94:
95: if(l_error_exists) then
96: update wip_job_dtls_interface wjdi
97: set process_status = wip_constants.error
98: where wjdi.group_id = p_group_id
99: and wjdi.process_phase = wip_constants.ml_validation
100: and wjdi.process_status in (wip_constants.running,
101: wip_constants.warning)

Line 99: and wjdi.process_phase = wip_constants.ml_validation

95: if(l_error_exists) then
96: update wip_job_dtls_interface wjdi
97: set process_status = wip_constants.error
98: where wjdi.group_id = p_group_id
99: and wjdi.process_phase = wip_constants.ml_validation
100: and wjdi.process_status in (wip_constants.running,
101: wip_constants.warning)
102: and wjdi.wip_entity_id = p_wip_entity_id
103: and wjdi.organization_id = p_organization_id

Line 100: and wjdi.process_status in (wip_constants.running,

96: update wip_job_dtls_interface wjdi
97: set process_status = wip_constants.error
98: where wjdi.group_id = p_group_id
99: and wjdi.process_phase = wip_constants.ml_validation
100: and wjdi.process_status in (wip_constants.running,
101: wip_constants.warning)
102: and wjdi.wip_entity_id = p_wip_entity_id
103: and wjdi.organization_id = p_organization_id
104: and wjdi.load_type = wip_job_details.wip_res_instance

Line 101: wip_constants.warning)

97: set process_status = wip_constants.error
98: where wjdi.group_id = p_group_id
99: and wjdi.process_phase = wip_constants.ml_validation
100: and wjdi.process_status in (wip_constants.running,
101: wip_constants.warning)
102: and wjdi.wip_entity_id = p_wip_entity_id
103: and wjdi.organization_id = p_organization_id
104: and wjdi.load_type = wip_job_details.wip_res_instance
105: and wjdi.substitution_type = p_substitution_type

Line 146: and wjdi.process_phase = wip_constants.ml_validation

142: cursor c_invalid_rows is
143: select interface_id
144: from wip_job_dtls_interface wjdi
145: where wjdi.group_id = p_group_id
146: and wjdi.process_phase = wip_constants.ml_validation
147: and wjdi.process_status in (wip_constants.running,
148: wip_constants.warning)
149: and wjdi.wip_entity_id = p_wip_entity_id
150: and wjdi.organization_id = p_organization_id

Line 147: and wjdi.process_status in (wip_constants.running,

143: select interface_id
144: from wip_job_dtls_interface wjdi
145: where wjdi.group_id = p_group_id
146: and wjdi.process_phase = wip_constants.ml_validation
147: and wjdi.process_status in (wip_constants.running,
148: wip_constants.warning)
149: and wjdi.wip_entity_id = p_wip_entity_id
150: and wjdi.organization_id = p_organization_id
151: and wjdi.load_type = wip_job_details.wip_res_instance

Line 148: wip_constants.warning)

144: from wip_job_dtls_interface wjdi
145: where wjdi.group_id = p_group_id
146: and wjdi.process_phase = wip_constants.ml_validation
147: and wjdi.process_status in (wip_constants.running,
148: wip_constants.warning)
149: and wjdi.wip_entity_id = p_wip_entity_id
150: and wjdi.organization_id = p_organization_id
151: and wjdi.load_type = wip_job_details.wip_res_instance
152: and wjdi.substitution_type = p_substitution_type

Line 183: set process_status = wip_constants.error

179: end loop;
180:
181: if(l_error_exists) then
182: update wip_job_dtls_interface wjdi
183: set process_status = wip_constants.error
184: where wjdi.group_id = p_group_id
185: and wjdi.process_phase = wip_constants.ml_validation
186: and wjdi.process_status in (wip_constants.running,
187: wip_constants.warning)

Line 185: and wjdi.process_phase = wip_constants.ml_validation

181: if(l_error_exists) then
182: update wip_job_dtls_interface wjdi
183: set process_status = wip_constants.error
184: where wjdi.group_id = p_group_id
185: and wjdi.process_phase = wip_constants.ml_validation
186: and wjdi.process_status in (wip_constants.running,
187: wip_constants.warning)
188: and wjdi.wip_entity_id = p_wip_entity_id
189: and wjdi.organization_id = p_organization_id

Line 186: and wjdi.process_status in (wip_constants.running,

182: update wip_job_dtls_interface wjdi
183: set process_status = wip_constants.error
184: where wjdi.group_id = p_group_id
185: and wjdi.process_phase = wip_constants.ml_validation
186: and wjdi.process_status in (wip_constants.running,
187: wip_constants.warning)
188: and wjdi.wip_entity_id = p_wip_entity_id
189: and wjdi.organization_id = p_organization_id
190: and wjdi.load_type = wip_job_details.wip_res_instance

Line 187: wip_constants.warning)

183: set process_status = wip_constants.error
184: where wjdi.group_id = p_group_id
185: and wjdi.process_phase = wip_constants.ml_validation
186: and wjdi.process_status in (wip_constants.running,
187: wip_constants.warning)
188: and wjdi.wip_entity_id = p_wip_entity_id
189: and wjdi.organization_id = p_organization_id
190: and wjdi.load_type = wip_job_details.wip_res_instance
191: and wjdi.substitution_type = p_substitution_type

Line 215: and wjdi.process_phase = wip_constants.ml_validation

211: cursor c_invalid_rows(p_dept_id number, p_resource_id number) is
212: select interface_id
213: from wip_job_dtls_interface wjdi
214: where wjdi.group_id = p_group_id
215: and wjdi.process_phase = wip_constants.ml_validation
216: and wjdi.process_status in (wip_constants.running,
217: wip_constants.warning)
218: and wjdi.wip_entity_id = p_wip_entity_id
219: and wjdi.organization_id = p_organization_id

Line 216: and wjdi.process_status in (wip_constants.running,

212: select interface_id
213: from wip_job_dtls_interface wjdi
214: where wjdi.group_id = p_group_id
215: and wjdi.process_phase = wip_constants.ml_validation
216: and wjdi.process_status in (wip_constants.running,
217: wip_constants.warning)
218: and wjdi.wip_entity_id = p_wip_entity_id
219: and wjdi.organization_id = p_organization_id
220: and wjdi.load_type = wip_job_details.wip_res_instance

Line 217: wip_constants.warning)

213: from wip_job_dtls_interface wjdi
214: where wjdi.group_id = p_group_id
215: and wjdi.process_phase = wip_constants.ml_validation
216: and wjdi.process_status in (wip_constants.running,
217: wip_constants.warning)
218: and wjdi.wip_entity_id = p_wip_entity_id
219: and wjdi.organization_id = p_organization_id
220: and wjdi.load_type = wip_job_details.wip_res_instance
221: and wjdi.substitution_type = p_substitution_type

Line 269: set process_status = wip_constants.error

265: end if;
266: end loop;
267: if(l_error_exists) then
268: update wip_job_dtls_interface wjdi
269: set process_status = wip_constants.error
270: where wjdi.group_id = p_group_id
271: and wjdi.process_phase = wip_constants.ml_validation
272: and wjdi.process_status in (wip_constants.running,
273: wip_constants.warning)

Line 271: and wjdi.process_phase = wip_constants.ml_validation

267: if(l_error_exists) then
268: update wip_job_dtls_interface wjdi
269: set process_status = wip_constants.error
270: where wjdi.group_id = p_group_id
271: and wjdi.process_phase = wip_constants.ml_validation
272: and wjdi.process_status in (wip_constants.running,
273: wip_constants.warning)
274: and wjdi.wip_entity_id = p_wip_entity_id
275: and wjdi.organization_id = p_organization_id

Line 272: and wjdi.process_status in (wip_constants.running,

268: update wip_job_dtls_interface wjdi
269: set process_status = wip_constants.error
270: where wjdi.group_id = p_group_id
271: and wjdi.process_phase = wip_constants.ml_validation
272: and wjdi.process_status in (wip_constants.running,
273: wip_constants.warning)
274: and wjdi.wip_entity_id = p_wip_entity_id
275: and wjdi.organization_id = p_organization_id
276: and wjdi.load_type in (wip_job_details.wip_res_instance, wjdi.load_type)

Line 273: wip_constants.warning)

269: set process_status = wip_constants.error
270: where wjdi.group_id = p_group_id
271: and wjdi.process_phase = wip_constants.ml_validation
272: and wjdi.process_status in (wip_constants.running,
273: wip_constants.warning)
274: and wjdi.wip_entity_id = p_wip_entity_id
275: and wjdi.organization_id = p_organization_id
276: and wjdi.load_type in (wip_job_details.wip_res_instance, wjdi.load_type)
277: and wjdi.substitution_type = p_substitution_type

Line 307: and wjdi.process_phase = wip_constants.ml_validation

303: cursor c_invalid_rows(p_dept_id number, p_resource_id number) is
304: select interface_id
305: from wip_job_dtls_interface wjdi
306: where wjdi.group_id = p_group_id
307: and wjdi.process_phase = wip_constants.ml_validation
308: and wjdi.process_status in (wip_constants.running,
309: wip_constants.warning)
310: and wjdi.wip_entity_id = p_wip_entity_id
311: and wjdi.organization_id = p_organization_id

Line 308: and wjdi.process_status in (wip_constants.running,

304: select interface_id
305: from wip_job_dtls_interface wjdi
306: where wjdi.group_id = p_group_id
307: and wjdi.process_phase = wip_constants.ml_validation
308: and wjdi.process_status in (wip_constants.running,
309: wip_constants.warning)
310: and wjdi.wip_entity_id = p_wip_entity_id
311: and wjdi.organization_id = p_organization_id
312: and wjdi.load_type = wip_job_details.wip_res_instance

Line 309: wip_constants.warning)

305: from wip_job_dtls_interface wjdi
306: where wjdi.group_id = p_group_id
307: and wjdi.process_phase = wip_constants.ml_validation
308: and wjdi.process_status in (wip_constants.running,
309: wip_constants.warning)
310: and wjdi.wip_entity_id = p_wip_entity_id
311: and wjdi.organization_id = p_organization_id
312: and wjdi.load_type = wip_job_details.wip_res_instance
313: and wjdi.substitution_type = p_substitution_type

Line 373: set process_status = wip_constants.error

369: end loop;
370: if(l_error_exists) then
371:
372: update wip_job_dtls_interface wjdi
373: set process_status = wip_constants.error
374: where wjdi.group_id = p_group_id
375: and wjdi.process_phase = wip_constants.ml_validation
376: and wjdi.process_status in (wip_constants.running,
377: wip_constants.warning)

Line 375: and wjdi.process_phase = wip_constants.ml_validation

371:
372: update wip_job_dtls_interface wjdi
373: set process_status = wip_constants.error
374: where wjdi.group_id = p_group_id
375: and wjdi.process_phase = wip_constants.ml_validation
376: and wjdi.process_status in (wip_constants.running,
377: wip_constants.warning)
378: and wjdi.wip_entity_id = p_wip_entity_id
379: and wjdi.organization_id = p_organization_id

Line 376: and wjdi.process_status in (wip_constants.running,

372: update wip_job_dtls_interface wjdi
373: set process_status = wip_constants.error
374: where wjdi.group_id = p_group_id
375: and wjdi.process_phase = wip_constants.ml_validation
376: and wjdi.process_status in (wip_constants.running,
377: wip_constants.warning)
378: and wjdi.wip_entity_id = p_wip_entity_id
379: and wjdi.organization_id = p_organization_id
380: and wjdi.load_type in (wip_job_details.wip_res_instance, wjdi.load_type)

Line 377: wip_constants.warning)

373: set process_status = wip_constants.error
374: where wjdi.group_id = p_group_id
375: and wjdi.process_phase = wip_constants.ml_validation
376: and wjdi.process_status in (wip_constants.running,
377: wip_constants.warning)
378: and wjdi.wip_entity_id = p_wip_entity_id
379: and wjdi.organization_id = p_organization_id
380: and wjdi.load_type in (wip_job_details.wip_res_instance, wjdi.load_type)
381: and wjdi.substitution_type = p_substitution_type

Line 425: and wjdi.process_phase = wip_constants.ml_validation

421: cursor c_invalid_rows(p_count number, p_assigned_units number) is
422: select interface_id
423: from wip_job_dtls_interface wjdi
424: where wjdi.group_id = p_group_id
425: and wjdi.process_phase = wip_constants.ml_validation
426: and wjdi.process_status in (wip_constants.running,
427: wip_constants.warning)
428: and wjdi.wip_entity_id = p_wip_entity_id
429: and wjdi.organization_id = p_organization_id

Line 426: and wjdi.process_status in (wip_constants.running,

422: select interface_id
423: from wip_job_dtls_interface wjdi
424: where wjdi.group_id = p_group_id
425: and wjdi.process_phase = wip_constants.ml_validation
426: and wjdi.process_status in (wip_constants.running,
427: wip_constants.warning)
428: and wjdi.wip_entity_id = p_wip_entity_id
429: and wjdi.organization_id = p_organization_id
430: and wjdi.load_type = wip_job_details.wip_res_instance

Line 427: wip_constants.warning)

423: from wip_job_dtls_interface wjdi
424: where wjdi.group_id = p_group_id
425: and wjdi.process_phase = wip_constants.ml_validation
426: and wjdi.process_status in (wip_constants.running,
427: wip_constants.warning)
428: and wjdi.wip_entity_id = p_wip_entity_id
429: and wjdi.organization_id = p_organization_id
430: and wjdi.load_type = wip_job_details.wip_res_instance
431: and wjdi.substitution_type = wip_job_details.wip_add

Line 538: if ( l_logLevel <= wip_constants.full_logging ) then

534: l_del_count := 0;
535: End;
536:
537:
538: if ( l_logLevel <= wip_constants.full_logging ) then
539: wip_logger.log('Number of current units = ' ||to_char(l_count), l_retStatus);
540: wip_logger.log('Number of units to be added = ' ||to_char(l_add_count), l_retStatus);
541: wip_logger.log('Number of units to be deleted = ' ||to_char(l_del_count), l_retStatus);
542: end if;

Line 564: set process_status = wip_constants.error

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

Line 566: and wjdi.process_phase = wip_constants.ml_validation

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

Line 567: and wjdi.process_status in (wip_constants.running,

563: update wip_job_dtls_interface wjdi
564: set process_status = wip_constants.error
565: where wjdi.group_id = p_group_id
566: and wjdi.process_phase = wip_constants.ml_validation
567: and wjdi.process_status in (wip_constants.running,
568: wip_constants.warning)
569: and wjdi.wip_entity_id = p_wip_entity_id
570: and wjdi.organization_id = p_organization_id
571: and wjdi.load_type = wip_job_details.wip_res_instance

Line 568: wip_constants.warning)

564: set process_status = wip_constants.error
565: where wjdi.group_id = p_group_id
566: and wjdi.process_phase = wip_constants.ml_validation
567: and wjdi.process_status in (wip_constants.running,
568: wip_constants.warning)
569: and wjdi.wip_entity_id = p_wip_entity_id
570: and wjdi.organization_id = p_organization_id
571: and wjdi.load_type = wip_job_details.wip_res_instance
572: and wjdi.substitution_type = wip_job_details.wip_add

Line 609: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

605: attribute13,attribute14,attribute15, schedule_seq_num,
606: substitute_group_num, replacement_group_num, parent_seq_num, rowid
607: FROM WIP_JOB_DTLS_INTERFACE
608: WHERE group_id = p_group_id
609: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
610: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
611: AND wip_entity_id = p_wip_entity_id
612: AND organization_id = p_organization_id
613: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE

Line 610: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

606: substitute_group_num, replacement_group_num, parent_seq_num, rowid
607: FROM WIP_JOB_DTLS_INTERFACE
608: WHERE group_id = p_group_id
609: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
610: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
611: AND wip_entity_id = p_wip_entity_id
612: AND organization_id = p_organization_id
613: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
614: AND substitution_type = p_substitution_type;

Line 762: and wjdi.process_phase = wip_constants.ml_validation

758: cursor c_invalid_rows is
759: select interface_id
760: from wip_job_dtls_interface wjdi
761: where wjdi.group_id = p_group_id
762: and wjdi.process_phase = wip_constants.ml_validation
763: and wjdi.process_status in (wip_constants.running,
764: wip_constants.warning)
765: and wjdi.wip_entity_id = p_wip_entity_id
766: and wjdi.organization_id = p_organization_id

Line 763: and wjdi.process_status in (wip_constants.running,

759: select interface_id
760: from wip_job_dtls_interface wjdi
761: where wjdi.group_id = p_group_id
762: and wjdi.process_phase = wip_constants.ml_validation
763: and wjdi.process_status in (wip_constants.running,
764: wip_constants.warning)
765: and wjdi.wip_entity_id = p_wip_entity_id
766: and wjdi.organization_id = p_organization_id
767: and wjdi.load_type = wip_job_details.wip_res_instance

Line 764: wip_constants.warning)

760: from wip_job_dtls_interface wjdi
761: where wjdi.group_id = p_group_id
762: and wjdi.process_phase = wip_constants.ml_validation
763: and wjdi.process_status in (wip_constants.running,
764: wip_constants.warning)
765: and wjdi.wip_entity_id = p_wip_entity_id
766: and wjdi.organization_id = p_organization_id
767: and wjdi.load_type = wip_job_details.wip_res_instance
768: and wjdi.substitution_type = p_substitution_type

Line 801: set process_status = wip_constants.error

797: end loop;
798:
799: if(l_error_exists) then
800: update wip_job_dtls_interface wjdi
801: set process_status = wip_constants.error
802: where group_id = p_group_id
803: and process_phase = wip_constants.ml_validation
804: and process_status in (wip_constants.running,
805: wip_constants.warning)

Line 803: and process_phase = wip_constants.ml_validation

799: if(l_error_exists) then
800: update wip_job_dtls_interface wjdi
801: set process_status = wip_constants.error
802: where group_id = p_group_id
803: and process_phase = wip_constants.ml_validation
804: and process_status in (wip_constants.running,
805: wip_constants.warning)
806: and wip_entity_id = p_wip_entity_id
807: and organization_id = p_organization_id

Line 804: and process_status in (wip_constants.running,

800: update wip_job_dtls_interface wjdi
801: set process_status = wip_constants.error
802: where group_id = p_group_id
803: and process_phase = wip_constants.ml_validation
804: and process_status in (wip_constants.running,
805: wip_constants.warning)
806: and wip_entity_id = p_wip_entity_id
807: and organization_id = p_organization_id
808: and wjdi.load_type in (wip_job_details.wip_res_instance)

Line 805: wip_constants.warning)

801: set process_status = wip_constants.error
802: where group_id = p_group_id
803: and process_phase = wip_constants.ml_validation
804: and process_status in (wip_constants.running,
805: wip_constants.warning)
806: and wip_entity_id = p_wip_entity_id
807: and organization_id = p_organization_id
808: and wjdi.load_type in (wip_job_details.wip_res_instance)
809: and wjdi.substitution_type = p_substitution_type

Line 855: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

851: attribute13,attribute14,attribute15, schedule_seq_num,
852: substitute_group_num, replacement_group_num
853: FROM WIP_JOB_DTLS_INTERFACE
854: WHERE group_id = p_group_id
855: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
856: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
857: AND wip_entity_id = p_wip_entity_id
858: AND organization_id = p_organization_id
859: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE

Line 856: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

852: substitute_group_num, replacement_group_num
853: FROM WIP_JOB_DTLS_INTERFACE
854: WHERE group_id = p_group_id
855: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
856: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
857: AND wip_entity_id = p_wip_entity_id
858: AND organization_id = p_organization_id
859: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
860: AND substitution_type = p_substitution_type;

Line 986: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

982: attribute13,attribute14,attribute15, schedule_seq_num,
983: substitute_group_num, replacement_group_num
984: FROM WIP_JOB_DTLS_INTERFACE
985: WHERE group_id = p_group_id
986: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
987: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
988: AND wip_entity_id = p_wip_entity_id
989: AND organization_id = p_organization_id
990: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE

Line 987: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

983: substitute_group_num, replacement_group_num
984: FROM WIP_JOB_DTLS_INTERFACE
985: WHERE group_id = p_group_id
986: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
987: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
988: AND wip_entity_id = p_wip_entity_id
989: AND organization_id = p_organization_id
990: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
991: AND substitution_type = p_substitution_type;