APPS.WIP_JOB_DETAILS dependencies on WIP_JOB_DTLS_INTERFACE

Line 15: from wip_job_dtls_interface

11:
12: Cursor Job_Cur IS
13: select distinct wip_entity_id,
14: organization_id
15: from wip_job_dtls_interface
16: where group_id = p_group_id
17: and parent_header_id = p_parent_header_id
18: and process_phase = WIP_CONSTANTS.ML_VALIDATION
19: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;

Line 24: from wip_job_dtls_interface

20:
21: Cursor wdj_cur IS
22: select distinct wip_entity_id,
23: organization_id
24: from wip_job_dtls_interface
25: where group_id = p_group_id
26: and process_phase = WIP_CONSTANTS.ML_VALIDATION
27: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;
28:

Line 33: from wip_job_dtls_interface

29: Cursor Oper_Cur (p_wip_entity_id number, p_organization_id number) IS
30: select distinct wip_entity_id,
31: organization_id,
32: load_type, substitution_type
33: from wip_job_dtls_interface
34: where group_id = p_group_id
35: and ((p_std_alone = 0
36: and parent_header_id = p_parent_header_id)
37: OR p_std_alone = 1)

Line 48: from wip_job_dtls_interface

44: Cursor Res_Cur (p_wip_entity_id number, p_organization_id number) IS
45: select distinct wip_entity_id,
46: organization_id,
47: load_type, substitution_type
48: from wip_job_dtls_interface
49: where group_id = p_group_id
50: and ((p_std_alone = 0
51: and parent_header_id = p_parent_header_id)
52: OR p_std_alone = 1)

Line 63: from wip_job_dtls_interface

59: Cursor ResInst_Cur (p_wip_entity_id number, p_organization_id number) IS
60: select distinct wip_entity_id,
61: organization_id,
62: load_type, substitution_type
63: from wip_job_dtls_interface
64: where group_id = p_group_id
65: and ((p_std_alone = 0
66: and parent_header_id = p_parent_header_id)
67: OR p_std_alone = 1)

Line 78: from wip_job_dtls_interface

74: Cursor Req_Cur (p_wip_entity_id number, p_organization_id number) IS
75: select distinct wip_entity_id,
76: organization_id,
77: load_type, substitution_type
78: from wip_job_dtls_interface
79: where group_id = p_group_id
80: and ((p_std_alone = 0
81: and parent_header_id = p_parent_header_id)
82: OR p_std_alone = 1 )

Line 93: from wip_job_dtls_interface

89: Cursor Res_Usage_Cur (p_wip_entity_id number, p_organization_id number) IS
90: select distinct wip_entity_id,
91: organization_id,
92: load_type, substitution_type
93: from wip_job_dtls_interface
94: where group_id = p_group_id
95: and ((p_std_alone = 0
96: and parent_header_id = p_parent_header_id)
97: OR p_std_alone = 1)

Line 109: from wip_job_dtls_interface

105: Cursor SubRes_Cur (p_wip_entity_id number, p_organization_id number) IS
106: select distinct wip_entity_id,
107: organization_id,
108: load_type, substitution_type
109: from wip_job_dtls_interface
110: where group_id = p_group_id
111: and ((p_std_alone = 0
112: and parent_header_id = p_parent_header_id)
113: OR p_std_alone = 1)

Line 124: from wip_job_dtls_interface

120: Cursor Op_Link_Cur (p_wip_entity_id number, p_organization_id number) IS
121: select distinct wip_entity_id,
122: organization_id,
123: load_type, substitution_type
124: from wip_job_dtls_interface
125: where group_id = p_group_id
126: and ((p_std_alone = 0
127: and parent_header_id = p_parent_header_id)
128: OR p_std_alone = 1)

Line 139: from wip_job_dtls_interface

135: Cursor Serials_Cur (p_wip_entity_id number, p_organization_id number) IS
136: select distinct wip_entity_id,
137: organization_id,
138: load_type, substitution_type
139: from wip_job_dtls_interface
140: where group_id = p_group_id
141: and ((p_std_alone = 0
142: and parent_header_id = p_parent_header_id)
143: OR p_std_alone = 1)

Line 748: from WIP_JOB_DTLS_INTERFACE

744: cur_job.organization_id);
745:
746: SELECT count(*)
747: INTO x_count
748: from WIP_JOB_DTLS_INTERFACE
749: WHERE group_id = p_group_id
750: AND parent_header_id = p_parent_header_id
751: AND wip_entity_id = cur_job.wip_entity_id
752: AND organization_id = cur_job.organization_id

Line 768: UPDATE wip_job_dtls_interface

764:
765: IF x_err_code IS NULL THEN
766:
767: /* set process_status = COMPLETED */
768: UPDATE wip_job_dtls_interface
769: SET process_status = WIP_CONSTANTS.COMPLETED
770: WHERE group_id = p_group_id
771: AND wip_entity_id = cur_job.wip_entity_id
772: AND (p_parent_header_id IS NULL OR

Line 780: DELETE from wip_job_dtls_interface

776: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
777: AND process_status = WIP_CONSTANTS.RUNNING ;
778:
779: /* DELETE THE COMPLETED ROWS FROM INTERFACE TABLE */
780: DELETE from wip_job_dtls_interface
781: WHERE group_id = p_group_id
782: AND parent_header_id = p_parent_header_id
783: AND wip_entity_id = cur_job.wip_entity_id
784: AND organization_id = cur_job.organization_id

Line 821: from wip_job_dtls_interface wjdi

817: x_statement varchar(500);
818:
819: cursor c_invalid_rows is
820: select interface_id
821: from wip_job_dtls_interface wjdi
822: where wjdi.group_id = p_group_id
823: and wjdi.parent_header_id = p_parent_header_id
824: and wjdi.process_phase = wip_constants.ml_validation
825: and wjdi.process_status = wip_constants.running

Line 849: update wip_job_dtls_interface wjdi

845: p_text => substr(fnd_message.get,1,500),
846: p_error_type => wip_jdi_utils.msg_error);
847: end loop;
848: if(l_error_exists) then
849: update wip_job_dtls_interface wjdi
850: set process_status = wip_constants.warning
851: where group_id = p_group_id
852: and parent_header_id = p_parent_header_id
853: and process_phase = wip_constants.ml_validation

Line 871: Update wip_job_dtls_interface

867: where header_id = p_parent_header_id
868: and group_id = p_group_id
869: and process_status IN (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING);
870:
871: Update wip_job_dtls_interface
872: Set wip_entity_id = l_wip_entity_id,
873: organization_id = l_organization_id
874: where group_id = p_group_id
875: and parent_header_id = p_parent_header_id