eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 642: FROM AHL_ROUTE_OPERATIONS_V

638:
639: CURSOR get_dup_rec ( c_route_id NUMBER )
640: IS
641: SELECT step, concatenated_segments
642: FROM AHL_ROUTE_OPERATIONS_V
643: WHERE route_id = c_route_id
644: AND NVL( end_date_active, SYSDATE + 1 ) > SYSDATE
645: ORDER BY step, concatenated_segments;
646:

Line 649: l_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;

645: ORDER BY step, concatenated_segments;
646:
647: l_step NUMBER;
648: l_prev_step NUMBER;
649: l_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
650: l_prev_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
651:
652: BEGIN
653:

Line 650: l_prev_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;

646:
647: l_step NUMBER;
648: l_prev_step NUMBER;
649: l_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
650: l_prev_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
651:
652: BEGIN
653:
654: -- Check whether any duplicate route_operation records (based on step) for the given route_id

Line 940: INSERT INTO AHL_ROUTE_OPERATIONS

936: FOR i IN 1..p_x_route_operation_tbl.count LOOP
937: IF ( p_x_route_operation_tbl(i).dml_operation = 'C' ) THEN
938: BEGIN
939: -- Insert the record
940: INSERT INTO AHL_ROUTE_OPERATIONS
941: (
942: ROUTE_OPERATION_ID,
943: OBJECT_VERSION_NUMBER,
944: ROUTE_ID,

Line 971: AHL_ROUTE_OPERATIONS_S.NEXTVAL,

967: CREATED_BY,
968: LAST_UPDATE_LOGIN
969: ) VALUES
970: (
971: AHL_ROUTE_OPERATIONS_S.NEXTVAL,
972: p_x_route_operation_tbl(i).object_version_number,
973: p_route_id,
974: p_x_route_operation_tbl(i).operation_id,
975: p_x_route_operation_tbl(i).step,

Line 1027: UPDATE AHL_ROUTE_OPERATIONS SET

1023: ELSIF ( p_x_route_operation_tbl(i).dml_operation = 'U' ) THEN
1024:
1025: BEGIN
1026: -- Update the record
1027: UPDATE AHL_ROUTE_OPERATIONS SET
1028: object_version_number = object_version_number + 1,
1029: operation_id = p_x_route_operation_tbl(i).operation_id,
1030: step = p_x_route_operation_tbl(i).step,
1031: check_point_flag = p_x_route_operation_tbl(i).check_point_flag,

Line 1077: DELETE FROM AHL_ROUTE_OPERATIONS

1073: END;
1074:
1075: ELSIF ( p_x_route_operation_tbl(i).dml_operation = 'D' ) THEN
1076: -- Delete the record
1077: DELETE FROM AHL_ROUTE_OPERATIONS
1078: WHERE route_operation_id = p_x_route_operation_tbl(i).route_operation_id
1079: AND object_version_number = p_x_route_operation_tbl(i).object_version_number;
1080:
1081: -- If the record does not exist, then, abort API.