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_RES_INST_VALIDATIONS dependencies on WIP_JOB_DTLS_INTERFACE

Line 17: FROM WIP_JOB_DTLS_INTERFACE

13: BEGIN
14:
15: SELECT count(*)
16: INTO x_count
17: FROM WIP_JOB_DTLS_INTERFACE
18: WHERE group_id = p_group_id
19: AND process_status = WIP_CONSTANTS.ERROR
20: AND wip_entity_id = p_wip_entity_id
21: AND organization_id = p_organization_id

Line 46: from wip_job_dtls_interface wjdi

42: p_resource_type number) IS
43:
44: cursor c_invalid_rows is
45: select interface_id
46: from wip_job_dtls_interface wjdi
47: where wjdi.group_id = p_group_id
48: and wjdi.process_phase = wip_constants.ml_validation
49: and wjdi.process_status in (wip_constants.running,
50: wip_constants.warning)

Line 96: update wip_job_dtls_interface wjdi

92: end if;
93: end loop;
94:
95: if(l_error_exists) then
96: update wip_job_dtls_interface wjdi
97: set process_status = wip_constants.error
98: where wjdi.group_id = p_group_id
99: and wjdi.process_phase = wip_constants.ml_validation
100: and wjdi.process_status in (wip_constants.running,

Line 144: from wip_job_dtls_interface wjdi

140: p_resource_type number) IS
141:
142: cursor c_invalid_rows is
143: select interface_id
144: from wip_job_dtls_interface wjdi
145: where wjdi.group_id = p_group_id
146: and wjdi.process_phase = wip_constants.ml_validation
147: and wjdi.process_status in (wip_constants.running,
148: wip_constants.warning)

Line 182: update wip_job_dtls_interface wjdi

178: end if;
179: end loop;
180:
181: if(l_error_exists) then
182: update wip_job_dtls_interface wjdi
183: set process_status = wip_constants.error
184: where wjdi.group_id = p_group_id
185: and wjdi.process_phase = wip_constants.ml_validation
186: and wjdi.process_status in (wip_constants.running,

Line 213: from wip_job_dtls_interface wjdi

209:
210:
211: cursor c_invalid_rows(p_dept_id number, p_resource_id number) is
212: select interface_id
213: from wip_job_dtls_interface wjdi
214: where wjdi.group_id = p_group_id
215: and wjdi.process_phase = wip_constants.ml_validation
216: and wjdi.process_status in (wip_constants.running,
217: wip_constants.warning)

Line 268: update wip_job_dtls_interface wjdi

264: p_error_type => wip_jdi_utils.msg_error);
265: end if;
266: end loop;
267: if(l_error_exists) then
268: update wip_job_dtls_interface wjdi
269: set process_status = wip_constants.error
270: where wjdi.group_id = p_group_id
271: and wjdi.process_phase = wip_constants.ml_validation
272: and wjdi.process_status in (wip_constants.running,

Line 305: from wip_job_dtls_interface wjdi

301:
302:
303: cursor c_invalid_rows(p_dept_id number, p_resource_id number) is
304: select interface_id
305: from wip_job_dtls_interface wjdi
306: where wjdi.group_id = p_group_id
307: and wjdi.process_phase = wip_constants.ml_validation
308: and wjdi.process_status in (wip_constants.running,
309: wip_constants.warning)

Line 372: update wip_job_dtls_interface wjdi

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

Line 423: from wip_job_dtls_interface wjdi

419: l_assigned_units number;
420:
421: cursor c_invalid_rows(p_count number, p_assigned_units number) is
422: select interface_id
423: from wip_job_dtls_interface wjdi
424: where wjdi.group_id = p_group_id
425: and wjdi.process_phase = wip_constants.ml_validation
426: and wjdi.process_status in (wip_constants.running,
427: wip_constants.warning)

Line 510: from wip_job_dtls_interface

506:
507: Begin
508: select count(*)
509: into l_add_count
510: from wip_job_dtls_interface
511: where group_id = p_group_id
512: and wip_entity_id = p_wip_entity_id
513: and organization_id = p_organization_id
514: and load_type = wip_job_details.wip_res_instance

Line 525: from wip_job_dtls_interface

521:
522: Begin
523: select count(*)
524: into l_del_count
525: from wip_job_dtls_interface
526: where group_id = p_group_id
527: and wip_entity_id = p_wip_entity_id
528: and organization_id = p_organization_id
529: and load_type = wip_job_details.wip_res_instance

Line 563: update wip_job_dtls_interface wjdi

559: p_error_type => wip_jdi_utils.msg_error);
560: end if;
561: end loop;
562: if(l_error_exists) then
563: update wip_job_dtls_interface wjdi
564: set process_status = wip_constants.error
565: where wjdi.group_id = p_group_id
566: and wjdi.process_phase = wip_constants.ml_validation
567: and wjdi.process_status in (wip_constants.running,

Line 607: FROM WIP_JOB_DTLS_INTERFACE

603: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
604: attribute8,attribute9,attribute10,attribute11,attribute12,
605: attribute13,attribute14,attribute15, schedule_seq_num,
606: substitute_group_num, replacement_group_num, parent_seq_num, rowid
607: FROM WIP_JOB_DTLS_INTERFACE
608: WHERE group_id = p_group_id
609: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
610: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
611: AND wip_entity_id = p_wip_entity_id

Line 760: from wip_job_dtls_interface wjdi

756: -- Job/op_seq_num/resource_seq_num/resource_id all match
757: -- Validate only when delete/change resources
758: cursor c_invalid_rows is
759: select interface_id
760: from wip_job_dtls_interface wjdi
761: where wjdi.group_id = p_group_id
762: and wjdi.process_phase = wip_constants.ml_validation
763: and wjdi.process_status in (wip_constants.running,
764: wip_constants.warning)

Line 800: update wip_job_dtls_interface wjdi

796: end if;
797: end loop;
798:
799: if(l_error_exists) then
800: update wip_job_dtls_interface wjdi
801: set process_status = wip_constants.error
802: where group_id = p_group_id
803: and process_phase = wip_constants.ml_validation
804: and process_status in (wip_constants.running,

Line 853: FROM WIP_JOB_DTLS_INTERFACE

849: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
850: attribute8,attribute9,attribute10,attribute11,attribute12,
851: attribute13,attribute14,attribute15, schedule_seq_num,
852: substitute_group_num, replacement_group_num
853: FROM WIP_JOB_DTLS_INTERFACE
854: WHERE group_id = p_group_id
855: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
856: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
857: AND wip_entity_id = p_wip_entity_id

Line 984: FROM WIP_JOB_DTLS_INTERFACE

980: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
981: attribute8,attribute9,attribute10,attribute11,attribute12,
982: attribute13,attribute14,attribute15, schedule_seq_num,
983: substitute_group_num, replacement_group_num
984: FROM WIP_JOB_DTLS_INTERFACE
985: WHERE group_id = p_group_id
986: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
987: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
988: AND wip_entity_id = p_wip_entity_id