APPS.EAM_WO_COMP_UTILITY_PVT dependencies on WIP_DISCRETE_JOBS

Line 649: -- get some value from wip_discrete_jobs table

645: l_lot VARCHAR2(80);
646: BEGIN
647: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing update_row'); END IF;
648:
649: -- get some value from wip_discrete_jobs table
650: select parent_wip_entity_id,
651: asset_group_id,
652: asset_number,
653: primary_item_id,

Line 674: from wip_discrete_jobs

670: i_task_id,
671: i_maintenance_source_id, -- added as part of bug #2774571 to check whether the work order is of 'EAM' or 'CMRO'
672: i_maintenance_object_type, -- Fix for Bug 3448770
673: i_maintenance_object_id
674: from wip_discrete_jobs
675: where wip_entity_id = p_eam_wo_comp_rec.wip_entity_id;
676:
677: IF p_eam_wo_comp_rec.transaction_type = 4 THEN
678: l_txn_type:=1;

Line 864: FROM WIP_DISCRETE_JOBS

860: INTO l_asset_group_id ,
861: l_asset_number,
862: i_maintenance_object_type,
863: i_maintenance_object_id
864: FROM WIP_DISCRETE_JOBS
865: WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id;
866:
867:
868: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN

Line 912: UPDATE WIP_DISCRETE_JOBS

908: END IF;
909: END IF; --end of check for transaction type=completion
910:
911:
912: UPDATE WIP_DISCRETE_JOBS
913: SET last_update_date = sysdate,
914: last_updated_by = FND_GLOBAL.user_id,
915: last_update_login = FND_GLOBAL.login_id,
916: status_type = i_status_type,