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_PGA_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 112: When hr_api.check_integrity_violated Then

108: End If;
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 15);
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: --
115: pay_pga_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: --
115: pay_pga_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: pay_pga_shd.constraint_error

Line 117: When hr_api.unique_integrity_violated Then

113: -- A check constraint has been violated
114: --
115: pay_pga_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: pay_pga_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: pay_pga_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: --
124: Raise;
125: End dt_update_dml;

Line 238: If (p_datetrack_mode <> hr_api.g_correction) then

234: l_dummy_version_number number;
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: If (p_datetrack_mode <> hr_api.g_correction) then
239: --
240: -- Update the current effective end date
241: --
242: pay_pga_shd.upd_effective_end_date

Line 251: If (p_datetrack_mode = hr_api.g_update_override) then

247: ,p_validation_end_date => p_validation_end_date
248: ,p_object_version_number => l_dummy_version_number
249: );
250: --
251: If (p_datetrack_mode = hr_api.g_update_override) then
252: --
253: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
254: -- delete any future rows
255: --

Line 443: If (p_rec.set_of_books_id = hr_api.g_number) then

439: -- p_rec plsql record structure
440: -- to see if a system default is being used. If a system default
441: -- is being used then we must set to the 'current' argument value.
442: --
443: If (p_rec.set_of_books_id = hr_api.g_number) then
444: p_rec.set_of_books_id :=
445: pay_pga_shd.g_old_rec.set_of_books_id;
446: End If;
447: If (p_rec.gl_cash_ac_id = hr_api.g_number) then

Line 447: If (p_rec.gl_cash_ac_id = hr_api.g_number) then

443: If (p_rec.set_of_books_id = hr_api.g_number) then
444: p_rec.set_of_books_id :=
445: pay_pga_shd.g_old_rec.set_of_books_id;
446: End If;
447: If (p_rec.gl_cash_ac_id = hr_api.g_number) then
448: p_rec.gl_cash_ac_id :=
449: pay_pga_shd.g_old_rec.gl_cash_ac_id;
450: End If;
451: If (p_rec.gl_cash_clearing_ac_id = hr_api.g_number) then

Line 451: If (p_rec.gl_cash_clearing_ac_id = hr_api.g_number) then

447: If (p_rec.gl_cash_ac_id = hr_api.g_number) then
448: p_rec.gl_cash_ac_id :=
449: pay_pga_shd.g_old_rec.gl_cash_ac_id;
450: End If;
451: If (p_rec.gl_cash_clearing_ac_id = hr_api.g_number) then
452: p_rec.gl_cash_clearing_ac_id :=
453: pay_pga_shd.g_old_rec.gl_cash_clearing_ac_id;
454: End If;
455: If (p_rec.gl_control_ac_id = hr_api.g_number) then

Line 455: If (p_rec.gl_control_ac_id = hr_api.g_number) then

451: If (p_rec.gl_cash_clearing_ac_id = hr_api.g_number) then
452: p_rec.gl_cash_clearing_ac_id :=
453: pay_pga_shd.g_old_rec.gl_cash_clearing_ac_id;
454: End If;
455: If (p_rec.gl_control_ac_id = hr_api.g_number) then
456: p_rec.gl_control_ac_id :=
457: pay_pga_shd.g_old_rec.gl_control_ac_id;
458: End If;
459: If (p_rec.gl_error_ac_id = hr_api.g_number) then

Line 459: If (p_rec.gl_error_ac_id = hr_api.g_number) then

455: If (p_rec.gl_control_ac_id = hr_api.g_number) then
456: p_rec.gl_control_ac_id :=
457: pay_pga_shd.g_old_rec.gl_control_ac_id;
458: End If;
459: If (p_rec.gl_error_ac_id = hr_api.g_number) then
460: p_rec.gl_error_ac_id :=
461: pay_pga_shd.g_old_rec.gl_error_ac_id;
462: End If;
463: If (p_rec.external_account_id = hr_api.g_number) then

Line 463: If (p_rec.external_account_id = hr_api.g_number) then

459: If (p_rec.gl_error_ac_id = hr_api.g_number) then
460: p_rec.gl_error_ac_id :=
461: pay_pga_shd.g_old_rec.gl_error_ac_id;
462: End If;
463: If (p_rec.external_account_id = hr_api.g_number) then
464: p_rec.external_account_id :=
465: pay_pga_shd.g_old_rec.external_account_id;
466: End If;
467: If (p_rec.org_payment_method_id = hr_api.g_number) then

Line 467: If (p_rec.org_payment_method_id = hr_api.g_number) then

