APPS.AHL_RM_ROUTE_PVT dependencies on AHL_ROUTES_B

Line 2205: FROM AHL_ROUTES_B_KFV

2201:
2202: CURSOR get_concat_segs(c_route_id NUMBER)
2203: IS
2204: SELECT CONCATENATED_SEGMENTS
2205: FROM AHL_ROUTES_B_KFV
2206: WHERE ROUTE_ID = p_x_route_rec.route_id
2207: AND REPLACE(CONCATENATED_SEGMENTS, FND_FLEX_EXT.GET_DELIMITER('AHL', 'AHLR', 101), NULL) IS NOT NULL;
2208:
2209:

Line 2214: FROM AHL_ROUTES_B_KFV

2210: --validate system KFV to ensure that no two routes share the same System KFV.
2211: CURSOR validate_system_kfv(c_route_no VARCHAR2, c_concat_segs VARCHAR2)
2212: IS
2213: SELECT 'X'
2214: FROM AHL_ROUTES_B_KFV
2215: WHERE REPLACE(CONCATENATED_SEGMENTS, FND_FLEX_EXT.GET_DELIMITER('AHL', 'AHLR', 101), NULL) IS NOT NULL
2216: AND CONCATENATED_SEGMENTS = c_concat_segs
2217: AND ROUTE_NO <> c_route_no;
2218: --amsriniv. End

Line 2224: FROM ahl_routes_b

2220: --Enigma Phase II changes Start
2221: CURSOR get_enigma_route_id(c_route_id NUMBER)
2222: IS
2223: SELECT enigma_route_id
2224: FROM ahl_routes_b
2225: WHERE route_id = c_route_id;
2226: --Enigma Phase II changes End
2227:
2228:

Line 2311: UPDATE ahl_routes_b

2307: IF G_DEBUG = 'Y' THEN
2308: AHL_DEBUG_PUB.debug('DML : N ' || ' ' || p_x_route_rec.enigma_source_code );
2309: END IF;
2310: IF(p_x_route_rec.enigma_source_code = 'AUTOMATIC') THEN
2311: UPDATE ahl_routes_b
2312: set file_id = p_x_route_rec.file_id
2313: where route_id = p_x_route_rec.route_id;
2314: END IF ;
2315: IF FND_API.to_boolean( p_commit ) THEN

Line 2501: SELECT AHL_ROUTES_B_S.NEXTVAL

2497:
2498: BEGIN
2499:
2500: -- Get the Route ID from the Sequence
2501: SELECT AHL_ROUTES_B_S.NEXTVAL
2502: INTO p_x_route_rec.route_id
2503: FROM DUAL;
2504:
2505: --bachandr Enigma Phase I changes -- start

Line 2876: from ahl_routes_b

2872: --Enigma Phase II chanes --distinction between Automatic enigma routes and other routes is made on enigma rotue id
2873: cursor get_enigma_route_id
2874: is
2875: select enigma_route_id
2876: from ahl_routes_b
2877: where route_id = p_route_id;
2878: --snarkhed Enigma Phase II changes end
2879: --bachandr Enigma Phase I changes -- end
2880:

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

2997: END IF;
2998:
2999:
3000: IF G_DEBUG = 'Y' THEN
3001: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting AHL_ROUTES_B and AHL_ROUTES_TL' );
3002: END IF;
3003:
3004: -- Delete all the associations
3005:

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

3084: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Access Panels' );
3085: END IF;
3086:
3087: BEGIN
3088: -- Delete the record in AHL_ROUTES_B and AHL_ROUTES_TL
3089: AHL_ROUTES_PKG.delete_row
3090: (
3091: X_ROUTE_ID => p_route_id
3092: );

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

3509: IF ( TRUNC( l_old_route_rec.active_start_date ) < TRUNC( SYSDATE ) ) THEN
3510: l_old_route_rec.active_start_date := SYSDATE;
3511: END IF;
3512:
3513: -- Create copy of the route in AHL_ROUTES_B and AHL_ROUTES_TL
3514: BEGIN
3515:
3516: l_revision_number := l_revision_number + 1;
3517:

Line 3519: SELECT AHL_ROUTES_B_S.NEXTVAL

3515:
3516: l_revision_number := l_revision_number + 1;
3517:
3518: -- Get the Route ID from the Sequence
3519: SELECT AHL_ROUTES_B_S.NEXTVAL
3520: INTO l_route_id
3521: FROM DUAL;
3522:
3523: -- Insert the record