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 881: set process_status = wip_constants.error

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

Line 883: and wjdi.process_phase = wip_constants.ml_validation

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

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

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

Line 885: wip_constants.warning)

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

Line 929: and wjdi.process_phase = wip_constants.ml_validation

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

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

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

Line 931: wip_constants.warning)

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

Line 982: set process_status = wip_constants.error

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

Line 984: and wjdi.process_phase = wip_constants.ml_validation

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

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

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

Line 986: wip_constants.warning)

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

Line 1021: and wjdi.process_phase = wip_constants.ml_validation

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

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

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

Line 1023: wip_constants.warning)

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

Line 1084: set process_status = wip_constants.error

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

Line 1086: and wjdi.process_phase = wip_constants.ml_validation

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

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

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

Line 1088: wip_constants.warning)

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

Line 1125: set process_status = wip_constants.error

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

Line 1127: and wjdi.process_phase = wip_constants.ml_validation

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

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

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

Line 1129: wip_constants.warning)

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

Line 1162: and wjdi.process_phase = wip_constants.ml_validation

1158: cursor c_invalid_rows is
1159: select interface_id
1160: from wip_job_dtls_interface wjdi
1161: where wjdi.group_id = p_group_id
1162: and wjdi.process_phase = wip_constants.ml_validation
1163: and wjdi.process_status in (
1164: wip_constants.running,
1165: wip_constants.warning)
1166: and wjdi.wip_entity_id = p_wip_entity_id

Line 1164: wip_constants.running,

1160: from wip_job_dtls_interface wjdi
1161: where wjdi.group_id = p_group_id
1162: and wjdi.process_phase = wip_constants.ml_validation
1163: and wjdi.process_status in (
1164: wip_constants.running,
1165: wip_constants.warning)
1166: and wjdi.wip_entity_id = p_wip_entity_id
1167: and wjdi.organization_id = p_organization_id
1168: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 1165: wip_constants.warning)

1161: where wjdi.group_id = p_group_id
1162: and wjdi.process_phase = wip_constants.ml_validation
1163: and wjdi.process_status in (
1164: wip_constants.running,
1165: wip_constants.warning)
1166: and wjdi.wip_entity_id = p_wip_entity_id
1167: and wjdi.organization_id = p_organization_id
1168: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
1169: and wjdi.substitution_type = p_substitution_type

Line 1230: set wjdi.process_status = wip_constants.error

1226: end loop;
1227:
1228: if(l_error_exists) then
1229: update wip_job_dtls_interface wjdi
1230: set wjdi.process_status = wip_constants.error
1231: where wjdi.group_id = p_group_id
1232: and wjdi.process_phase = wip_constants.ml_validation
1233: and wjdi.process_status in (wip_constants.running,
1234: wip_constants.warning)

Line 1232: and wjdi.process_phase = wip_constants.ml_validation

1228: if(l_error_exists) then
1229: update wip_job_dtls_interface wjdi
1230: set wjdi.process_status = wip_constants.error
1231: where wjdi.group_id = p_group_id
1232: and wjdi.process_phase = wip_constants.ml_validation
1233: and wjdi.process_status in (wip_constants.running,
1234: wip_constants.warning)
1235: and wjdi.wip_entity_id = p_wip_entity_id
1236: and wjdi.organization_id = p_organization_id

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

1229: update wip_job_dtls_interface wjdi
1230: set wjdi.process_status = wip_constants.error
1231: where wjdi.group_id = p_group_id
1232: and wjdi.process_phase = wip_constants.ml_validation
1233: and wjdi.process_status in (wip_constants.running,
1234: wip_constants.warning)
1235: and wjdi.wip_entity_id = p_wip_entity_id
1236: and wjdi.organization_id = p_organization_id
1237: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 1234: wip_constants.warning)

1230: set wjdi.process_status = wip_constants.error
1231: where wjdi.group_id = p_group_id
1232: and wjdi.process_phase = wip_constants.ml_validation
1233: and wjdi.process_status in (wip_constants.running,
1234: wip_constants.warning)
1235: and wjdi.wip_entity_id = p_wip_entity_id
1236: and wjdi.organization_id = p_organization_id
1237: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
1238: and wjdi.substitution_type = p_substitution_type

Line 1416: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1412: attribute13,attribute14,attribute15, schedule_seq_num,
1413: substitute_group_num, replacement_group_num, parent_seq_num, rowid
1414: FROM WIP_JOB_DTLS_INTERFACE
1415: WHERE group_id = p_group_id
1416: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1417: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1418: AND wip_entity_id = p_wip_entity_id
1419: AND organization_id = p_organization_id
1420: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE

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

1413: substitute_group_num, replacement_group_num, parent_seq_num, rowid
1414: FROM WIP_JOB_DTLS_INTERFACE
1415: WHERE group_id = p_group_id
1416: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1417: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1418: AND wip_entity_id = p_wip_entity_id
1419: AND organization_id = p_organization_id
1420: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
1421: AND substitution_type = p_substitution_type;

Line 1582: and wjdi.process_phase = wip_constants.ml_validation

1578: cursor c_invalid_rows is
1579: select interface_id
1580: from wip_job_dtls_interface wjdi
1581: where wjdi.group_id = p_group_id
1582: and wjdi.process_phase = wip_constants.ml_validation
1583: and wjdi.process_status in (wip_constants.running,
1584: wip_constants.warning)
1585: and wjdi.wip_entity_id = p_wip_entity_id
1586: and wjdi.organization_id = p_organization_id

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

1579: select interface_id
1580: from wip_job_dtls_interface wjdi
1581: where wjdi.group_id = p_group_id
1582: and wjdi.process_phase = wip_constants.ml_validation
1583: and wjdi.process_status in (wip_constants.running,
1584: wip_constants.warning)
1585: and wjdi.wip_entity_id = p_wip_entity_id
1586: and wjdi.organization_id = p_organization_id
1587: and wjdi.load_type = wip_job_details.wip_resource

Line 1584: wip_constants.warning)

1580: from wip_job_dtls_interface wjdi
1581: where wjdi.group_id = p_group_id
1582: and wjdi.process_phase = wip_constants.ml_validation
1583: and wjdi.process_status in (wip_constants.running,
1584: wip_constants.warning)
1585: and wjdi.wip_entity_id = p_wip_entity_id
1586: and wjdi.organization_id = p_organization_id
1587: and wjdi.load_type = wip_job_details.wip_resource
1588: and wjdi.substitution_type = p_substitution_type

Line 1624: set process_status = wip_constants.error

1620: end if;
1621: end loop;
1622: if(l_error_exists) then
1623: update wip_job_dtls_interface wjdi
1624: set process_status = wip_constants.error
1625: where wjdi.group_id = p_group_id
1626: and wjdi.process_phase = wip_constants.ml_validation
1627: and wjdi.process_status in (wip_constants.running,
1628: wip_constants.warning)

Line 1626: and wjdi.process_phase = wip_constants.ml_validation

1622: if(l_error_exists) then
1623: update wip_job_dtls_interface wjdi
1624: set process_status = wip_constants.error
1625: where wjdi.group_id = p_group_id
1626: and wjdi.process_phase = wip_constants.ml_validation
1627: and wjdi.process_status in (wip_constants.running,
1628: wip_constants.warning)
1629: and wjdi.wip_entity_id = p_wip_entity_id
1630: and wjdi.organization_id = p_organization_id

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

1623: update wip_job_dtls_interface wjdi
1624: set process_status = wip_constants.error
1625: where wjdi.group_id = p_group_id
1626: and wjdi.process_phase = wip_constants.ml_validation
1627: and wjdi.process_status in (wip_constants.running,
1628: wip_constants.warning)
1629: and wjdi.wip_entity_id = p_wip_entity_id
1630: and wjdi.organization_id = p_organization_id
1631: and wjdi.load_type in (wip_job_details.wip_resource)

Line 1628: wip_constants.warning)

1624: set process_status = wip_constants.error
1625: where wjdi.group_id = p_group_id
1626: and wjdi.process_phase = wip_constants.ml_validation
1627: and wjdi.process_status in (wip_constants.running,
1628: wip_constants.warning)
1629: and wjdi.wip_entity_id = p_wip_entity_id
1630: and wjdi.organization_id = p_organization_id
1631: and wjdi.load_type in (wip_job_details.wip_resource)
1632: and wjdi.substitution_type = p_substitution_type

Line 1649: and wjdi.process_phase = wip_constants.ml_validation

1645: cursor c_invalid_rows is
1646: select interface_id
1647: from wip_job_dtls_interface wjdi
1648: where wjdi.group_id = p_group_id
1649: and wjdi.process_phase = wip_constants.ml_validation
1650: and wjdi.process_status in (wip_constants.running,
1651: wip_constants.warning)
1652: and wjdi.wip_entity_id = p_wip_entity_id
1653: and wjdi.organization_id = p_organization_id

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

1646: select interface_id
1647: from wip_job_dtls_interface wjdi
1648: where wjdi.group_id = p_group_id
1649: and wjdi.process_phase = wip_constants.ml_validation
1650: and wjdi.process_status in (wip_constants.running,
1651: wip_constants.warning)
1652: and wjdi.wip_entity_id = p_wip_entity_id
1653: and wjdi.organization_id = p_organization_id
1654: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 1651: wip_constants.warning)

1647: from wip_job_dtls_interface wjdi
1648: where wjdi.group_id = p_group_id
1649: and wjdi.process_phase = wip_constants.ml_validation
1650: and wjdi.process_status in (wip_constants.running,
1651: wip_constants.warning)
1652: and wjdi.wip_entity_id = p_wip_entity_id
1653: and wjdi.organization_id = p_organization_id
1654: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
1655: and wjdi.substitution_type = p_substitution_type

Line 1686: set process_status = wip_constants.error

1682: end loop;
1683:
1684: if(l_error_exists) then
1685: update wip_job_dtls_interface wjdi
1686: set process_status = wip_constants.error
1687: where wjdi.group_id = p_group_id
1688: and wjdi.process_phase = wip_constants.ml_validation
1689: and wjdi.process_status in (wip_constants.running,
1690: wip_constants.warning)

Line 1688: and wjdi.process_phase = wip_constants.ml_validation

1684: if(l_error_exists) then
1685: update wip_job_dtls_interface wjdi
1686: set process_status = wip_constants.error
1687: where wjdi.group_id = p_group_id
1688: and wjdi.process_phase = wip_constants.ml_validation
1689: and wjdi.process_status in (wip_constants.running,
1690: wip_constants.warning)
1691: and wjdi.wip_entity_id = p_wip_entity_id
1692: and wjdi.organization_id = p_organization_id

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

1685: update wip_job_dtls_interface wjdi
1686: set process_status = wip_constants.error
1687: where wjdi.group_id = p_group_id
1688: and wjdi.process_phase = wip_constants.ml_validation
1689: and wjdi.process_status in (wip_constants.running,
1690: wip_constants.warning)
1691: and wjdi.wip_entity_id = p_wip_entity_id
1692: and wjdi.organization_id = p_organization_id
1693: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 1690: wip_constants.warning)

1686: set process_status = wip_constants.error
1687: where wjdi.group_id = p_group_id
1688: and wjdi.process_phase = wip_constants.ml_validation
1689: and wjdi.process_status in (wip_constants.running,
1690: wip_constants.warning)
1691: and wjdi.wip_entity_id = p_wip_entity_id
1692: and wjdi.organization_id = p_organization_id
1693: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
1694: and wjdi.substitution_type = p_substitution_type

Line 1752: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1748: schedule_seq_num, substitute_group_num,
1749: replacement_group_num, parent_seq_num, rowid
1750: FROM WIP_JOB_DTLS_INTERFACE
1751: WHERE group_id = p_group_id
1752: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1753: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1754: AND wip_entity_id = p_wip_entity_id
1755: AND organization_id = p_organization_id
1756: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE

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

1749: replacement_group_num, parent_seq_num, rowid
1750: FROM WIP_JOB_DTLS_INTERFACE
1751: WHERE group_id = p_group_id
1752: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1753: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1754: AND wip_entity_id = p_wip_entity_id
1755: AND organization_id = p_organization_id
1756: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
1757: AND substitution_type = p_substitution_type;

Line 1960: AND process_status = WIP_CONSTANTS.ERROR

1956: SELECT count(*)
1957: INTO x_count
1958: FROM WIP_JOB_DTLS_INTERFACE
1959: WHERE group_id = p_group_id
1960: AND process_status = WIP_CONSTANTS.ERROR
1961: AND wip_entity_id = p_wip_entity_id
1962: AND organization_id = p_organization_id
1963: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
1964: AND substitution_type= p_substitution_type

Line 1992: AND process_status = WIP_CONSTANTS.ERROR

1988: SELECT count(*)
1989: INTO x_count
1990: FROM WIP_JOB_DTLS_INTERFACE
1991: WHERE group_id = p_group_id
1992: AND process_status = WIP_CONSTANTS.ERROR
1993: AND wip_entity_id = p_wip_entity_id
1994: AND organization_id = p_organization_id
1995: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
1996: 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 2020: AND process_status = WIP_CONSTANTS.ERROR

2016: SELECT count(*)
2017: INTO x_count
2018: FROM WIP_JOB_DTLS_INTERFACE
2019: WHERE group_id = p_group_id
2020: AND process_status = WIP_CONSTANTS.ERROR
2021: AND wip_entity_id = p_wip_entity_id
2022: AND organization_id = p_organization_id
2023: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
2024: AND substitution_type= p_substitution_type

Line 2066: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

2062: attribute8,attribute9,attribute10,attribute11,attribute12,
2063: attribute13,attribute14,attribute15
2064: FROM WIP_JOB_DTLS_INTERFACE
2065: WHERE group_id = p_group_id
2066: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2067: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2068: AND wip_entity_id = p_wip_entity_id
2069: AND organization_id = p_organization_id
2070: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES

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

2063: attribute13,attribute14,attribute15
2064: FROM WIP_JOB_DTLS_INTERFACE
2065: WHERE group_id = p_group_id
2066: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2067: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2068: AND wip_entity_id = p_wip_entity_id
2069: AND organization_id = p_organization_id
2070: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES
2071: AND substitution_type = p_substitution_type;

Line 2116: and wjdi.process_phase = wip_constants.ml_validation

2112: cursor c_invalid_rows is
2113: select interface_id
2114: from wip_job_dtls_interface wjdi
2115: where wjdi.group_id = p_group_id
2116: and wjdi.process_phase = wip_constants.ml_validation
2117: and wjdi.process_status in (wip_constants.running,
2118: wip_constants.warning)
2119: and wjdi.wip_entity_id = p_wip_entity_id
2120: and wjdi.organization_id = p_organization_id

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

2113: select interface_id
2114: from wip_job_dtls_interface wjdi
2115: where wjdi.group_id = p_group_id
2116: and wjdi.process_phase = wip_constants.ml_validation
2117: and wjdi.process_status in (wip_constants.running,
2118: wip_constants.warning)
2119: and wjdi.wip_entity_id = p_wip_entity_id
2120: and wjdi.organization_id = p_organization_id
2121: and wjdi.load_type = wip_job_details.wip_resource

Line 2118: wip_constants.warning)

2114: from wip_job_dtls_interface wjdi
2115: where wjdi.group_id = p_group_id
2116: and wjdi.process_phase = wip_constants.ml_validation
2117: and wjdi.process_status in (wip_constants.running,
2118: wip_constants.warning)
2119: and wjdi.wip_entity_id = p_wip_entity_id
2120: and wjdi.organization_id = p_organization_id
2121: and wjdi.load_type = wip_job_details.wip_resource
2122: and wjdi.substitution_type = p_substitution_type

Line 2174: and wjdi.process_phase = wip_constants.ml_validation

2170: select wjdi.substitute_group_num,
2171: wjdi.replacement_group_num
2172: from wip_job_dtls_interface wjdi
2173: where wjdi.group_id = p_group_id
2174: and wjdi.process_phase = wip_constants.ml_validation
2175: and wjdi.process_status in (wip_constants.running,
2176: wip_constants.warning)
2177: and wjdi.wip_entity_id = p_wip_entity_id
2178: and wjdi.organization_id = p_organization_id

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

