APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_OPERATIONS_B

Line 11: p_concatenated_segments IN AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE,

7: PROCEDURE validate_operation
8: (
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_concatenated_segments IN AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE,
12: p_x_operation_id IN OUT NOCOPY AHL_OPERATIONS_B.operation_id%TYPE
13: )
14: IS
15:

Line 12: p_x_operation_id IN OUT NOCOPY AHL_OPERATIONS_B.operation_id%TYPE

8: (
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_concatenated_segments IN AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE,
12: p_x_operation_id IN OUT NOCOPY AHL_OPERATIONS_B.operation_id%TYPE
13: )
14: IS
15:
16: l_operation_id AHL_OPERATIONS_B.operation_id%TYPE;

Line 16: l_operation_id AHL_OPERATIONS_B.operation_id%TYPE;

12: p_x_operation_id IN OUT NOCOPY AHL_OPERATIONS_B.operation_id%TYPE
13: )
14: IS
15:
16: l_operation_id AHL_OPERATIONS_B.operation_id%TYPE;
17:
18: CURSOR get_rec_from_value ( c_concatenated_segments AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE )
19: IS
20: SELECT DISTINCT operation_id

Line 18: CURSOR get_rec_from_value ( c_concatenated_segments AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE )

14: IS
15:
16: l_operation_id AHL_OPERATIONS_B.operation_id%TYPE;
17:
18: CURSOR get_rec_from_value ( c_concatenated_segments AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE )
19: IS
20: SELECT DISTINCT operation_id
21: FROM AHL_OPERATIONS_B_KFV
22: WHERE concatenated_segments = c_concatenated_segments;

Line 21: FROM AHL_OPERATIONS_B_KFV

17:
18: CURSOR get_rec_from_value ( c_concatenated_segments AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE )
19: IS
20: SELECT DISTINCT operation_id
21: FROM AHL_OPERATIONS_B_KFV
22: WHERE concatenated_segments = c_concatenated_segments;
23:
24: CURSOR get_rec_from_id ( c_operation_id AHL_OPERATIONS_B.operation_id%TYPE )
25: IS

Line 24: CURSOR get_rec_from_id ( c_operation_id AHL_OPERATIONS_B.operation_id%TYPE )

20: SELECT DISTINCT operation_id
21: FROM AHL_OPERATIONS_B_KFV
22: WHERE concatenated_segments = c_concatenated_segments;
23:
24: CURSOR get_rec_from_id ( c_operation_id AHL_OPERATIONS_B.operation_id%TYPE )
25: IS
26: SELECT DISTINCT operation_id
27: FROM AHL_OPERATIONS_B
28: WHERE operation_id = c_operation_id;

Line 27: FROM AHL_OPERATIONS_B

23:
24: CURSOR get_rec_from_id ( c_operation_id AHL_OPERATIONS_B.operation_id%TYPE )
25: IS
26: SELECT DISTINCT operation_id
27: FROM AHL_OPERATIONS_B
28: WHERE operation_id = c_operation_id;
29:
30: BEGIN
31: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3213: FROM ahl_operations_b

3209: IS
3210:
3211: CURSOR get_operation_status(c_operation_id number) IS
3212: SELECT revision_status_code
3213: FROM ahl_operations_b
3214: WHERE operation_id = c_operation_id;
3215: l_operation_status_code VARCHAR2(30);
3216:
3217: BEGIN

Line 3286: FROM AHL_RT_OPER_RESOURCES RES, AHL_OPERATIONS_B OPER, AHL_ROUTE_OPERATIONS ASS

3282: /*
3283: CURSOR get_max_op_resource_duration( c_route_id NUMBER )
3284: IS
3285: SELECT MAX( RES.duration )
3286: FROM AHL_RT_OPER_RESOURCES RES, AHL_OPERATIONS_B OPER, AHL_ROUTE_OPERATIONS ASS
3287: WHERE RES.association_type_code = 'OPERATION'
3288: AND RES.object_id = ASS.operation_id
3289: AND NVL( OPER.end_date_active , TRUNC( SYSDATE ) + 1 ) > TRUNC( SYSDATE )
3290: AND OPER.operation_id = ASS.operation_id

Line 3299: FROM AHL_RT_OPER_RESOURCES RES, AHL_OPERATIONS_B OPER, AHL_ROUTE_OPERATIONS ASS

3295: IS
3296: SELECT SUM(OPR_DURATION)
3297: FROM
3298: (SELECT RES.object_id,RES.schedule_seq, MAX(duration) "OPR_DURATION"
3299: FROM AHL_RT_OPER_RESOURCES RES, AHL_OPERATIONS_B OPER, AHL_ROUTE_OPERATIONS ASS
3300: WHERE RES.association_type_code = 'OPERATION'
3301: AND RES.object_id = ASS.operation_id
3302: AND NVL( OPER.end_date_active , TRUNC( SYSDATE ) + 1 ) > TRUNC( SYSDATE )
3303: AND OPER.operation_id = ASS.operation_id

Line 3504: FROM AHL_OPERATIONS_B_KFV A, AHL_OPERATIONS_B_KFV B

3500:
3501: CURSOR get_op_latest_start_date( c_operation_id NUMBER )
3502: IS
3503: SELECT MAX( A.start_date_active )
3504: FROM AHL_OPERATIONS_B_KFV A, AHL_OPERATIONS_B_KFV B
3505: WHERE A.concatenated_segments = B.concatenated_segments
3506: AND A.operation_id <> c_operation_id
3507: AND B.operation_id = c_operation_id;
3508: