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_RESOURCE_VALIDATIONS dependencies on WIP_CONSTANTS

Line 36: and wjdi.process_phase = wip_constants.ml_validation

32: cursor c_invalid_rows is
33: select interface_id
34: from wip_job_dtls_interface wjdi
35: where wjdi.group_id = p_group_id
36: and wjdi.process_phase = wip_constants.ml_validation
37: and wjdi.process_status in (wip_constants.running,
38: wip_constants.warning)
39: and wjdi.wip_entity_id = p_wip_entity_id
40: and wjdi.organization_id = p_organization_id

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

33: select interface_id
34: from wip_job_dtls_interface wjdi
35: where wjdi.group_id = p_group_id
36: and wjdi.process_phase = wip_constants.ml_validation
37: and wjdi.process_status in (wip_constants.running,
38: wip_constants.warning)
39: and wjdi.wip_entity_id = p_wip_entity_id
40: and wjdi.organization_id = p_organization_id
41: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 38: wip_constants.warning)

34: from wip_job_dtls_interface wjdi
35: where wjdi.group_id = p_group_id
36: and wjdi.process_phase = wip_constants.ml_validation
37: and wjdi.process_status in (wip_constants.running,
38: wip_constants.warning)
39: and wjdi.wip_entity_id = p_wip_entity_id
40: and wjdi.organization_id = p_organization_id
41: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
42: and wjdi.substitution_type = p_substitution_type

Line 67: set process_status = wip_constants.error

63: end loop;
64:
65: if(l_error_exists) then
66: update wip_job_dtls_interface wjdi
67: set process_status = wip_constants.error
68: where group_id = p_group_id
69: and process_phase = wip_constants.ml_validation
70: and process_status in (wip_constants.running,
71: wip_constants.warning)

Line 69: and process_phase = wip_constants.ml_validation

65: if(l_error_exists) then
66: update wip_job_dtls_interface wjdi
67: set process_status = wip_constants.error
68: where group_id = p_group_id
69: and process_phase = wip_constants.ml_validation
70: and process_status in (wip_constants.running,
71: wip_constants.warning)
72: and wip_entity_id = p_wip_entity_id
73: and organization_id = p_organization_id

Line 70: and process_status in (wip_constants.running,

66: update wip_job_dtls_interface wjdi
67: set process_status = wip_constants.error
68: where group_id = p_group_id
69: and process_phase = wip_constants.ml_validation
70: and process_status in (wip_constants.running,
71: wip_constants.warning)
72: and wip_entity_id = p_wip_entity_id
73: and organization_id = p_organization_id
74: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 71: wip_constants.warning)

67: set process_status = wip_constants.error
68: where group_id = p_group_id
69: and process_phase = wip_constants.ml_validation
70: and process_status in (wip_constants.running,
71: wip_constants.warning)
72: and wip_entity_id = p_wip_entity_id
73: and organization_id = p_organization_id
74: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
75: and wjdi.substitution_type = p_substitution_type

Line 98: and wjdi.process_phase = wip_constants.ml_validation

94: cursor c_invalid_rows is
95: select interface_id
96: from wip_job_dtls_interface wjdi
97: where wjdi.group_id = p_group_id
98: and wjdi.process_phase = wip_constants.ml_validation
99: and wjdi.process_status in (wip_constants.running,
100: wip_constants.warning)
101: and wjdi.wip_entity_id = p_wip_entity_id
102: and wjdi.organization_id = p_organization_id

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

95: select interface_id
96: from wip_job_dtls_interface wjdi
97: where wjdi.group_id = p_group_id
98: and wjdi.process_phase = wip_constants.ml_validation
99: and wjdi.process_status in (wip_constants.running,
100: wip_constants.warning)
101: and wjdi.wip_entity_id = p_wip_entity_id
102: and wjdi.organization_id = p_organization_id
103: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 100: wip_constants.warning)

96: from wip_job_dtls_interface wjdi
97: where wjdi.group_id = p_group_id
98: and wjdi.process_phase = wip_constants.ml_validation
99: and wjdi.process_status in (wip_constants.running,
100: wip_constants.warning)
101: and wjdi.wip_entity_id = p_wip_entity_id
102: and wjdi.organization_id = p_organization_id
103: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
104: and wjdi.substitution_type = p_substitution_type

Line 145: set process_status = wip_constants.error

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

Line 147: and process_phase = wip_constants.ml_validation

143: if(l_error_exists) then
144: update wip_job_dtls_interface wjdi
145: set process_status = wip_constants.error
146: where group_id = p_group_id
147: and process_phase = wip_constants.ml_validation
148: and process_status in (wip_constants.running,
149: wip_constants.warning)
150: and wip_entity_id = p_wip_entity_id
151: and organization_id = p_organization_id

Line 148: and process_status in (wip_constants.running,

144: update wip_job_dtls_interface wjdi
145: set process_status = wip_constants.error
146: where group_id = p_group_id
147: and process_phase = wip_constants.ml_validation
148: and process_status in (wip_constants.running,
149: wip_constants.warning)
150: and wip_entity_id = p_wip_entity_id
151: and organization_id = p_organization_id
152: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 149: wip_constants.warning)

145: set process_status = wip_constants.error
146: where group_id = p_group_id
147: and process_phase = wip_constants.ml_validation
148: and process_status in (wip_constants.running,
149: wip_constants.warning)
150: and wip_entity_id = p_wip_entity_id
151: and organization_id = p_organization_id
152: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
153: and wjdi.substitution_type = p_substitution_type

Line 189: and wjdi.process_phase = wip_constants.ml_validation

185: cursor c_invalid_wor_rows is
186: select interface_id
187: from wip_job_dtls_interface wjdi, wip_operation_resources wor
188: where wjdi.group_id = p_group_id
189: and wjdi.process_phase = wip_constants.ml_validation
190: and wjdi.process_status in (wip_constants.running,
191: wip_constants.warning)
192: and wjdi.wip_entity_id = p_wip_entity_id
193: and wjdi.organization_id = p_organization_id

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

186: select interface_id
187: from wip_job_dtls_interface wjdi, wip_operation_resources wor
188: where wjdi.group_id = p_group_id
189: and wjdi.process_phase = wip_constants.ml_validation
190: and wjdi.process_status in (wip_constants.running,
191: wip_constants.warning)
192: and wjdi.wip_entity_id = p_wip_entity_id
193: and wjdi.organization_id = p_organization_id
194: and wjdi.load_type = wip_job_details.wip_resource

Line 191: wip_constants.warning)

187: from wip_job_dtls_interface wjdi, wip_operation_resources wor
188: where wjdi.group_id = p_group_id
189: and wjdi.process_phase = wip_constants.ml_validation
190: and wjdi.process_status in (wip_constants.running,
191: wip_constants.warning)
192: and wjdi.wip_entity_id = p_wip_entity_id
193: and wjdi.organization_id = p_organization_id
194: and wjdi.load_type = wip_job_details.wip_resource
195: and wjdi.substitution_type = p_substitution_type

Line 208: and wjdi.process_phase = wip_constants.ml_validation

204: cursor c_invalid_txn_rows is
205: select interface_id
206: from wip_job_dtls_interface wjdi
207: where wjdi.group_id = p_group_id
208: and wjdi.process_phase = wip_constants.ml_validation
209: and wjdi.process_status in (wip_constants.running,
210: wip_constants.warning)
211: and wjdi.wip_entity_id = p_wip_entity_id
212: and wjdi.organization_id = p_organization_id

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

205: select interface_id
206: from wip_job_dtls_interface wjdi
207: where wjdi.group_id = p_group_id
208: and wjdi.process_phase = wip_constants.ml_validation
209: and wjdi.process_status in (wip_constants.running,
210: wip_constants.warning)
211: and wjdi.wip_entity_id = p_wip_entity_id
212: and wjdi.organization_id = p_organization_id
213: and wjdi.load_type = wip_job_details.wip_resource

Line 210: wip_constants.warning)

206: from wip_job_dtls_interface wjdi
207: where wjdi.group_id = p_group_id
208: and wjdi.process_phase = wip_constants.ml_validation
209: and wjdi.process_status in (wip_constants.running,
210: wip_constants.warning)
211: and wjdi.wip_entity_id = p_wip_entity_id
212: and wjdi.organization_id = p_organization_id
213: and wjdi.load_type = wip_job_details.wip_resource
214: and wjdi.substitution_type = p_substitution_type

Line 255: set wjdi.process_status = wip_constants.error

251: end loop;
252:
253: if(l_error_exists) then
254: update wip_job_dtls_interface wjdi
255: set wjdi.process_status = wip_constants.error
256: where wjdi.group_id = p_group_id
257: and wjdi.process_phase = wip_constants.ml_validation
258: and wjdi.process_status in (wip_constants.running,
259: wip_constants.warning)

Line 257: and wjdi.process_phase = wip_constants.ml_validation

253: if(l_error_exists) then
254: update wip_job_dtls_interface wjdi
255: set wjdi.process_status = wip_constants.error
256: where wjdi.group_id = p_group_id
257: and wjdi.process_phase = wip_constants.ml_validation
258: and wjdi.process_status in (wip_constants.running,
259: wip_constants.warning)
260: and wjdi.wip_entity_id = p_wip_entity_id
261: and wjdi.organization_id = p_organization_id

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

254: update wip_job_dtls_interface wjdi
255: set wjdi.process_status = wip_constants.error
256: where wjdi.group_id = p_group_id
257: and wjdi.process_phase = wip_constants.ml_validation
258: and wjdi.process_status in (wip_constants.running,
259: wip_constants.warning)
260: and wjdi.wip_entity_id = p_wip_entity_id
261: and wjdi.organization_id = p_organization_id
262: and wjdi.load_type = wip_job_details.wip_resource

Line 259: wip_constants.warning)

255: set wjdi.process_status = wip_constants.error
256: where wjdi.group_id = p_group_id
257: and wjdi.process_phase = wip_constants.ml_validation
258: and wjdi.process_status in (wip_constants.running,
259: wip_constants.warning)
260: and wjdi.wip_entity_id = p_wip_entity_id
261: and wjdi.organization_id = p_organization_id
262: and wjdi.load_type = wip_job_details.wip_resource
263: and wjdi.substitution_type = p_substitution_type

Line 294: set process_status = wip_constants.error

290: end loop;
291:
292: if(l_error_exists) then
293: update wip_job_dtls_interface wjdi
294: set process_status = wip_constants.error
295: where wjdi.group_id = p_group_id
296: and wjdi.process_phase = wip_constants.ml_validation
297: and wjdi.process_status in (wip_constants.running,
298: wip_constants.warning)

Line 296: and wjdi.process_phase = wip_constants.ml_validation

292: if(l_error_exists) then
293: update wip_job_dtls_interface wjdi
294: set process_status = wip_constants.error
295: where wjdi.group_id = p_group_id
296: and wjdi.process_phase = wip_constants.ml_validation
297: and wjdi.process_status in (wip_constants.running,
298: wip_constants.warning)
299: and wjdi.wip_entity_id = p_wip_entity_id
300: and wjdi.organization_id = p_organization_id

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

293: update wip_job_dtls_interface wjdi
294: set process_status = wip_constants.error
295: where wjdi.group_id = p_group_id
296: and wjdi.process_phase = wip_constants.ml_validation
297: and wjdi.process_status in (wip_constants.running,
298: wip_constants.warning)
299: and wjdi.wip_entity_id = p_wip_entity_id
300: and wjdi.organization_id = p_organization_id
301: and wjdi.load_type = wip_job_details.wip_resource

Line 298: wip_constants.warning)

294: set process_status = wip_constants.error
295: where wjdi.group_id = p_group_id
296: and wjdi.process_phase = wip_constants.ml_validation
297: and wjdi.process_status in (wip_constants.running,
298: wip_constants.warning)
299: and wjdi.wip_entity_id = p_wip_entity_id
300: and wjdi.organization_id = p_organization_id
301: and wjdi.load_type = wip_job_details.wip_resource
302: and wjdi.substitution_type = p_substitution_type

Line 341: and wjdi.process_phase = wip_constants.ml_validation

337: cursor c_invalid_rows is
338: select interface_id
339: from wip_job_dtls_interface wjdi
340: where wjdi.group_id = p_group_id
341: and wjdi.process_phase = wip_constants.ml_validation
342: and wjdi.process_status in (wip_constants.running,
343: wip_constants.warning)
344: and wjdi.wip_entity_id = p_wip_entity_id
345: and wjdi.organization_id = p_organization_id

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

338: select interface_id
339: from wip_job_dtls_interface wjdi
340: where wjdi.group_id = p_group_id
341: and wjdi.process_phase = wip_constants.ml_validation
342: and wjdi.process_status in (wip_constants.running,
343: wip_constants.warning)
344: and wjdi.wip_entity_id = p_wip_entity_id
345: and wjdi.organization_id = p_organization_id
346: and wjdi.load_type = wip_job_details.wip_resource

Line 343: wip_constants.warning)

339: from wip_job_dtls_interface wjdi
340: where wjdi.group_id = p_group_id
341: and wjdi.process_phase = wip_constants.ml_validation
342: and wjdi.process_status in (wip_constants.running,
343: wip_constants.warning)
344: and wjdi.wip_entity_id = p_wip_entity_id
345: and wjdi.organization_id = p_organization_id
346: and wjdi.load_type = wip_job_details.wip_resource
347: and wjdi.substitution_type = p_substitution_type

Line 409: l_propagate_job_change_to_po = WIP_CONSTANTS.YES) THEN

405: -- There can't be any outside processing going on with the job
406: for l_inv_row in c_invalid_rows loop
407: IF(po_code_release_grp.Current_Release >=
408: po_code_release_grp.PRC_11i_Family_Pack_J AND
409: l_propagate_job_change_to_po = WIP_CONSTANTS.YES) THEN
410: -- cancel all PO/requisitions associate to this job/operation
411: wip_osp.cancelPOReq(p_job_id => p_wip_entity_id,
412: p_org_id => p_organization_id,
413: p_op_seq_num => p_operation_seq_num,

Line 455: set process_status = wip_constants.warning

451: end loop;
452:
453: if(l_warning_exists) then
454: update wip_job_dtls_interface wjdi
455: set process_status = wip_constants.warning
456: where wjdi.group_id = p_group_id
457: and wjdi.process_phase = wip_constants.ml_validation
458: and wjdi.process_status in (wip_constants.running,
459: wip_constants.warning)

Line 457: and wjdi.process_phase = wip_constants.ml_validation

453: if(l_warning_exists) then
454: update wip_job_dtls_interface wjdi
455: set process_status = wip_constants.warning
456: where wjdi.group_id = p_group_id
457: and wjdi.process_phase = wip_constants.ml_validation
458: and wjdi.process_status in (wip_constants.running,
459: wip_constants.warning)
460: and wjdi.wip_entity_id = p_wip_entity_id
461: and wjdi.organization_id = p_organization_id

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

454: update wip_job_dtls_interface wjdi
455: set process_status = wip_constants.warning
456: where wjdi.group_id = p_group_id
457: and wjdi.process_phase = wip_constants.ml_validation
458: and wjdi.process_status in (wip_constants.running,
459: wip_constants.warning)
460: and wjdi.wip_entity_id = p_wip_entity_id
461: and wjdi.organization_id = p_organization_id
462: and wjdi.load_type = wip_job_details.wip_resource

Line 459: wip_constants.warning)

455: set process_status = wip_constants.warning
456: where wjdi.group_id = p_group_id
457: and wjdi.process_phase = wip_constants.ml_validation
458: and wjdi.process_status in (wip_constants.running,
459: wip_constants.warning)
460: and wjdi.wip_entity_id = p_wip_entity_id
461: and wjdi.organization_id = p_organization_id
462: and wjdi.load_type = wip_job_details.wip_resource
463: and wjdi.substitution_type = p_substitution_type

Line 539: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

535: attribute8,attribute9,attribute10,attribute11,attribute12,
536: attribute13,attribute14,attribute15
537: FROM WIP_JOB_DTLS_INTERFACE
538: WHERE group_id = p_group_id
539: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
540: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
541: AND wip_entity_id = p_wip_entity_id
542: AND organization_id = p_organization_id
543: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE

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

536: attribute13,attribute14,attribute15
537: FROM WIP_JOB_DTLS_INTERFACE
538: WHERE group_id = p_group_id
539: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
540: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
541: AND wip_entity_id = p_wip_entity_id
542: AND organization_id = p_organization_id
543: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
544: AND substitution_type = p_substitution_type;

Line 620: and wjdi.process_phase = wip_constants.ml_validation

616: cursor c_invalid_rows is
617: select interface_id
618: from wip_job_dtls_interface wjdi
619: where wjdi.group_id = p_group_id
620: and wjdi.process_phase = wip_constants.ml_validation
621: and wjdi.process_status in (wip_constants.running,
622: wip_constants.warning)
623: and wjdi.wip_entity_id = p_wip_entity_id
624: and wjdi.organization_id = p_organization_id

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

617: select interface_id
618: from wip_job_dtls_interface wjdi
619: where wjdi.group_id = p_group_id
620: and wjdi.process_phase = wip_constants.ml_validation
621: and wjdi.process_status in (wip_constants.running,
622: wip_constants.warning)
623: and wjdi.wip_entity_id = p_wip_entity_id
624: and wjdi.organization_id = p_organization_id
625: and wjdi.load_type = wip_job_details.wip_resource

Line 622: wip_constants.warning)

618: from wip_job_dtls_interface wjdi
619: where wjdi.group_id = p_group_id
620: and wjdi.process_phase = wip_constants.ml_validation
621: and wjdi.process_status in (wip_constants.running,
622: wip_constants.warning)
623: and wjdi.wip_entity_id = p_wip_entity_id
624: and wjdi.organization_id = p_organization_id
625: and wjdi.load_type = wip_job_details.wip_resource
626: and wjdi.substitution_type = p_substitution_type

Line 651: set process_status = wip_constants.error

647: end loop;
648:
649: if(l_error_exists) then
650: update wip_job_dtls_interface wjdi
651: set process_status = wip_constants.error
652: where wjdi.group_id = p_group_id
653: and wjdi.process_phase = wip_constants.ml_validation
654: and wjdi.process_status in (wip_constants.running,
655: wip_constants.warning)

Line 653: and wjdi.process_phase = wip_constants.ml_validation

649: if(l_error_exists) then
650: update wip_job_dtls_interface wjdi
651: set process_status = wip_constants.error
652: where wjdi.group_id = p_group_id
653: and wjdi.process_phase = wip_constants.ml_validation
654: and wjdi.process_status in (wip_constants.running,
655: wip_constants.warning)
656: and wjdi.wip_entity_id = p_wip_entity_id
657: and wjdi.organization_id = p_organization_id

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

650: update wip_job_dtls_interface wjdi
651: set process_status = wip_constants.error
652: where wjdi.group_id = p_group_id
653: and wjdi.process_phase = wip_constants.ml_validation
654: and wjdi.process_status in (wip_constants.running,
655: wip_constants.warning)
656: and wjdi.wip_entity_id = p_wip_entity_id
657: and wjdi.organization_id = p_organization_id
658: and wjdi.load_type = wip_job_details.wip_resource

Line 655: wip_constants.warning)

651: set process_status = wip_constants.error
652: where wjdi.group_id = p_group_id
653: and wjdi.process_phase = wip_constants.ml_validation
654: and wjdi.process_status in (wip_constants.running,
655: wip_constants.warning)
656: and wjdi.wip_entity_id = p_wip_entity_id
657: and wjdi.organization_id = p_organization_id
658: and wjdi.load_type = wip_job_details.wip_resource
659: and wjdi.substitution_type = p_substitution_type

Line 679: and wjdi.process_phase = wip_constants.ml_validation

675: cursor c_invalid_rows is
676: select interface_id
677: from wip_job_dtls_interface wjdi
678: where wjdi.group_id = p_group_id
679: and wjdi.process_phase = wip_constants.ml_validation
680: and wjdi.process_status in (wip_constants.running,
681: wip_constants.warning)
682: and wjdi.wip_entity_id = p_wip_entity_id
683: and wjdi.organization_id = p_organization_id

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

676: select interface_id
677: from wip_job_dtls_interface wjdi
678: where wjdi.group_id = p_group_id
679: and wjdi.process_phase = wip_constants.ml_validation
680: and wjdi.process_status in (wip_constants.running,
681: wip_constants.warning)
682: and wjdi.wip_entity_id = p_wip_entity_id
683: and wjdi.organization_id = p_organization_id
684: and wjdi.load_type in (wip_job_details.wip_resource, wjdi.load_type)

Line 681: wip_constants.warning)

677: from wip_job_dtls_interface wjdi
678: where wjdi.group_id = p_group_id
679: and wjdi.process_phase = wip_constants.ml_validation
680: and wjdi.process_status in (wip_constants.running,
681: wip_constants.warning)
682: and wjdi.wip_entity_id = p_wip_entity_id
683: and wjdi.organization_id = p_organization_id
684: and wjdi.load_type in (wip_job_details.wip_resource, wjdi.load_type)
685: and wjdi.substitution_type = p_substitution_type

Line 713: set process_status = wip_constants.error

709: end loop;
710:
711: if(l_error_exists) then
712: update wip_job_dtls_interface wjdi
713: set process_status = wip_constants.error
714: where wjdi.group_id = p_group_id
715: and wjdi.process_phase = wip_constants.ml_validation
716: and wjdi.process_status in (wip_constants.running,
717: wip_constants.warning)

Line 715: and wjdi.process_phase = wip_constants.ml_validation

711: if(l_error_exists) then
712: update wip_job_dtls_interface wjdi
713: set process_status = wip_constants.error
714: where wjdi.group_id = p_group_id
715: and wjdi.process_phase = wip_constants.ml_validation
716: and wjdi.process_status in (wip_constants.running,
717: wip_constants.warning)
718: and wjdi.wip_entity_id = p_wip_entity_id
719: and wjdi.organization_id = p_organization_id

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

712: update wip_job_dtls_interface wjdi
713: set process_status = wip_constants.error
714: where wjdi.group_id = p_group_id
715: and wjdi.process_phase = wip_constants.ml_validation
716: and wjdi.process_status in (wip_constants.running,
717: wip_constants.warning)
718: and wjdi.wip_entity_id = p_wip_entity_id
719: and wjdi.organization_id = p_organization_id
720: and wjdi.load_type in (wip_job_details.wip_resource, wjdi.load_type)

Line 717: wip_constants.warning)

713: set process_status = wip_constants.error
714: where wjdi.group_id = p_group_id
715: and wjdi.process_phase = wip_constants.ml_validation
716: and wjdi.process_status in (wip_constants.running,
717: wip_constants.warning)
718: and wjdi.wip_entity_id = p_wip_entity_id
719: and wjdi.organization_id = p_organization_id
720: and wjdi.load_type in (wip_job_details.wip_resource, wjdi.load_type)
721: and wjdi.substitution_type = p_substitution_type

Line 743: and wjdi.process_phase = wip_constants.ml_validation

739: cursor c_invalid_rows is
740: select interface_id
741: from wip_job_dtls_interface wjdi
742: where wjdi.group_id = p_group_id
743: and wjdi.process_phase = wip_constants.ml_validation
744: and wjdi.process_status in (wip_constants.running,
745: wip_constants.warning)
746: and wjdi.wip_entity_id = p_wip_entity_id
747: and wjdi.organization_id = p_organization_id

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

740: select interface_id
741: from wip_job_dtls_interface wjdi
742: where wjdi.group_id = p_group_id
743: and wjdi.process_phase = wip_constants.ml_validation
744: and wjdi.process_status in (wip_constants.running,
745: wip_constants.warning)
746: and wjdi.wip_entity_id = p_wip_entity_id
747: and wjdi.organization_id = p_organization_id
748: and wjdi.load_type in (wip_job_details.wip_resource, wjdi.load_type)

Line 745: wip_constants.warning)

741: from wip_job_dtls_interface wjdi
742: where wjdi.group_id = p_group_id
743: and wjdi.process_phase = wip_constants.ml_validation
744: and wjdi.process_status in (wip_constants.running,
745: wip_constants.warning)
746: and wjdi.wip_entity_id = p_wip_entity_id
747: and wjdi.organization_id = p_organization_id
748: and wjdi.load_type in (wip_job_details.wip_resource, wjdi.load_type)
749: and wjdi.substitution_type = p_substitution_type

Line 787: set process_status = wip_constants.error

783: end loop;
784:
785: if(l_error_exists) then
786: update wip_job_dtls_interface wjdi
787: set process_status = wip_constants.error
788: where wjdi.group_id = p_group_id
789: and wjdi.process_phase = wip_constants.ml_validation
790: and wjdi.process_status in (wip_constants.running,
791: wip_constants.warning)

Line 789: and wjdi.process_phase = wip_constants.ml_validation

785: if(l_error_exists) then
786: update wip_job_dtls_interface wjdi
787: set process_status = wip_constants.error
788: where wjdi.group_id = p_group_id
789: and wjdi.process_phase = wip_constants.ml_validation
790: and wjdi.process_status in (wip_constants.running,
791: wip_constants.warning)
792: and wjdi.wip_entity_id = p_wip_entity_id
793: and wjdi.organization_id = p_organization_id

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

786: update wip_job_dtls_interface wjdi
787: set process_status = wip_constants.error
788: where wjdi.group_id = p_group_id
789: and wjdi.process_phase = wip_constants.ml_validation
790: and wjdi.process_status in (wip_constants.running,
791: wip_constants.warning)
792: and wjdi.wip_entity_id = p_wip_entity_id
793: and wjdi.organization_id = p_organization_id
794: and wjdi.load_type in (wip_job_details.wip_resource, wjdi.load_type)

Line 791: wip_constants.warning)

787: set process_status = wip_constants.error
788: where wjdi.group_id = p_group_id
789: and wjdi.process_phase = wip_constants.ml_validation
790: and wjdi.process_status in (wip_constants.running,
791: wip_constants.warning)
792: and wjdi.wip_entity_id = p_wip_entity_id
793: and wjdi.organization_id = p_organization_id
794: and wjdi.load_type in (wip_job_details.wip_resource, wjdi.load_type)
795: and wjdi.substitution_type = p_substitution_type

