eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_PRSI_API dependencies on HR_API

Line 18: SELECT hr_api.g_update_change_insert update_mode

14: ,p_prsi_details_id in number) RETURN VARCHAR2 IS
15: --
16: --
17: CURSOR prsi_csr IS
18: SELECT hr_api.g_update_change_insert update_mode
19: FROM pay_ie_prsi_details_f
20: WHERE prsi_details_id = p_prsi_details_id
21: AND effective_start_date > p_period_end_date;
22: --

Line 30: l_mode := hr_api.g_update;

26: OPEN prsi_csr;
27: FETCH prsi_csr INTO l_mode;
28: --
29: IF prsi_csr%notfound THEN
30: l_mode := hr_api.g_update;
31: END IF;
32: CLOSE prsi_csr;
33: --
34: RETURN l_mode;

Line 132: when hr_api.cannot_find_prog_unit then

128: ,p_director_flag => p_director_flag
129: ,p_community_flag => p_community_flag
130: );
131: exception
132: when hr_api.cannot_find_prog_unit then
133: hr_api.cannot_find_prog_unit_error
134: (p_module_name => 'create_ie_prsi_details'
135: ,p_hook_type => 'BP'
136: );

Line 133: hr_api.cannot_find_prog_unit_error

129: ,p_community_flag => p_community_flag
130: );
131: exception
132: when hr_api.cannot_find_prog_unit then
133: hr_api.cannot_find_prog_unit_error
134: (p_module_name => 'create_ie_prsi_details'
135: ,p_hook_type => 'BP'
136: );
137: end;

Line 191: ,p_datetrack_mode => hr_api.g_update

187: l_validation_end_date date;
188: BEGIN
189: pay_sid_shd.lck
190: ( p_effective_date => period_rec.end_date+1
191: ,p_datetrack_mode => hr_api.g_update
192: ,p_prsi_details_id => l_prsi_details_id
193: ,p_object_version_number => l_object_version_number
194: ,p_validation_start_date => l_validation_start_date
195: ,p_validation_end_date => l_validation_end_date );

Line 202: ,p_datetrack_mode => hr_api.g_update

198: -- Update prsi details as of the begining of next pay period
199: --
200: pay_sid_upd.upd
201: ( p_effective_date => period_rec.end_date+1
202: ,p_datetrack_mode => hr_api.g_update
203: ,p_prsi_details_id => l_prsi_details_id
204: ,p_object_version_number => l_object_version_number
205: ,p_assignment_id => p_assignment_id
206: ,p_contribution_class => p_contribution_class

Line 253: when hr_api.cannot_find_prog_unit then

249: ,p_effective_start_date => l_effective_start_date
250: ,p_effective_end_date => l_effective_end_date
251: );
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'create_ie_prsi_details'
256: ,p_hook_type => 'AP'
257: );

Line 254: hr_api.cannot_find_prog_unit_error

250: ,p_effective_end_date => l_effective_end_date
251: );
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'create_ie_prsi_details'
256: ,p_hook_type => 'AP'
257: );
258: end;

Line 263: raise hr_api.validate_enabled;

259: --
260: -- When in validation only mode raise the Validate_Enabled exception
261: --
262: if p_validate then
263: raise hr_api.validate_enabled;
264: end if;
265: --
266: -- Set all output arguments
267: --

Line 274: when hr_api.validate_enabled then

270: p_effective_start_date := l_effective_start_date;
271: p_effective_end_date := l_effective_end_Date;
272: --
273: exception
274: when hr_api.validate_enabled then
275: --
276: -- As the Validate_Enabled exception has been raised
277: -- we must rollback to the savepoint
278: --

Line 313: ,p_contribution_class in varchar2 default hr_api.g_varchar2

309: (p_validate in boolean default false
310: ,p_effective_date in date
311: ,p_datetrack_update_mode in varchar2
312: ,p_prsi_details_id in number
313: ,p_contribution_class in varchar2 default hr_api.g_varchar2
314: ,p_overridden_subclass in varchar2 default hr_api.g_varchar2
315: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
316: ,p_soc_ben_start_date in date default hr_api.g_date
317: ,p_overridden_ins_weeks in number default hr_api.g_number

Line 314: ,p_overridden_subclass in varchar2 default hr_api.g_varchar2

310: ,p_effective_date in date
311: ,p_datetrack_update_mode in varchar2
312: ,p_prsi_details_id in number
313: ,p_contribution_class in varchar2 default hr_api.g_varchar2
314: ,p_overridden_subclass in varchar2 default hr_api.g_varchar2
315: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
316: ,p_soc_ben_start_date in date default hr_api.g_date
317: ,p_overridden_ins_weeks in number default hr_api.g_number
318: ,p_non_standard_ins_weeks in number default hr_api.g_number

Line 315: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2

311: ,p_datetrack_update_mode in varchar2
312: ,p_prsi_details_id in number
313: ,p_contribution_class in varchar2 default hr_api.g_varchar2
314: ,p_overridden_subclass in varchar2 default hr_api.g_varchar2
315: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
316: ,p_soc_ben_start_date in date default hr_api.g_date
317: ,p_overridden_ins_weeks in number default hr_api.g_number
318: ,p_non_standard_ins_weeks in number default hr_api.g_number
319: ,p_exemption_start_date in date default hr_api.g_date

Line 316: ,p_soc_ben_start_date in date default hr_api.g_date

312: ,p_prsi_details_id in number
313: ,p_contribution_class in varchar2 default hr_api.g_varchar2
314: ,p_overridden_subclass in varchar2 default hr_api.g_varchar2
315: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
316: ,p_soc_ben_start_date in date default hr_api.g_date
317: ,p_overridden_ins_weeks in number default hr_api.g_number
318: ,p_non_standard_ins_weeks in number default hr_api.g_number
319: ,p_exemption_start_date in date default hr_api.g_date
320: ,p_exemption_end_date in date default hr_api.g_date

Line 317: ,p_overridden_ins_weeks in number default hr_api.g_number

313: ,p_contribution_class in varchar2 default hr_api.g_varchar2
314: ,p_overridden_subclass in varchar2 default hr_api.g_varchar2
315: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
316: ,p_soc_ben_start_date in date default hr_api.g_date
317: ,p_overridden_ins_weeks in number default hr_api.g_number
318: ,p_non_standard_ins_weeks in number default hr_api.g_number
319: ,p_exemption_start_date in date default hr_api.g_date
320: ,p_exemption_end_date in date default hr_api.g_date
321: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2

Line 318: ,p_non_standard_ins_weeks in number default hr_api.g_number

314: ,p_overridden_subclass in varchar2 default hr_api.g_varchar2
315: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
316: ,p_soc_ben_start_date in date default hr_api.g_date
317: ,p_overridden_ins_weeks in number default hr_api.g_number
318: ,p_non_standard_ins_weeks in number default hr_api.g_number
319: ,p_exemption_start_date in date default hr_api.g_date
320: ,p_exemption_end_date in date default hr_api.g_date
321: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
322: ,p_director_flag in varchar2 default hr_api.g_varchar2

Line 319: ,p_exemption_start_date in date default hr_api.g_date

315: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
316: ,p_soc_ben_start_date in date default hr_api.g_date
317: ,p_overridden_ins_weeks in number default hr_api.g_number
318: ,p_non_standard_ins_weeks in number default hr_api.g_number
319: ,p_exemption_start_date in date default hr_api.g_date
320: ,p_exemption_end_date in date default hr_api.g_date
321: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
322: ,p_director_flag in varchar2 default hr_api.g_varchar2
323: ,p_community_flag in varchar2 default hr_api.g_varchar2

Line 320: ,p_exemption_end_date in date default hr_api.g_date

316: ,p_soc_ben_start_date in date default hr_api.g_date
317: ,p_overridden_ins_weeks in number default hr_api.g_number
318: ,p_non_standard_ins_weeks in number default hr_api.g_number
319: ,p_exemption_start_date in date default hr_api.g_date
320: ,p_exemption_end_date in date default hr_api.g_date
321: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
322: ,p_director_flag in varchar2 default hr_api.g_varchar2
323: ,p_community_flag in varchar2 default hr_api.g_varchar2
324: ,p_object_version_number in out nocopy number

Line 321: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2

317: ,p_overridden_ins_weeks in number default hr_api.g_number
318: ,p_non_standard_ins_weeks in number default hr_api.g_number
319: ,p_exemption_start_date in date default hr_api.g_date
320: ,p_exemption_end_date in date default hr_api.g_date
321: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
322: ,p_director_flag in varchar2 default hr_api.g_varchar2
323: ,p_community_flag in varchar2 default hr_api.g_varchar2
324: ,p_object_version_number in out nocopy number
325: ,p_effective_start_date out nocopy date

Line 322: ,p_director_flag in varchar2 default hr_api.g_varchar2

318: ,p_non_standard_ins_weeks in number default hr_api.g_number
319: ,p_exemption_start_date in date default hr_api.g_date
320: ,p_exemption_end_date in date default hr_api.g_date
321: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
322: ,p_director_flag in varchar2 default hr_api.g_varchar2
323: ,p_community_flag in varchar2 default hr_api.g_varchar2
324: ,p_object_version_number in out nocopy number
325: ,p_effective_start_date out nocopy date
326: ,p_effective_end_date out nocopy date

Line 323: ,p_community_flag in varchar2 default hr_api.g_varchar2

319: ,p_exemption_start_date in date default hr_api.g_date
320: ,p_exemption_end_date in date default hr_api.g_date
321: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
322: ,p_director_flag in varchar2 default hr_api.g_varchar2
323: ,p_community_flag in varchar2 default hr_api.g_varchar2
324: ,p_object_version_number in out nocopy number
325: ,p_effective_start_date out nocopy date
326: ,p_effective_end_date out nocopy date
327: ) IS

Line 413: when hr_api.cannot_find_prog_unit then

409: ,p_community_flag => p_community_flag
410: ,p_object_version_number => l_object_version_number
411: );
412: exception
413: when hr_api.cannot_find_prog_unit then
414: hr_api.cannot_find_prog_unit_error
415: (p_module_name => 'update_ie_prsi_details'
416: ,p_hook_type => 'BP'
417: );

Line 414: hr_api.cannot_find_prog_unit_error

410: ,p_object_version_number => l_object_version_number
411: );
412: exception
413: when hr_api.cannot_find_prog_unit then
414: hr_api.cannot_find_prog_unit_error
415: (p_module_name => 'update_ie_prsi_details'
416: ,p_hook_type => 'BP'
417: );
418: end;

Line 543: when hr_api.cannot_find_prog_unit then

539: ,p_effective_start_date => l_effective_start_date
540: ,p_effective_end_date => l_effective_end_date
541: );
542: exception
543: when hr_api.cannot_find_prog_unit then
544: hr_api.cannot_find_prog_unit_error
545: (p_module_name => 'update_ie_prsi_details'
546: ,p_hook_type => 'AP'
547: );

Line 544: hr_api.cannot_find_prog_unit_error

540: ,p_effective_end_date => l_effective_end_date
541: );
542: exception
543: when hr_api.cannot_find_prog_unit then
544: hr_api.cannot_find_prog_unit_error
545: (p_module_name => 'update_ie_prsi_details'
546: ,p_hook_type => 'AP'
547: );
548: end;

Line 553: raise hr_api.validate_enabled;

549: --
550: -- When in validation only mode raise the Validate_Enabled exception
551: --
552: if p_validate then
553: raise hr_api.validate_enabled;
554: end if;
555: --
556: -- Set all output arguments
557: --

Line 563: when hr_api.validate_enabled then

559: p_effective_start_date := l_effective_start_date;
560: p_effective_end_date := l_effective_end_Date;
561: --
562: exception
563: when hr_api.validate_enabled then
564: --
565: -- As the Validate_Enabled exception has been raised
566: -- we must rollback to the savepoint
567: --

Line 658: when hr_api.cannot_find_prog_unit then

654: ,p_prsi_details_id => p_prsi_details_id
655: ,p_object_version_number => l_object_version_number
656: );
657: exception
658: when hr_api.cannot_find_prog_unit then
659: hr_api.cannot_find_prog_unit_error
660: (p_module_name => 'delete_ie_prsi_details'
661: ,p_hook_type => 'BP'
662: );

Line 659: hr_api.cannot_find_prog_unit_error

655: ,p_object_version_number => l_object_version_number
656: );
657: exception
658: when hr_api.cannot_find_prog_unit then
659: hr_api.cannot_find_prog_unit_error
660: (p_module_name => 'delete_ie_prsi_details'
661: ,p_hook_type => 'BP'
662: );
663: end;

Line 692: when hr_api.cannot_find_prog_unit then

688: ,p_effective_start_date => l_effective_start_date
689: ,p_effective_end_date => l_effective_end_date
690: );
691: exception
692: when hr_api.cannot_find_prog_unit then
693: hr_api.cannot_find_prog_unit_error
694: (p_module_name => 'delete_ie_prsi_details'
695: ,p_hook_type => 'AP'
696: );

Line 693: hr_api.cannot_find_prog_unit_error

689: ,p_effective_end_date => l_effective_end_date
690: );
691: exception
692: when hr_api.cannot_find_prog_unit then
693: hr_api.cannot_find_prog_unit_error
694: (p_module_name => 'delete_ie_prsi_details'
695: ,p_hook_type => 'AP'
696: );
697: end;

Line 702: raise hr_api.validate_enabled;

698: --
699: -- When in validation only mode raise the Validate_Enabled exception
700: --
701: if p_validate then
702: raise hr_api.validate_enabled;
703: end if;
704: --
705: -- Set all output arguments
706: --

Line 712: when hr_api.validate_enabled then

708: p_effective_start_date := l_effective_start_date;
709: p_effective_end_date := l_effective_end_Date;
710: --
711: exception
712: when hr_api.validate_enabled then
713: --
714: -- As the Validate_Enabled exception has been raised
715: -- we must rollback to the savepoint
716: --