APPS.GMP_APS_OUTPUT_PKG dependencies on WIP_JOB_DTLS_INTERFACE

Line 475: FROM WIP_JOB_DTLS_INTERFACE wdi ,

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

Line 510: DELETE wip_job_dtls_interface

506: DELETE wip_job_schedule_interface
507: WHERE group_id = p_group_id
508: AND process_status = 1
509: AND load_type = 1 ;
510: DELETE wip_job_dtls_interface
511: WHERE group_id = p_group_id
512: AND process_status = 1 ;
513: END IF;
514:

Line 521: DELETE wip_job_dtls_interface

517: WHERE group_id = p_group_id
518: AND process_status = 1
519: AND nvl(status_type,0 ) <> 7 /* Rescheduled Batch */
520: AND load_type = 3 ;
521: DELETE wip_job_dtls_interface
522: WHERE group_id = p_group_id
523: AND process_status = 1 ;
524: END IF;
525:

Line 533: DELETE wip_job_dtls_interface

529: AND process_status = 1
530: AND nvl(status_type,0 ) = 7 /* Cancelled Batch */
531: AND load_type = 3 ;
532:
533: DELETE wip_job_dtls_interface
534: WHERE group_id = p_group_id
535: AND process_status = 1 ;
536: END IF;
537: END IF;