2171: wjdi.replacement_group_num
2172: from wip_job_dtls_interface wjdi
2173: where wjdi.group_id = p_group_id
2174: and wjdi.process_phase = wip_constants.ml_validation
2175: and wjdi.process_status in (wip_constants.running,
2176: wip_constants.warning)
2177: and wjdi.wip_entity_id = p_wip_entity_id
2178: and wjdi.organization_id = p_organization_id
2179: and wjdi.load_type = wip_job_details.wip_resource

Line 2176: wip_constants.warning)

2172: from wip_job_dtls_interface wjdi
2173: where wjdi.group_id = p_group_id
2174: and wjdi.process_phase = wip_constants.ml_validation
2175: and wjdi.process_status in (wip_constants.running,
2176: wip_constants.warning)
2177: and wjdi.wip_entity_id = p_wip_entity_id
2178: and wjdi.organization_id = p_organization_id
2179: and wjdi.load_type = wip_job_details.wip_resource
2180: and wjdi.substitution_type = p_substitution_type

Line 2213: and process_phase = wip_constants.ml_validation

2209: resource_seq_num,
2210: substitute_group_num
2211: from wip_job_dtls_interface
2212: where group_id = p_group_id
2213: and process_phase = wip_constants.ml_validation
2214: and process_status in (wip_constants.running,
2215: wip_constants.warning)
2216: and wip_entity_id = p_wip_entity_id
2217: and organization_id = p_organization_id

Line 2214: and process_status in (wip_constants.running,

2210: substitute_group_num
2211: from wip_job_dtls_interface
2212: where group_id = p_group_id
2213: and process_phase = wip_constants.ml_validation
2214: and process_status in (wip_constants.running,
2215: wip_constants.warning)
2216: and wip_entity_id = p_wip_entity_id
2217: and organization_id = p_organization_id
2218: and load_type = wip_job_details.wip_resource

Line 2215: wip_constants.warning)

2211: from wip_job_dtls_interface
2212: where group_id = p_group_id
2213: and process_phase = wip_constants.ml_validation
2214: and process_status in (wip_constants.running,
2215: wip_constants.warning)
2216: and wip_entity_id = p_wip_entity_id
2217: and organization_id = p_organization_id
2218: and load_type = wip_job_details.wip_resource
2219: and substitution_type = p_substitution_type

Line 2249: set process_status = wip_constants.error

2245: end loop;
2246:
2247: if(l_error_exists) then
2248: update wip_job_dtls_interface wjdi
2249: set process_status = wip_constants.error
2250: where wjdi.group_id = p_group_id
2251: and wjdi.process_phase = wip_constants.ml_validation
2252: and wjdi.process_status in (wip_constants.running,
2253: wip_constants.warning)

Line 2251: and wjdi.process_phase = wip_constants.ml_validation

2247: if(l_error_exists) then
2248: update wip_job_dtls_interface wjdi
2249: set process_status = wip_constants.error
2250: where wjdi.group_id = p_group_id
2251: and wjdi.process_phase = wip_constants.ml_validation
2252: and wjdi.process_status in (wip_constants.running,
2253: wip_constants.warning)
2254: and wjdi.wip_entity_id = p_wip_entity_id
2255: and wjdi.organization_id = p_organization_id

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

2248: update wip_job_dtls_interface wjdi
2249: set process_status = wip_constants.error
2250: where wjdi.group_id = p_group_id
2251: and wjdi.process_phase = wip_constants.ml_validation
2252: and wjdi.process_status in (wip_constants.running,
2253: wip_constants.warning)
2254: and wjdi.wip_entity_id = p_wip_entity_id
2255: and wjdi.organization_id = p_organization_id
2256: and wjdi.load_type = wip_job_details.wip_resource

Line 2253: wip_constants.warning)

2249: set process_status = wip_constants.error
2250: where wjdi.group_id = p_group_id
2251: and wjdi.process_phase = wip_constants.ml_validation
2252: and wjdi.process_status in (wip_constants.running,
2253: wip_constants.warning)
2254: and wjdi.wip_entity_id = p_wip_entity_id
2255: and wjdi.organization_id = p_organization_id
2256: and wjdi.load_type = wip_job_details.wip_resource
2257: and wjdi.substitution_type = p_substitution_type

Line 2327: and wjdi.process_phase = wip_constants.ml_validation

