APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_RESOURCES

Line 2429: p_aso_resource_name IN AHL_RESOURCES.name%TYPE,

2425: PROCEDURE validate_aso_resource
2426: (
2427: x_return_status OUT NOCOPY VARCHAR2,
2428: x_msg_data OUT NOCOPY VARCHAR2,
2429: p_aso_resource_name IN AHL_RESOURCES.name%TYPE,
2430: p_x_aso_resource_id IN OUT NOCOPY AHL_RESOURCES.resource_id%TYPE
2431: )
2432: IS
2433:

Line 2430: p_x_aso_resource_id IN OUT NOCOPY AHL_RESOURCES.resource_id%TYPE

2426: (
2427: x_return_status OUT NOCOPY VARCHAR2,
2428: x_msg_data OUT NOCOPY VARCHAR2,
2429: p_aso_resource_name IN AHL_RESOURCES.name%TYPE,
2430: p_x_aso_resource_id IN OUT NOCOPY AHL_RESOURCES.resource_id%TYPE
2431: )
2432: IS
2433:
2434: l_aso_resource_id AHL_RESOURCES.resource_id%TYPE;

Line 2434: l_aso_resource_id AHL_RESOURCES.resource_id%TYPE;

2430: p_x_aso_resource_id IN OUT NOCOPY AHL_RESOURCES.resource_id%TYPE
2431: )
2432: IS
2433:
2434: l_aso_resource_id AHL_RESOURCES.resource_id%TYPE;
2435:
2436: CURSOR get_rec_from_value ( c_aso_resource_name AHL_RESOURCES.name%TYPE )
2437: IS
2438: SELECT DISTINCT resource_id

Line 2436: CURSOR get_rec_from_value ( c_aso_resource_name AHL_RESOURCES.name%TYPE )

2432: IS
2433:
2434: l_aso_resource_id AHL_RESOURCES.resource_id%TYPE;
2435:
2436: CURSOR get_rec_from_value ( c_aso_resource_name AHL_RESOURCES.name%TYPE )
2437: IS
2438: SELECT DISTINCT resource_id
2439: FROM AHL_RESOURCES
2440: WHERE UPPER(TRIM(name)) = UPPER(TRIM(c_aso_resource_name));

Line 2439: FROM AHL_RESOURCES

2435:
2436: CURSOR get_rec_from_value ( c_aso_resource_name AHL_RESOURCES.name%TYPE )
2437: IS
2438: SELECT DISTINCT resource_id
2439: FROM AHL_RESOURCES
2440: WHERE UPPER(TRIM(name)) = UPPER(TRIM(c_aso_resource_name));
2441:
2442: CURSOR get_rec_from_id ( c_aso_resource_id AHL_RESOURCES.resource_id%TYPE )
2443: IS

Line 2442: CURSOR get_rec_from_id ( c_aso_resource_id AHL_RESOURCES.resource_id%TYPE )

2438: SELECT DISTINCT resource_id
2439: FROM AHL_RESOURCES
2440: WHERE UPPER(TRIM(name)) = UPPER(TRIM(c_aso_resource_name));
2441:
2442: CURSOR get_rec_from_id ( c_aso_resource_id AHL_RESOURCES.resource_id%TYPE )
2443: IS
2444: SELECT DISTINCT resource_id
2445: FROM AHL_RESOURCES
2446: WHERE resource_id = c_aso_resource_id;

Line 2445: FROM AHL_RESOURCES

2441:
2442: CURSOR get_rec_from_id ( c_aso_resource_id AHL_RESOURCES.resource_id%TYPE )
2443: IS
2444: SELECT DISTINCT resource_id
2445: FROM AHL_RESOURCES
2446: WHERE resource_id = c_aso_resource_id;
2447:
2448: BEGIN
2449: x_return_status := FND_API.G_RET_STS_SUCCESS;