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

Line 15: and wjdi.process_phase = wip_constants.ml_validation

11: cursor c_invalid_rows is
12: select interface_id
13: from wip_job_dtls_interface wjdi
14: where wjdi.group_id = p_group_id
15: and wjdi.process_phase = wip_constants.ml_validation
16: and wjdi.process_status in (wip_constants.running,
17: wip_constants.warning)
18: and wjdi.wip_entity_id = p_wip_entity_id
19: and wjdi.organization_id = p_organization_id

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

12: select interface_id
13: from wip_job_dtls_interface wjdi
14: where wjdi.group_id = p_group_id
15: and wjdi.process_phase = wip_constants.ml_validation
16: and wjdi.process_status in (wip_constants.running,
17: wip_constants.warning)
18: and wjdi.wip_entity_id = p_wip_entity_id
19: and wjdi.organization_id = p_organization_id
20: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 17: wip_constants.warning)

13: from wip_job_dtls_interface wjdi
14: where wjdi.group_id = p_group_id
15: and wjdi.process_phase = wip_constants.ml_validation
16: and wjdi.process_status in (wip_constants.running,
17: wip_constants.warning)
18: and wjdi.wip_entity_id = p_wip_entity_id
19: and wjdi.organization_id = p_organization_id
20: and wjdi.load_type = wip_job_details.wip_mtl_requirement
21: and wjdi.substitution_type = p_substitution_type

Line 45: set process_status = wip_constants.error

41: end loop;
42:
43: if(l_error_exists) then
44: update wip_job_dtls_interface wjdi
45: set process_status = wip_constants.error
46: where group_id = p_group_id
47: and process_phase = wip_constants.ml_validation
48: and process_status in (wip_constants.running,
49: wip_constants.warning)

Line 47: and process_phase = wip_constants.ml_validation

43: if(l_error_exists) then
44: update wip_job_dtls_interface wjdi
45: set process_status = wip_constants.error
46: where group_id = p_group_id
47: and process_phase = wip_constants.ml_validation
48: and process_status in (wip_constants.running,
49: wip_constants.warning)
50: and wip_entity_id = p_wip_entity_id
51: and organization_id = p_organization_id

Line 48: and process_status in (wip_constants.running,

44: update wip_job_dtls_interface wjdi
45: set process_status = wip_constants.error
46: where group_id = p_group_id
47: and process_phase = wip_constants.ml_validation
48: and process_status in (wip_constants.running,
49: wip_constants.warning)
50: and wip_entity_id = p_wip_entity_id
51: and organization_id = p_organization_id
52: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 49: wip_constants.warning)

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

Line 80: and wjdi.process_phase = wip_constants.ml_validation

76: from wip_job_dtls_interface wjdi,
77: wip_entities we,
78: mtl_system_items_kfv msik
79: where wjdi.group_id = p_group_id
80: and wjdi.process_phase = wip_constants.ml_validation
81: and wjdi.process_status in (wip_constants.running,
82: wip_constants.warning)
83: and wjdi.wip_entity_id = p_wip_entity_id
84: and wjdi.organization_id = p_organization_id

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

77: wip_entities we,
78: mtl_system_items_kfv msik
79: where wjdi.group_id = p_group_id
80: and wjdi.process_phase = wip_constants.ml_validation
81: and wjdi.process_status in (wip_constants.running,
82: wip_constants.warning)
83: and wjdi.wip_entity_id = p_wip_entity_id
84: and wjdi.organization_id = p_organization_id
85: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 82: wip_constants.warning)

78: mtl_system_items_kfv msik
79: where wjdi.group_id = p_group_id
80: and wjdi.process_phase = wip_constants.ml_validation
81: and wjdi.process_status in (wip_constants.running,
82: wip_constants.warning)
83: and wjdi.wip_entity_id = p_wip_entity_id
84: and wjdi.organization_id = p_organization_id
85: and wjdi.load_type = wip_job_details.wip_mtl_requirement
86: and wjdi.substitution_type = p_substitution_type

Line 125: set process_status = wip_constants.error

121: end loop;
122:
123: if(l_error_exists) then
124: update wip_job_dtls_interface wjdi
125: set process_status = wip_constants.error
126: where group_id = p_group_id
127: and process_phase = wip_constants.ml_validation
128: and process_status in (wip_constants.running,
129: wip_constants.warning)

Line 127: and process_phase = wip_constants.ml_validation

123: if(l_error_exists) then
124: update wip_job_dtls_interface wjdi
125: set process_status = wip_constants.error
126: where group_id = p_group_id
127: and process_phase = wip_constants.ml_validation
128: and process_status in (wip_constants.running,
129: wip_constants.warning)
130: and wip_entity_id = p_wip_entity_id
131: and organization_id = p_organization_id

Line 128: and process_status in (wip_constants.running,

124: update wip_job_dtls_interface wjdi
125: set process_status = wip_constants.error
126: where group_id = p_group_id
127: and process_phase = wip_constants.ml_validation
128: and process_status in (wip_constants.running,
129: wip_constants.warning)
130: and wip_entity_id = p_wip_entity_id
131: and organization_id = p_organization_id
132: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 129: wip_constants.warning)

125: set process_status = wip_constants.error
126: where group_id = p_group_id
127: and process_phase = wip_constants.ml_validation
128: and process_status in (wip_constants.running,
129: wip_constants.warning)
130: and wip_entity_id = p_wip_entity_id
131: and organization_id = p_organization_id
132: and wjdi.load_type = wip_job_details.wip_mtl_requirement
133: and wjdi.substitution_type = p_substitution_type

Line 160: and wjdi.process_phase = wip_constants.ml_validation

156: cursor c_invalid_wro_rows is
157: select interface_id
158: from wip_job_dtls_interface wjdi
159: where wjdi.group_id = p_group_id
160: and wjdi.process_phase = wip_constants.ml_validation
161: and wjdi.process_status in (wip_constants.running,
162: wip_constants.warning)
163: and wjdi.wip_entity_id = p_wip_entity_id
164: and wjdi.organization_id = p_organization_id

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

157: select interface_id
158: from wip_job_dtls_interface wjdi
159: where wjdi.group_id = p_group_id
160: and wjdi.process_phase = wip_constants.ml_validation
161: and wjdi.process_status in (wip_constants.running,
162: wip_constants.warning)
163: and wjdi.wip_entity_id = p_wip_entity_id
164: and wjdi.organization_id = p_organization_id
165: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 162: wip_constants.warning)

158: from wip_job_dtls_interface wjdi
159: where wjdi.group_id = p_group_id
160: and wjdi.process_phase = wip_constants.ml_validation
161: and wjdi.process_status in (wip_constants.running,
162: wip_constants.warning)
163: and wjdi.wip_entity_id = p_wip_entity_id
164: and wjdi.organization_id = p_organization_id
165: and wjdi.load_type = wip_job_details.wip_mtl_requirement
166: and wjdi.substitution_type = p_substitution_type

Line 181: and wjdi.process_phase = wip_constants.ml_validation

177: cursor c_invalid_mmtt_rows is
178: select interface_id
179: from wip_job_dtls_interface wjdi
180: where wjdi.group_id = p_group_id
181: and wjdi.process_phase = wip_constants.ml_validation
182: and wjdi.process_status in (wip_constants.running,
183: wip_constants.warning)
184: and wjdi.wip_entity_id = p_wip_entity_id
185: and wjdi.organization_id = p_organization_id

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

178: select interface_id
179: from wip_job_dtls_interface wjdi
180: where wjdi.group_id = p_group_id
181: and wjdi.process_phase = wip_constants.ml_validation
182: and wjdi.process_status in (wip_constants.running,
183: wip_constants.warning)
184: and wjdi.wip_entity_id = p_wip_entity_id
185: and wjdi.organization_id = p_organization_id
186: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 183: wip_constants.warning)

179: from wip_job_dtls_interface wjdi
180: where wjdi.group_id = p_group_id
181: and wjdi.process_phase = wip_constants.ml_validation
182: and wjdi.process_status in (wip_constants.running,
183: wip_constants.warning)
184: and wjdi.wip_entity_id = p_wip_entity_id
185: and wjdi.organization_id = p_organization_id
186: and wjdi.load_type = wip_job_details.wip_mtl_requirement
187: and wjdi.substitution_type = p_substitution_type

Line 201: and wjdi.process_phase = wip_constants.ml_validation

197: cursor c_invalid_mmt_rows is
198: select interface_id
199: from wip_job_dtls_interface wjdi
200: where wjdi.group_id = p_group_id
201: and wjdi.process_phase = wip_constants.ml_validation
202: and wjdi.process_status in (wip_constants.running,
203: wip_constants.warning)
204: and wjdi.wip_entity_id = p_wip_entity_id
205: and wjdi.organization_id = p_organization_id

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

198: select interface_id
199: from wip_job_dtls_interface wjdi
200: where wjdi.group_id = p_group_id
201: and wjdi.process_phase = wip_constants.ml_validation
202: and wjdi.process_status in (wip_constants.running,
203: wip_constants.warning)
204: and wjdi.wip_entity_id = p_wip_entity_id
205: and wjdi.organization_id = p_organization_id
206: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 203: wip_constants.warning)

199: from wip_job_dtls_interface wjdi
200: where wjdi.group_id = p_group_id
201: and wjdi.process_phase = wip_constants.ml_validation
202: and wjdi.process_status in (wip_constants.running,
203: wip_constants.warning)
204: and wjdi.wip_entity_id = p_wip_entity_id
205: and wjdi.organization_id = p_organization_id
206: and wjdi.load_type = wip_job_details.wip_mtl_requirement
207: and wjdi.substitution_type = p_substitution_type

Line 239: set process_status = wip_constants.error

235: end loop;
236:
237: if(l_error_exists) then
238: update wip_job_dtls_interface wjdi
239: set process_status = wip_constants.error
240: where group_id = p_group_id
241: and process_phase = wip_constants.ml_validation
242: and process_status in (wip_constants.running,
243: wip_constants.warning)

Line 241: and process_phase = wip_constants.ml_validation

237: if(l_error_exists) then
238: update wip_job_dtls_interface wjdi
239: set process_status = wip_constants.error
240: where group_id = p_group_id
241: and process_phase = wip_constants.ml_validation
242: and process_status in (wip_constants.running,
243: wip_constants.warning)
244: and wip_entity_id = p_wip_entity_id
245: and organization_id = p_organization_id

Line 242: and process_status in (wip_constants.running,

238: update wip_job_dtls_interface wjdi
239: set process_status = wip_constants.error
240: where group_id = p_group_id
241: and process_phase = wip_constants.ml_validation
242: and process_status in (wip_constants.running,
243: wip_constants.warning)
244: and wip_entity_id = p_wip_entity_id
245: and organization_id = p_organization_id
246: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 243: wip_constants.warning)