2323: cursor c_invalid_rows is
2324: select interface_id
2325: from wip_job_dtls_interface wjdi
2326: where wjdi.group_id = p_group_id
2327: and wjdi.process_phase = wip_constants.ml_validation
2328: and wjdi.process_status in (wip_constants.running,
2329: wip_constants.warning)
2330: and wjdi.wip_entity_id = p_wip_entity_id
2331: and wjdi.organization_id = p_organization_id

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

2324: select interface_id
2325: from wip_job_dtls_interface wjdi
2326: where wjdi.group_id = p_group_id
2327: and wjdi.process_phase = wip_constants.ml_validation
2328: and wjdi.process_status in (wip_constants.running,
2329: wip_constants.warning)
2330: and wjdi.wip_entity_id = p_wip_entity_id
2331: and wjdi.organization_id = p_organization_id
2332: and wjdi.load_type = wip_job_details.wip_sub_res

Line 2329: wip_constants.warning)

2325: from wip_job_dtls_interface wjdi
2326: where wjdi.group_id = p_group_id
2327: and wjdi.process_phase = wip_constants.ml_validation
2328: and wjdi.process_status in (wip_constants.running,
2329: wip_constants.warning)
2330: and wjdi.wip_entity_id = p_wip_entity_id
2331: and wjdi.organization_id = p_organization_id
2332: and wjdi.load_type = wip_job_details.wip_sub_res
2333: and wjdi.substitution_type = p_substitution_type

Line 2376: set process_status = wip_constants.error

2372: end loop;
2373:
2374: if(l_error_exists) then
2375: update wip_job_dtls_interface wjdi
2376: set process_status = wip_constants.error
2377: where wjdi.group_id = p_group_id
2378: and wjdi.process_phase = wip_constants.ml_validation
2379: and wjdi.process_status in (wip_constants.running,
2380: wip_constants.warning)

Line 2378: and wjdi.process_phase = wip_constants.ml_validation

2374: if(l_error_exists) then
2375: update wip_job_dtls_interface wjdi
2376: set process_status = wip_constants.error
2377: where wjdi.group_id = p_group_id
2378: and wjdi.process_phase = wip_constants.ml_validation
2379: and wjdi.process_status in (wip_constants.running,
2380: wip_constants.warning)
2381: and wjdi.wip_entity_id = p_wip_entity_id
2382: and wjdi.organization_id = p_organization_id

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

2375: update wip_job_dtls_interface wjdi
2376: set process_status = wip_constants.error
2377: where wjdi.group_id = p_group_id
2378: and wjdi.process_phase = wip_constants.ml_validation
2379: and wjdi.process_status in (wip_constants.running,
2380: wip_constants.warning)
2381: and wjdi.wip_entity_id = p_wip_entity_id
2382: and wjdi.organization_id = p_organization_id
2383: and wjdi.load_type = wip_job_details.wip_sub_res

Line 2380: wip_constants.warning)

2376: set process_status = wip_constants.error
2377: where wjdi.group_id = p_group_id
2378: and wjdi.process_phase = wip_constants.ml_validation
2379: and wjdi.process_status in (wip_constants.running,
2380: wip_constants.warning)
2381: and wjdi.wip_entity_id = p_wip_entity_id
2382: and wjdi.organization_id = p_organization_id
2383: and wjdi.load_type = wip_job_details.wip_sub_res
2384: and wjdi.substitution_type = p_substitution_type

Line 2440: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

2436: attribute13,attribute14,attribute15,schedule_seq_num,
2437: substitute_group_num, replacement_group_num, parent_seq_num, rowid
2438: FROM WIP_JOB_DTLS_INTERFACE
2439: WHERE group_id = p_group_id
2440: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2441: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2442: AND wip_entity_id = p_wip_entity_id
2443: AND organization_id = p_organization_id
2444: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES

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

2437: substitute_group_num, replacement_group_num, parent_seq_num, rowid
2438: FROM WIP_JOB_DTLS_INTERFACE
2439: WHERE group_id = p_group_id
2440: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2441: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2442: AND wip_entity_id = p_wip_entity_id
2443: AND organization_id = p_organization_id
2444: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES
2445: AND substitution_type = p_substitution_type;

