DBA Data[Home] [Help]

APPS.EAM_PM_UTILS dependencies on WIP_JOB_SCHEDULE_INTERFACE

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

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

Line 493: insert into wip_job_schedule_interface(

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

Line 592: insert into wip_job_schedule_interface(

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

Line 695: insert into wip_job_schedule_interface(

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

Line 732: insert into wip_job_schedule_interface(

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