DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on DUAL

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

477: );
478:
479: ELSE
480:
481: SELECT EAM_CE_WORK_ORDER_LINES_S.NEXTVAL INTO l_wo_line_id_seq FROM DUAL;
482:
483: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
484: p_estimate_work_order_line_id => l_wo_line_id_seq
485: ,p_estimate_work_order_id => FND_API.G_MISS_NUM

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

4918: -- and work order related details
4919: IF (l_estimate_rec.CREATE_PARENT_WO_FLAG = 'Y' AND
4920: l_parent_estimate_wo_line_id = l_est_workorder_line_rec.ESTIMATE_WORK_ORDER_LINE_ID) THEN
4921:
4922: SELECT EAM_CE_WORK_ORDER_LINES_S.NEXTVAL INTO l_wo_line_id_seq FROM DUAL;
4923:
4924: EAM_CE_WORK_ORDER_LINES_PKG.INSERT_ROW(
4925: p_estimate_work_order_line_id => l_wo_line_id_seq
4926: ,p_estimate_work_order_id => NULL