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 266: update wip_job_dtls_interface wjdi

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

Line 300: from wip_job_dtls_interface wjdi

296:
297:
298: cursor c_invalid_rows(p_dept_id number, p_resource_id number) is
299: select interface_id
300: from wip_job_dtls_interface wjdi
301: where wjdi.group_id = p_group_id
302: and wjdi.process_phase = wip_constants.ml_validation
303: and wjdi.process_status in (wip_constants.running,
304: wip_constants.warning)

Line 367: update wip_job_dtls_interface wjdi

363: end if;
364: end loop;
365: if(l_error_exists) then
366:
367: update wip_job_dtls_interface wjdi
368: set process_status = wip_constants.error
369: where wjdi.group_id = p_group_id
370: and wjdi.process_phase = wip_constants.ml_validation
371: and wjdi.process_status in (wip_constants.running,

Line 418: from wip_job_dtls_interface wjdi

414: l_assigned_units number;
415:
416: cursor c_invalid_rows(p_count number, p_assigned_units number) 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)

Line 505: from wip_job_dtls_interface

501:
502: Begin
503: select count(*)
504: into l_add_count
505: from wip_job_dtls_interface
506: where group_id = p_group_id
507: and wip_entity_id = p_wip_entity_id
508: and organization_id = p_organization_id
509: and load_type = wip_job_details.wip_res_instance

Line 520: from wip_job_dtls_interface

516:
517: Begin
518: select count(*)
519: into l_del_count
520: from wip_job_dtls_interface
521: where group_id = p_group_id
522: and wip_entity_id = p_wip_entity_id
523: and organization_id = p_organization_id
524: and load_type = wip_job_details.wip_res_instance

Line 558: update wip_job_dtls_interface wjdi

554: p_error_type => wip_jdi_utils.msg_error);
555: end if;
556: end loop;
557: if(l_error_exists) then
558: update wip_job_dtls_interface wjdi
559: set process_status = wip_constants.error
560: where wjdi.group_id = p_group_id
561: and wjdi.process_phase = wip_constants.ml_validation
562: and wjdi.process_status in (wip_constants.running,

Line 602: FROM WIP_JOB_DTLS_INTERFACE

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

Line 755: from wip_job_dtls_interface wjdi

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

Line 795: update wip_job_dtls_interface wjdi

791: end if;
792: end loop;
793:
794: if(l_error_exists) then
795: update wip_job_dtls_interface wjdi
796: set process_status = wip_constants.error
797: where group_id = p_group_id
798: and process_phase = wip_constants.ml_validation
799: and process_status in (wip_constants.running,

Line 848: FROM WIP_JOB_DTLS_INTERFACE

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

Line 979: FROM WIP_JOB_DTLS_INTERFACE

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