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

Line 48: AND process_status = WIP_CONSTANTS.ERROR

44: SELECT count(*)
45: INTO x_count
46: FROM WIP_JOB_DTLS_INTERFACE
47: WHERE group_id = p_group_id
48: AND process_status = WIP_CONSTANTS.ERROR
49: AND wip_entity_id = p_wip_entity_id
50: AND organization_id = p_organization_id
51: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
52: AND substitution_type= p_substitution_type;

Line 128: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

124: CURSOR c_link_rows IS
125: select interface_id, operation_seq_num, next_network_op_seq_num
126: FROM WIP_JOB_DTLS_INTERFACE wjdi
127: WHERE wjdi.group_id = p_group_id
128: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
129: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
130: AND wip_entity_id = p_wip_entity_id
131: AND organization_id = p_organization_id
132: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

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

125: select interface_id, operation_seq_num, next_network_op_seq_num
126: FROM WIP_JOB_DTLS_INTERFACE wjdi
127: WHERE wjdi.group_id = p_group_id
128: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
129: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
130: AND wip_entity_id = p_wip_entity_id
131: AND organization_id = p_organization_id
132: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
133: AND substitution_type = p_subst_type;

Line 160: set process_status = wip_constants.error

156: END LOOP;
157:
158: if(l_error_exists) then
159: update wip_job_dtls_interface wjdi
160: set process_status = wip_constants.error
161: where wjdi.group_id = p_group_id
162: and process_phase = wip_constants.ml_validation
163: and process_status in (wip_constants.running,
164: wip_constants.pending,

Line 162: and process_phase = wip_constants.ml_validation

158: if(l_error_exists) then
159: update wip_job_dtls_interface wjdi
160: set process_status = wip_constants.error
161: where wjdi.group_id = p_group_id
162: and process_phase = wip_constants.ml_validation
163: and process_status in (wip_constants.running,
164: wip_constants.pending,
165: wip_constants.warning)
166: and wip_entity_id = p_wip_entity_id

Line 163: and process_status in (wip_constants.running,

159: update wip_job_dtls_interface wjdi
160: set process_status = wip_constants.error
161: where wjdi.group_id = p_group_id
162: and process_phase = wip_constants.ml_validation
163: and process_status in (wip_constants.running,
164: wip_constants.pending,
165: wip_constants.warning)
166: and wip_entity_id = p_wip_entity_id
167: and organization_id = p_organization_id

Line 164: wip_constants.pending,

160: set process_status = wip_constants.error
161: where wjdi.group_id = p_group_id
162: and process_phase = wip_constants.ml_validation
163: and process_status in (wip_constants.running,
164: wip_constants.pending,
165: wip_constants.warning)
166: and wip_entity_id = p_wip_entity_id
167: and organization_id = p_organization_id
168: and load_type = wip_job_details.wip_op_link

Line 165: wip_constants.warning)

161: where wjdi.group_id = p_group_id
162: and process_phase = wip_constants.ml_validation
163: and process_status in (wip_constants.running,
164: wip_constants.pending,
165: wip_constants.warning)
166: and wip_entity_id = p_wip_entity_id
167: and organization_id = p_organization_id
168: and load_type = wip_job_details.wip_op_link
169: and substitution_type = p_subst_type;

Line 184: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

180: CURSOR c_invalid_op_seq_num IS
181: select interface_id
182: FROM WIP_JOB_DTLS_INTERFACE wjdi
183: WHERE wjdi.group_id = p_group_id
184: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
185: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
186: AND wip_entity_id = p_wip_entity_id
187: AND organization_id = p_organization_id
188: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

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

181: select interface_id
182: FROM WIP_JOB_DTLS_INTERFACE wjdi
183: WHERE wjdi.group_id = p_group_id
184: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
185: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
186: AND wip_entity_id = p_wip_entity_id
187: AND organization_id = p_organization_id
188: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
189: AND substitution_type = p_subst_type

Line 214: set process_status = wip_constants.error

210: close c_invalid_op_seq_num;
211:
212: if(l_error_exists) then
213: update wip_job_dtls_interface wjdi
214: set process_status = wip_constants.error
215: where wjdi.group_id = p_group_id
216: and process_phase = wip_constants.ml_validation
217: and process_status in (wip_constants.running,
218: wip_constants.pending,

Line 216: and process_phase = wip_constants.ml_validation

212: if(l_error_exists) then
213: update wip_job_dtls_interface wjdi
214: set process_status = wip_constants.error
215: where wjdi.group_id = p_group_id
216: and process_phase = wip_constants.ml_validation
217: and process_status in (wip_constants.running,
218: wip_constants.pending,
219: wip_constants.warning)
220: and wip_entity_id = p_wip_entity_id

Line 217: and process_status in (wip_constants.running,

213: update wip_job_dtls_interface wjdi
214: set process_status = wip_constants.error
215: where wjdi.group_id = p_group_id
216: and process_phase = wip_constants.ml_validation
217: and process_status in (wip_constants.running,
218: wip_constants.pending,
219: wip_constants.warning)
220: and wip_entity_id = p_wip_entity_id
221: and organization_id = p_organization_id

Line 218: wip_constants.pending,

214: set process_status = wip_constants.error
215: where wjdi.group_id = p_group_id
216: and process_phase = wip_constants.ml_validation
217: and process_status in (wip_constants.running,
218: wip_constants.pending,
219: wip_constants.warning)
220: and wip_entity_id = p_wip_entity_id
221: and organization_id = p_organization_id
222: and load_type = wip_job_details.wip_op_link

Line 219: wip_constants.warning)

215: where wjdi.group_id = p_group_id
216: and process_phase = wip_constants.ml_validation
217: and process_status in (wip_constants.running,
218: wip_constants.pending,
219: wip_constants.warning)
220: and wip_entity_id = p_wip_entity_id
221: and organization_id = p_organization_id
222: and load_type = wip_job_details.wip_op_link
223: and substitution_type = p_subst_type;

Line 243: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

239: attribute8,attribute9,attribute10,attribute11,attribute12,
240: attribute13,attribute14,attribute15
241: FROM WIP_JOB_DTLS_INTERFACE
242: WHERE group_id = p_group_id
243: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
244: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
245: AND wip_entity_id = p_wip_entity_id
246: AND organization_id = p_organization_id
247: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

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

240: attribute13,attribute14,attribute15
241: FROM WIP_JOB_DTLS_INTERFACE
242: WHERE group_id = p_group_id
243: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
244: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
245: AND wip_entity_id = p_wip_entity_id
246: AND organization_id = p_organization_id
247: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
248: AND substitution_type = p_subst_type;

Line 283: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

279: attribute8,attribute9,attribute10,attribute11,attribute12,
280: attribute13,attribute14,attribute15
281: FROM WIP_JOB_DTLS_INTERFACE
282: WHERE group_id = p_group_id
283: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
284: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
285: AND wip_entity_id = p_wip_entity_id
286: AND organization_id = p_organization_id
287: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

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

280: attribute13,attribute14,attribute15
281: FROM WIP_JOB_DTLS_INTERFACE
282: WHERE group_id = p_group_id
283: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
284: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
285: AND wip_entity_id = p_wip_entity_id
286: AND organization_id = p_organization_id
287: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
288: AND substitution_type = p_subst_type;

Line 334: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

330:
331: select interface_id into l_interface_id
332: FROM WIP_JOB_DTLS_INTERFACE wjdi
333: WHERE wjdi.group_id = p_group_id
334: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
335: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
336: AND wip_entity_id = p_wip_entity_id
337: AND organization_id = p_organization_id
338: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

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

331: select interface_id into l_interface_id
332: FROM WIP_JOB_DTLS_INTERFACE wjdi
333: WHERE wjdi.group_id = p_group_id
334: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
335: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
336: AND wip_entity_id = p_wip_entity_id
337: AND organization_id = p_organization_id
338: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
339: AND operation_seq_num = from_id

Line 375: set process_status = wip_constants.error

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

Line 377: and process_phase = wip_constants.ml_validation

373: if(l_error_exists) then
374: update wip_job_dtls_interface wjdi
375: set process_status = wip_constants.error
376: where wjdi.group_id = p_group_id
377: and process_phase = wip_constants.ml_validation
378: and process_status in (wip_constants.running,
379: wip_constants.pending,
380: wip_constants.warning)
381: and wip_entity_id = p_wip_entity_id

Line 378: and process_status in (wip_constants.running,

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

Line 379: wip_constants.pending,

375: set process_status = wip_constants.error
376: where wjdi.group_id = p_group_id
377: and process_phase = wip_constants.ml_validation
378: and process_status in (wip_constants.running,
379: wip_constants.pending,
380: wip_constants.warning)
381: and wip_entity_id = p_wip_entity_id
382: and organization_id = p_organization_id
383: and load_type = wip_job_details.wip_op_link

Line 380: wip_constants.warning)

376: where wjdi.group_id = p_group_id
377: and process_phase = wip_constants.ml_validation
378: and process_status in (wip_constants.running,
379: wip_constants.pending,
380: wip_constants.warning)
381: and wip_entity_id = p_wip_entity_id
382: and organization_id = p_organization_id
383: and load_type = wip_job_details.wip_op_link
384: and substitution_type = p_subst_type;

Line 418: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

414: CURSOR c_op_link_rows IS
415: select interface_id
416: FROM WIP_JOB_DTLS_INTERFACE wjdi
417: WHERE wjdi.group_id = p_group_id
418: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
419: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
420: AND wip_entity_id = p_wip_entity_id
421: AND organization_id = p_organization_id
422: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

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

415: select interface_id
416: FROM WIP_JOB_DTLS_INTERFACE wjdi
417: WHERE wjdi.group_id = p_group_id
418: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
419: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
420: AND wip_entity_id = p_wip_entity_id
421: AND organization_id = p_organization_id
422: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
423: AND substitution_type = p_subst_type

Line 461: set process_status = wip_constants.error

457: close c_op_link_rows;
458:
459: if(l_error_exists) then
460: update wip_job_dtls_interface wjdi
461: set process_status = wip_constants.error
462: where wjdi.group_id = p_group_id
463: and process_phase = wip_constants.ml_validation
464: and process_status in (wip_constants.running,
465: wip_constants.pending,

Line 463: and process_phase = wip_constants.ml_validation

459: if(l_error_exists) then
460: update wip_job_dtls_interface wjdi
461: set process_status = wip_constants.error
462: where wjdi.group_id = p_group_id
463: and process_phase = wip_constants.ml_validation
464: and process_status in (wip_constants.running,
465: wip_constants.pending,
466: wip_constants.warning)
467: and wip_entity_id = p_wip_entity_id

Line 464: and process_status in (wip_constants.running,

460: update wip_job_dtls_interface wjdi
461: set process_status = wip_constants.error
462: where wjdi.group_id = p_group_id
463: and process_phase = wip_constants.ml_validation
464: and process_status in (wip_constants.running,
465: wip_constants.pending,
466: wip_constants.warning)
467: and wip_entity_id = p_wip_entity_id
468: and organization_id = p_organization_id

Line 465: wip_constants.pending,

461: set process_status = wip_constants.error
462: where wjdi.group_id = p_group_id
463: and process_phase = wip_constants.ml_validation
464: and process_status in (wip_constants.running,
465: wip_constants.pending,
466: wip_constants.warning)
467: and wip_entity_id = p_wip_entity_id
468: and organization_id = p_organization_id
469: and load_type = wip_job_details.wip_op_link

Line 466: wip_constants.warning)

462: where wjdi.group_id = p_group_id
463: and process_phase = wip_constants.ml_validation
464: and process_status in (wip_constants.running,
465: wip_constants.pending,
466: wip_constants.warning)
467: and wip_entity_id = p_wip_entity_id
468: and organization_id = p_organization_id
469: and load_type = wip_job_details.wip_op_link
470: and substitution_type = p_subst_type;

Line 531: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

527: attribute8,attribute9,attribute10,attribute11,attribute12,
528: attribute13,attribute14,attribute15
529: FROM WIP_JOB_DTLS_INTERFACE
530: WHERE group_id = p_group_id
531: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
532: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
533: AND wip_entity_id = p_wip_entity_id
534: AND organization_id = p_organization_id
535: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

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

528: attribute13,attribute14,attribute15
529: FROM WIP_JOB_DTLS_INTERFACE
530: WHERE group_id = p_group_id
531: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
532: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
533: AND wip_entity_id = p_wip_entity_id
534: AND organization_id = p_organization_id
535: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
536: AND substitution_type = p_substitution_type;