eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RM_ROUTE_UTIL dependencies on PER_QUALIFICATION_TYPES

Line 3131: p_qualification_type IN PER_QUALIFICATION_TYPES.name%TYPE,

3127: PROCEDURE validate_qualification_type
3128: (
3129: x_return_status OUT NOCOPY VARCHAR2,
3130: x_msg_data OUT NOCOPY VARCHAR2,
3131: p_qualification_type IN PER_QUALIFICATION_TYPES.name%TYPE,
3132: p_x_qualification_type_id IN OUT NOCOPY PER_QUALIFICATION_TYPES.qualification_type_id%TYPE
3133: )
3134: IS
3135:

Line 3132: p_x_qualification_type_id IN OUT NOCOPY PER_QUALIFICATION_TYPES.qualification_type_id%TYPE

3128: (
3129: x_return_status OUT NOCOPY VARCHAR2,
3130: x_msg_data OUT NOCOPY VARCHAR2,
3131: p_qualification_type IN PER_QUALIFICATION_TYPES.name%TYPE,
3132: p_x_qualification_type_id IN OUT NOCOPY PER_QUALIFICATION_TYPES.qualification_type_id%TYPE
3133: )
3134: IS
3135:
3136: l_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE;

Line 3136: l_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE;

3132: p_x_qualification_type_id IN OUT NOCOPY PER_QUALIFICATION_TYPES.qualification_type_id%TYPE
3133: )
3134: IS
3135:
3136: l_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE;
3137:
3138: CURSOR get_rec_from_value ( c_qualification_type PER_QUALIFICATION_TYPES.name%TYPE )
3139: IS
3140: SELECT DISTINCT qualification_type_id

Line 3138: CURSOR get_rec_from_value ( c_qualification_type PER_QUALIFICATION_TYPES.name%TYPE )

3134: IS
3135:
3136: l_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE;
3137:
3138: CURSOR get_rec_from_value ( c_qualification_type PER_QUALIFICATION_TYPES.name%TYPE )
3139: IS
3140: SELECT DISTINCT qualification_type_id
3141: FROM PER_QUALIFICATION_TYPES
3142: WHERE name = c_qualification_type;

Line 3141: FROM PER_QUALIFICATION_TYPES

3137:
3138: CURSOR get_rec_from_value ( c_qualification_type PER_QUALIFICATION_TYPES.name%TYPE )
3139: IS
3140: SELECT DISTINCT qualification_type_id
3141: FROM PER_QUALIFICATION_TYPES
3142: WHERE name = c_qualification_type;
3143:
3144: CURSOR get_rec_from_id ( c_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE )
3145: IS

Line 3144: CURSOR get_rec_from_id ( c_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE )

3140: SELECT DISTINCT qualification_type_id
3141: FROM PER_QUALIFICATION_TYPES
3142: WHERE name = c_qualification_type;
3143:
3144: CURSOR get_rec_from_id ( c_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE )
3145: IS
3146: SELECT DISTINCT qualification_type_id
3147: FROM PER_QUALIFICATION_TYPES
3148: WHERE qualification_type_id = c_qualification_type_id;

Line 3147: FROM PER_QUALIFICATION_TYPES

3143:
3144: CURSOR get_rec_from_id ( c_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE )
3145: IS
3146: SELECT DISTINCT qualification_type_id
3147: FROM PER_QUALIFICATION_TYPES
3148: WHERE qualification_type_id = c_qualification_type_id;
3149:
3150: BEGIN
3151: x_return_status := FND_API.G_RET_STS_SUCCESS;