Line 828: and wjdi.process_phase = wip_constants.ml_validation

824: cursor c_invalid_rows is
825: select interface_id
826: from wip_job_dtls_interface wjdi, wip_operations wo
827: where wjdi.group_id = p_group_id
828: and wjdi.process_phase = wip_constants.ml_validation
829: and wjdi.process_status in (wip_constants.running,
830: wip_constants.warning)
831: and wjdi.wip_entity_id = p_wip_entity_id
832: and wjdi.organization_id = p_organization_id

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

825: select interface_id
826: from wip_job_dtls_interface wjdi, wip_operations wo
827: where wjdi.group_id = p_group_id
828: and wjdi.process_phase = wip_constants.ml_validation
829: and wjdi.process_status in (wip_constants.running,
830: wip_constants.warning)
831: and wjdi.wip_entity_id = p_wip_entity_id
832: and wjdi.organization_id = p_organization_id
833: and wjdi.load_type in (wip_job_details.wip_resource, wjdi.load_type)

Line 830: wip_constants.warning)

826: from wip_job_dtls_interface wjdi, wip_operations wo
827: where wjdi.group_id = p_group_id
828: and wjdi.process_phase = wip_constants.ml_validation
829: and wjdi.process_status in (wip_constants.running,
830: wip_constants.warning)
831: and wjdi.wip_entity_id = p_wip_entity_id
832: and wjdi.organization_id = p_organization_id
833: and wjdi.load_type in (wip_job_details.wip_resource, wjdi.load_type)
834: and wjdi.substitution_type = p_substitution_type

Line 882: set process_status = wip_constants.error

878: end loop;
879:
880: if(l_error_exists) then
881: update wip_job_dtls_interface wjdi
882: set process_status = wip_constants.error
883: where wjdi.group_id = p_group_id
884: and wjdi.process_phase = wip_constants.ml_validation
885: and wjdi.process_status in (wip_constants.running,
886: wip_constants.warning)

Line 884: and wjdi.process_phase = wip_constants.ml_validation

880: if(l_error_exists) then
881: update wip_job_dtls_interface wjdi
882: set process_status = wip_constants.error
883: where wjdi.group_id = p_group_id
884: and wjdi.process_phase = wip_constants.ml_validation
885: and wjdi.process_status in (wip_constants.running,
886: wip_constants.warning)
887: and wjdi.wip_entity_id = p_wip_entity_id
888: and wjdi.organization_id = p_organization_id

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

881: update wip_job_dtls_interface wjdi
882: set process_status = wip_constants.error
883: where wjdi.group_id = p_group_id
884: and wjdi.process_phase = wip_constants.ml_validation
885: and wjdi.process_status in (wip_constants.running,
886: wip_constants.warning)
887: and wjdi.wip_entity_id = p_wip_entity_id
888: and wjdi.organization_id = p_organization_id
889: and wjdi.load_type in (wip_job_details.wip_resource, wjdi.load_type)

Line 886: wip_constants.warning)

882: set process_status = wip_constants.error
883: where wjdi.group_id = p_group_id
884: and wjdi.process_phase = wip_constants.ml_validation
885: and wjdi.process_status in (wip_constants.running,
886: wip_constants.warning)
887: and wjdi.wip_entity_id = p_wip_entity_id
888: and wjdi.organization_id = p_organization_id
889: and wjdi.load_type in (wip_job_details.wip_resource, wjdi.load_type)
890: and wjdi.substitution_type = p_substitution_type

Line 931: and wjdi.process_phase = wip_constants.ml_validation

927: cursor c_invalid_rows is
928: select wjdi.interface_id
929: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
930: where wjdi.group_id = p_group_id
931: and wjdi.process_phase = wip_constants.ml_validation
932: and wjdi.process_status in (wip_constants.running,
933: wip_constants.warning)
934: and wjdi.wip_entity_id = p_wip_entity_id
935: and wjdi.organization_id = p_organization_id

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

928: select wjdi.interface_id
929: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
930: where wjdi.group_id = p_group_id
931: and wjdi.process_phase = wip_constants.ml_validation
932: and wjdi.process_status in (wip_constants.running,
933: wip_constants.warning)
934: and wjdi.wip_entity_id = p_wip_entity_id
935: and wjdi.organization_id = p_organization_id
936: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 933: wip_constants.warning)

929: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
930: where wjdi.group_id = p_group_id
931: and wjdi.process_phase = wip_constants.ml_validation
932: and wjdi.process_status in (wip_constants.running,
933: wip_constants.warning)
934: and wjdi.wip_entity_id = p_wip_entity_id
935: and wjdi.organization_id = p_organization_id
936: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
937: and wjdi.substitution_type = p_substitution_type

Line 984: set process_status = wip_constants.error

980: end loop;
981:
982: if(l_error_exists) then
983: update wip_job_dtls_interface wjdi
984: set process_status = wip_constants.error
985: where wjdi.group_id = p_group_id
986: and wjdi.process_phase = wip_constants.ml_validation
987: and wjdi.process_status in (wip_constants.running,
988: wip_constants.warning)

Line 986: and wjdi.process_phase = wip_constants.ml_validation

982: if(l_error_exists) then
983: update wip_job_dtls_interface wjdi
984: set process_status = wip_constants.error
985: where wjdi.group_id = p_group_id
986: and wjdi.process_phase = wip_constants.ml_validation
987: and wjdi.process_status in (wip_constants.running,
988: wip_constants.warning)
989: and wjdi.wip_entity_id = p_wip_entity_id
990: and wjdi.organization_id = p_organization_id

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

983: update wip_job_dtls_interface wjdi
984: set process_status = wip_constants.error
985: where wjdi.group_id = p_group_id
986: and wjdi.process_phase = wip_constants.ml_validation
987: and wjdi.process_status in (wip_constants.running,
988: wip_constants.warning)
989: and wjdi.wip_entity_id = p_wip_entity_id
990: and wjdi.organization_id = p_organization_id
991: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 988: wip_constants.warning)

984: set process_status = wip_constants.error
985: where wjdi.group_id = p_group_id
986: and wjdi.process_phase = wip_constants.ml_validation
987: and wjdi.process_status in (wip_constants.running,
988: wip_constants.warning)
989: and wjdi.wip_entity_id = p_wip_entity_id
990: and wjdi.organization_id = p_organization_id
991: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
992: and wjdi.substitution_type = p_substitution_type

Line 1023: and wjdi.process_phase = wip_constants.ml_validation

1019: cursor c_invalid_rows is
1020: select interface_id, wjdi.usage_rate_or_amount
1021: from wip_job_dtls_interface wjdi
1022: where wjdi.group_id = p_group_id
1023: and wjdi.process_phase = wip_constants.ml_validation
1024: and wjdi.process_status in (wip_constants.running,
1025: wip_constants.warning)
1026: and wjdi.wip_entity_id = p_wip_entity_id
1027: and wjdi.organization_id = p_organization_id

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

1020: select interface_id, wjdi.usage_rate_or_amount
1021: from wip_job_dtls_interface wjdi
1022: where wjdi.group_id = p_group_id
1023: and wjdi.process_phase = wip_constants.ml_validation
1024: and wjdi.process_status in (wip_constants.running,
1025: wip_constants.warning)
1026: and wjdi.wip_entity_id = p_wip_entity_id
1027: and wjdi.organization_id = p_organization_id
1028: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 1025: wip_constants.warning)

1021: from wip_job_dtls_interface wjdi
1022: where wjdi.group_id = p_group_id
1023: and wjdi.process_phase = wip_constants.ml_validation
1024: and wjdi.process_status in (wip_constants.running,
1025: wip_constants.warning)
1026: and wjdi.wip_entity_id = p_wip_entity_id
1027: and wjdi.organization_id = p_organization_id
1028: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
1029: and wjdi.substitution_type = p_substitution_type

Line 1087: set process_status = wip_constants.error

1083: end loop;
1084:
1085: if(l_error_exists) then
1086: update wip_job_dtls_interface wjdi
1087: set process_status = wip_constants.error
1088: where wjdi.group_id = p_group_id
1089: and wjdi.process_phase = wip_constants.ml_validation
1090: and wjdi.process_status in (wip_constants.running,
1091: wip_constants.warning)

Line 1089: and wjdi.process_phase = wip_constants.ml_validation

1085: if(l_error_exists) then
1086: update wip_job_dtls_interface wjdi
1087: set process_status = wip_constants.error
1088: where wjdi.group_id = p_group_id
1089: and wjdi.process_phase = wip_constants.ml_validation
1090: and wjdi.process_status in (wip_constants.running,
1091: wip_constants.warning)
1092: and wjdi.wip_entity_id = p_wip_entity_id
1093: and wjdi.organization_id = p_organization_id

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

1086: update wip_job_dtls_interface wjdi
1087: set process_status = wip_constants.error
1088: where wjdi.group_id = p_group_id
1089: and wjdi.process_phase = wip_constants.ml_validation
1090: and wjdi.process_status in (wip_constants.running,
1091: wip_constants.warning)
1092: and wjdi.wip_entity_id = p_wip_entity_id
1093: and wjdi.organization_id = p_organization_id
1094: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 1091: wip_constants.warning)

1087: set process_status = wip_constants.error
1088: where wjdi.group_id = p_group_id
1089: and wjdi.process_phase = wip_constants.ml_validation
1090: and wjdi.process_status in (wip_constants.running,
1091: wip_constants.warning)
1092: and wjdi.wip_entity_id = p_wip_entity_id
1093: and wjdi.organization_id = p_organization_id
1094: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
1095: and wjdi.substitution_type = p_substitution_type

Line 1129: set process_status = wip_constants.error

1125: end loop;
1126:
1127: if(l_error_exists) then
1128: update wip_job_dtls_interface wjdi
1129: set process_status = wip_constants.error
1130: where wjdi.group_id = p_group_id
1131: and wjdi.process_phase = wip_constants.ml_validation
1132: and wjdi.process_status in (wip_constants.running,
1133: wip_constants.warning)

Line 1131: and wjdi.process_phase = wip_constants.ml_validation

1127: if(l_error_exists) then
1128: update wip_job_dtls_interface wjdi
1129: set process_status = wip_constants.error
1130: where wjdi.group_id = p_group_id
1131: and wjdi.process_phase = wip_constants.ml_validation
1132: and wjdi.process_status in (wip_constants.running,
1133: wip_constants.warning)
1134: and wjdi.wip_entity_id = p_wip_entity_id
1135: and wjdi.organization_id = p_organization_id

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

1128: update wip_job_dtls_interface wjdi
1129: set process_status = wip_constants.error
1130: where wjdi.group_id = p_group_id
1131: and wjdi.process_phase = wip_constants.ml_validation
1132: and wjdi.process_status in (wip_constants.running,
1133: wip_constants.warning)
1134: and wjdi.wip_entity_id = p_wip_entity_id
1135: and wjdi.organization_id = p_organization_id
1136: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 1133: wip_constants.warning)

1129: set process_status = wip_constants.error
1130: where wjdi.group_id = p_group_id
1131: and wjdi.process_phase = wip_constants.ml_validation
1132: and wjdi.process_status in (wip_constants.running,
1133: wip_constants.warning)
1134: and wjdi.wip_entity_id = p_wip_entity_id
1135: and wjdi.organization_id = p_organization_id
1136: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
1137: and wjdi.substitution_type = p_substitution_type

Line 1170: and wjdi.process_phase = wip_constants.ml_validation

1166: cursor c_invalid_rows is
1167: select interface_id
1168: from wip_job_dtls_interface wjdi
1169: where wjdi.group_id = p_group_id
1170: and wjdi.process_phase = wip_constants.ml_validation
1171: and wjdi.process_status in (
1172: wip_constants.running,
1173: wip_constants.warning)
1174: and wjdi.wip_entity_id = p_wip_entity_id

Line 1172: wip_constants.running,

1168: from wip_job_dtls_interface wjdi
1169: where wjdi.group_id = p_group_id
1170: and wjdi.process_phase = wip_constants.ml_validation
1171: and wjdi.process_status in (
1172: wip_constants.running,
1173: wip_constants.warning)
1174: and wjdi.wip_entity_id = p_wip_entity_id
1175: and wjdi.organization_id = p_organization_id
1176: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 1173: wip_constants.warning)

1169: where wjdi.group_id = p_group_id
1170: and wjdi.process_phase = wip_constants.ml_validation
1171: and wjdi.process_status in (
1172: wip_constants.running,
1173: wip_constants.warning)
1174: and wjdi.wip_entity_id = p_wip_entity_id
1175: and wjdi.organization_id = p_organization_id
1176: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
1177: and wjdi.substitution_type = p_substitution_type

Line 1262: set wjdi.process_status = wip_constants.error

1258: end loop;
1259:
1260: if(l_error_exists) then
1261: update wip_job_dtls_interface wjdi
1262: set wjdi.process_status = wip_constants.error
1263: where wjdi.group_id = p_group_id
1264: and wjdi.process_phase = wip_constants.ml_validation
1265: and wjdi.process_status in (wip_constants.running,
1266: wip_constants.warning)

Line 1264: and wjdi.process_phase = wip_constants.ml_validation

1260: if(l_error_exists) then
1261: update wip_job_dtls_interface wjdi
1262: set wjdi.process_status = wip_constants.error
1263: where wjdi.group_id = p_group_id
1264: and wjdi.process_phase = wip_constants.ml_validation
1265: and wjdi.process_status in (wip_constants.running,
1266: wip_constants.warning)
1267: and wjdi.wip_entity_id = p_wip_entity_id
1268: and wjdi.organization_id = p_organization_id

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

1261: update wip_job_dtls_interface wjdi
1262: set wjdi.process_status = wip_constants.error
1263: where wjdi.group_id = p_group_id
1264: and wjdi.process_phase = wip_constants.ml_validation
1265: and wjdi.process_status in (wip_constants.running,
1266: wip_constants.warning)
1267: and wjdi.wip_entity_id = p_wip_entity_id
1268: and wjdi.organization_id = p_organization_id
1269: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 1266: wip_constants.warning)

1262: set wjdi.process_status = wip_constants.error
1263: where wjdi.group_id = p_group_id
1264: and wjdi.process_phase = wip_constants.ml_validation
1265: and wjdi.process_status in (wip_constants.running,
1266: wip_constants.warning)
1267: and wjdi.wip_entity_id = p_wip_entity_id
1268: and wjdi.organization_id = p_organization_id
1269: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
1270: and wjdi.substitution_type = p_substitution_type

Line 1448: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1444: attribute13,attribute14,attribute15, schedule_seq_num,
1445: substitute_group_num, replacement_group_num, parent_seq_num, rowid
1446: FROM WIP_JOB_DTLS_INTERFACE
1447: WHERE group_id = p_group_id
1448: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1449: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1450: AND wip_entity_id = p_wip_entity_id
1451: AND organization_id = p_organization_id
1452: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE

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

1445: substitute_group_num, replacement_group_num, parent_seq_num, rowid
1446: FROM WIP_JOB_DTLS_INTERFACE
1447: WHERE group_id = p_group_id
1448: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1449: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1450: AND wip_entity_id = p_wip_entity_id
1451: AND organization_id = p_organization_id
1452: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
1453: AND substitution_type = p_substitution_type;

Line 1614: and wjdi.process_phase = wip_constants.ml_validation

1610: cursor c_invalid_rows is
1611: select interface_id
1612: from wip_job_dtls_interface wjdi
1613: where wjdi.group_id = p_group_id
1614: and wjdi.process_phase = wip_constants.ml_validation
1615: and wjdi.process_status in (wip_constants.running,
1616: wip_constants.warning)
1617: and wjdi.wip_entity_id = p_wip_entity_id
1618: and wjdi.organization_id = p_organization_id

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

1611: select interface_id
1612: from wip_job_dtls_interface wjdi
1613: where wjdi.group_id = p_group_id
1614: and wjdi.process_phase = wip_constants.ml_validation
1615: and wjdi.process_status in (wip_constants.running,
1616: wip_constants.warning)
1617: and wjdi.wip_entity_id = p_wip_entity_id
1618: and wjdi.organization_id = p_organization_id
1619: and wjdi.load_type = wip_job_details.wip_resource

Line 1616: wip_constants.warning)

1612: from wip_job_dtls_interface wjdi
1613: where wjdi.group_id = p_group_id
1614: and wjdi.process_phase = wip_constants.ml_validation
1615: and wjdi.process_status in (wip_constants.running,
1616: wip_constants.warning)
1617: and wjdi.wip_entity_id = p_wip_entity_id
1618: and wjdi.organization_id = p_organization_id
1619: and wjdi.load_type = wip_job_details.wip_resource
1620: and wjdi.substitution_type = p_substitution_type

Line 1656: set process_status = wip_constants.error

1652: end if;
1653: end loop;
1654: if(l_error_exists) then
1655: update wip_job_dtls_interface wjdi
1656: set process_status = wip_constants.error
1657: where wjdi.group_id = p_group_id
1658: and wjdi.process_phase = wip_constants.ml_validation
1659: and wjdi.process_status in (wip_constants.running,
1660: wip_constants.warning)

Line 1658: and wjdi.process_phase = wip_constants.ml_validation

1654: if(l_error_exists) then
1655: update wip_job_dtls_interface wjdi
1656: set process_status = wip_constants.error
1657: where wjdi.group_id = p_group_id
1658: and wjdi.process_phase = wip_constants.ml_validation
1659: and wjdi.process_status in (wip_constants.running,
1660: wip_constants.warning)
1661: and wjdi.wip_entity_id = p_wip_entity_id
1662: and wjdi.organization_id = p_organization_id

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

1655: update wip_job_dtls_interface wjdi
1656: set process_status = wip_constants.error
1657: where wjdi.group_id = p_group_id
1658: and wjdi.process_phase = wip_constants.ml_validation
1659: and wjdi.process_status in (wip_constants.running,
1660: wip_constants.warning)
1661: and wjdi.wip_entity_id = p_wip_entity_id
1662: and wjdi.organization_id = p_organization_id
1663: and wjdi.load_type in (wip_job_details.wip_resource)

Line 1660: wip_constants.warning)

1656: set process_status = wip_constants.error
1657: where wjdi.group_id = p_group_id
1658: and wjdi.process_phase = wip_constants.ml_validation
1659: and wjdi.process_status in (wip_constants.running,
1660: wip_constants.warning)
1661: and wjdi.wip_entity_id = p_wip_entity_id
1662: and wjdi.organization_id = p_organization_id
1663: and wjdi.load_type in (wip_job_details.wip_resource)
1664: and wjdi.substitution_type = p_substitution_type

Line 1681: and wjdi.process_phase = wip_constants.ml_validation

1677: cursor c_invalid_rows is
1678: select interface_id
1679: from wip_job_dtls_interface wjdi
1680: where wjdi.group_id = p_group_id
1681: and wjdi.process_phase = wip_constants.ml_validation
1682: and wjdi.process_status in (wip_constants.running,
1683: wip_constants.warning)
1684: and wjdi.wip_entity_id = p_wip_entity_id
1685: and wjdi.organization_id = p_organization_id

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

1678: select interface_id
1679: from wip_job_dtls_interface wjdi
1680: where wjdi.group_id = p_group_id
1681: and wjdi.process_phase = wip_constants.ml_validation
1682: and wjdi.process_status in (wip_constants.running,
1683: wip_constants.warning)
1684: and wjdi.wip_entity_id = p_wip_entity_id
1685: and wjdi.organization_id = p_organization_id
1686: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 1683: wip_constants.warning)

1679: from wip_job_dtls_interface wjdi
1680: where wjdi.group_id = p_group_id
1681: and wjdi.process_phase = wip_constants.ml_validation
1682: and wjdi.process_status in (wip_constants.running,
1683: wip_constants.warning)
1684: and wjdi.wip_entity_id = p_wip_entity_id
1685: and wjdi.organization_id = p_organization_id
1686: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
1687: and wjdi.substitution_type = p_substitution_type

Line 1718: set process_status = wip_constants.error

1714: end loop;
1715:
1716: if(l_error_exists) then
1717: update wip_job_dtls_interface wjdi
1718: set process_status = wip_constants.error
1719: where wjdi.group_id = p_group_id
1720: and wjdi.process_phase = wip_constants.ml_validation
1721: and wjdi.process_status in (wip_constants.running,
1722: wip_constants.warning)

Line 1720: and wjdi.process_phase = wip_constants.ml_validation

1716: if(l_error_exists) then
1717: update wip_job_dtls_interface wjdi
1718: set process_status = wip_constants.error
1719: where wjdi.group_id = p_group_id
1720: and wjdi.process_phase = wip_constants.ml_validation
1721: and wjdi.process_status in (wip_constants.running,
1722: wip_constants.warning)
1723: and wjdi.wip_entity_id = p_wip_entity_id
1724: and wjdi.organization_id = p_organization_id

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

1717: update wip_job_dtls_interface wjdi
1718: set process_status = wip_constants.error
1719: where wjdi.group_id = p_group_id
1720: and wjdi.process_phase = wip_constants.ml_validation
1721: and wjdi.process_status in (wip_constants.running,
1722: wip_constants.warning)
1723: and wjdi.wip_entity_id = p_wip_entity_id
1724: and wjdi.organization_id = p_organization_id
1725: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 1722: wip_constants.warning)

1718: set process_status = wip_constants.error
1719: where wjdi.group_id = p_group_id
1720: and wjdi.process_phase = wip_constants.ml_validation
1721: and wjdi.process_status in (wip_constants.running,
1722: wip_constants.warning)
1723: and wjdi.wip_entity_id = p_wip_entity_id
1724: and wjdi.organization_id = p_organization_id
1725: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
1726: and wjdi.substitution_type = p_substitution_type

Line 1787: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1783: schedule_seq_num, substitute_group_num,
1784: replacement_group_num, parent_seq_num, rowid
1785: FROM WIP_JOB_DTLS_INTERFACE
1786: WHERE group_id = p_group_id
1787: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1788: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1789: AND wip_entity_id = p_wip_entity_id
1790: AND organization_id = p_organization_id
1791: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE

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

1784: replacement_group_num, parent_seq_num, rowid
1785: FROM WIP_JOB_DTLS_INTERFACE
1786: WHERE group_id = p_group_id
1787: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1788: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1789: AND wip_entity_id = p_wip_entity_id
1790: AND organization_id = p_organization_id
1791: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
1792: AND substitution_type = p_substitution_type;

Line 2006: AND process_status = WIP_CONSTANTS.ERROR

2002: SELECT count(*)
2003: INTO x_count
2004: FROM WIP_JOB_DTLS_INTERFACE
2005: WHERE group_id = p_group_id
2006: AND process_status = WIP_CONSTANTS.ERROR
2007: AND wip_entity_id = p_wip_entity_id
2008: AND organization_id = p_organization_id
2009: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
2010: AND substitution_type= p_substitution_type

Line 2038: AND process_status = WIP_CONSTANTS.ERROR

2034: SELECT count(*)
2035: INTO x_count
2036: FROM WIP_JOB_DTLS_INTERFACE
2037: WHERE group_id = p_group_id
2038: AND process_status = WIP_CONSTANTS.ERROR
2039: AND wip_entity_id = p_wip_entity_id
2040: AND organization_id = p_organization_id
2041: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
2042: AND substitution_type= p_substitution_type

Line 2052: AND process_status = WIP_CONSTANTS.ERROR

2048: SELECT count(*)
2049: INTO x_count
2050: FROM WIP_JOB_DTLS_INTERFACE
2051: WHERE group_id = p_group_id
2052: AND process_status = WIP_CONSTANTS.ERROR
2053: AND wip_entity_id = p_wip_entity_id
2054: AND organization_id = p_organization_id
2055: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
2056: AND substitution_type= p_substitution_type

Line 2066: AND process_status = WIP_CONSTANTS.ERROR

2062: SELECT count(*)
2063: INTO x_count
2064: FROM WIP_JOB_DTLS_INTERFACE
2065: WHERE group_id = p_group_id
2066: AND process_status = WIP_CONSTANTS.ERROR
2067: AND wip_entity_id = p_wip_entity_id
2068: AND organization_id = p_organization_id
2069: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
2070: AND substitution_type= p_substitution_type

Line 2110: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

2106: attribute8,attribute9,attribute10,attribute11,attribute12,
2107: attribute13,attribute14,attribute15
2108: FROM WIP_JOB_DTLS_INTERFACE
2109: WHERE group_id = p_group_id
2110: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2111: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2112: AND wip_entity_id = p_wip_entity_id
2113: AND organization_id = p_organization_id
2114: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES

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

2107: attribute13,attribute14,attribute15
2108: FROM WIP_JOB_DTLS_INTERFACE
2109: WHERE group_id = p_group_id
2110: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2111: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2112: AND wip_entity_id = p_wip_entity_id
2113: AND organization_id = p_organization_id
2114: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES
2115: AND substitution_type = p_substitution_type;

Line 2160: and wjdi.process_phase = wip_constants.ml_validation

2156: cursor c_invalid_rows is
2157: select interface_id
2158: from wip_job_dtls_interface wjdi
2159: where wjdi.group_id = p_group_id
2160: and wjdi.process_phase = wip_constants.ml_validation
2161: and wjdi.process_status in (wip_constants.running,
2162: wip_constants.warning)
2163: and wjdi.wip_entity_id = p_wip_entity_id
2164: and wjdi.organization_id = p_organization_id

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

2157: select interface_id
2158: from wip_job_dtls_interface wjdi
2159: where wjdi.group_id = p_group_id
2160: and wjdi.process_phase = wip_constants.ml_validation
2161: and wjdi.process_status in (wip_constants.running,
2162: wip_constants.warning)
2163: and wjdi.wip_entity_id = p_wip_entity_id
2164: and wjdi.organization_id = p_organization_id
2165: and wjdi.load_type = wip_job_details.wip_resource

Line 2162: wip_constants.warning)

2158: from wip_job_dtls_interface wjdi
2159: where wjdi.group_id = p_group_id
2160: and wjdi.process_phase = wip_constants.ml_validation
2161: and wjdi.process_status in (wip_constants.running,
2162: wip_constants.warning)
2163: and wjdi.wip_entity_id = p_wip_entity_id
2164: and wjdi.organization_id = p_organization_id
2165: and wjdi.load_type = wip_job_details.wip_resource
2166: and wjdi.substitution_type = p_substitution_type

Line 2219: and wjdi.process_phase = wip_constants.ml_validation

2215: select wjdi.substitute_group_num,
2216: wjdi.replacement_group_num
2217: from wip_job_dtls_interface wjdi
2218: where wjdi.group_id = p_group_id
2219: and wjdi.process_phase = wip_constants.ml_validation
2220: and wjdi.process_status in (wip_constants.running,
2221: wip_constants.warning)
2222: and wjdi.wip_entity_id = p_wip_entity_id
2223: and wjdi.organization_id = p_organization_id

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

2216: wjdi.replacement_group_num
2217: from wip_job_dtls_interface wjdi
2218: where wjdi.group_id = p_group_id
2219: and wjdi.process_phase = wip_constants.ml_validation
2220: and wjdi.process_status in (wip_constants.running,
2221: wip_constants.warning)
2222: and wjdi.wip_entity_id = p_wip_entity_id
2223: and wjdi.organization_id = p_organization_id
2224: and wjdi.load_type = wip_job_details.wip_resource

Line 2221: wip_constants.warning)

2217: from wip_job_dtls_interface wjdi
2218: where wjdi.group_id = p_group_id
2219: and wjdi.process_phase = wip_constants.ml_validation
2220: and wjdi.process_status in (wip_constants.running,
2221: wip_constants.warning)
2222: and wjdi.wip_entity_id = p_wip_entity_id
2223: and wjdi.organization_id = p_organization_id
2224: and wjdi.load_type = wip_job_details.wip_resource
2225: and wjdi.substitution_type = p_substitution_type

Line 2258: and process_phase = wip_constants.ml_validation

2254: resource_seq_num,
2255: substitute_group_num
2256: from wip_job_dtls_interface
2257: where group_id = p_group_id
2258: and process_phase = wip_constants.ml_validation
2259: and process_status in (wip_constants.running,
2260: wip_constants.warning)
2261: and wip_entity_id = p_wip_entity_id
2262: and organization_id = p_organization_id

Line 2259: and process_status in (wip_constants.running,

2255: substitute_group_num
2256: from wip_job_dtls_interface
2257: where group_id = p_group_id
2258: and process_phase = wip_constants.ml_validation
2259: and process_status in (wip_constants.running,
2260: wip_constants.warning)
2261: and wip_entity_id = p_wip_entity_id
2262: and organization_id = p_organization_id
2263: and load_type = wip_job_details.wip_resource

Line 2260: wip_constants.warning)

2256: from wip_job_dtls_interface
2257: where group_id = p_group_id
2258: and process_phase = wip_constants.ml_validation
2259: and process_status in (wip_constants.running,
2260: wip_constants.warning)
2261: and wip_entity_id = p_wip_entity_id
2262: and organization_id = p_organization_id
2263: and load_type = wip_job_details.wip_resource
2264: and substitution_type = p_substitution_type

Line 2294: set process_status = wip_constants.error

2290: end loop;
2291:
2292: if(l_error_exists) then
2293: update wip_job_dtls_interface wjdi
2294: set process_status = wip_constants.error
2295: where wjdi.group_id = p_group_id
2296: and wjdi.process_phase = wip_constants.ml_validation
2297: and wjdi.process_status in (wip_constants.running,
2298: wip_constants.warning)

Line 2296: and wjdi.process_phase = wip_constants.ml_validation

2292: if(l_error_exists) then
2293: update wip_job_dtls_interface wjdi
2294: set process_status = wip_constants.error
2295: where wjdi.group_id = p_group_id
2296: and wjdi.process_phase = wip_constants.ml_validation
2297: and wjdi.process_status in (wip_constants.running,
2298: wip_constants.warning)
2299: and wjdi.wip_entity_id = p_wip_entity_id
2300: and wjdi.organization_id = p_organization_id

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

2293: update wip_job_dtls_interface wjdi
2294: set process_status = wip_constants.error
2295: where wjdi.group_id = p_group_id
2296: and wjdi.process_phase = wip_constants.ml_validation
2297: and wjdi.process_status in (wip_constants.running,
2298: wip_constants.warning)
2299: and wjdi.wip_entity_id = p_wip_entity_id
2300: and wjdi.organization_id = p_organization_id
2301: and wjdi.load_type = wip_job_details.wip_resource

Line 2298: wip_constants.warning)

2294: set process_status = wip_constants.error
2295: where wjdi.group_id = p_group_id
2296: and wjdi.process_phase = wip_constants.ml_validation
2297: and wjdi.process_status in (wip_constants.running,
2298: wip_constants.warning)
2299: and wjdi.wip_entity_id = p_wip_entity_id
2300: and wjdi.organization_id = p_organization_id
2301: and wjdi.load_type = wip_job_details.wip_resource
2302: and wjdi.substitution_type = p_substitution_type

Line 2373: and wjdi.process_phase = wip_constants.ml_validation

2369: cursor c_invalid_rows is
2370: select interface_id
2371: from wip_job_dtls_interface wjdi
2372: where wjdi.group_id = p_group_id
2373: and wjdi.process_phase = wip_constants.ml_validation
2374: and wjdi.process_status in (wip_constants.running,
2375: wip_constants.warning)
2376: and wjdi.wip_entity_id = p_wip_entity_id
2377: and wjdi.organization_id = p_organization_id

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

2370: select interface_id
2371: from wip_job_dtls_interface wjdi
2372: where wjdi.group_id = p_group_id
2373: and wjdi.process_phase = wip_constants.ml_validation
2374: and wjdi.process_status in (wip_constants.running,
2375: wip_constants.warning)
2376: and wjdi.wip_entity_id = p_wip_entity_id
2377: and wjdi.organization_id = p_organization_id
2378: and wjdi.load_type = wip_job_details.wip_sub_res

Line 2375: wip_constants.warning)

2371: from wip_job_dtls_interface wjdi
2372: where wjdi.group_id = p_group_id
2373: and wjdi.process_phase = wip_constants.ml_validation
2374: and wjdi.process_status in (wip_constants.running,
2375: wip_constants.warning)
2376: and wjdi.wip_entity_id = p_wip_entity_id
2377: and wjdi.organization_id = p_organization_id
2378: and wjdi.load_type = wip_job_details.wip_sub_res
2379: and wjdi.substitution_type = p_substitution_type

Line 2423: set process_status = wip_constants.error

2419: end loop;
2420:
2421: if(l_error_exists) then
2422: update wip_job_dtls_interface wjdi
2423: set process_status = wip_constants.error
2424: where wjdi.group_id = p_group_id
2425: and wjdi.process_phase = wip_constants.ml_validation
2426: and wjdi.process_status in (wip_constants.running,
2427: wip_constants.warning)

Line 2425: and wjdi.process_phase = wip_constants.ml_validation

2421: if(l_error_exists) then
2422: update wip_job_dtls_interface wjdi
2423: set process_status = wip_constants.error
2424: where wjdi.group_id = p_group_id
2425: and wjdi.process_phase = wip_constants.ml_validation
2426: and wjdi.process_status in (wip_constants.running,
2427: wip_constants.warning)
2428: and wjdi.wip_entity_id = p_wip_entity_id
2429: and wjdi.organization_id = p_organization_id

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

2422: update wip_job_dtls_interface wjdi
2423: set process_status = wip_constants.error
2424: where wjdi.group_id = p_group_id
2425: and wjdi.process_phase = wip_constants.ml_validation
2426: and wjdi.process_status in (wip_constants.running,
2427: wip_constants.warning)
2428: and wjdi.wip_entity_id = p_wip_entity_id
2429: and wjdi.organization_id = p_organization_id
2430: and wjdi.load_type = wip_job_details.wip_sub_res

Line 2427: wip_constants.warning)

2423: set process_status = wip_constants.error
2424: where wjdi.group_id = p_group_id
2425: and wjdi.process_phase = wip_constants.ml_validation
2426: and wjdi.process_status in (wip_constants.running,
2427: wip_constants.warning)
2428: and wjdi.wip_entity_id = p_wip_entity_id
2429: and wjdi.organization_id = p_organization_id
2430: and wjdi.load_type = wip_job_details.wip_sub_res
2431: and wjdi.substitution_type = p_substitution_type

Line 2488: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

2484: attribute13,attribute14,attribute15,schedule_seq_num,
2485: substitute_group_num, replacement_group_num, parent_seq_num, rowid
2486: FROM WIP_JOB_DTLS_INTERFACE
2487: WHERE group_id = p_group_id
2488: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2489: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2490: AND wip_entity_id = p_wip_entity_id
2491: AND organization_id = p_organization_id
2492: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES

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

2485: substitute_group_num, replacement_group_num, parent_seq_num, rowid
2486: FROM WIP_JOB_DTLS_INTERFACE
2487: WHERE group_id = p_group_id
2488: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2489: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2490: AND wip_entity_id = p_wip_entity_id
2491: AND organization_id = p_organization_id
2492: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES
2493: AND substitution_type = p_substitution_type;

Line 2665: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

2661: attribute13,attribute14,attribute15,schedule_seq_num,
2662: substitute_group_num, replacement_group_num
2663: FROM WIP_JOB_DTLS_INTERFACE
2664: WHERE group_id = p_group_id
2665: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2666: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2667: AND wip_entity_id = p_wip_entity_id
2668: AND organization_id = p_organization_id
2669: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES

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

2662: substitute_group_num, replacement_group_num
2663: FROM WIP_JOB_DTLS_INTERFACE
2664: WHERE group_id = p_group_id
2665: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2666: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2667: AND wip_entity_id = p_wip_entity_id
2668: AND organization_id = p_organization_id
2669: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES
2670: AND substitution_type = p_substitution_type;

Line 2831: and wjdi.process_phase = wip_constants.ml_validation

2827: cursor sched_rows is
2828: select *
2829: from wip_job_dtls_interface wjdi
2830: where wjdi.group_id = p_group_id
2831: and wjdi.process_phase = wip_constants.ml_validation
2832: and wjdi.process_status in (wip_constants.running,
2833: wip_constants.warning)
2834: and wjdi.wip_entity_id = p_wip_entity_id
2835: and wjdi.organization_id = p_organization_id

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

2828: select *
2829: from wip_job_dtls_interface wjdi
2830: where wjdi.group_id = p_group_id
2831: and wjdi.process_phase = wip_constants.ml_validation
2832: and wjdi.process_status in (wip_constants.running,
2833: wip_constants.warning)
2834: and wjdi.wip_entity_id = p_wip_entity_id
2835: and wjdi.organization_id = p_organization_id
2836: and wjdi.load_type = wip_job_details.wip_resource

Line 2833: wip_constants.warning)

2829: from wip_job_dtls_interface wjdi
2830: where wjdi.group_id = p_group_id
2831: and wjdi.process_phase = wip_constants.ml_validation
2832: and wjdi.process_status in (wip_constants.running,
2833: wip_constants.warning)
2834: and wjdi.wip_entity_id = p_wip_entity_id
2835: and wjdi.organization_id = p_organization_id
2836: and wjdi.load_type = wip_job_details.wip_resource
2837: and wjdi.substitution_type = p_substitution_type

Line 2879: set process_status = wip_constants.error

2875: p_error_type => wip_jdi_utils.msg_error);
2876: end if;
2877:
2878: update wip_job_dtls_interface
2879: set process_status = wip_constants.error
2880: where current of sched_rows;
2881: return;
2882: end if;
2883:

Line 3013: and wjdi.process_phase = wip_constants.ml_validation

3009: cursor sched_rows is
3010: select *
3011: from wip_job_dtls_interface wjdi
3012: where wjdi.group_id = p_group_id
3013: and wjdi.process_phase = wip_constants.ml_validation
3014: and wjdi.process_status in (wip_constants.running,
3015: wip_constants.warning)
3016: and wjdi.wip_entity_id = p_wip_entity_id
3017: and wjdi.organization_id = p_organization_id

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

3010: select *
3011: from wip_job_dtls_interface wjdi
3012: where wjdi.group_id = p_group_id
3013: and wjdi.process_phase = wip_constants.ml_validation
3014: and wjdi.process_status in (wip_constants.running,
3015: wip_constants.warning)
3016: and wjdi.wip_entity_id = p_wip_entity_id
3017: and wjdi.organization_id = p_organization_id
3018: and wjdi.load_type = wip_job_details.wip_sub_res

Line 3015: wip_constants.warning)

3011: from wip_job_dtls_interface wjdi
3012: where wjdi.group_id = p_group_id
3013: and wjdi.process_phase = wip_constants.ml_validation
3014: and wjdi.process_status in (wip_constants.running,
3015: wip_constants.warning)
3016: and wjdi.wip_entity_id = p_wip_entity_id
3017: and wjdi.organization_id = p_organization_id
3018: and wjdi.load_type = wip_job_details.wip_sub_res
3019: and wjdi.substitution_type = p_substitution_type

Line 3056: set process_status = wip_constants.error

3052: p_error_type => wip_jdi_utils.msg_error);
3053: end if;
3054:
3055: update wip_job_dtls_interface
3056: set process_status = wip_constants.error
3057: where current of sched_rows;
3058:
3059: return;
3060: end if;

Line 3077: set process_status = wip_constants.error

3073: p_error_type => wip_jdi_utils.msg_error);
3074: end if;
3075:
3076: update wip_job_dtls_interface
3077: set process_status = wip_constants.error
3078: where current of sched_rows;
3079:
3080: return;
3081: end if;

Line 3123: set process_status = wip_constants.error

3119: p_error_type => wip_jdi_utils.msg_error);
3120: end if;
3121:
3122: update wip_job_dtls_interface
3123: set process_status = wip_constants.error
3124: where current of sched_rows;
3125:
3126: return;
3127: end if;

Line 3140: and wjdi.process_phase = wip_constants.ml_validation

3136: cursor c_invalid_rows (p_operation_seq_num NUMBER) is
3137: select interface_id
3138: from wip_job_dtls_interface wjdi
3139: where wjdi.group_id = p_group_id
3140: and wjdi.process_phase = wip_constants.ml_validation
3141: and wjdi.process_status in (wip_constants.running,
3142: wip_constants.warning)
3143: and wjdi.wip_entity_id = p_wip_entity_id
3144: and wjdi.organization_id = p_organization_id

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

3137: select interface_id
3138: from wip_job_dtls_interface wjdi
3139: where wjdi.group_id = p_group_id
3140: and wjdi.process_phase = wip_constants.ml_validation
3141: and wjdi.process_status in (wip_constants.running,
3142: wip_constants.warning)
3143: and wjdi.wip_entity_id = p_wip_entity_id
3144: and wjdi.organization_id = p_organization_id
3145: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 3142: wip_constants.warning)

3138: from wip_job_dtls_interface wjdi
3139: where wjdi.group_id = p_group_id
3140: and wjdi.process_phase = wip_constants.ml_validation
3141: and wjdi.process_status in (wip_constants.running,
3142: wip_constants.warning)
3143: and wjdi.wip_entity_id = p_wip_entity_id
3144: and wjdi.organization_id = p_organization_id
3145: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
3146: and wjdi.operation_seq_num = p_operation_seq_num;

Line 3168: set wjdi.process_status = wip_constants.error

3164: end if;
3165: end loop;
3166:
3167: update wip_job_dtls_interface wjdi
3168: set wjdi.process_status = wip_constants.error
3169: where wjdi.group_id = p_group_id
3170: and wjdi.process_phase = wip_constants.ml_validation
3171: and wjdi.process_status in (wip_constants.running,
3172: wip_constants.warning)

Line 3170: and wjdi.process_phase = wip_constants.ml_validation

3166:
3167: update wip_job_dtls_interface wjdi
3168: set wjdi.process_status = wip_constants.error
3169: where wjdi.group_id = p_group_id
3170: and wjdi.process_phase = wip_constants.ml_validation
3171: and wjdi.process_status in (wip_constants.running,
3172: wip_constants.warning)
3173: and wjdi.wip_entity_id = p_wip_entity_id
3174: and wjdi.organization_id = p_organization_id

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

3167: update wip_job_dtls_interface wjdi
3168: set wjdi.process_status = wip_constants.error
3169: where wjdi.group_id = p_group_id
3170: and wjdi.process_phase = wip_constants.ml_validation
3171: and wjdi.process_status in (wip_constants.running,
3172: wip_constants.warning)
3173: and wjdi.wip_entity_id = p_wip_entity_id
3174: and wjdi.organization_id = p_organization_id
3175: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 3172: wip_constants.warning)

3168: set wjdi.process_status = wip_constants.error
3169: where wjdi.group_id = p_group_id
3170: and wjdi.process_phase = wip_constants.ml_validation
3171: and wjdi.process_status in (wip_constants.running,
3172: wip_constants.warning)
3173: and wjdi.wip_entity_id = p_wip_entity_id
3174: and wjdi.organization_id = p_organization_id
3175: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
3176: and wjdi.operation_seq_num = l_op_seq;