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

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

Line 239: and process_phase = wip_constants.ml_validation

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

Line 240: and process_status in (wip_constants.running,

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

Line 241: wip_constants.warning)

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

Line 275: set process_status = wip_constants.error

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

Line 277: and process_phase = wip_constants.ml_validation

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

Line 278: and process_status in (wip_constants.running,

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

Line 279: wip_constants.warning)

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

Line 312: set process_status = wip_constants.error

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

Line 314: and process_phase = wip_constants.ml_validation

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

Line 315: and process_status in (wip_constants.running,

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

Line 316: wip_constants.warning)

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

Line 359: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

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

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

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

Line 420: and wjdi.process_phase = wip_constants.ml_validation

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

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

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

Line 422: wip_constants.warning)

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

Line 451: set process_status = wip_constants.error

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

Line 453: and process_phase = wip_constants.ml_validation

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

Line 454: and process_status in (wip_constants.running,

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

Line 455: wip_constants.warning)

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

Line 480: and wjdi.process_phase = wip_constants.ml_validation

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

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

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

Line 482: wip_constants.warning)

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

Line 527: set process_status = wip_constants.error

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

Line 529: and process_phase = wip_constants.ml_validation

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

Line 530: and process_status in (wip_constants.running,

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

Line 531: wip_constants.warning)

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

Line 572: and wjdi.process_phase = wip_constants.ml_validation

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

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

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

Line 574: wip_constants.warning)

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

Line 591: and wjdi.process_phase = wip_constants.ml_validation

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

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

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

Line 593: wip_constants.warning)

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

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

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

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

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

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

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

Line 612: and wjdi.process_phase = wip_constants.ml_validation

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

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

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

Line 614: wip_constants.warning)

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

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

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

Line 631: and wjdi.process_phase = wip_constants.ml_validation

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

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

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

Line 633: wip_constants.warning)

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

Line 652: and wjdi.process_phase = wip_constants.ml_validation

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

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

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

Line 654: wip_constants.warning )

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

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

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

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

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

Line 757: set process_status = wip_constants.error

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

Line 759: and process_phase = wip_constants.ml_validation

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

Line 760: and process_status in (wip_constants.running,

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

Line 761: wip_constants.warning)

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

Line 798: and wjdi.process_phase = wip_constants.ml_validation

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

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

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

Line 800: wip_constants.warning)

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

Line 816: and wjdi.wip_supply_type = wip_constants.op_pull

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

Line 841: set process_status = wip_constants.error

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

Line 857: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

853: CURSOR addsubinv_check IS
854: SELECT interface_id,inventory_item_id_new inventory_item_id,supply_subinventory,supply_locator_id,wip_supply_type
855: FROM WIP_JOB_DTLS_INTERFACE
856: WHERE group_id=p_group_id
857: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
858: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
859: AND wip_entity_id = p_wip_entity_id
860: AND organization_id = p_organization_id
861: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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

854: SELECT interface_id,inventory_item_id_new inventory_item_id,supply_subinventory,supply_locator_id,wip_supply_type
855: FROM WIP_JOB_DTLS_INTERFACE
856: WHERE group_id=p_group_id
857: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
858: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
859: AND wip_entity_id = p_wip_entity_id
860: AND organization_id = p_organization_id
861: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
862: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD

Line 901: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION

897: wjdi.supply_locator_id)) supply_locator_id
898: ,NVL(WJDI.wip_supply_Type,wro.wip_supply_type) wip_supply_type
899: FROM WIP_JOB_DTLS_INTERFACE wjdi,WIP_REQUIREMENT_OPERATIONS wro
900: WHERE group_id=p_group_id
901: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
902: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
903: AND wjdi.wip_entity_id = p_wip_entity_id
904: AND wro.wip_entity_id=wjdi.wip_entity_id
905: AND wro.operation_seq_num=wjdi.operation_seq_num

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

898: ,NVL(WJDI.wip_supply_Type,wro.wip_supply_type) wip_supply_type
899: FROM WIP_JOB_DTLS_INTERFACE wjdi,WIP_REQUIREMENT_OPERATIONS wro
900: WHERE group_id=p_group_id
901: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
902: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
903: AND wjdi.wip_entity_id = p_wip_entity_id
904: AND wro.wip_entity_id=wjdi.wip_entity_id
905: AND wro.operation_seq_num=wjdi.operation_seq_num
906: AND wro.inventory_item_id=wjdi.inventory_item_id_old

Line 1054: set process_status = wip_constants.error

1050: wip_interface_err_Utils.add_error(p_interface_id => error_tbl(indx).interface_id,
1051: p_text => substr(fnd_message.get,1,500),
1052: p_error_type => wip_jdi_utils.msg_error);
1053: update wip_job_dtls_interface wjdi
1054: set process_status = wip_constants.error
1055: where interface_id = error_tbl(indx).interface_id;
1056:
1057: end loop;
1058: END IF;

Line 1098: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1094: attribute8,attribute9,attribute10,attribute11,attribute12,
1095: attribute13,attribute14,attribute15
1096: FROM WIP_JOB_DTLS_INTERFACE
1097: WHERE group_id = p_group_id
1098: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1099: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1100: AND wip_entity_id = p_wip_entity_id
1101: AND organization_id = p_organization_id
1102: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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

1095: attribute13,attribute14,attribute15
1096: FROM WIP_JOB_DTLS_INTERFACE
1097: WHERE group_id = p_group_id
1098: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1099: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1100: AND wip_entity_id = p_wip_entity_id
1101: AND organization_id = p_organization_id
1102: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1103: AND substitution_type = p_substitution_type;

Line 1215: and wjdi.process_phase = wip_constants.ml_validation

1211: cursor c_invalid_rows is
1212: select interface_id
1213: from wip_job_dtls_interface wjdi
1214: where wjdi.group_id = p_group_id
1215: and wjdi.process_phase = wip_constants.ml_validation
1216: and wjdi.process_status in (wip_constants.running,
1217: wip_constants.warning)
1218: and wjdi.wip_entity_id = p_wip_entity_id
1219: and wjdi.organization_id = p_organization_id

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

1212: select interface_id
1213: from wip_job_dtls_interface wjdi
1214: where wjdi.group_id = p_group_id
1215: and wjdi.process_phase = wip_constants.ml_validation
1216: and wjdi.process_status in (wip_constants.running,
1217: wip_constants.warning)
1218: and wjdi.wip_entity_id = p_wip_entity_id
1219: and wjdi.organization_id = p_organization_id
1220: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 1217: wip_constants.warning)

1213: from wip_job_dtls_interface wjdi
1214: where wjdi.group_id = p_group_id
1215: and wjdi.process_phase = wip_constants.ml_validation
1216: and wjdi.process_status in (wip_constants.running,
1217: wip_constants.warning)
1218: and wjdi.wip_entity_id = p_wip_entity_id
1219: and wjdi.organization_id = p_organization_id
1220: and wjdi.load_type = wip_job_details.wip_mtl_requirement
1221: and wjdi.substitution_type = p_substitution_type

Line 1249: set process_status = wip_constants.error

1245: end loop;
1246:
1247: if(l_error_exists) then
1248: update wip_job_dtls_interface wjdi
1249: set process_status = wip_constants.error
1250: where group_id = p_group_id
1251: and process_phase = wip_constants.ml_validation
1252: and process_status in (wip_constants.running,
1253: wip_constants.warning)

Line 1251: and process_phase = wip_constants.ml_validation

1247: if(l_error_exists) then
1248: update wip_job_dtls_interface wjdi
1249: set process_status = wip_constants.error
1250: where group_id = p_group_id
1251: and process_phase = wip_constants.ml_validation
1252: and process_status in (wip_constants.running,
1253: wip_constants.warning)
1254: and wip_entity_id = p_wip_entity_id
1255: and organization_id = p_organization_id

Line 1252: and process_status in (wip_constants.running,

1248: update wip_job_dtls_interface wjdi
1249: set process_status = wip_constants.error
1250: where group_id = p_group_id
1251: and process_phase = wip_constants.ml_validation
1252: and process_status in (wip_constants.running,
1253: wip_constants.warning)
1254: and wip_entity_id = p_wip_entity_id
1255: and organization_id = p_organization_id
1256: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 1253: wip_constants.warning)

1249: set process_status = wip_constants.error
1250: where group_id = p_group_id
1251: and process_phase = wip_constants.ml_validation
1252: and process_status in (wip_constants.running,
1253: wip_constants.warning)
1254: and wip_entity_id = p_wip_entity_id
1255: and organization_id = p_organization_id
1256: and wjdi.load_type = wip_job_details.wip_mtl_requirement
1257: and wjdi.substitution_type = p_substitution_type

Line 1275: and wjdi.process_phase = wip_constants.ml_validation

1271: cursor c_invalid_rows is
1272: select interface_id
1273: from wip_job_dtls_interface wjdi
1274: where wjdi.group_id = p_group_id
1275: and wjdi.process_phase = wip_constants.ml_validation
1276: and wjdi.process_status in (wip_constants.running,
1277: wip_constants.warning)
1278: and wjdi.wip_entity_id = p_wip_entity_id
1279: and wjdi.organization_id = p_organization_id

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

1272: select interface_id
1273: from wip_job_dtls_interface wjdi
1274: where wjdi.group_id = p_group_id
1275: and wjdi.process_phase = wip_constants.ml_validation
1276: and wjdi.process_status in (wip_constants.running,
1277: wip_constants.warning)
1278: and wjdi.wip_entity_id = p_wip_entity_id
1279: and wjdi.organization_id = p_organization_id
1280: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 1277: wip_constants.warning)

1273: from wip_job_dtls_interface wjdi
1274: where wjdi.group_id = p_group_id
1275: and wjdi.process_phase = wip_constants.ml_validation
1276: and wjdi.process_status in (wip_constants.running,
1277: wip_constants.warning)
1278: and wjdi.wip_entity_id = p_wip_entity_id
1279: and wjdi.organization_id = p_organization_id
1280: and wjdi.load_type = wip_job_details.wip_mtl_requirement
1281: and wjdi.substitution_type = p_substitution_type

Line 1326: set process_status = wip_constants.error

1322: end loop;
1323:
1324: if(l_error_exists) then
1325: update wip_job_dtls_interface wjdi
1326: set process_status = wip_constants.error
1327: where group_id = p_group_id
1328: and process_phase = wip_constants.ml_validation
1329: and process_status in (wip_constants.running,
1330: wip_constants.warning)

Line 1328: and process_phase = wip_constants.ml_validation

1324: if(l_error_exists) then
1325: update wip_job_dtls_interface wjdi
1326: set process_status = wip_constants.error
1327: where group_id = p_group_id
1328: and process_phase = wip_constants.ml_validation
1329: and process_status in (wip_constants.running,
1330: wip_constants.warning)
1331: and wip_entity_id = p_wip_entity_id
1332: and organization_id = p_organization_id

Line 1329: and process_status in (wip_constants.running,

1325: update wip_job_dtls_interface wjdi
1326: set process_status = wip_constants.error
1327: where group_id = p_group_id
1328: and process_phase = wip_constants.ml_validation
1329: and process_status in (wip_constants.running,
1330: wip_constants.warning)
1331: and wip_entity_id = p_wip_entity_id
1332: and organization_id = p_organization_id
1333: and wjdi.load_type = wip_job_details.wip_mtl_requirement

Line 1330: wip_constants.warning)

1326: set process_status = wip_constants.error
1327: where group_id = p_group_id
1328: and process_phase = wip_constants.ml_validation
1329: and process_status in (wip_constants.running,
1330: wip_constants.warning)
1331: and wip_entity_id = p_wip_entity_id
1332: and organization_id = p_organization_id
1333: and wjdi.load_type = wip_job_details.wip_mtl_requirement
1334: and wjdi.substitution_type = p_substitution_type

Line 1430: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then

1426: and x_required_quantity is not null then /*User entered required qty, calculate yield */
1427:
1428: /* LBM Project changes have been re-evaluated by Jenny */
1429: /*bug 9932127: not calculating component_yield_factor, rather will default from BOM*/
1430: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then
1431: x_component_yield_factor := null; /*round(x_qpa_val / x_required_quantity,6);*/
1432: else
1433: x_component_yield_factor := null; /*round(x_qpa_val * X_start_quantity / x_required_quantity,6);*/
1434: end if;

Line 1439: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then

1435:
1436: elsif x_required_quantity is not null and x_quantity_per_assembly is not null
1437: and x_component_yield_factor is null then /*User entered required qty and QPA, calculate yield */
1438:
1439: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then
1440: x_component_yield_factor := round(x_qpa_val / x_required_quantity,6);
1441: else
1442: x_component_yield_factor := round(x_qpa_val * X_start_quantity / x_required_quantity,6);
1443: end if;

Line 1448: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then

1444:
1445: elsif x_required_quantity is not null and x_component_yield_factor is not null
1446: and x_quantity_per_assembly is null then /*User entered required qty and yield, calculate QPA */
1447:
1448: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then
1449: X_quantity_per_assembly := round(x_cyf_val * x_required_quantity,6);
1450: else
1451: X_quantity_per_assembly := round(x_cyf_val * x_required_quantity / X_start_quantity ,6);
1452: end if;

Line 1458: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then

1454: else /*User entered QPA, calculate required qty */
1455: /*User entered yield, calculate required qty */
1456: /*User entered QPA and yield, calculate required qty */
1457: /*User entered QPA, required qty and yield, re-calculate required qty */
1458: if p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL then
1459: x_required_quantity := round(x_qpa_val / x_cyf_val , 6);
1460: else
1461: x_required_quantity := round(x_start_quantity * x_qpa_val / x_cyf_val , 6);
1462: end if;

Line 1520: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1516: attribute8,attribute9,attribute10,attribute11,attribute12,
1517: attribute13,attribute14,attribute15
1518: FROM WIP_JOB_DTLS_INTERFACE
1519: WHERE group_id = p_group_id
1520: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1521: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1522: AND wip_entity_id = p_wip_entity_id
1523: AND organization_id = p_organization_id
1524: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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

1517: attribute13,attribute14,attribute15
1518: FROM WIP_JOB_DTLS_INTERFACE
1519: WHERE group_id = p_group_id
1520: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1521: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1522: AND wip_entity_id = p_wip_entity_id
1523: AND organization_id = p_organization_id
1524: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1525: AND substitution_type = p_substitution_type;

Line 1701: AND process_status = WIP_CONSTANTS.ERROR

1697: SELECT count(*)
1698: INTO x_count
1699: FROM WIP_JOB_DTLS_INTERFACE
1700: WHERE group_id = p_group_id
1701: AND process_status = WIP_CONSTANTS.ERROR
1702: AND wip_entity_id = p_wip_entity_id
1703: AND organization_id = p_organization_id
1704: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1705: AND substitution_type= p_substitution_type

Line 1714: AND process_status = WIP_CONSTANTS.ERROR

1710: SELECT count(*)
1711: INTO x_count
1712: FROM WIP_JOB_DTLS_INTERFACE
1713: WHERE group_id = p_group_id
1714: AND process_status = WIP_CONSTANTS.ERROR
1715: AND wip_entity_id = p_wip_entity_id
1716: AND organization_id = p_organization_id
1717: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1718: AND substitution_type= p_substitution_type

Line 1727: AND process_status = WIP_CONSTANTS.ERROR

1723: SELECT count(*)
1724: INTO x_count
1725: FROM WIP_JOB_DTLS_INTERFACE
1726: WHERE group_id = p_group_id
1727: AND process_status = WIP_CONSTANTS.ERROR
1728: AND wip_entity_id = p_wip_entity_id
1729: AND organization_id = p_organization_id
1730: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1731: AND substitution_type= p_substitution_type

Line 1761: AND process_status = WIP_CONSTANTS.ERROR

1757: SELECT count(*)
1758: INTO x_count
1759: FROM WIP_JOB_DTLS_INTERFACE
1760: WHERE group_id = p_group_id
1761: AND process_status = WIP_CONSTANTS.ERROR
1762: AND wip_entity_id = p_wip_entity_id
1763: AND organization_id = p_organization_id
1764: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1765: AND substitution_type= p_substitution_type

Line 1774: AND process_status = WIP_CONSTANTS.ERROR

1770: SELECT count(*)
1771: INTO x_count
1772: FROM WIP_JOB_DTLS_INTERFACE
1773: WHERE group_id = p_group_id
1774: AND process_status = WIP_CONSTANTS.ERROR
1775: AND wip_entity_id = p_wip_entity_id
1776: AND organization_id = p_organization_id
1777: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1778: AND substitution_type= p_substitution_type

Line 1788: AND process_status = WIP_CONSTANTS.ERROR

1784: SELECT count(*)
1785: INTO x_count
1786: FROM WIP_JOB_DTLS_INTERFACE
1787: WHERE group_id = p_group_id
1788: AND process_status = WIP_CONSTANTS.ERROR
1789: AND wip_entity_id = p_wip_entity_id
1790: AND organization_id = p_organization_id
1791: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1792: AND substitution_type= p_substitution_type