APPS.AHL_PRD_OPERATIONS_PVT dependencies on AHL_WORKORDER_OPERATIONS_S

Line 87: SELECT ahl_workorder_operations_s.NEXTVAL

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

Line 1441: UPDATE AHL_WORKORDER_OPERATIONS SET

1437: p_x_prd_operation_tbl(i).status_code := l_op_status;
1438: idx := idx + 1;
1439: END IF;
1440:
1441: UPDATE AHL_WORKORDER_OPERATIONS SET
1442: OBJECT_VERSION_NUMBER =p_x_prd_operation_tbl(I).OBJECT_VERSION_NUMBER +1,
1443: LAST_UPDATE_DATE =NVL(p_x_prd_operation_tbl(I).LAST_UPDATE_DATE,SYSDATE),
1444: LAST_UPDATED_BY =NVL(p_x_prd_operation_tbl(I).LAST_UPDATED_BY,FND_GLOBAL.user_id),
1445: OPERATION_SEQUENCE_NUM =p_x_prd_operation_tbl(I).OPERATION_SEQUENCE_NUM,