[Home] [Help]
3: procedure jobs (p_group_id IN number,
4: p_parent_header_id IN number) is
5: cursor c_ml_invalid_rows is
6: select interface_id
7: from wip_job_dtls_interface wjdi
8: where wjdi.group_id = p_group_id
9: and wjdi.parent_header_id = p_parent_header_id
10: and wjdi.process_phase = wip_constants.ml_validation
11: and wjdi.process_status in (wip_constants.running, wip_constants.warning)
15: and wjdi.parent_header_id = wjsi.header_id);
16:
17: cursor c_wdj_invalid_rows is
18: select interface_id
19: from wip_job_dtls_interface wjdi
20: where wjdi.group_id = p_group_id
21: and wjdi.process_phase = wip_constants.ml_validation
22: and wjdi.process_status in (wip_constants.running,
23: wip_constants.warning)
65: end if;
66:
67: if(l_error_exists) then
68: if(wip_job_details.std_alone = 1) then
69: update wip_job_dtls_interface wjdi
70: set process_status = wip_constants.error
71: where wjdi.group_id = p_group_id
72: and process_phase = wip_constants.ml_validation
73: and process_status in (wip_constants.running,
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
81: set process_status = wip_constants.error
82: where group_id = p_group_id
83: and parent_header_id = p_parent_header_id
84: and process_phase = wip_constants.ml_validation
95: procedure job_status (p_group_id in number,
96: p_parent_header_id in number) is
97: cursor c_ml_invalid_rows is
98: select interface_id
99: from wip_job_dtls_interface wjdi
100: where wjdi.group_id = p_group_id
101: and wjdi.parent_header_id = p_parent_header_id
102: and wjdi.process_phase = wip_constants.ml_validation
103: and wjdi.process_status in (wip_constants.running,
128: end loop;
129: end if;
130:
131: if(l_error_exists) then
132: update wip_job_dtls_interface wjdi
133: set process_status = wip_constants.error
134: where group_id = p_group_id
135: and parent_header_id = p_parent_header_id
136: and process_phase = wip_constants.ml_validation
150: procedure is_firm (p_group_id number,
151: p_parent_header_id number) is
152: cursor c_invalid_rows is
153: select interface_id
154: from wip_job_dtls_interface wjdi
155: where wjdi.group_id = p_group_id
156: and wjdi.parent_header_id = p_parent_header_id
157: and wjdi.process_phase = wip_constants.ml_validation
158: and wjdi.process_status in (wip_constants.running,
181: end loop;
182: end if;
183:
184: if(l_error_exists) then
185: update wip_job_dtls_interface wjdi
186: set process_status = wip_constants.error
187: where group_id = p_group_id
188: and parent_header_id = p_parent_header_id
189: and process_phase = wip_constants.ml_validation
213: and wip_entity_id = p_wip_entity_id;
214:
215: cursor c_ml_invalid_rows is
216: select interface_id
217: from wip_job_dtls_interface wjdi
218: where wjdi.group_id = p_group_id
219: and wjdi.parent_header_id = p_parent_header_id
220: and wjdi.process_phase = wip_constants.ml_validation
221: and wjdi.process_status in (wip_constants.running,
235: and wjdi.operation_seq_num = wo.operation_seq_num);
236:
237: cursor c_wdj_invalid_rows is
238: select interface_id
239: from wip_job_dtls_interface wjdi
240: where wjdi.group_id = p_group_id
241: and wjdi.process_phase = wip_constants.ml_validation
242: and wjdi.process_status in (wip_constants.running,
243: wip_constants.warning)
267: -- For add requirement only: If the operation sequence number given by the
268: -- user is one, then we should treat it as the first operation.
269: select count(*)
270: into l_num_first_op_rows
271: from wip_job_dtls_interface
272: where group_id = p_group_id
273: and parent_header_id = p_parent_header_id
274: and process_phase = wip_constants.ml_validation
275: and process_status in (wip_constants.running,wip_constants.warning)
286:
287: --update the details rows to the first op seq.
288: if(c_first_operation%FOUND) then
289: if l_first_op_seq_num is NOT NULL then /* Fix for Bug#3247891*/
290: update wip_job_dtls_interface
291: set operation_seq_num = l_first_op_seq_num
292: where group_id = p_group_id
293: and parent_header_id = p_parent_header_id
294: and process_phase = wip_constants.ml_validation
339: end if;
340:
341: if(l_error_exists) then
342: if(wip_job_details.std_alone = 1) then
343: update wip_job_dtls_interface wjdi
344: set process_status = wip_constants.error
345: where group_id = p_group_id
346: and process_phase = wip_constants.ml_validation
347: and process_status in (wip_constants.running,
361: where wjdi.wip_entity_id = wo.wip_entity_id
362: and wjdi.organization_id = wo.organization_id
363: and wjdi.operation_seq_num = wo.operation_seq_num);
364: else
365: update wip_job_dtls_interface wjdi
366: set process_status = wip_constants.error
367: where group_id = p_group_id
368: and parent_header_id = p_parent_header_id
369: and process_phase = wip_constants.ml_validation
392: p_wip_entity_id IN number,
393: p_organization_id IN number) IS
394: cursor c_invalid_rows is
395: select interface_id
396: from wip_job_dtls_interface wjdi
397: where wjdi.group_id = p_group_id
398: and wjdi.parent_header_id = p_parent_header_id
399: and wjdi.process_phase = wip_constants.ml_validation
400: and wjdi.process_status in (wip_constants.running,
424: end if;
425: end loop;
426:
427: if(l_error_exists) then
428: update wip_job_dtls_interface
429: set process_status = wip_constants.error
430: where group_id = p_group_id
431: and parent_header_id = p_parent_header_id
432: and process_phase = wip_constants.ml_validation
446: p_organization_id IN number) IS
447:
448: cursor c_invalid_rows is
449: select interface_id
450: from wip_job_dtls_interface wjdi
451: where wjdi.group_id = p_group_id
452: and wjdi.parent_header_id = p_parent_header_id
453: and wjdi.process_phase = wip_constants.ml_validation
454: and wjdi.process_status in (wip_constants.running,
479: end if;
480: end loop;
481:
482: if(l_error_exists) then
483: update wip_job_dtls_interface wjdi
484: set process_status = wip_constants.error
485: where group_id = p_group_id
486: and parent_header_id = p_parent_header_id
487: and process_phase = wip_constants.ml_validation
501: p_wip_entity_id IN NUMBER,
502: p_organization_id IN NUMBER) IS
503: cursor c_invalid_rows is
504: select interface_id
505: from wip_job_dtls_interface wjdi
506: where wjdi.group_id = p_group_id
507: and wjdi.parent_header_id = p_parent_header_id
508: and wjdi.process_phase = wip_constants.ml_validation
509: and wjdi.process_status in (wip_constants.running,
534: end if;
535: end loop;
536:
537: if(l_error_exists) then
538: update wip_job_dtls_interface wjdi
539: set process_status = wip_constants.error
540: where group_id = p_group_id
541: and parent_header_id = p_parent_header_id
542: and process_phase = wip_constants.ml_validation
561: p_wip_entity_id IN NUMBER,
562: p_organization_id IN NUMBER) is
563: cursor c_invalid_rows is
564: select interface_id
565: from wip_job_dtls_interface wjdi
566: where wjdi.group_id = p_group_id
567: and wjdi.parent_header_id = p_parent_header_id
568: and wjdi.process_phase = wip_constants.ml_validation
569: and wjdi.process_status in (wip_constants.running,
570: wip_constants.warning)
571: and wjdi.wip_entity_id = p_wip_entity_id
572: and wjdi.organization_id = p_organization_id
573: and exists (select 1
574: from wip_job_dtls_interface wjdi2
575: where wjdi2.group_id = wjdi.group_id
576: and wjdi2.parent_header_id = wjdi.parent_header_id
577: and wjdi2.process_status = wip_constants.error
578: and wjdi2.wip_entity_id = wjdi.wip_entity_id
587: p_text => substr(fnd_message.get,1,500),
588: p_error_type => wip_jdi_utils.msg_error);
589: end loop;
590: if(l_error_exists) then
591: update wip_job_dtls_interface wjdi
592: set process_status = wip_constants.error
593: where group_id = p_group_id
594: and parent_header_id = p_parent_header_id
595: and process_phase = wip_constants.ml_validation
597: wip_constants.warning)
598: and wip_entity_id = p_wip_entity_id
599: and organization_id = p_organization_id
600: and exists (select 1
601: from wip_job_dtls_interface wjdi2
602: where wjdi2.group_id = wjdi.group_id
603: and wjdi2.parent_header_id = wjdi.parent_header_id
604: and wjdi2.process_status = wip_constants.error
605: and wjdi2.wip_entity_id = wjdi.wip_entity_id