APPS.GMP_APS_OUTPUT_PKG dependencies on WIP_JOB_DTLS_INTERFACE

Line 473: FROM WIP_JOB_DTLS_INTERFACE wdi ,

469: gri.INSTANCE_NUMBER ,
470: wdi.FIRM_FLAG ,
471: wdi.PARENT_SEQ_NUM ,
472: wdi.RESOURCE_INSTANCE_ID
473: FROM WIP_JOB_DTLS_INTERFACE wdi ,
474: GMP_RESOURCE_INSTANCES gri
475: WHERE
476: wdi.group_id = p_group_id
477: AND wdi.resource_id_new = gri.resource_id (+)

Line 505: DELETE wip_job_dtls_interface

501: DELETE wip_job_schedule_interface
502: WHERE group_id = p_group_id
503: AND process_status = 1
504: AND load_type = 1 ;
505: DELETE wip_job_dtls_interface
506: WHERE group_id = p_group_id
507: AND process_status = 1 ;
508: END IF;
509:

Line 516: DELETE wip_job_dtls_interface

512: WHERE group_id = p_group_id
513: AND process_status = 1
514: AND nvl(status_type,0 ) <> 7 /* Rescheduled Batch */
515: AND load_type = 3 ;
516: DELETE wip_job_dtls_interface
517: WHERE group_id = p_group_id
518: AND process_status = 1 ;
519: END IF;
520:

Line 528: DELETE wip_job_dtls_interface

524: AND process_status = 1
525: AND nvl(status_type,0 ) = 7 /* Cancelled Batch */
526: AND load_type = 3 ;
527:
528: DELETE wip_job_dtls_interface
529: WHERE group_id = p_group_id
530: AND process_status = 1 ;
531: END IF;
532: