DBA Data[Home] [Help]

APPS.AHL_PRD_OPERATIONS_PVT dependencies on AHL_WORKORDER_OPERATIONS_S

Line 89: SELECT ahl_workorder_operations_s.NEXTVAL

85: p_x_prd_workoper_rec.operation_description:=l_description;
86: END IF;
87: END IF;
88:
89: SELECT ahl_workorder_operations_s.NEXTVAL
90: INTO p_x_prd_workoper_rec.workorder_operation_id
91: FROM DUAL;
92:
93: p_x_prd_workoper_rec.LAST_UPDATE_DATE :=SYSDATE;

Line 1467: UPDATE AHL_WORKORDER_OPERATIONS SET

1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465: END IF;
1466: --sukhwsin::VEE Code Changes - end
1467: UPDATE AHL_WORKORDER_OPERATIONS SET
1468: OBJECT_VERSION_NUMBER =p_x_prd_operation_tbl(I).OBJECT_VERSION_NUMBER +1,
1469: LAST_UPDATE_DATE =NVL(p_x_prd_operation_tbl(I).LAST_UPDATE_DATE,SYSDATE),
1470: LAST_UPDATED_BY =NVL(p_x_prd_operation_tbl(I).LAST_UPDATED_BY,FND_GLOBAL.user_id),
1471: OPERATION_SEQUENCE_NUM =p_x_prd_operation_tbl(I).OPERATION_SEQUENCE_NUM,