DBA Data[Home] [Help]

APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on WIP_DJ_CLOSE_TEMP

Line 834: SELECT wip_dj_close_temp_s.nextval

830: return;
831: END;
832: BEGIN
833: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.change_status: Selecting group_id'); END IF;
834: SELECT wip_dj_close_temp_s.nextval
835: INTO l_gid
836: FROM dual;
837: EXCEPTION
838: WHEN OTHERS THEN

Line 843: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.change_status: Insert into WIP_DJ_CLOSE_TEMP'); END IF;

839: raise fnd_api.g_exc_unexpected_error;
840: END;
841:
842: BEGIN
843: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.change_status: Insert into WIP_DJ_CLOSE_TEMP'); END IF;
844: INSERT INTO WIP_DJ_CLOSE_TEMP
845: (WIP_ENTITY_ID,
846: ORGANIZATION_ID,
847: WIP_ENTITY_NAME,

Line 844: INSERT INTO WIP_DJ_CLOSE_TEMP

840: END;
841:
842: BEGIN
843: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.change_status: Insert into WIP_DJ_CLOSE_TEMP'); END IF;
844: INSERT INTO WIP_DJ_CLOSE_TEMP
845: (WIP_ENTITY_ID,
846: ORGANIZATION_ID,
847: WIP_ENTITY_NAME,
848: PRIMARY_ITEM_ID,