Line 2617: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

2613: attribute13,attribute14,attribute15,schedule_seq_num,
2614: substitute_group_num, replacement_group_num
2615: FROM WIP_JOB_DTLS_INTERFACE
2616: WHERE group_id = p_group_id
2617: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2618: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2619: AND wip_entity_id = p_wip_entity_id
2620: AND organization_id = p_organization_id
2621: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES

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

2614: substitute_group_num, replacement_group_num
2615: FROM WIP_JOB_DTLS_INTERFACE
2616: WHERE group_id = p_group_id
2617: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2618: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2619: AND wip_entity_id = p_wip_entity_id
2620: AND organization_id = p_organization_id
2621: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES
2622: AND substitution_type = p_substitution_type;

Line 2783: and wjdi.process_phase = wip_constants.ml_validation

2779: cursor sched_rows is
2780: select *
2781: from wip_job_dtls_interface wjdi
2782: where wjdi.group_id = p_group_id
2783: and wjdi.process_phase = wip_constants.ml_validation
2784: and wjdi.process_status in (wip_constants.running,
2785: wip_constants.warning)
2786: and wjdi.wip_entity_id = p_wip_entity_id
2787: and wjdi.organization_id = p_organization_id

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

2780: select *
2781: from wip_job_dtls_interface wjdi
2782: where wjdi.group_id = p_group_id
2783: and wjdi.process_phase = wip_constants.ml_validation
2784: and wjdi.process_status in (wip_constants.running,
2785: wip_constants.warning)
2786: and wjdi.wip_entity_id = p_wip_entity_id
2787: and wjdi.organization_id = p_organization_id
2788: and wjdi.load_type = wip_job_details.wip_resource

Line 2785: wip_constants.warning)

2781: from wip_job_dtls_interface wjdi
2782: where wjdi.group_id = p_group_id
2783: and wjdi.process_phase = wip_constants.ml_validation
2784: and wjdi.process_status in (wip_constants.running,
2785: wip_constants.warning)
2786: and wjdi.wip_entity_id = p_wip_entity_id
2787: and wjdi.organization_id = p_organization_id
2788: and wjdi.load_type = wip_job_details.wip_resource
2789: and wjdi.substitution_type = p_substitution_type

Line 2826: set process_status = wip_constants.error

2822: p_error_type => wip_jdi_utils.msg_error);
2823: end if;
2824:
2825: update wip_job_dtls_interface
2826: set process_status = wip_constants.error
2827: where current of sched_rows;
2828:
2829: return;
2830: end if;

Line 2940: and wjdi.process_phase = wip_constants.ml_validation

2936: cursor sched_rows is
2937: select *
2938: from wip_job_dtls_interface wjdi
2939: where wjdi.group_id = p_group_id
2940: and wjdi.process_phase = wip_constants.ml_validation
2941: and wjdi.process_status in (wip_constants.running,
2942: wip_constants.warning)
2943: and wjdi.wip_entity_id = p_wip_entity_id
2944: and wjdi.organization_id = p_organization_id

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

2937: select *
2938: from wip_job_dtls_interface wjdi
2939: where wjdi.group_id = p_group_id
2940: and wjdi.process_phase = wip_constants.ml_validation
2941: and wjdi.process_status in (wip_constants.running,
2942: wip_constants.warning)
2943: and wjdi.wip_entity_id = p_wip_entity_id
2944: and wjdi.organization_id = p_organization_id
2945: and wjdi.load_type = wip_job_details.wip_sub_res

Line 2942: wip_constants.warning)

2938: from wip_job_dtls_interface wjdi
2939: where wjdi.group_id = p_group_id
2940: and wjdi.process_phase = wip_constants.ml_validation
2941: and wjdi.process_status in (wip_constants.running,
2942: wip_constants.warning)
2943: and wjdi.wip_entity_id = p_wip_entity_id
2944: and wjdi.organization_id = p_organization_id
2945: and wjdi.load_type = wip_job_details.wip_sub_res
2946: and wjdi.substitution_type = p_substitution_type

Line 2983: set process_status = wip_constants.error