463: If (p_rec.external_account_id = hr_api.g_number) then
464: p_rec.external_account_id :=
465: pay_pga_shd.g_old_rec.external_account_id;
466: End If;
467: If (p_rec.org_payment_method_id = hr_api.g_number) then
468: p_rec.org_payment_method_id :=
469: pay_pga_shd.g_old_rec.org_payment_method_id;
470: End If;
471: --

Line 566: ,p_set_of_books_id in number default hr_api.g_number

562: (p_effective_date in date
563: ,p_datetrack_mode in varchar2
564: ,p_pay_gl_account_id in number
565: ,p_object_version_number in out nocopy number
566: ,p_set_of_books_id in number default hr_api.g_number
567: ,p_gl_cash_ac_id in number default hr_api.g_number
568: ,p_gl_cash_clearing_ac_id in number default hr_api.g_number
569: ,p_gl_control_ac_id in number default hr_api.g_number
570: ,p_gl_error_ac_id in number default hr_api.g_number

Line 567: ,p_gl_cash_ac_id in number default hr_api.g_number

563: ,p_datetrack_mode in varchar2
564: ,p_pay_gl_account_id in number
565: ,p_object_version_number in out nocopy number
566: ,p_set_of_books_id in number default hr_api.g_number
567: ,p_gl_cash_ac_id in number default hr_api.g_number
568: ,p_gl_cash_clearing_ac_id in number default hr_api.g_number
569: ,p_gl_control_ac_id in number default hr_api.g_number
570: ,p_gl_error_ac_id in number default hr_api.g_number
571: ,p_external_account_id in number default hr_api.g_number

Line 568: ,p_gl_cash_clearing_ac_id in number default hr_api.g_number

564: ,p_pay_gl_account_id in number
565: ,p_object_version_number in out nocopy number
566: ,p_set_of_books_id in number default hr_api.g_number
567: ,p_gl_cash_ac_id in number default hr_api.g_number
568: ,p_gl_cash_clearing_ac_id in number default hr_api.g_number
569: ,p_gl_control_ac_id in number default hr_api.g_number
570: ,p_gl_error_ac_id in number default hr_api.g_number
571: ,p_external_account_id in number default hr_api.g_number
572: ,p_org_payment_method_id in number default hr_api.g_number

Line 569: ,p_gl_control_ac_id in number default hr_api.g_number

565: ,p_object_version_number in out nocopy number
566: ,p_set_of_books_id in number default hr_api.g_number
567: ,p_gl_cash_ac_id in number default hr_api.g_number
568: ,p_gl_cash_clearing_ac_id in number default hr_api.g_number
569: ,p_gl_control_ac_id in number default hr_api.g_number
570: ,p_gl_error_ac_id in number default hr_api.g_number
571: ,p_external_account_id in number default hr_api.g_number
572: ,p_org_payment_method_id in number default hr_api.g_number
573: ,p_effective_start_date out nocopy date

Line 570: ,p_gl_error_ac_id in number default hr_api.g_number

566: ,p_set_of_books_id in number default hr_api.g_number
567: ,p_gl_cash_ac_id in number default hr_api.g_number
568: ,p_gl_cash_clearing_ac_id in number default hr_api.g_number
569: ,p_gl_control_ac_id in number default hr_api.g_number
570: ,p_gl_error_ac_id in number default hr_api.g_number
571: ,p_external_account_id in number default hr_api.g_number
572: ,p_org_payment_method_id in number default hr_api.g_number
573: ,p_effective_start_date out nocopy date
574: ,p_effective_end_date out nocopy date

Line 571: ,p_external_account_id in number default hr_api.g_number

567: ,p_gl_cash_ac_id in number default hr_api.g_number
568: ,p_gl_cash_clearing_ac_id in number default hr_api.g_number
569: ,p_gl_control_ac_id in number default hr_api.g_number
570: ,p_gl_error_ac_id in number default hr_api.g_number
571: ,p_external_account_id in number default hr_api.g_number
572: ,p_org_payment_method_id in number default hr_api.g_number
573: ,p_effective_start_date out nocopy date
574: ,p_effective_end_date out nocopy date
575: ) is

Line 572: ,p_org_payment_method_id in number default hr_api.g_number

568: ,p_gl_cash_clearing_ac_id in number default hr_api.g_number
569: ,p_gl_control_ac_id in number default hr_api.g_number
570: ,p_gl_error_ac_id in number default hr_api.g_number
571: ,p_external_account_id in number default hr_api.g_number
572: ,p_org_payment_method_id in number default hr_api.g_number
573: ,p_effective_start_date out nocopy date
574: ,p_effective_end_date out nocopy date
575: ) is
576: --