APPS.WIP_ATO_JOBS_PRIV dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 612: | wip_job_schedule_interface. Just perform the feedback loop. |

608: | run of this program. |
609: | |
610: | When cleaning, up skip the sections that marks mtl_demand |
611: | records that need to be loaded and inserts records into |
612: | wip_job_schedule_interface. Just perform the feedback loop. |
613: +===============================================================+*/
614: if (L_FAILED_REQ_ID = -1) then
615:
616: if (l_logLevel <= wip_constants.full_logging) then

Line 740: | MTL_DEMAND and WIP_JOB_SCHEDULE_INTERFACE. |

736: | If failed_request_id <> 0, the program is being run in |
737: | 'cleanup mode' -- see comment earlier in program for details |
738: | on what happens in 'cleanup' mode, If this is the case, |
739: | the group_ids used for feedback must be retrieved from |
740: | MTL_DEMAND and WIP_JOB_SCHEDULE_INTERFACE. |
741: +===============================================================+*/
742: if (L_FAILED_REQ_ID <> -1) THEN
743:
744: /* OM Installed - No Clean-up Mode Code Yet */

Line 785: FROM wip_job_schedule_interface

781:
782: wjsi_group_id := l_wip_group_id;
783:
784: SELECT COUNT(*) INTO num_error_records
785: FROM wip_job_schedule_interface
786: WHERE GROUP_ID = wjsi_group_id
787: AND (PROCESS_STATUS <> WCOMPLETED
788: OR PROCESS_PHASE <> WIP_ML_COMPLETE);
789:

Line 1040: FROM WIP_JOB_SCHEDULE_INTERFACE

1036: with process phase and process status COMPLETE else these may remain orphan */
1037: DELETE FROM WIP_INTERFACE_ERRORS
1038: WHERE INTERFACE_ID IN (
1039: SELECT INTERFACE_ID
1040: FROM WIP_JOB_SCHEDULE_INTERFACE
1041: WHERE GROUP_ID = wei_group_id
1042: AND PROCESS_PHASE = WIP_ML_COMPLETE
1043: AND PROCESS_STATUS = WCOMPLETED);
1044:

Line 1045: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE I

1041: WHERE GROUP_ID = wei_group_id
1042: AND PROCESS_PHASE = WIP_ML_COMPLETE
1043: AND PROCESS_STATUS = WCOMPLETED);
1044:
1045: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE I
1046: WHERE I.GROUP_ID = wei_group_id
1047: AND I.PROCESS_PHASE = WIP_ML_COMPLETE
1048: AND I.PROCESS_STATUS = WCOMPLETED;
1049:

Line 1062: FROM WIP_JOB_SCHEDULE_INTERFACE

1058:
1059: DELETE FROM WIP_INTERFACE_ERRORS
1060: WHERE INTERFACE_ID IN
1061: (SELECT INTERFACE_ID
1062: FROM WIP_JOB_SCHEDULE_INTERFACE
1063: WHERE GROUP_ID = wei_group_id);
1064:
1065: DELETE FROM wip_job_schedule_interface wei
1066: WHERE group_id = wei_group_id;

Line 1065: DELETE FROM wip_job_schedule_interface wei

1061: (SELECT INTERFACE_ID
1062: FROM WIP_JOB_SCHEDULE_INTERFACE
1063: WHERE GROUP_ID = wei_group_id);
1064:
1065: DELETE FROM wip_job_schedule_interface wei
1066: WHERE group_id = wei_group_id;
1067:
1068: END IF;
1069:

Line 1075: FROM WIP_JOB_SCHEDULE_INTERFACE WHERE GROUP_ID = wei_group_id ;

1071: if (l_logLevel <= wip_constants.full_logging) then
1072: wip_logger.log('Dbg:'||SQL%ROWCOUNT||' records deleted from interface', l_returnStatus);
1073:
1074: SELECT COUNT(*) INTO n_undeleted_records
1075: FROM WIP_JOB_SCHEDULE_INTERFACE WHERE GROUP_ID = wei_group_id ;
1076:
1077: if(n_undeleted_records <> 0) THEN
1078: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);
1079: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);

Line 1079: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);

1075: FROM WIP_JOB_SCHEDULE_INTERFACE WHERE GROUP_ID = wei_group_id ;
1076:
1077: if(n_undeleted_records <> 0) THEN
1078: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);
1079: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);
1080: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);
1081: wip_logger.log('Dbg:for details.', l_returnStatus);
1082: END IF;
1083: