APPS.AHL_RM_OP_ROUTE_AS_PVT dependencies on AHL_OPERATIONS_B

Line 581: FROM AHL_OPERATIONS_B

577:
578: CURSOR get_active_operation ( c_operation_id NUMBER )
579: IS
580: SELECT 'X'
581: FROM AHL_OPERATIONS_B
582: WHERE operation_id = c_operation_id
583: AND TRUNC( NVL( END_DATE_ACTIVE, SYSDATE + 1 ) ) > TRUNC( SYSDATE );
584:
585: BEGIN

Line 726: CURSOR duplicate_step(c_concatenated_segments AHL_OPERATIONS_B_KFV.CONCATENATED_SEGMENTS%TYPE, c_step NUMBER,c_route_id NUMBER)

722: FROM ahl_routes_b
723: WHERE route_id = p_route_id;
724:
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

Line 1059: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'

1055: fnd_log.string
1056: (
1057: fnd_log.level_unexpected,
1058: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
1059: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
1060: );
1061: END IF;
1062: END IF;
1063: FND_MSG_PUB.add;