APPS.AHL_PRD_OPERATIONS_PVT dependencies on AHL_WORKORDER_OPERATIONS

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

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

Line 628: AHL_WORKORDER_OPERATIONS wop,

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

Line 799: AHL_WORKORDER_OPERATIONS

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

Line 980: FROM AHL_WORKORDER_OPERATIONS

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

Line 1025: FROM AHL_WORKORDER_OPERATIONS

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

Line 1242: FROM AHL_WORKORDER_OPERATIONS

1238: --cursor to retrieve the Operation Status Code
1239: CURSOR get_op_status(x_workorder_operation_id NUMBER)
1240: IS
1241: SELECT STATUS_CODE,OBJECT_VERSION_NUMBER
1242: FROM AHL_WORKORDER_OPERATIONS
1243: WHERE WORKORDER_OPERATION_ID = x_workorder_operation_id;
1244:
1245: BEGIN
1246: SAVEPOINT process_operations_PVT;

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

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

Line 1356: INSERT INTO AHL_WORKORDER_OPERATIONS

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

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

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

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,