239: set process_status = wip_constants.error
240: where group_id = p_group_id
241: and process_phase = wip_constants.ml_validation
242: and process_status in (wip_constants.running,
243: wip_constants.warning)
244: and wip_entity_id = p_wip_entity_id
245: and organization_id = p_organization_id
246: and wjdi.load_type = wip_job_details.wip_mtl_requirement
247: and wjdi.substitution_type = p_substitution_type

Line 277: set process_status = wip_constants.error

273: end loop;
274:
275: if(l_error_exists) then
276: update wip_job_dtls_interface wjdi
277: set process_status = wip_constants.error
278: where group_id = p_group_id
279: and process_phase = wip_constants.ml_validation
280: and process_status in (wip_constants.running,
281: wip_constants.warning)

Line 279: and process_phase = wip_constants.ml_validation

275: if(l_error_exists) then
276: update wip_job_dtls_interface wjdi
277: set process_status = wip_constants.error
278: where group_id = p_group_id
279: and process_phase = wip_constants.ml_validation
280: and process_status in (wip_constants.running,
281: wip_constants.warning)
282: and wip_entity_id = p_wip_entity_id
283: and organization_id = p_organization_id

Line 280: and process_status in (wip_constants.running,

276: update wip_job_dtls_interface wjdi
277: set process_status = wip_constants.error
278: where group_id = p_group_id
279: and process_phase = wip_constants.ml_validation
280: and process_status in (wip_constants.running,
281: wip_constants.warning)
282: and wip_entity_id = p_wip_entity_id
283: and organization_id = p_organization_id
284: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 281: wip_constants.warning)

277: set process_status = wip_constants.error
278: where group_id = p_group_id
279: and process_phase = wip_constants.ml_validation
280: and process_status in (wip_constants.running,
281: wip_constants.warning)
282: and wip_entity_id = p_wip_entity_id
283: and organization_id = p_organization_id
284: and wjdi.load_type = wip_job_details.wip_mtl_requirement
285: and wjdi.substitution_type = p_substitution_type

Line 314: set process_status = wip_constants.error

310: end loop;
311:
312: if(l_error_exists) then
313: update wip_job_dtls_interface wjdi
314: set process_status = wip_constants.error
315: where group_id = p_group_id
316: and process_phase = wip_constants.ml_validation
317: and process_status in (wip_constants.running,
318: wip_constants.warning)

Line 316: and process_phase = wip_constants.ml_validation

312: if(l_error_exists) then
313: update wip_job_dtls_interface wjdi
314: set process_status = wip_constants.error
315: where group_id = p_group_id
316: and process_phase = wip_constants.ml_validation
317: and process_status in (wip_constants.running,
318: wip_constants.warning)
319: and wip_entity_id = p_wip_entity_id
320: and organization_id = p_organization_id

Line 317: and process_status in (wip_constants.running,

313: update wip_job_dtls_interface wjdi
314: set process_status = wip_constants.error
315: where group_id = p_group_id
316: and process_phase = wip_constants.ml_validation
317: and process_status in (wip_constants.running,
318: wip_constants.warning)
319: and wip_entity_id = p_wip_entity_id
320: and organization_id = p_organization_id
321: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 318: wip_constants.warning)

314: set process_status = wip_constants.error
315: where group_id = p_group_id
316: and process_phase = wip_constants.ml_validation
317: and process_status in (wip_constants.running,
318: wip_constants.warning)
319: and wip_entity_id = p_wip_entity_id
320: and organization_id = p_organization_id
321: and wjdi.load_type = wip_job_details.wip_mtl_requirement
322: and wjdi.substitution_type = p_substitution_type

Line 361: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

357: attribute8,attribute9,attribute10,attribute11,attribute12,
358: attribute13,attribute14,attribute15
359: FROM WIP_JOB_DTLS_INTERFACE
360: WHERE group_id = p_group_id
361: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
362: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
363: AND wip_entity_id = p_wip_entity_id
364: AND organization_id = p_organization_id
365: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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

358: attribute13,attribute14,attribute15
359: FROM WIP_JOB_DTLS_INTERFACE
360: WHERE group_id = p_group_id
361: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
362: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
363: AND wip_entity_id = p_wip_entity_id
364: AND organization_id = p_organization_id
365: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
366: AND substitution_type = p_substitution_type;

Line 422: and wjdi.process_phase = wip_constants.ml_validation

418: cursor c_invalid_rows is
419: select interface_id
420: from wip_job_dtls_interface wjdi
421: where wjdi.group_id = p_group_id
422: and wjdi.process_phase = wip_constants.ml_validation
423: and wjdi.process_status in (wip_constants.running,
424: wip_constants.warning)
425: and wjdi.wip_entity_id = p_wip_entity_id
426: and wjdi.organization_id = p_organization_id

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

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

Line 424: wip_constants.warning)

420: from wip_job_dtls_interface wjdi
421: where wjdi.group_id = p_group_id
422: and wjdi.process_phase = wip_constants.ml_validation
423: and wjdi.process_status in (wip_constants.running,
424: wip_constants.warning)
425: and wjdi.wip_entity_id = p_wip_entity_id
426: and wjdi.organization_id = p_organization_id
427: and wjdi.load_type = wip_job_details.wip_mtl_requirement
428: and wjdi.substitution_type = p_substitution_type

Line 453: set process_status = wip_constants.error

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

Line 455: and process_phase = wip_constants.ml_validation

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

Line 456: and process_status in (wip_constants.running,

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

Line 457: wip_constants.warning)

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

