APPS.PQH_PROCESS_ACADEMIC_RANK dependencies on HR_API

Line 41: FROM hr_api_transaction_steps s,

37: decode(a.name, 'P_PERSON_EXTRA_INFO_ID' , a.varchar2_value ,null) person_extra_info_id,
38: -- Bug# 5415237
39: -- Replaced a.varchar2_value with a.number_value.
40: decode(a.name, 'P_OBJECT_VERSION_NUMBER', a.number_value ,null) object_version_number
41: FROM hr_api_transaction_steps s,
42: hr_api_transaction_values a
43: WHERE s.transaction_step_id = a.transaction_step_id
44: and s.transaction_step_id = p_transaction_step_id
45: AND s.api_name = 'PQH_PROCESS_ACADEMIC_RANK.PROCESS_API'

Line 42: hr_api_transaction_values a

38: -- Bug# 5415237
39: -- Replaced a.varchar2_value with a.number_value.
40: decode(a.name, 'P_OBJECT_VERSION_NUMBER', a.number_value ,null) object_version_number
41: FROM hr_api_transaction_steps s,
42: hr_api_transaction_values a
43: WHERE s.transaction_step_id = a.transaction_step_id
44: and s.transaction_step_id = p_transaction_step_id
45: AND s.api_name = 'PQH_PROCESS_ACADEMIC_RANK.PROCESS_API'
46: )

Line 66: l_api_name hr_api_transaction_steps.api_name%TYPE;

62: ,x_pei_information5 out nocopy varchar2
63: ,x_person_extra_info_id out nocopy varchar2 ) IS
64:
65: l_transaction_step_id number;
66: l_api_name hr_api_transaction_steps.api_name%TYPE;
67:
68: BEGIN
69: hr_utility.set_location('Entering: PQH_PROCESS_ACADEMIC_RANK.get_academic_rank_details',5);
70: --

Line 148: l_api_name constant hr_api_transaction_steps.api_name%TYPE := 'PQH_PROCESS_ACADEMIC_RANK.PROCESS_API';

144: l_transaction_id number;
145: l_trans_tbl hr_transaction_ss.transaction_table;
146: l_count number;
147: l_transaction_step_id number;
148: l_api_name constant hr_api_transaction_steps.api_name%TYPE := 'PQH_PROCESS_ACADEMIC_RANK.PROCESS_API';
149: l_result varchar2(100);
150: l_trns_object_version_number number;
151: l_review_proc_call VARCHAR2(30);
152: l_effective_date DATE ;