DBA Data[Home] [Help]

APPS.EAM_PM_UTILS dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 348: * forecast table to wip_job_schedule_interface to be uploaded. It removes the

344:
345:
346: /**
347: * This procedure is called to move the forecasted work order suggestions from
348: * forecast table to wip_job_schedule_interface to be uploaded. It removes the
349: * records from forecast table then.
350: */
351: procedure transfer_to_wdj(p_group_id number) is
352: cursor pms is

Line 494: insert into wip_job_schedule_interface(

490: if ( recinfo.action_type = 1 ) then
491: -- Create
492: if ( l_eam_item_type = 1 ) then
493: -- for Asset Group and number
494: insert into wip_job_schedule_interface(
495: group_id,
496: last_update_date,
497: last_updated_by,
498: creation_date,

Line 593: insert into wip_job_schedule_interface(

589: 1
590: );
591: elsif (l_eam_item_type = 3) then
592: -- for rebuildables
593: insert into wip_job_schedule_interface(
594: group_id,
595: last_update_date,
596: last_updated_by,
597: creation_date,

Line 696: insert into wip_job_schedule_interface(

692: end if;
693:
694: elsif ( recinfo.action_type = 2 ) then
695: -- Reschdule
696: insert into wip_job_schedule_interface(
697: group_id,
698: last_update_date,
699: last_updated_by,
700: creation_date,

Line 733: insert into wip_job_schedule_interface(

729: 1
730: );
731: elsif ( recinfo.action_type = 3 ) then
732: -- Cancel
733: insert into wip_job_schedule_interface(
734: group_id,
735: last_update_date,
736: last_updated_by,
737: creation_date,