APPS.PQH_GSP_STAGE_TO_BEN dependencies on HR_API

Line 82: ,p_datetrack_mode => hr_api.g_delete

78: ,p_effective_start_date => l_esd
79: ,p_effective_end_date => l_eed
80: ,p_object_version_number => l_ovn
81: ,p_effective_date => p_effective_date
82: ,p_datetrack_mode => hr_api.g_delete
83: );
84: elsif p_crit_type ='PR' then
85: select elig_perf_rtng_prte_id,object_version_number
86: into l_pk,l_ovn

Line 98: ,p_datetrack_mode => hr_api.g_delete

94: ,p_effective_start_date => l_esd
95: ,p_effective_end_date => l_eed
96: ,p_object_version_number => l_ovn
97: ,p_effective_date => p_effective_date
98: ,p_datetrack_mode => hr_api.g_delete
99: );
100: elsif p_crit_type ='PT' then
101: select elig_per_typ_prte_id,object_version_number
102: into l_pk,l_ovn

Line 114: ,p_datetrack_mode => hr_api.g_delete

110: ,p_effective_start_date => l_esd
111: ,p_effective_end_date => l_eed
112: ,p_object_version_number => l_ovn
113: ,p_effective_date => p_effective_date
114: ,p_datetrack_mode => hr_api.g_delete
115: );
116: elsif p_crit_type ='FP' then
117: select elig_fl_tm_pt_tm_prte_id,object_version_number
118: into l_pk,l_ovn

Line 130: ,p_datetrack_mode => hr_api.g_delete

126: ,p_effective_start_date => l_esd
127: ,p_effective_end_date => l_eed
128: ,p_object_version_number => l_ovn
129: ,p_effective_date => p_effective_date
130: ,p_datetrack_mode => hr_api.g_delete
131: );
132: elsif p_crit_type ='BU' then
133: select elig_brgng_unit_prte_id,object_version_number
134: into l_pk,l_ovn

Line 146: ,p_datetrack_mode => hr_api.g_delete

142: ,p_effective_start_date => l_esd
143: ,p_effective_end_date => l_eed
144: ,p_object_version_number => l_ovn
145: ,p_effective_date => p_effective_date
146: ,p_datetrack_mode => hr_api.g_delete
147: );
148: elsif p_crit_type ='SA' then
149: select elig_svc_area_prte_id,object_version_number
150: into l_pk,l_ovn

Line 162: ,p_datetrack_mode => hr_api.g_delete

158: ,p_effective_start_date => l_esd
159: ,p_effective_end_date => l_eed
160: ,p_object_version_number => l_ovn
161: ,p_effective_date => p_effective_date
162: ,p_datetrack_mode => hr_api.g_delete
163: );
164: elsif p_crit_type ='LOC' then
165: select elig_wk_loc_prte_id,object_version_number
166: into l_pk,l_ovn

Line 178: ,p_datetrack_mode => hr_api.g_delete

174: ,p_effective_start_date => l_esd
175: ,p_effective_end_date => l_eed
176: ,p_object_version_number => l_ovn
177: ,p_effective_date => p_effective_date
178: ,p_datetrack_mode => hr_api.g_delete
179: );
180: elsif p_crit_type ='ORG' then
181: select elig_org_unit_prte_id,object_version_number
182: into l_pk,l_ovn

Line 194: ,p_datetrack_mode => hr_api.g_delete

190: ,p_effective_start_date => l_esd
191: ,p_effective_end_date => l_eed
192: ,p_object_version_number => l_ovn
193: ,p_effective_date => p_effective_date
194: ,p_datetrack_mode => hr_api.g_delete
195: );
196: elsif p_crit_type ='JOB' then
197: select elig_job_prte_id,object_version_number
198: into l_pk,l_ovn

Line 210: ,p_datetrack_mode => hr_api.g_delete

206: ,p_effective_start_date => l_esd
207: ,p_effective_end_date => l_eed
208: ,p_object_version_number => l_ovn
209: ,p_effective_date => p_effective_date
210: ,p_datetrack_mode => hr_api.g_delete
211: );
212: else
213: hr_utility.set_location('invalid crit passed',100);
214: end if;