APPS.AHL_PRD_OPERATIONS_PVT dependencies on AHL_WORKORDER_OPERATIONS

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 244: FROM AHL_WORKORDER_OPERATIONS_V

240: AS
241: cursor get_operation_rec(c_operation_id NUMBER)
242: is
243: SELECT *
244: FROM AHL_WORKORDER_OPERATIONS_V
245: WHERE workorder_operation_id=c_operation_id;
246:
247: l_old_operation_rec get_operation_rec%ROWTYPE;
248:

Line 626: AHL_WORKORDER_OPERATIONS wop,

622: IS
623: SELECT
624: rop.concatenated_segments
625: FROM
626: AHL_WORKORDER_OPERATIONS wop,
627: AHL_OPERATIONS_B_KFV rop
628: WHERE
629: rop.operation_id = wop.operation_id
630: AND wop.workorder_operation_id = p_wo_op_id;

Line 797: AHL_WORKORDER_OPERATIONS

793: SELECT
794: TO_CHAR(ACTUAL_START_DATE, 'ss') actual_start_sec,
795: TO_CHAR(ACTUAL_END_DATE, 'ss') actual_end_sec
796: FROM
797: AHL_WORKORDER_OPERATIONS
798: WHERE
799: workorder_operation_id = c_wo_op_id;
800:
801: l_compl_subinv_rec get_completion_sub_inv%ROWTYPE;

Line 978: FROM AHL_WORKORDER_OPERATIONS

974: AS
975: CURSOR validate_unique_operation(c_workorder_id NUMBER,c_operation_seq_num NUMBER)
976: IS
977: SELECT 'X'
978: FROM AHL_WORKORDER_OPERATIONS
979: WHERE workorder_id =c_workorder_id
980: AND operation_sequence_num =c_operation_seq_num;
981:
982: l_unique_rec VARCHAR2(1);

Line 1023: FROM AHL_WORKORDER_OPERATIONS

1019: -- fix for bug# 7555681
1020: CURSOR get_curr_operation_status(c_workorder_id NUMBER,c_operation_seq_num NUMBER)
1021: IS
1022: SELECT status_code
1023: FROM AHL_WORKORDER_OPERATIONS
1024: WHERE workorder_id =c_workorder_id
1025: AND operation_sequence_num =c_operation_seq_num;
1026:
1027: l_curr_op_status VARCHAR2(1);

Line 1238: FROM AHL_WORKORDER_OPERATIONS

1234: --cursor to retrieve the Operation Status Code
1235: CURSOR get_op_status(x_workorder_operation_id NUMBER)
1236: IS
1237: SELECT STATUS_CODE
1238: FROM AHL_WORKORDER_OPERATIONS
1239: WHERE WORKORDER_OPERATION_ID = x_workorder_operation_id;
1240:
1241: BEGIN
1242: SAVEPOINT process_operations_PVT;

Line 1349: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Inserting into AHL_WORKORDER_OPERATIONS' );

1345:
1346: IF p_x_prd_operation_tbl(i).dml_operation='C' THEN
1347:
1348: IF ( G_DEBUG = 'Y' ) THEN
1349: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Inserting into AHL_WORKORDER_OPERATIONS' );
1350: END IF;
1351:
1352: INSERT INTO AHL_WORKORDER_OPERATIONS
1353: (

Line 1352: INSERT INTO AHL_WORKORDER_OPERATIONS

1348: IF ( G_DEBUG = 'Y' ) THEN
1349: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Inserting into AHL_WORKORDER_OPERATIONS' );
1350: END IF;
1351:
1352: INSERT INTO AHL_WORKORDER_OPERATIONS
1353: (
1354: WORKORDER_OPERATION_ID,
1355: OBJECT_VERSION_NUMBER ,
1356: LAST_UPDATE_DATE ,

Line 1424: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Updating AHL_WORKORDER_OPERATIONS' );

1420: );
1421: ELSIF p_x_prd_operation_tbl(I).DML_OPERATION='U' THEN
1422:
1423: IF ( G_DEBUG = 'Y' ) THEN
1424: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Updating AHL_WORKORDER_OPERATIONS' );
1425: END IF;
1426:
1427: -- R12
1428: -- Tech UIs

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,