APPS.PQH_PROCESS_ACADEMIC_RANK dependencies on HR_TRANSACTION_API

Line 80: hr_transaction_api.get_varchar2_value

76: end if;
77: --
78:
79: x_pei_information1 :=
80: hr_transaction_api.get_varchar2_value
81: (p_transaction_step_id => l_transaction_step_id
82: ,p_name => 'P_ACADEMIC_RANK');
83: --
84: x_pei_information2 :=

Line 86: hr_transaction_api.get_varchar2_value

82: ,p_name => 'P_ACADEMIC_RANK');
83: --
84: x_pei_information2 :=
85: REPLACE(SUBSTR(
86: hr_transaction_api.get_varchar2_value
87: (p_transaction_step_id => l_transaction_step_id
88: ,p_name => 'P_EFFECTIVE_START_DATE')
89: ,1,10),'/','-');
90: --

Line 93: hr_transaction_api.get_varchar2_value

89: ,1,10),'/','-');
90: --
91: x_pei_information3 :=
92: REPLACE(SUBSTR(
93: hr_transaction_api.get_varchar2_value
94: (p_transaction_step_id => l_transaction_step_id
95: ,p_name => 'P_EFFECTIVE_END_DATE')
96: ,1,10),'/','-');
97: --

Line 99: hr_transaction_api.get_varchar2_value

95: ,p_name => 'P_EFFECTIVE_END_DATE')
96: ,1,10),'/','-');
97: --
98: x_pei_information4 :=
99: hr_transaction_api.get_varchar2_value
100: (p_transaction_step_id => l_transaction_step_id
101: ,p_name => 'P_NEXT_ACADEMIC_RANK');
102: --
103: x_pei_information5 :=

Line 105: hr_transaction_api.get_varchar2_value

101: ,p_name => 'P_NEXT_ACADEMIC_RANK');
102: --
103: x_pei_information5 :=
104: REPLACE(SUBSTR(
105: hr_transaction_api.get_varchar2_value
106: (p_transaction_step_id => l_transaction_step_id
107: ,p_name => 'P_PROJECTED_DATE')
108: ,1,10),'/','-');
109: --

Line 111: hr_transaction_api.get_varchar2_value

107: ,p_name => 'P_PROJECTED_DATE')
108: ,1,10),'/','-');
109: --
110: x_person_extra_info_id :=
111: hr_transaction_api.get_varchar2_value
112: (p_transaction_step_id => l_transaction_step_id
113: ,p_name => 'P_PERSON_EXTRA_INFO_ID');
114: --
115: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.get_academic_rank_details',5);

Line 159: hr_transaction_api.get_transaction_step_info

155: hr_utility.set_location('Entering: PQH_PROCESS_ACADEMIC_RANK.set_academic_rank_details',5);
156: l_review_proc_call := 'PqhAcademicRankReview';
157: l_effective_date := SYSDATE;
158: --
159: hr_transaction_api.get_transaction_step_info
160: (p_item_type => x_item_type
161: ,p_item_key => x_item_key
162: ,p_activity_id => x_activity_id
163: ,p_transaction_step_id => l_transaction_step_id

Line 265: l_person_id := hr_transaction_api.get_varchar2_value (

261: ,x_pei_information4 => l_pei_information4
262: ,x_pei_information5 => l_pei_information5
263: ,x_person_extra_info_id => l_person_extra_info_id);
264:
265: l_person_id := hr_transaction_api.get_varchar2_value (
266: p_transaction_step_id => p_transaction_step_id,
267: p_name => 'P_PERSON_ID');
268: --
269: l_ovn := hr_transaction_api.get_number_value (

Line 269: l_ovn := hr_transaction_api.get_number_value (

265: l_person_id := hr_transaction_api.get_varchar2_value (
266: p_transaction_step_id => p_transaction_step_id,
267: p_name => 'P_PERSON_ID');
268: --
269: l_ovn := hr_transaction_api.get_number_value (
270: p_transaction_step_id => p_transaction_step_id,
271: p_name => 'P_OBJECT_VERSION_NUMBER');
272: --
273: IF l_pei_information2 IS NOT NULL THEN