APPS.PQH_PROCESS_TENURE_STATUS dependencies on HR_TRANSACTION_API

Line 119: hr_transaction_api.get_varchar2_value

115: end if;
116: --
117:
118: x_pei_information1 :=
119: hr_transaction_api.get_varchar2_value
120: (p_transaction_step_id => l_transaction_step_id
121: ,p_name => 'P_TENURE_STATUS');
122: --
123: x_pei_information2 :=

Line 125: hr_transaction_api.get_varchar2_value

121: ,p_name => 'P_TENURE_STATUS');
122: --
123: x_pei_information2 :=
124: REPLACE(SUBSTR(
125: hr_transaction_api.get_varchar2_value
126: (p_transaction_step_id => l_transaction_step_id
127: ,p_name => 'P_DATE_DETERMINE')
128: ,1,10),'/','-');
129: --

Line 132: hr_transaction_api.get_varchar2_value

128: ,1,10),'/','-');
129: --
130: x_pei_information3 :=
131: REPLACE(SUBSTR(
132: hr_transaction_api.get_varchar2_value
133: (p_transaction_step_id => l_transaction_step_id
134: ,p_name => 'P_PROJECTED_TENURE_DATE')
135: ,1,10),'/','-');
136: --

Line 139: hr_transaction_api.get_varchar2_value

135: ,1,10),'/','-');
136: --
137: x_pei_information4 :=
138: REPLACE(SUBSTR(
139: hr_transaction_api.get_varchar2_value
140: (p_transaction_step_id => l_transaction_step_id
141: ,p_name => 'P_ADJUSTED_DATE')
142: ,1,10),'/','-');
143: --

Line 145: hr_transaction_api.get_varchar2_value

141: ,p_name => 'P_ADJUSTED_DATE')
142: ,1,10),'/','-');
143: --
144: x_pei_information5 :=
145: hr_transaction_api.get_varchar2_value
146: (p_transaction_step_id => l_transaction_step_id
147: ,p_name => 'P_REASON_ADJUSTED');
148: --
149: x_pei_information6 :=

Line 150: hr_transaction_api.get_varchar2_value

146: (p_transaction_step_id => l_transaction_step_id
147: ,p_name => 'P_REASON_ADJUSTED');
148: --
149: x_pei_information6 :=
150: hr_transaction_api.get_varchar2_value
151: (p_transaction_step_id => l_transaction_step_id
152: ,p_name => 'P_SUBJECT_TO_QUOTA');
153: --
154: x_person_extra_info_id :=

Line 155: hr_transaction_api.get_varchar2_value

151: (p_transaction_step_id => l_transaction_step_id
152: ,p_name => 'P_SUBJECT_TO_QUOTA');
153: --
154: x_person_extra_info_id :=
155: hr_transaction_api.get_varchar2_value
156: (p_transaction_step_id => l_transaction_step_id
157: ,p_name => 'P_PERSON_EXTRA_INFO_ID');
158: --
159: hr_utility.set_location('Leaving: PQH_PROCESS_TENURE.get_tenure_details',10);

Line 204: hr_transaction_api.get_transaction_step_info

200: hr_utility.set_location('Entering: PQH_PROCESS_TENURE.set_tenure_details',5);
201: l_review_proc_call := 'PqhTenureStatusReview';
202: l_effective_date := SYSDATE;
203: --
204: hr_transaction_api.get_transaction_step_info
205: (p_item_type => x_item_type
206: ,p_item_key => x_item_key
207: ,p_activity_id => x_activity_id
208: ,p_transaction_step_id => l_transaction_step_id

Line 317: l_person_id := hr_transaction_api.get_varchar2_value (

313: ,x_pei_information5 => l_pei_information5
314: ,x_pei_information6 => l_pei_information6
315: ,x_person_extra_info_id => l_person_extra_info_id);
316:
317: l_person_id := hr_transaction_api.get_varchar2_value (
318: p_transaction_step_id => p_transaction_step_id,
319: p_name => 'P_PERSON_ID');
320: --
321: --

Line 322: l_ovn := hr_transaction_api.get_varchar2_value (

318: p_transaction_step_id => p_transaction_step_id,
319: p_name => 'P_PERSON_ID');
320: --
321: --
322: l_ovn := hr_transaction_api.get_varchar2_value (
323: p_transaction_step_id => p_transaction_step_id,
324: p_name => 'P_OBJECT_VERSION_NUMBER');
325: --
326: