APPS.WIP_SERIAL_ASSOC_VALIDATIONS dependencies on WIP_JOB_DTLS_INTERFACE

Line 205: from wip_job_dtls_interface wjdi

201: x_return_status out nocopy varchar2) is
202:
203: cursor c_invalid_rows is
204: select interface_id
205: from wip_job_dtls_interface wjdi
206: where wjdi.group_id = p_group_id
207: and wjdi.process_phase = wip_constants.ml_validation
208: and wjdi.process_status in (wip_constants.running,
209: wip_constants.pending,

Line 235: update wip_job_dtls_interface wjdi

231: end if;
232: end loop;
233:
234: if(x_return_status <> fnd_api.g_ret_sts_success) then
235: update wip_job_dtls_interface wjdi
236: set process_status = wip_constants.error
237: where group_id = p_group_id
238: and process_phase = wip_constants.ml_validation
239: and process_status in (wip_constants.running,

Line 260: from wip_job_dtls_interface wjdi,

256: select interface_id,
257: we.primary_item_id,
258: wjdi.serial_number_new,
259: wjdi.rowid
260: from wip_job_dtls_interface wjdi,
261: wip_entities we
262: where wjdi.group_id = p_group_id
263: and wjdi.process_phase = wip_constants.ml_validation
264: and wjdi.process_status in (wip_constants.running,

Line 311: update wip_job_dtls_interface wjdi

307: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
308: p_text => substr(fnd_message.get,1,500),
309: p_error_type => wip_jdi_utils.msg_error);
310: end if;
311: update wip_job_dtls_interface wjdi
312: set process_status = wip_constants.error
313: where rowid = l_ser_rec.rowid;
314: end if;
315: end loop;

Line 325: from wip_job_dtls_interface wjdi

321: p_substitution_type in number,
322: x_return_status out nocopy varchar2) is
323: cursor c_invalid_rows is
324: select interface_id
325: from wip_job_dtls_interface wjdi
326: where wjdi.group_id = p_group_id
327: and wjdi.process_phase = wip_constants.ml_validation
328: and wjdi.process_status in (wip_constants.running,
329: wip_constants.pending,

Line 355: update wip_job_dtls_interface wjdi

351: end if;
352: end loop;
353:
354: if(x_return_status <> fnd_api.g_ret_sts_success) then
355: update wip_job_dtls_interface wjdi
356: set process_status = wip_constants.error
357: where group_id = p_group_id
358: and process_phase = wip_constants.ml_validation
359: and process_status in (wip_constants.running,

Line 377: from wip_job_dtls_interface wjdi

373: p_substitution_type in number,
374: x_return_status out nocopy varchar2) is
375: cursor c_invalid_rows is
376: select interface_id
377: from wip_job_dtls_interface wjdi
378: where wjdi.group_id = p_group_id
379: and wjdi.process_phase = wip_constants.ml_validation
380: and wjdi.process_status in (wip_constants.running,
381: wip_constants.pending,

Line 415: update wip_job_dtls_interface wjdi

411: end if;
412: end loop;
413:
414: if(x_return_status <> fnd_api.g_ret_sts_success) then
415: update wip_job_dtls_interface wjdi
416: set process_status = wip_constants.error
417: where group_id = p_group_id
418: and process_phase = wip_constants.ml_validation
419: and process_status in (wip_constants.running,

Line 447: from wip_job_dtls_interface wjdi

443: x_return_status out nocopy varchar2) is
444:
445: cursor c_invalid_rows is
446: select interface_id
447: from wip_job_dtls_interface wjdi
448: where wjdi.group_id = p_group_id
449: and wjdi.process_phase = wip_constants.ml_validation
450: and wjdi.process_status in (wip_constants.running,
451: wip_constants.pending,

Line 486: update wip_job_dtls_interface wjdi

482: end if;
483: end loop;
484:
485: if(x_return_status <> fnd_api.g_ret_sts_success) then
486: update wip_job_dtls_interface wjdi
487: set process_status = wip_constants.error
488: where group_id = p_group_id
489: and process_phase = wip_constants.ml_validation
490: and process_status in (wip_constants.running,

Line 518: from wip_job_dtls_interface wjdi

514: p_substitution_type in number,
515: x_return_status out nocopy varchar2) is
516: cursor c_invalid_rows is
517: select interface_id
518: from wip_job_dtls_interface wjdi
519: where wjdi.group_id = p_group_id
520: and wjdi.process_phase = wip_constants.ml_validation
521: and wjdi.process_status in (wip_constants.running,
522: wip_constants.pending,

Line 554: update wip_job_dtls_interface wjdi

550: end if;
551: end loop;
552:
553: if(x_return_status <> fnd_api.g_ret_sts_success) then
554: update wip_job_dtls_interface wjdi
555: set process_status = wip_constants.error
556: where group_id = p_group_id
557: and process_phase = wip_constants.ml_validation
558: and process_status in (wip_constants.running,

Line 582: from wip_job_dtls_interface wjdi

578: p_substitution_type in number,
579: x_return_status out nocopy varchar2) is
580: cursor c_invalid_rows is
581: select interface_id
582: from wip_job_dtls_interface wjdi
583: where wjdi.group_id = p_group_id
584: and wjdi.process_phase = wip_constants.ml_validation
585: and wjdi.process_status in (wip_constants.running,
586: wip_constants.pending,

Line 621: update wip_job_dtls_interface wjdi

617: end if;
618: end loop;
619:
620: if(x_return_status <> fnd_api.g_ret_sts_success) then
621: update wip_job_dtls_interface wjdi
622: set process_status = wip_constants.error
623: where group_id = p_group_id
624: and process_phase = wip_constants.ml_validation
625: and process_status in (wip_constants.running,