Line 482: and wjdi.process_phase = wip_constants.ml_validation

478: cursor c_invalid_rows is
479: select interface_id
480: from wip_job_dtls_interface wjdi
481: where wjdi.group_id = p_group_id
482: and wjdi.process_phase = wip_constants.ml_validation
483: and wjdi.process_status in (wip_constants.running,
484: wip_constants.warning)
485: and wjdi.wip_entity_id = p_wip_entity_id
486: and wjdi.organization_id = p_organization_id

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

479: select interface_id
480: from wip_job_dtls_interface wjdi
481: where wjdi.group_id = p_group_id
482: and wjdi.process_phase = wip_constants.ml_validation
483: and wjdi.process_status in (wip_constants.running,
484: wip_constants.warning)
485: and wjdi.wip_entity_id = p_wip_entity_id
486: and wjdi.organization_id = p_organization_id
487: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 484: wip_constants.warning)

480: from wip_job_dtls_interface wjdi
481: where wjdi.group_id = p_group_id
482: and wjdi.process_phase = wip_constants.ml_validation
483: and wjdi.process_status in (wip_constants.running,
484: wip_constants.warning)
485: and wjdi.wip_entity_id = p_wip_entity_id
486: and wjdi.organization_id = p_organization_id
487: and wjdi.load_type = wip_job_details.wip_mtl_requirement
488: and wjdi.substitution_type = p_substitution_type

Line 529: set process_status = wip_constants.error

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

Line 531: and process_phase = wip_constants.ml_validation

527: if(l_error_exists) then
528: update wip_job_dtls_interface wjdi
529: set process_status = wip_constants.error
530: where group_id = p_group_id
531: and process_phase = wip_constants.ml_validation
532: and process_status in (wip_constants.running,
533: wip_constants.warning)
534: and wip_entity_id = p_wip_entity_id
535: and organization_id = p_organization_id

Line 532: and process_status in (wip_constants.running,

528: update wip_job_dtls_interface wjdi
529: set process_status = wip_constants.error
530: where group_id = p_group_id
531: and process_phase = wip_constants.ml_validation
532: and process_status in (wip_constants.running,
533: wip_constants.warning)
534: and wip_entity_id = p_wip_entity_id
535: and organization_id = p_organization_id
536: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 533: wip_constants.warning)

529: set process_status = wip_constants.error
530: where group_id = p_group_id
531: and process_phase = wip_constants.ml_validation
532: and process_status in (wip_constants.running,
533: wip_constants.warning)
534: and wip_entity_id = p_wip_entity_id
535: and organization_id = p_organization_id
536: and wjdi.load_type = wip_job_details.wip_mtl_requirement
537: and wjdi.substitution_type = p_substitution_type

Line 574: and wjdi.process_phase = wip_constants.ml_validation

570: cursor c_invalid_rows is
571: select interface_id
572: from wip_job_dtls_interface wjdi
573: where wjdi.group_id = p_group_id
574: and wjdi.process_phase = wip_constants.ml_validation
575: and wjdi.process_status in (wip_constants.running,
576: wip_constants.warning)
577: and wjdi.wip_entity_id = p_wip_entity_id
578: and wjdi.organization_id = p_organization_id

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

571: select interface_id
572: from wip_job_dtls_interface wjdi
573: where wjdi.group_id = p_group_id
574: and wjdi.process_phase = wip_constants.ml_validation
575: and wjdi.process_status in (wip_constants.running,
576: wip_constants.warning)
577: and wjdi.wip_entity_id = p_wip_entity_id
578: and wjdi.organization_id = p_organization_id
579: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 576: wip_constants.warning)

572: from wip_job_dtls_interface wjdi
573: where wjdi.group_id = p_group_id
574: and wjdi.process_phase = wip_constants.ml_validation
575: and wjdi.process_status in (wip_constants.running,
576: wip_constants.warning)
577: and wjdi.wip_entity_id = p_wip_entity_id
578: and wjdi.organization_id = p_organization_id
579: and wjdi.load_type = wip_job_details.wip_mtl_requirement
580: and wjdi.substitution_type = p_substitution_type

Line 593: and wjdi.process_phase = wip_constants.ml_validation

589: cursor c_supply_types_invalid_rows is
590: select wjdi.interface_id
591: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
592: where wjdi.group_id = p_group_id
593: and wjdi.process_phase = wip_constants.ml_validation
594: and wjdi.process_status in (wip_constants.running,
595: wip_constants.warning)
596: and wjdi.wip_entity_id = p_wip_entity_id
597: and wjdi.organization_id = p_organization_id

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

590: select wjdi.interface_id
591: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
592: where wjdi.group_id = p_group_id
593: and wjdi.process_phase = wip_constants.ml_validation
594: and wjdi.process_status in (wip_constants.running,
595: wip_constants.warning)
596: and wjdi.wip_entity_id = p_wip_entity_id
597: and wjdi.organization_id = p_organization_id
598: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 595: wip_constants.warning)

591: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
592: where wjdi.group_id = p_group_id
593: and wjdi.process_phase = wip_constants.ml_validation
594: and wjdi.process_status in (wip_constants.running,
595: wip_constants.warning)
596: and wjdi.wip_entity_id = p_wip_entity_id
597: and wjdi.organization_id = p_organization_id
598: and wjdi.load_type = wip_job_details.wip_mtl_requirement
599: and wjdi.substitution_type = p_substitution_type

Line 606: and (wjdi.wip_supply_type = wip_constants.phantom

602: and wjdi.parent_header_id = wjsi.header_id
603: and wjdi.group_id = wjsi.group_id
604: and wjdi.organization_id = wjsi.organization_id
605: and wjdi.wip_entity_id = wjsi.wip_entity_id
606: and (wjdi.wip_supply_type = wip_constants.phantom
607: or (wjsi.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job)
608: and wjdi.wip_supply_type <> wip_constants.push));
609:
610: cursor c_mrp_net_flag_invalid_rows is

Line 607: or (wjsi.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job)

603: and wjdi.group_id = wjsi.group_id
604: and wjdi.organization_id = wjsi.organization_id
605: and wjdi.wip_entity_id = wjsi.wip_entity_id
606: and (wjdi.wip_supply_type = wip_constants.phantom
607: or (wjsi.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job)
608: and wjdi.wip_supply_type <> wip_constants.push));
609:
610: cursor c_mrp_net_flag_invalid_rows is
611: select wjdi.interface_id

Line 608: and wjdi.wip_supply_type <> wip_constants.push));

604: and wjdi.organization_id = wjsi.organization_id
605: and wjdi.wip_entity_id = wjsi.wip_entity_id
606: and (wjdi.wip_supply_type = wip_constants.phantom
607: or (wjsi.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job)
608: and wjdi.wip_supply_type <> wip_constants.push));
609:
610: cursor c_mrp_net_flag_invalid_rows is
611: select wjdi.interface_id
612: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

Line 614: and wjdi.process_phase = wip_constants.ml_validation

610: cursor c_mrp_net_flag_invalid_rows is
611: select wjdi.interface_id
612: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
613: where wjdi.group_id = p_group_id
614: and wjdi.process_phase = wip_constants.ml_validation
615: and wjdi.process_status in (wip_constants.running,
616: wip_constants.warning)
617: and wjdi.wip_entity_id = p_wip_entity_id
618: and wjdi.organization_id = p_organization_id

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

611: select wjdi.interface_id
612: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
613: where wjdi.group_id = p_group_id
614: and wjdi.process_phase = wip_constants.ml_validation
615: and wjdi.process_status in (wip_constants.running,
616: wip_constants.warning)
617: and wjdi.wip_entity_id = p_wip_entity_id
618: and wjdi.organization_id = p_organization_id
619: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 616: wip_constants.warning)

612: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
613: where wjdi.group_id = p_group_id
614: and wjdi.process_phase = wip_constants.ml_validation
615: and wjdi.process_status in (wip_constants.running,
616: wip_constants.warning)
617: and wjdi.wip_entity_id = p_wip_entity_id
618: and wjdi.organization_id = p_organization_id
619: and wjdi.load_type = wip_job_details.wip_mtl_requirement
620: and wjdi.substitution_type = p_substitution_type

Line 627: and (wjdi.mrp_net_flag not in (wip_constants.yes, wip_constants.no));

623: and wjdi.parent_header_id = wjsi.header_id
624: and wjdi.group_id = wjsi.group_id
625: and wjdi.organization_id = wjsi.organization_id
626: and wjdi.wip_entity_id = wjsi.wip_entity_id
627: and (wjdi.mrp_net_flag not in (wip_constants.yes, wip_constants.no));
628:
629: cursor c_auto_req_mat_invalid_rows is
630: select wjdi.interface_id
631: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

Line 633: and wjdi.process_phase = wip_constants.ml_validation

629: cursor c_auto_req_mat_invalid_rows is
630: select wjdi.interface_id
631: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
632: where wjdi.group_id = p_group_id
633: and wjdi.process_phase = wip_constants.ml_validation
634: and wjdi.process_status in (wip_constants.running,
635: wip_constants.warning)
636: and wjdi.wip_entity_id = p_wip_entity_id
637: and wjdi.organization_id = p_organization_id

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

630: select wjdi.interface_id
631: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
632: where wjdi.group_id = p_group_id
633: and wjdi.process_phase = wip_constants.ml_validation
634: and wjdi.process_status in (wip_constants.running,
635: wip_constants.warning)
636: and wjdi.wip_entity_id = p_wip_entity_id
637: and wjdi.organization_id = p_organization_id
638: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 635: wip_constants.warning)

631: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
632: where wjdi.group_id = p_group_id
633: and wjdi.process_phase = wip_constants.ml_validation
634: and wjdi.process_status in (wip_constants.running,
635: wip_constants.warning)
636: and wjdi.wip_entity_id = p_wip_entity_id
637: and wjdi.organization_id = p_organization_id
638: and wjdi.load_type = wip_job_details.wip_mtl_requirement
639: and wjdi.substitution_type = p_substitution_type

Line 654: and wjdi.process_phase = wip_constants.ml_validation

650: cursor c_direct_item_rows(p_profile_value IN number) is
651: select interface_id
652: from wip_job_dtls_interface wjdi
653: where wjdi.group_id=p_group_id
654: and wjdi.process_phase = wip_constants.ml_validation
655: and wjdi.process_status in ( wip_constants.running,
656: wip_constants.warning )
657: and wjdi.wip_entity_id = p_wip_entity_id
658: and wjdi.organization_id = p_organization_id

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

651: select interface_id
652: from wip_job_dtls_interface wjdi
653: where wjdi.group_id=p_group_id
654: and wjdi.process_phase = wip_constants.ml_validation
655: and wjdi.process_status in ( wip_constants.running,
656: wip_constants.warning )
657: and wjdi.wip_entity_id = p_wip_entity_id
658: and wjdi.organization_id = p_organization_id
659: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 656: wip_constants.warning )

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