2979: p_error_type => wip_jdi_utils.msg_error);
2980: end if;
2981:
2982: update wip_job_dtls_interface
2983: set process_status = wip_constants.error
2984: where current of sched_rows;
2985:
2986: return;
2987: end if;

Line 3004: set process_status = wip_constants.error

3000: p_error_type => wip_jdi_utils.msg_error);
3001: end if;
3002:
3003: update wip_job_dtls_interface
3004: set process_status = wip_constants.error
3005: where current of sched_rows;
3006:
3007: return;
3008: end if;

Line 3050: set process_status = wip_constants.error

3046: p_error_type => wip_jdi_utils.msg_error);
3047: end if;
3048:
3049: update wip_job_dtls_interface
3050: set process_status = wip_constants.error
3051: where current of sched_rows;
3052:
3053: return;
3054: end if;

Line 3067: and wjdi.process_phase = wip_constants.ml_validation

3063: cursor c_invalid_rows (p_operation_seq_num NUMBER) is
3064: select interface_id
3065: from wip_job_dtls_interface wjdi
3066: where wjdi.group_id = p_group_id
3067: and wjdi.process_phase = wip_constants.ml_validation
3068: and wjdi.process_status in (wip_constants.running,
3069: wip_constants.warning)
3070: and wjdi.wip_entity_id = p_wip_entity_id
3071: and wjdi.organization_id = p_organization_id

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

3064: select interface_id
3065: from wip_job_dtls_interface wjdi
3066: where wjdi.group_id = p_group_id
3067: and wjdi.process_phase = wip_constants.ml_validation
3068: and wjdi.process_status in (wip_constants.running,
3069: wip_constants.warning)
3070: and wjdi.wip_entity_id = p_wip_entity_id
3071: and wjdi.organization_id = p_organization_id
3072: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 3069: wip_constants.warning)

3065: from wip_job_dtls_interface wjdi
3066: where wjdi.group_id = p_group_id
3067: and wjdi.process_phase = wip_constants.ml_validation
3068: and wjdi.process_status in (wip_constants.running,
3069: wip_constants.warning)
3070: and wjdi.wip_entity_id = p_wip_entity_id
3071: and wjdi.organization_id = p_organization_id
3072: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
3073: and wjdi.operation_seq_num = p_operation_seq_num;

Line 3095: set wjdi.process_status = wip_constants.error

3091: end if;
3092: end loop;
3093:
3094: update wip_job_dtls_interface wjdi
3095: set wjdi.process_status = wip_constants.error
3096: where wjdi.group_id = p_group_id
3097: and wjdi.process_phase = wip_constants.ml_validation
3098: and wjdi.process_status in (wip_constants.running,
3099: wip_constants.warning)

Line 3097: and wjdi.process_phase = wip_constants.ml_validation

3093:
3094: update wip_job_dtls_interface wjdi
3095: set wjdi.process_status = wip_constants.error
3096: where wjdi.group_id = p_group_id
3097: and wjdi.process_phase = wip_constants.ml_validation
3098: and wjdi.process_status in (wip_constants.running,
3099: wip_constants.warning)
3100: and wjdi.wip_entity_id = p_wip_entity_id
3101: and wjdi.organization_id = p_organization_id

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

3094: update wip_job_dtls_interface wjdi
3095: set wjdi.process_status = wip_constants.error
3096: where wjdi.group_id = p_group_id
3097: and wjdi.process_phase = wip_constants.ml_validation
3098: and wjdi.process_status in (wip_constants.running,
3099: wip_constants.warning)
3100: and wjdi.wip_entity_id = p_wip_entity_id
3101: and wjdi.organization_id = p_organization_id
3102: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)

Line 3099: wip_constants.warning)

3095: set wjdi.process_status = wip_constants.error
3096: where wjdi.group_id = p_group_id
3097: and wjdi.process_phase = wip_constants.ml_validation
3098: and wjdi.process_status in (wip_constants.running,
3099: wip_constants.warning)
3100: and wjdi.wip_entity_id = p_wip_entity_id
3101: and wjdi.organization_id = p_organization_id
3102: and wjdi.load_type in (wip_job_details.wip_resource, wip_job_details.wip_sub_res)
3103: and wjdi.operation_seq_num = l_op_seq;