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.PQH_GIN_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 111: When hr_api.check_integrity_violated Then

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

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

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

Line 116: When hr_api.unique_integrity_violated Then

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

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

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

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

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

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

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

Line 432: when hr_api.cannot_find_prog_unit then

428: );
429: --
430: exception
431: --
432: when hr_api.cannot_find_prog_unit then
433: --
434: hr_api.cannot_find_prog_unit_error
435: (p_module_name => 'PQH_FR_GLOBAL_INDICES_F'
436: ,p_hook_type => 'AU');

Line 434: hr_api.cannot_find_prog_unit_error

430: exception
431: --
432: when hr_api.cannot_find_prog_unit then
433: --
434: hr_api.cannot_find_prog_unit_error
435: (p_module_name => 'PQH_FR_GLOBAL_INDICES_F'
436: ,p_hook_type => 'AU');
437: --
438: end;

Line 497: If (p_rec.type_of_record = hr_api.g_varchar2) then

493: -- p_rec plsql record structure
494: -- to see if a system default is being used. If a system default
495: -- is being used then we must set to the 'current' argument value.
496: --
497: If (p_rec.type_of_record = hr_api.g_varchar2) then
498: p_rec.type_of_record :=
499: pqh_gin_shd.g_old_rec.type_of_record;
500: End If;
501: If (p_rec.gross_index = hr_api.g_number) then

Line 501: If (p_rec.gross_index = hr_api.g_number) then

497: If (p_rec.type_of_record = hr_api.g_varchar2) then
498: p_rec.type_of_record :=
499: pqh_gin_shd.g_old_rec.type_of_record;
500: End If;
501: If (p_rec.gross_index = hr_api.g_number) then
502: p_rec.gross_index :=
503: pqh_gin_shd.g_old_rec.gross_index;
504: End If;
505: If (p_rec.increased_index = hr_api.g_number) then

Line 505: If (p_rec.increased_index = hr_api.g_number) then

501: If (p_rec.gross_index = hr_api.g_number) then
502: p_rec.gross_index :=
503: pqh_gin_shd.g_old_rec.gross_index;
504: End If;
505: If (p_rec.increased_index = hr_api.g_number) then
506: p_rec.increased_index :=
507: pqh_gin_shd.g_old_rec.increased_index;
508: End If;
509: If (p_rec.basic_salary_rate = hr_api.g_number) then

Line 509: If (p_rec.basic_salary_rate = hr_api.g_number) then

505: If (p_rec.increased_index = hr_api.g_number) then
506: p_rec.increased_index :=
507: pqh_gin_shd.g_old_rec.increased_index;
508: End If;
509: If (p_rec.basic_salary_rate = hr_api.g_number) then
510: p_rec.basic_salary_rate :=
511: pqh_gin_shd.g_old_rec.basic_salary_rate;
512: End If;
513: If (p_rec.housing_indemnity_rate = hr_api.g_number) then

Line 513: If (p_rec.housing_indemnity_rate = hr_api.g_number) then

509: If (p_rec.basic_salary_rate = hr_api.g_number) then
510: p_rec.basic_salary_rate :=
511: pqh_gin_shd.g_old_rec.basic_salary_rate;
512: End If;
513: If (p_rec.housing_indemnity_rate = hr_api.g_number) then
514: p_rec.housing_indemnity_rate :=
515: pqh_gin_shd.g_old_rec.housing_indemnity_rate;
516: End If;
517: If (p_rec.currency_code = hr_api.g_varchar2) then

Line 517: If (p_rec.currency_code = hr_api.g_varchar2) then

513: If (p_rec.housing_indemnity_rate = hr_api.g_number) then
514: p_rec.housing_indemnity_rate :=
515: pqh_gin_shd.g_old_rec.housing_indemnity_rate;
516: End If;
517: If (p_rec.currency_code = hr_api.g_varchar2) then
518: p_rec.currency_code :=
519: pqh_gin_shd.g_old_rec.currency_code;
520: End If;
521:

Line 672: ,p_type_of_record in varchar2 default hr_api.g_varchar2

668: (p_effective_date in date
669: ,p_datetrack_mode in varchar2
670: ,p_global_index_id in number
671: ,p_object_version_number in out nocopy number
672: ,p_type_of_record in varchar2 default hr_api.g_varchar2
673: ,p_gross_index in number default hr_api.g_number
674: ,p_increased_index in number default hr_api.g_number
675: ,p_basic_salary_rate in number default hr_api.g_number
676: ,p_housing_indemnity_rate in number default hr_api.g_number

Line 673: ,p_gross_index in number default hr_api.g_number

669: ,p_datetrack_mode in varchar2
670: ,p_global_index_id in number
671: ,p_object_version_number in out nocopy number
672: ,p_type_of_record in varchar2 default hr_api.g_varchar2
673: ,p_gross_index in number default hr_api.g_number
674: ,p_increased_index in number default hr_api.g_number
675: ,p_basic_salary_rate in number default hr_api.g_number
676: ,p_housing_indemnity_rate in number default hr_api.g_number
677: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 674: ,p_increased_index in number default hr_api.g_number

670: ,p_global_index_id in number
671: ,p_object_version_number in out nocopy number
672: ,p_type_of_record in varchar2 default hr_api.g_varchar2
673: ,p_gross_index in number default hr_api.g_number
674: ,p_increased_index in number default hr_api.g_number
675: ,p_basic_salary_rate in number default hr_api.g_number
676: ,p_housing_indemnity_rate in number default hr_api.g_number
677: ,p_currency_code in varchar2 default hr_api.g_varchar2
678: ,p_effective_start_date out nocopy date

Line 675: ,p_basic_salary_rate in number default hr_api.g_number

671: ,p_object_version_number in out nocopy number
672: ,p_type_of_record in varchar2 default hr_api.g_varchar2
673: ,p_gross_index in number default hr_api.g_number
674: ,p_increased_index in number default hr_api.g_number
675: ,p_basic_salary_rate in number default hr_api.g_number
676: ,p_housing_indemnity_rate in number default hr_api.g_number
677: ,p_currency_code in varchar2 default hr_api.g_varchar2
678: ,p_effective_start_date out nocopy date
679: ,p_effective_end_date out nocopy date

Line 676: ,p_housing_indemnity_rate in number default hr_api.g_number

672: ,p_type_of_record in varchar2 default hr_api.g_varchar2
673: ,p_gross_index in number default hr_api.g_number
674: ,p_increased_index in number default hr_api.g_number
675: ,p_basic_salary_rate in number default hr_api.g_number
676: ,p_housing_indemnity_rate in number default hr_api.g_number
677: ,p_currency_code in varchar2 default hr_api.g_varchar2
678: ,p_effective_start_date out nocopy date
679: ,p_effective_end_date out nocopy date
680: ) is

Line 677: ,p_currency_code in varchar2 default hr_api.g_varchar2

673: ,p_gross_index in number default hr_api.g_number
674: ,p_increased_index in number default hr_api.g_number
675: ,p_basic_salary_rate in number default hr_api.g_number
676: ,p_housing_indemnity_rate in number default hr_api.g_number
677: ,p_currency_code in varchar2 default hr_api.g_varchar2
678: ,p_effective_start_date out nocopy date
679: ,p_effective_end_date out nocopy date
680: ) is
681: --