Line 668: and (( p_profile_value = WIP_CONSTANTS.YES)

664: where msi.inventory_item_id = wjdi.inventory_item_id_new
665: and msi.organization_id = wjdi.organization_id
666: and BOM_ENABLED_FLAG = 'Y'
667: and BOM_ITEM_TYPE = 4
668: and (( p_profile_value = WIP_CONSTANTS.YES)
669: or (ENG_ITEM_FLAG = 'N' and p_profile_value = WIP_CONSTANTS.NO))
670: );
671: /* end of 3112793 */
672:

Line 669: or (ENG_ITEM_FLAG = 'N' and p_profile_value = WIP_CONSTANTS.NO))

665: and msi.organization_id = wjdi.organization_id
666: and BOM_ENABLED_FLAG = 'Y'
667: and BOM_ITEM_TYPE = 4
668: and (( p_profile_value = WIP_CONSTANTS.YES)
669: or (ENG_ITEM_FLAG = 'N' and p_profile_value = WIP_CONSTANTS.NO))
670: );
671: /* end of 3112793 */
672:
673: l_profile_value number ;

Line 759: set process_status = wip_constants.error

755: end loop;
756:
757: if(l_error_exists) then
758: update wip_job_dtls_interface wjdi
759: set process_status = wip_constants.error
760: where group_id = p_group_id
761: and process_phase = wip_constants.ml_validation
762: and process_status in (wip_constants.running,
763: wip_constants.warning)

Line 761: and process_phase = wip_constants.ml_validation

757: if(l_error_exists) then
758: update wip_job_dtls_interface wjdi
759: set process_status = wip_constants.error
760: where group_id = p_group_id
761: and process_phase = wip_constants.ml_validation
762: and process_status in (wip_constants.running,
763: wip_constants.warning)
764: and wip_entity_id = p_wip_entity_id
765: and organization_id = p_organization_id

Line 762: and process_status in (wip_constants.running,

758: update wip_job_dtls_interface wjdi
759: set process_status = wip_constants.error
760: where group_id = p_group_id
761: and process_phase = wip_constants.ml_validation
762: and process_status in (wip_constants.running,
763: wip_constants.warning)
764: and wip_entity_id = p_wip_entity_id
765: and organization_id = p_organization_id
766: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 763: wip_constants.warning)

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

Line 800: and wjdi.process_phase = wip_constants.ml_validation

796: cursor c_supply_types_invalid_rows is
797: select wjdi.interface_id
798: from wip_job_dtls_interface wjdi /*, wip_job_schedule_interface wjsi */
799: where wjdi.group_id = p_group_id
800: and wjdi.process_phase = wip_constants.ml_validation
801: and wjdi.process_status in (wip_constants.running,
802: wip_constants.warning)
803: and wjdi.wip_entity_id = p_wip_entity_id
804: and wjdi.organization_id = p_organization_id

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

797: select wjdi.interface_id
798: from wip_job_dtls_interface wjdi /*, wip_job_schedule_interface wjsi */
799: where wjdi.group_id = p_group_id
800: and wjdi.process_phase = wip_constants.ml_validation
801: and wjdi.process_status in (wip_constants.running,
802: wip_constants.warning)
803: and wjdi.wip_entity_id = p_wip_entity_id
804: and wjdi.organization_id = p_organization_id
805: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 802: wip_constants.warning)

798: from wip_job_dtls_interface wjdi /*, wip_job_schedule_interface wjsi */
799: where wjdi.group_id = p_group_id
800: and wjdi.process_phase = wip_constants.ml_validation
801: and wjdi.process_status in (wip_constants.running,
802: wip_constants.warning)
803: and wjdi.wip_entity_id = p_wip_entity_id
804: and wjdi.organization_id = p_organization_id
805: and wjdi.load_type = wip_job_details.wip_mtl_requirement
806: and wjdi.substitution_type = p_substitution_type

Line 818: and wjdi.wip_supply_type = wip_constants.op_pull

814: /*and (wjdi.parent_header_id = p_parent_header_id or
815: WIP_JOB_DETAILS.STD_ALONE = 1)*/
816: /*and wjdi.organization_id = wjsi.organization_id
817: and wjdi.wip_entity_id = wjsi.wip_entity_id*/
818: and wjdi.wip_supply_type = wip_constants.op_pull
819: and not exists
820: (select 1 from wip_operations
821: where wip_entity_id = wjdi.wip_entity_id
822: and organization_id = wjdi.organization_id);

Line 843: set process_status = wip_constants.error

839: p_error_type => wip_jdi_utils.msg_error);
840: end if;
841:
842: update wip_job_dtls_interface wjdi
843: set process_status = wip_constants.error
844: where interface_id = l_inv_row.interface_id;
845: end loop;
846:
847: end valid_requirement_supply_type;

Line 881: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

877: attribute8,attribute9,attribute10,attribute11,attribute12,
878: attribute13,attribute14,attribute15
879: FROM WIP_JOB_DTLS_INTERFACE
880: WHERE group_id = p_group_id
881: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
882: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
883: AND wip_entity_id = p_wip_entity_id
884: AND organization_id = p_organization_id
885: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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

878: attribute13,attribute14,attribute15
879: FROM WIP_JOB_DTLS_INTERFACE
880: WHERE group_id = p_group_id
881: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
882: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
883: AND wip_entity_id = p_wip_entity_id
884: AND organization_id = p_organization_id
885: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
886: AND substitution_type = p_substitution_type;

