APPS.AHL_RM_ROUTE_PVT dependencies on AHL_ROUTES_B

Line 1978: FROM AHL_ROUTES_B_KFV

1974:
1975: CURSOR get_concat_segs(c_route_id NUMBER)
1976: IS
1977: SELECT CONCATENATED_SEGMENTS
1978: FROM AHL_ROUTES_B_KFV
1979: WHERE ROUTE_ID = p_x_route_rec.route_id
1980: AND REPLACE(CONCATENATED_SEGMENTS, FND_FLEX_EXT.GET_DELIMITER('AHL', 'AHLR', 101), NULL) IS NOT NULL;
1981:
1982:

Line 1987: FROM AHL_ROUTES_B_KFV

1983: --validate system KFV to ensure that no two routes share the same System KFV.
1984: CURSOR validate_system_kfv(c_route_no VARCHAR2, c_concat_segs VARCHAR2)
1985: IS
1986: SELECT 'X'
1987: FROM AHL_ROUTES_B_KFV
1988: WHERE REPLACE(CONCATENATED_SEGMENTS, FND_FLEX_EXT.GET_DELIMITER('AHL', 'AHLR', 101), NULL) IS NOT NULL
1989: AND CONCATENATED_SEGMENTS = c_concat_segs
1990: AND ROUTE_NO <> c_route_no;
1991: --amsriniv. End

Line 2201: SELECT AHL_ROUTES_B_S.NEXTVAL

2197:
2198: BEGIN
2199:
2200: -- Get the Route ID from the Sequence
2201: SELECT AHL_ROUTES_B_S.NEXTVAL
2202: INTO p_x_route_rec.route_id
2203: FROM DUAL;
2204:
2205: --bachandr Enigma Phase I changes -- start

Line 2556: from ahl_routes_b

2552: -- Cursor to get the document_id
2553: cursor get_doc_id
2554: is
2555: select enigma_doc_id
2556: from ahl_routes_b
2557: where route_id = p_route_id;
2558: --bachandr Enigma Phase I changes -- end
2559:
2560: l_dummy VARCHAR2(1);

Line 2670: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting AHL_ROUTES_B and AHL_ROUTES_TL' );

2666: END IF;
2667:
2668:
2669: IF G_DEBUG = 'Y' THEN
2670: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting AHL_ROUTES_B and AHL_ROUTES_TL' );
2671: END IF;
2672:
2673: -- Delete all the associations
2674:

Line 2757: -- Delete the record in AHL_ROUTES_B and AHL_ROUTES_TL

2753: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Access Panels' );
2754: END IF;
2755:
2756: BEGIN
2757: -- Delete the record in AHL_ROUTES_B and AHL_ROUTES_TL
2758: AHL_ROUTES_PKG.delete_row
2759: (
2760: X_ROUTE_ID => p_route_id
2761: );

Line 3105: -- Create copy of the route in AHL_ROUTES_B and AHL_ROUTES_TL

3101: IF ( TRUNC( l_old_route_rec.active_start_date ) < TRUNC( SYSDATE ) ) THEN
3102: l_old_route_rec.active_start_date := SYSDATE;
3103: END IF;
3104:
3105: -- Create copy of the route in AHL_ROUTES_B and AHL_ROUTES_TL
3106: BEGIN
3107:
3108: l_revision_number := l_revision_number + 1;
3109:

Line 3111: SELECT AHL_ROUTES_B_S.NEXTVAL

3107:
3108: l_revision_number := l_revision_number + 1;
3109:
3110: -- Get the Route ID from the Sequence
3111: SELECT AHL_ROUTES_B_S.NEXTVAL
3112: INTO l_route_id
3113: FROM DUAL;
3114:
3115: -- Insert the record