APPS.EAM_WO_PROCESSOR dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 56: -- rows for WIP_JOB_SCHEDULE_INTERFACE for processing.

52: -- The status will be set to 'Not Ready' if the processing fails.
53: -- 2. Multiple Work Order processing.
54: -- Takes argument p_group_id, p_org_id
55: -- p_group_id is the group id to be used for Mass Load to takes
56: -- rows for WIP_JOB_SCHEDULE_INTERFACE for processing.
57: -- It calls Mass Load for scheduling and change the job status
58: -- from 'Pending Scheduling' to 'Unreleased','Released', or 'Hold'.
59: -- The status will be set to 'Not Ready' if the processing fails.
60:

Line 259: from wip_job_schedule_interface

255: l_index := l_jobs.first;
256: loop
257: select count(*)
258: into l_err_cnt
259: from wip_job_schedule_interface
260: where wip_entity_id = l_jobs(l_index).wip_entity_id
261: and group_id = p_group_id
262: and process_status <> WIP_CONSTANTS.COMPLETED;
263:

Line 467: -- Fucntion to populate PL/SQL table from WIP_JOB_SCHEDULE_INTERFACE

463: retcode := G_ERROR;
464: return ;
465: end;
466:
467: -- Fucntion to populate PL/SQL table from WIP_JOB_SCHEDULE_INTERFACE
468: function populate_jobs(p_group_id number) return jobs_table is
469: l_jobs jobs_table;
470: cursor job_cursor is
471: select wip_entity_id,status_type

Line 472: from wip_job_schedule_interface

468: function populate_jobs(p_group_id number) return jobs_table is
469: l_jobs jobs_table;
470: cursor job_cursor is
471: select wip_entity_id,status_type
472: from wip_job_schedule_interface
473: where group_id = p_group_id;
474: l_index number := 0;
475: begin
476: for job_cursor_record in job_cursor loop