APPS.AHL_RM_ROUTE_UTIL dependencies on PER_QUALIFICATION_TYPES

Line 2999: p_qualification_type IN PER_QUALIFICATION_TYPES.name%TYPE,

2995: PROCEDURE validate_qualification_type
2996: (
2997: x_return_status OUT NOCOPY VARCHAR2,
2998: x_msg_data OUT NOCOPY VARCHAR2,
2999: p_qualification_type IN PER_QUALIFICATION_TYPES.name%TYPE,
3000: p_x_qualification_type_id IN OUT NOCOPY PER_QUALIFICATION_TYPES.qualification_type_id%TYPE
3001: )
3002: IS
3003:

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

2996: (
2997: x_return_status OUT NOCOPY VARCHAR2,
2998: x_msg_data OUT NOCOPY VARCHAR2,
2999: p_qualification_type IN PER_QUALIFICATION_TYPES.name%TYPE,
3000: p_x_qualification_type_id IN OUT NOCOPY PER_QUALIFICATION_TYPES.qualification_type_id%TYPE
3001: )
3002: IS
3003:
3004: l_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE;

Line 3004: l_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE;

3000: p_x_qualification_type_id IN OUT NOCOPY PER_QUALIFICATION_TYPES.qualification_type_id%TYPE
3001: )
3002: IS
3003:
3004: l_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE;
3005:
3006: CURSOR get_rec_from_value ( c_qualification_type PER_QUALIFICATION_TYPES.name%TYPE )
3007: IS
3008: SELECT DISTINCT qualification_type_id

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

3002: IS
3003:
3004: l_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE;
3005:
3006: CURSOR get_rec_from_value ( c_qualification_type PER_QUALIFICATION_TYPES.name%TYPE )
3007: IS
3008: SELECT DISTINCT qualification_type_id
3009: FROM PER_QUALIFICATION_TYPES
3010: WHERE name = c_qualification_type;

Line 3009: FROM PER_QUALIFICATION_TYPES

3005:
3006: CURSOR get_rec_from_value ( c_qualification_type PER_QUALIFICATION_TYPES.name%TYPE )
3007: IS
3008: SELECT DISTINCT qualification_type_id
3009: FROM PER_QUALIFICATION_TYPES
3010: WHERE name = c_qualification_type;
3011:
3012: CURSOR get_rec_from_id ( c_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE )
3013: IS

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

3008: SELECT DISTINCT qualification_type_id
3009: FROM PER_QUALIFICATION_TYPES
3010: WHERE name = c_qualification_type;
3011:
3012: CURSOR get_rec_from_id ( c_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE )
3013: IS
3014: SELECT DISTINCT qualification_type_id
3015: FROM PER_QUALIFICATION_TYPES
3016: WHERE qualification_type_id = c_qualification_type_id;

Line 3015: FROM PER_QUALIFICATION_TYPES

3011:
3012: CURSOR get_rec_from_id ( c_qualification_type_id PER_QUALIFICATION_TYPES.qualification_type_id%TYPE )
3013: IS
3014: SELECT DISTINCT qualification_type_id
3015: FROM PER_QUALIFICATION_TYPES
3016: WHERE qualification_type_id = c_qualification_type_id;
3017:
3018: BEGIN
3019: x_return_status := FND_API.G_RET_STS_SUCCESS;