APPS.WIP_ATO_JOBS_PRIV dependencies on WIP_JOB_SCHEDULE_INTERFACE

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

706: | run of this program. |
707: | |
708: | When cleaning, up skip the sections that marks mtl_demand |
709: | records that need to be loaded and inserts records into |
710: | wip_job_schedule_interface. Just perform the feedback loop. |
711: +===============================================================+*/
712: if (L_FAILED_REQ_ID = -1) then
713:
714: if (l_logLevel <= wip_constants.full_logging) then

Line 844: from wip_job_schedule_interface

840: into l_line_count
841: from dual
842: where exists
843: ( select source_line_id
844: from wip_job_schedule_interface
845: where group_id = l_wip_group_id
846: and process_phase = WIP_CONSTANTS.ML_COMPLETE
847: and process_status in (WIP_CONSTANTS.COMPLETED,WIP_CONSTANTS.WARNING)
848: );

Line 891: | MTL_DEMAND and WIP_JOB_SCHEDULE_INTERFACE. |

887: | If failed_request_id <> 0, the program is being run in |
888: | 'cleanup mode' -- see comment earlier in program for details |
889: | on what happens in 'cleanup' mode, If this is the case, |
890: | the group_ids used for feedback must be retrieved from |
891: | MTL_DEMAND and WIP_JOB_SCHEDULE_INTERFACE. |
892: +===============================================================+*/
893: if (L_FAILED_REQ_ID <> -1) THEN
894:
895: /* OM Installed - No Clean-up Mode Code Yet */

Line 936: FROM wip_job_schedule_interface

932:
933: wjsi_group_id := l_wip_group_id;
934:
935: SELECT COUNT(*) INTO num_error_records
936: FROM wip_job_schedule_interface
937: WHERE GROUP_ID = wjsi_group_id
938: AND (PROCESS_STATUS <> WCOMPLETED
939: OR PROCESS_PHASE <> WIP_ML_COMPLETE);
940:

Line 1195: FROM WIP_JOB_SCHEDULE_INTERFACE

1191: with process phase and process status COMPLETE else these may remain orphan */
1192: DELETE FROM WIP_INTERFACE_ERRORS
1193: WHERE INTERFACE_ID IN (
1194: SELECT INTERFACE_ID
1195: FROM WIP_JOB_SCHEDULE_INTERFACE
1196: WHERE GROUP_ID = wei_group_id
1197: AND PROCESS_PHASE = WIP_ML_COMPLETE
1198: AND PROCESS_STATUS = WCOMPLETED);
1199:

Line 1202: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE I

1198: AND PROCESS_STATUS = WCOMPLETED);
1199:
1200: fnd_file.put_line(which => fnd_file.log, buff => 'Deleted from wie:' || sql%rowcount);
1201:
1202: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE I
1203: WHERE I.GROUP_ID = wei_group_id
1204: AND I.PROCESS_PHASE = WIP_ML_COMPLETE
1205: AND I.PROCESS_STATUS = WCOMPLETED;
1206:

Line 1223: FROM WIP_JOB_SCHEDULE_INTERFACE

1219: /*
1220: DELETE FROM WIP_INTERFACE_ERRORS
1221: WHERE INTERFACE_ID IN
1222: (SELECT INTERFACE_ID
1223: FROM WIP_JOB_SCHEDULE_INTERFACE
1224: WHERE GROUP_ID = wei_group_id);
1225:
1226: DELETE FROM wip_job_schedule_interface wei
1227: WHERE group_id = wei_group_id;

Line 1226: DELETE FROM wip_job_schedule_interface wei

1222: (SELECT INTERFACE_ID
1223: FROM WIP_JOB_SCHEDULE_INTERFACE
1224: WHERE GROUP_ID = wei_group_id);
1225:
1226: DELETE FROM wip_job_schedule_interface wei
1227: WHERE group_id = wei_group_id;
1228: */
1229: null;
1230:

Line 1238: FROM WIP_JOB_SCHEDULE_INTERFACE WHERE GROUP_ID = wei_group_id ;

1234: if (l_logLevel <= wip_constants.full_logging) then
1235: wip_logger.log('Dbg:'||SQL%ROWCOUNT||' records deleted from interface', l_returnStatus);
1236:
1237: SELECT COUNT(*) INTO n_undeleted_records
1238: FROM WIP_JOB_SCHEDULE_INTERFACE WHERE GROUP_ID = wei_group_id ;
1239:
1240: if(n_undeleted_records <> 0) THEN
1241: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);
1242: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);

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

1238: FROM WIP_JOB_SCHEDULE_INTERFACE WHERE GROUP_ID = wei_group_id ;
1239:
1240: if(n_undeleted_records <> 0) THEN
1241: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);
1242: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);
1243: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);
1244: wip_logger.log('Dbg:for details.', l_returnStatus);
1245: END IF;
1246: