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_JOB_DTLS_INTERFACE

Line 46: FROM WIP_JOB_DTLS_INTERFACE

42: BEGIN
43:
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

Line 126: FROM WIP_JOB_DTLS_INTERFACE wjdi

122: p_subst_type in number, x_err_code out nocopy varchar2, x_err_msg out nocopy varchar2,
123: x_return_status out nocopy varchar2) is
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

Line 159: update wip_job_dtls_interface wjdi

155:
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,

Line 182: FROM WIP_JOB_DTLS_INTERFACE wjdi

178: p_operation_seq_num in number) IS
179:
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

Line 213: update wip_job_dtls_interface wjdi

209: end if;
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,

Line 241: FROM WIP_JOB_DTLS_INTERFACE

237: attribute_category, attribute1,
238: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
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

Line 281: FROM WIP_JOB_DTLS_INTERFACE

277: attribute_category, attribute1,
278: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
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

Line 332: FROM WIP_JOB_DTLS_INTERFACE wjdi

328: null;
329: end;
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

Line 374: update wip_job_dtls_interface wjdi

370: end if;
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,

Line 416: FROM WIP_JOB_DTLS_INTERFACE wjdi

412: x_return_status out nocopy varchar2) is
413:
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

Line 460: update wip_job_dtls_interface wjdi

456: end if;
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,

Line 529: FROM WIP_JOB_DTLS_INTERFACE

525: attribute_category, attribute1,
526: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
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