DBA Data[Home] [Help]

APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on WIP_DJ_CLOSE_TEMP

Line 787: SELECT wip_dj_close_temp_s.nextval

783: return;
784: END;
785: BEGIN
786: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Selecting group_id'); END IF;
787: SELECT wip_dj_close_temp_s.nextval
788: INTO l_gid
789: FROM dual;
790: EXCEPTION
791: WHEN OTHERS THEN

Line 796: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Insert into WIP_DJ_CLOSE_TEMP'); END IF;

792: raise fnd_api.g_exc_unexpected_error;
793: END;
794:
795: BEGIN
796: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Insert into WIP_DJ_CLOSE_TEMP'); END IF;
797: INSERT INTO WIP_DJ_CLOSE_TEMP
798: (WIP_ENTITY_ID,
799: ORGANIZATION_ID,
800: WIP_ENTITY_NAME,

Line 797: INSERT INTO WIP_DJ_CLOSE_TEMP

793: END;
794:
795: BEGIN
796: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Insert into WIP_DJ_CLOSE_TEMP'); END IF;
797: INSERT INTO WIP_DJ_CLOSE_TEMP
798: (WIP_ENTITY_ID,
799: ORGANIZATION_ID,
800: WIP_ENTITY_NAME,
801: PRIMARY_ITEM_ID,