APPS.PQH_PROCESS_TENURE_STATUS dependencies on HR_API

Line 77: FROM hr_api_transaction_steps s,

73: decode(a.name, 'P_REASON_ADJUSTED' , a.varchar2_value ,null) pei_information5,
74: decode(a.name, 'P_PERSON_EXTRA_INFO_ID' , a.varchar2_value ,null) person_extra_info_id,
75: decode(a.name, 'P_OBJECT_VERSION_NUMBER', a.varchar2_value ,null) object_version_number,
76: decode(a.name, 'P_SUBJECT_TO_QUOTA' , a.varchar2_value ,null) pei_information6
77: FROM hr_api_transaction_steps s,
78: hr_api_transaction_values a
79: WHERE s.transaction_step_id = a.transaction_step_id
80: and s.transaction_step_id = p_transaction_step_id
81: AND s.api_name = 'PQH_PROCESS_TENURE_STATUS.PROCESS_API'

Line 78: hr_api_transaction_values a

74: decode(a.name, 'P_PERSON_EXTRA_INFO_ID' , a.varchar2_value ,null) person_extra_info_id,
75: decode(a.name, 'P_OBJECT_VERSION_NUMBER', a.varchar2_value ,null) object_version_number,
76: decode(a.name, 'P_SUBJECT_TO_QUOTA' , a.varchar2_value ,null) pei_information6
77: FROM hr_api_transaction_steps s,
78: hr_api_transaction_values a
79: WHERE s.transaction_step_id = a.transaction_step_id
80: and s.transaction_step_id = p_transaction_step_id
81: AND s.api_name = 'PQH_PROCESS_TENURE_STATUS.PROCESS_API'
82: )

Line 105: l_api_name hr_api_transaction_steps.api_name%TYPE;

101: ,x_pei_information6 out nocopy varchar2
102: ,x_person_extra_info_id out nocopy varchar2 ) IS
103:
104: l_transaction_step_id number;
105: l_api_name hr_api_transaction_steps.api_name%TYPE;
106:
107: BEGIN
108: hr_utility.set_location('Entering: PQH_PROCESS_TENURE.get_tenure_details',5);
109: --

Line 193: l_api_name constant hr_api_transaction_steps.api_name%TYPE := 'PQH_PROCESS_TENURE_STATUS.PROCESS_API';

189: l_transaction_id number;
190: l_trans_tbl hr_transaction_ss.transaction_table;
191: l_count number;
192: l_transaction_step_id number;
193: l_api_name constant hr_api_transaction_steps.api_name%TYPE := 'PQH_PROCESS_TENURE_STATUS.PROCESS_API';
194: l_result varchar2(100);
195: l_trns_object_version_number number;
196: l_review_proc_call VARCHAR2(30);
197: l_effective_date DATE ;