Line 993: and wjdi.process_phase = wip_constants.ml_validation

989: cursor c_invalid_rows is
990: select interface_id
991: from wip_job_dtls_interface wjdi
992: where wjdi.group_id = p_group_id
993: and wjdi.process_phase = wip_constants.ml_validation
994: and wjdi.process_status in (wip_constants.running,
995: wip_constants.warning)
996: and wjdi.wip_entity_id = p_wip_entity_id
997: and wjdi.organization_id = p_organization_id

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

990: select interface_id
991: from wip_job_dtls_interface wjdi
992: where wjdi.group_id = p_group_id
993: and wjdi.process_phase = wip_constants.ml_validation
994: and wjdi.process_status in (wip_constants.running,
995: wip_constants.warning)
996: and wjdi.wip_entity_id = p_wip_entity_id
997: and wjdi.organization_id = p_organization_id
998: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 995: wip_constants.warning)

991: from wip_job_dtls_interface wjdi
992: where wjdi.group_id = p_group_id
993: and wjdi.process_phase = wip_constants.ml_validation
994: and wjdi.process_status in (wip_constants.running,
995: wip_constants.warning)
996: and wjdi.wip_entity_id = p_wip_entity_id
997: and wjdi.organization_id = p_organization_id
998: and wjdi.load_type = wip_job_details.wip_mtl_requirement
999: and wjdi.substitution_type = p_substitution_type

Line 1027: set process_status = wip_constants.error

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

Line 1029: and process_phase = wip_constants.ml_validation

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

Line 1030: and process_status in (wip_constants.running,

1026: update wip_job_dtls_interface wjdi
1027: set process_status = wip_constants.error
1028: where group_id = p_group_id
1029: and process_phase = wip_constants.ml_validation
1030: and process_status in (wip_constants.running,
1031: wip_constants.warning)
1032: and wip_entity_id = p_wip_entity_id
1033: and organization_id = p_organization_id
1034: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 1031: wip_constants.warning)

1027: set process_status = wip_constants.error
1028: where group_id = p_group_id
1029: and process_phase = wip_constants.ml_validation
1030: and process_status in (wip_constants.running,
1031: wip_constants.warning)
1032: and wip_entity_id = p_wip_entity_id
1033: and organization_id = p_organization_id
1034: and wjdi.load_type = wip_job_details.wip_mtl_requirement
1035: and wjdi.substitution_type = p_substitution_type

Line 1053: and wjdi.process_phase = wip_constants.ml_validation

1049: cursor c_invalid_rows is
1050: select interface_id
1051: from wip_job_dtls_interface wjdi
1052: where wjdi.group_id = p_group_id
1053: and wjdi.process_phase = wip_constants.ml_validation
1054: and wjdi.process_status in (wip_constants.running,
1055: wip_constants.warning)
1056: and wjdi.wip_entity_id = p_wip_entity_id
1057: and wjdi.organization_id = p_organization_id

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

1050: select interface_id
1051: from wip_job_dtls_interface wjdi
1052: where wjdi.group_id = p_group_id
1053: and wjdi.process_phase = wip_constants.ml_validation
1054: and wjdi.process_status in (wip_constants.running,
1055: wip_constants.warning)
1056: and wjdi.wip_entity_id = p_wip_entity_id
1057: and wjdi.organization_id = p_organization_id
1058: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 1055: wip_constants.warning)

1051: from wip_job_dtls_interface wjdi
1052: where wjdi.group_id = p_group_id
1053: and wjdi.process_phase = wip_constants.ml_validation
1054: and wjdi.process_status in (wip_constants.running,
1055: wip_constants.warning)
1056: and wjdi.wip_entity_id = p_wip_entity_id
1057: and wjdi.organization_id = p_organization_id
1058: and wjdi.load_type = wip_job_details.wip_mtl_requirement
1059: and wjdi.substitution_type = p_substitution_type

Line 1104: set process_status = wip_constants.error

1100: end loop;
1101:
1102: if(l_error_exists) then
1103: update wip_job_dtls_interface wjdi
1104: set process_status = wip_constants.error
1105: where group_id = p_group_id
1106: and process_phase = wip_constants.ml_validation
1107: and process_status in (wip_constants.running,
1108: wip_constants.warning)

Line 1106: and process_phase = wip_constants.ml_validation

1102: if(l_error_exists) then
1103: update wip_job_dtls_interface wjdi
1104: set process_status = wip_constants.error
1105: where group_id = p_group_id
1106: and process_phase = wip_constants.ml_validation
1107: and process_status in (wip_constants.running,
1108: wip_constants.warning)
1109: and wip_entity_id = p_wip_entity_id
1110: and organization_id = p_organization_id

Line 1107: and process_status in (wip_constants.running,

1103: update wip_job_dtls_interface wjdi
1104: set process_status = wip_constants.error
1105: where group_id = p_group_id
1106: and process_phase = wip_constants.ml_validation
1107: and process_status in (wip_constants.running,
1108: wip_constants.warning)
1109: and wip_entity_id = p_wip_entity_id
1110: and organization_id = p_organization_id
1111: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 1108: wip_constants.warning)

1104: set process_status = wip_constants.error
1105: where group_id = p_group_id
1106: and process_phase = wip_constants.ml_validation
1107: and process_status in (wip_constants.running,
1108: wip_constants.warning)
1109: and wip_entity_id = p_wip_entity_id
1110: and organization_id = p_organization_id
1111: and wjdi.load_type = wip_job_details.wip_mtl_requirement
1112: and wjdi.substitution_type = p_substitution_type

Line 1207: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then

1203: elsif x_quantity_per_assembly is null and x_component_yield_factor is null
1204: and x_required_quantity is not null then /*User entered required qty, calculate yield */
1205:
1206: /* LBM Project changes have been re-evaluated by Jenny */
1207: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then
1208: x_component_yield_factor := round(x_qpa_val / x_required_quantity,6);
1209: else
1210: x_component_yield_factor := round(x_qpa_val * X_start_quantity / x_required_quantity,6);
1211: end if;

Line 1216: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then

1212:
1213: elsif x_required_quantity is not null and x_quantity_per_assembly is not null
1214: and x_component_yield_factor is null then /*User entered required qty and QPA, calculate yield */
1215:
1216: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then
1217: x_component_yield_factor := round(x_qpa_val / x_required_quantity,6);
1218: else
1219: x_component_yield_factor := round(x_qpa_val * X_start_quantity / x_required_quantity,6);
1220: end if;

Line 1225: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then

1221:
1222: elsif x_required_quantity is not null and x_component_yield_factor is not null
1223: and x_quantity_per_assembly is null then /*User entered required qty and yield, calculate QPA */
1224:
1225: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then
1226: X_quantity_per_assembly := round(x_cyf_val * x_required_quantity,6);
1227: else
1228: X_quantity_per_assembly := round(x_cyf_val * x_required_quantity / X_start_quantity ,6);
1229: end if;

Line 1235: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then

1231: else /*User entered QPA, calculate required qty */
1232: /*User entered yield, calculate required qty */
1233: /*User entered QPA and yield, calculate required qty */
1234: /*User entered QPA, required qty and yield, re-calculate required qty */
1235: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then
1236: x_required_quantity := round(x_qpa_val / x_cyf_val , 6);
1237: else
1238: x_required_quantity := round(x_start_quantity * x_qpa_val / x_cyf_val , 6);
1239: end if;

Line 1297: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1293: attribute8,attribute9,attribute10,attribute11,attribute12,
1294: attribute13,attribute14,attribute15
1295: FROM WIP_JOB_DTLS_INTERFACE
1296: WHERE group_id = p_group_id
1297: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1298: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1299: AND wip_entity_id = p_wip_entity_id
1300: AND organization_id = p_organization_id
1301: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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

1294: attribute13,attribute14,attribute15
1295: FROM WIP_JOB_DTLS_INTERFACE
1296: WHERE group_id = p_group_id
1297: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1298: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1299: AND wip_entity_id = p_wip_entity_id
1300: AND organization_id = p_organization_id
1301: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1302: AND substitution_type = p_substitution_type;

Line 1466: AND process_status = WIP_CONSTANTS.ERROR

1462: SELECT count(*)
1463: INTO x_count
1464: FROM WIP_JOB_DTLS_INTERFACE
1465: WHERE group_id = p_group_id
1466: AND process_status = WIP_CONSTANTS.ERROR
1467: AND wip_entity_id = p_wip_entity_id
1468: AND organization_id = p_organization_id
1469: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1470: AND substitution_type= p_substitution_type

Line 1479: AND process_status = WIP_CONSTANTS.ERROR

1475: SELECT count(*)
1476: INTO x_count
1477: FROM WIP_JOB_DTLS_INTERFACE
1478: WHERE group_id = p_group_id
1479: AND process_status = WIP_CONSTANTS.ERROR
1480: AND wip_entity_id = p_wip_entity_id
1481: AND organization_id = p_organization_id
1482: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1483: AND substitution_type= p_substitution_type

Line 1492: AND process_status = WIP_CONSTANTS.ERROR

1488: SELECT count(*)
1489: INTO x_count
1490: FROM WIP_JOB_DTLS_INTERFACE
1491: WHERE group_id = p_group_id
1492: AND process_status = WIP_CONSTANTS.ERROR
1493: AND wip_entity_id = p_wip_entity_id
1494: AND organization_id = p_organization_id
1495: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1496: AND substitution_type= p_substitution_type

Line 1526: AND process_status = WIP_CONSTANTS.ERROR

1522: SELECT count(*)
1523: INTO x_count
1524: FROM WIP_JOB_DTLS_INTERFACE
1525: WHERE group_id = p_group_id
1526: AND process_status = WIP_CONSTANTS.ERROR
1527: AND wip_entity_id = p_wip_entity_id
1528: AND organization_id = p_organization_id
1529: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1530: AND substitution_type= p_substitution_type

Line 1539: AND process_status = WIP_CONSTANTS.ERROR

1535: SELECT count(*)
1536: INTO x_count
1537: FROM WIP_JOB_DTLS_INTERFACE
1538: WHERE group_id = p_group_id
1539: AND process_status = WIP_CONSTANTS.ERROR
1540: AND wip_entity_id = p_wip_entity_id
1541: AND organization_id = p_organization_id
1542: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1543: AND substitution_type= p_substitution_type

Line 1553: AND process_status = WIP_CONSTANTS.ERROR

1549: SELECT count(*)
1550: INTO x_count
1551: FROM WIP_JOB_DTLS_INTERFACE
1552: WHERE group_id = p_group_id
1553: AND process_status = WIP_CONSTANTS.ERROR
1554: AND wip_entity_id = p_wip_entity_id
1555: AND organization_id = p_organization_id
1556: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1557: AND substitution_type= p_substitution_type