DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on DUAL

Line 526: SELECT EAM_CE_WORK_ORDER_LINES_S.NEXTVAL INTO l_wo_line_id_seq FROM DUAL;

522: );
523:
524: ELSE
525:
526: SELECT EAM_CE_WORK_ORDER_LINES_S.NEXTVAL INTO l_wo_line_id_seq FROM DUAL;
527: debug(' Generating new Parent Work order - ' || l_wo_line_id_seq);
528:
529: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
530: p_estimate_work_order_line_id => l_wo_line_id_seq

Line 5112: SELECT EAM_CE_WORK_ORDER_LINES_S.NEXTVAL INTO l_wo_line_id_seq FROM DUAL;

5108: -- and work order related details
5109: IF (l_estimate_rec.CREATE_PARENT_WO_FLAG = 'Y' AND
5110: l_parent_estimate_wo_line_id = l_est_workorder_line_rec.ESTIMATE_WORK_ORDER_LINE_ID) THEN
5111:
5112: SELECT EAM_CE_WORK_ORDER_LINES_S.NEXTVAL INTO l_wo_line_id_seq FROM DUAL;
5113:
5114: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
5115: p_estimate_work_order_line_id => l_wo_line_id_seq
5116: ,p_estimate_work_order_id => NULL