APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_RESOURCES

Line 2561: p_aso_resource_name IN AHL_RESOURCES.name%TYPE,

2557: PROCEDURE validate_aso_resource
2558: (
2559: x_return_status OUT NOCOPY VARCHAR2,
2560: x_msg_data OUT NOCOPY VARCHAR2,
2561: p_aso_resource_name IN AHL_RESOURCES.name%TYPE,
2562: p_x_aso_resource_id IN OUT NOCOPY AHL_RESOURCES.resource_id%TYPE
2563: )
2564: IS
2565:

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

2558: (
2559: x_return_status OUT NOCOPY VARCHAR2,
2560: x_msg_data OUT NOCOPY VARCHAR2,
2561: p_aso_resource_name IN AHL_RESOURCES.name%TYPE,
2562: p_x_aso_resource_id IN OUT NOCOPY AHL_RESOURCES.resource_id%TYPE
2563: )
2564: IS
2565:
2566: l_aso_resource_id AHL_RESOURCES.resource_id%TYPE;

Line 2566: l_aso_resource_id AHL_RESOURCES.resource_id%TYPE;

2562: p_x_aso_resource_id IN OUT NOCOPY AHL_RESOURCES.resource_id%TYPE
2563: )
2564: IS
2565:
2566: l_aso_resource_id AHL_RESOURCES.resource_id%TYPE;
2567:
2568: CURSOR get_rec_from_value ( c_aso_resource_name AHL_RESOURCES.name%TYPE )
2569: IS
2570: SELECT DISTINCT resource_id

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

2564: IS
2565:
2566: l_aso_resource_id AHL_RESOURCES.resource_id%TYPE;
2567:
2568: CURSOR get_rec_from_value ( c_aso_resource_name AHL_RESOURCES.name%TYPE )
2569: IS
2570: SELECT DISTINCT resource_id
2571: FROM AHL_RESOURCES
2572: WHERE UPPER(TRIM(name)) = UPPER(TRIM(c_aso_resource_name));

Line 2571: FROM AHL_RESOURCES

2567:
2568: CURSOR get_rec_from_value ( c_aso_resource_name AHL_RESOURCES.name%TYPE )
2569: IS
2570: SELECT DISTINCT resource_id
2571: FROM AHL_RESOURCES
2572: WHERE UPPER(TRIM(name)) = UPPER(TRIM(c_aso_resource_name));
2573:
2574: CURSOR get_rec_from_id ( c_aso_resource_id AHL_RESOURCES.resource_id%TYPE )
2575: IS

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

2570: SELECT DISTINCT resource_id
2571: FROM AHL_RESOURCES
2572: WHERE UPPER(TRIM(name)) = UPPER(TRIM(c_aso_resource_name));
2573:
2574: CURSOR get_rec_from_id ( c_aso_resource_id AHL_RESOURCES.resource_id%TYPE )
2575: IS
2576: SELECT DISTINCT resource_id
2577: FROM AHL_RESOURCES
2578: WHERE resource_id = c_aso_resource_id;

Line 2577: FROM AHL_RESOURCES

2573:
2574: CURSOR get_rec_from_id ( c_aso_resource_id AHL_RESOURCES.resource_id%TYPE )
2575: IS
2576: SELECT DISTINCT resource_id
2577: FROM AHL_RESOURCES
2578: WHERE resource_id = c_aso_resource_id;
2579:
2580: BEGIN
2581: x_return_status := FND_API.G_RET_STS_SUCCESS;