APPS.AHL_RM_OP_ROUTE_AS_PVT dependencies on AHL_ROUTE_OPERATIONS

Line 311: FROM AHL_ROUTE_OPERATIONS_V

307: attribute12,
308: attribute13,
309: attribute14,
310: attribute15
311: FROM AHL_ROUTE_OPERATIONS_V
312: WHERE route_operation_id = c_route_operation_id;
313:
314: BEGIN
315:

Line 647: FROM AHL_ROUTE_OPERATIONS_V

643:
644: CURSOR get_dup_rec ( c_route_id NUMBER )
645: IS
646: SELECT step, concatenated_segments
647: FROM AHL_ROUTE_OPERATIONS_V
648: WHERE route_id = c_route_id
649: AND NVL( end_date_active, SYSDATE + 1 ) > SYSDATE
650: ORDER BY step, concatenated_segments;
651:

Line 654: l_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;

650: ORDER BY step, concatenated_segments;
651:
652: l_step NUMBER;
653: l_prev_step NUMBER;
654: l_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
655: l_prev_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
656:
657: BEGIN
658:

Line 655: l_prev_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;

651:
652: l_step NUMBER;
653: l_prev_step NUMBER;
654: l_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
655: l_prev_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
656:
657: BEGIN
658:
659: -- Check whether any duplicate route_operation records (based on step) for the given route_id

Line 729: FROM ahl_route_operations_v

725: -- Pekambar Added for USAF - VEE
726: CURSOR duplicate_step(c_concatenated_segments AHL_OPERATIONS_B_KFV.CONCATENATED_SEGMENTS%TYPE, c_step NUMBER,c_route_id NUMBER)
727: IS
728: SELECT 'X'
729: FROM ahl_route_operations_v
730: WHERE concatenated_segments <> c_concatenated_segments
731: AND step = c_step
732: AND route_id = c_route_id
733: AND NVL( end_date_active, SYSDATE + 1 ) > SYSDATE;

Line 984: INSERT INTO AHL_ROUTE_OPERATIONS

980: FOR i IN 1..p_x_route_operation_tbl.count LOOP
981: IF ( p_x_route_operation_tbl(i).dml_operation = 'C' ) THEN
982: BEGIN
983: -- Insert the record
984: INSERT INTO AHL_ROUTE_OPERATIONS
985: (
986: ROUTE_OPERATION_ID,
987: OBJECT_VERSION_NUMBER,
988: ROUTE_ID,

Line 1015: AHL_ROUTE_OPERATIONS_S.NEXTVAL,

1011: CREATED_BY,
1012: LAST_UPDATE_LOGIN
1013: ) VALUES
1014: (
1015: AHL_ROUTE_OPERATIONS_S.NEXTVAL,
1016: p_x_route_operation_tbl(i).object_version_number,
1017: p_route_id,
1018: p_x_route_operation_tbl(i).operation_id,
1019: p_x_route_operation_tbl(i).step,

Line 1071: UPDATE AHL_ROUTE_OPERATIONS SET

1067: ELSIF ( p_x_route_operation_tbl(i).dml_operation = 'U' ) THEN
1068:
1069: BEGIN
1070: -- Update the record
1071: UPDATE AHL_ROUTE_OPERATIONS SET
1072: object_version_number = object_version_number + 1,
1073: operation_id = p_x_route_operation_tbl(i).operation_id,
1074: step = p_x_route_operation_tbl(i).step,
1075: check_point_flag = p_x_route_operation_tbl(i).check_point_flag,

Line 1135: DELETE FROM AHL_ROUTE_OPERATIONS

1131: END;
1132:
1133: ELSIF ( p_x_route_operation_tbl(i).dml_operation = 'D' ) THEN
1134: -- Delete the record
1135: DELETE FROM AHL_ROUTE_OPERATIONS
1136: WHERE route_operation_id = p_x_route_operation_tbl(i).route_operation_id
1137: AND object_version_number = p_x_route_operation_tbl(i).object_version_number;
1138:
1139: -- If the record does not exist, then, abort API.