DBA Data[Home] [Help]

APPS.EAM_WO_DEFAULT_PVT dependencies on DUAL

Line 43: FROM dual;

39: 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_DEFAULT_PVT.get_wip_entity_id : Start ================'); END IF;
40:
41: SELECT wip_entities_s.nextval
42: INTO l_wip_entity_id
43: FROM dual;
44:
45: 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_DEFAULT_PVT.get_wip_entity_id : End wip_entity_id: '||l_wip_entity_id||' ================'); END IF;
46:
47: RETURN l_wip_entity_id;

Line 154: FROM dual;

150: LOOP
151: IF nvl(p_source_code,'EAM') ='BUD' THEN -- ER 14323372
152: SELECT eam_bfwo_job_number_s.nextval
153: INTO l_wip_entity_name
154: FROM dual;
155: ELSE
156: SELECT wip_job_number_s.nextval
157: INTO l_wip_entity_name
158: FROM dual;

Line 158: FROM dual;

154: FROM dual;
155: ELSE
156: SELECT wip_job_number_s.nextval
157: INTO l_wip_entity_name
158: FROM dual;
159: END IF;
160:
161: l_wip_entity_name := l_wip_entity_name_prefix || l_wip_entity_name;
162: