21: and wjdi.process_phase = wip_constants.ml_validation
22: and wjdi.process_status in (wip_constants.running,
23: wip_constants.warning)
24: and not exists (select 1
25: from wip_discrete_jobs wdj
26: where wjdi.wip_entity_id = wdj.wip_entity_id
27: and wjdi.organization_id = wdj.organization_id);
28:
29: l_interface_id NUMBER;
72: and process_phase = wip_constants.ml_validation
73: and process_status in (wip_constants.running,
74: wip_constants.warning)
75: and not exists (select 1
76: from wip_discrete_jobs wdj
77: where wjdi.wip_entity_id = wdj.wip_entity_id
78: and wjdi.organization_id = wdj.organization_id);
79: else
80: update wip_job_dtls_interface wjdi
102: and wjdi.process_phase = wip_constants.ml_validation
103: and wjdi.process_status in (wip_constants.running,
104: wip_constants.warning)
105: and not exists (select 1
106: from wip_discrete_jobs wdj
107: where wjdi.wip_entity_id = wdj.wip_entity_id
108: and wjdi.organization_id = wdj.organization_id
109: and wdj.status_type in (wip_constants.unreleased,
110: wip_constants.released,
136: and process_phase = wip_constants.ml_validation
137: and process_status in (wip_constants.running,
138: wip_constants.warning)
139: and not exists (select 1
140: from wip_discrete_jobs wdj
141: where wjdi.wip_entity_id = wdj.wip_entity_id
142: and wjdi.organization_id = wdj.organization_id
143: and wdj.status_type in (wip_constants.unreleased,
144: wip_constants.released,
157: and wjdi.process_phase = wip_constants.ml_validation
158: and wjdi.process_status in (wip_constants.running,
159: wip_constants.warning)
160: and exists (select 1
161: from wip_discrete_jobs wdj
162: where wjdi.wip_entity_id = wdj.wip_entity_id
163: and wjdi.organization_id = wdj.organization_id
164: and wdj.status_type in (wip_constants.unreleased,
165: wip_constants.released,
189: and process_phase = wip_constants.ml_validation
190: and process_status in (wip_constants.running,
191: wip_constants.warning)
192: and exists (select 1
193: from wip_discrete_jobs wdj
194: where wjdi.wip_entity_id = wdj.wip_entity_id
195: and wjdi.organization_id = wdj.organization_id
196: and wdj.status_type in (wip_constants.unreleased,
197: wip_constants.released,