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.GHR_CBA_UPD dependencies on HR_API

Line 87: When hr_api.check_integrity_violated Then

83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: --
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: --
90: ghr_cba_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: --
90: ghr_cba_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: --
95: ghr_cba_shd.constraint_error

Line 92: When hr_api.parent_integrity_violated Then

88: -- A check constraint has been violated
89: --
90: ghr_cba_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: --
95: ghr_cba_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: --
95: ghr_cba_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: --
100: ghr_cba_shd.constraint_error

Line 97: When hr_api.unique_integrity_violated Then

93: -- Parent integrity has been violated
94: --
95: ghr_cba_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: --
100: ghr_cba_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: --
100: ghr_cba_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When Others Then
103: --
104: Raise;
105: End update_dml;

Line 215: when hr_api.cannot_find_prog_unit then

211: );
212: --
213: exception
214: --
215: when hr_api.cannot_find_prog_unit then
216: --
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'GHR_COMPL_BASES'
219: ,p_hook_type => 'AU');

Line 217: hr_api.cannot_find_prog_unit_error

213: exception
214: --
215: when hr_api.cannot_find_prog_unit then
216: --
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'GHR_COMPL_BASES'
219: ,p_hook_type => 'AU');
220: --
221: end;

Line 280: If (p_rec.compl_claim_id = hr_api.g_number) then

276: -- p_rec plsql record structure
277: -- to see if a system default is being used. If a system default
278: -- is being used then we must set to the 'current' argument value.
279: --
280: If (p_rec.compl_claim_id = hr_api.g_number) then
281: p_rec.compl_claim_id :=
282: ghr_cba_shd.g_old_rec.compl_claim_id;
283: End If;
284: If (p_rec.basis = hr_api.g_varchar2) then

Line 284: If (p_rec.basis = hr_api.g_varchar2) then

280: If (p_rec.compl_claim_id = hr_api.g_number) then
281: p_rec.compl_claim_id :=
282: ghr_cba_shd.g_old_rec.compl_claim_id;
283: End If;
284: If (p_rec.basis = hr_api.g_varchar2) then
285: p_rec.basis :=
286: ghr_cba_shd.g_old_rec.basis;
287: End If;
288: If (p_rec.value = hr_api.g_varchar2) then

Line 288: If (p_rec.value = hr_api.g_varchar2) then

284: If (p_rec.basis = hr_api.g_varchar2) then
285: p_rec.basis :=
286: ghr_cba_shd.g_old_rec.basis;
287: End If;
288: If (p_rec.value = hr_api.g_varchar2) then
289: p_rec.value :=
290: ghr_cba_shd.g_old_rec.value;
291: End If;
292: If (p_rec.statute = hr_api.g_varchar2) then

Line 292: If (p_rec.statute = hr_api.g_varchar2) then

288: If (p_rec.value = hr_api.g_varchar2) then
289: p_rec.value :=
290: ghr_cba_shd.g_old_rec.value;
291: End If;
292: If (p_rec.statute = hr_api.g_varchar2) then
293: p_rec.statute :=
294: ghr_cba_shd.g_old_rec.statute;
295: End If;
296: If (p_rec.agency_finding = hr_api.g_varchar2) then

Line 296: If (p_rec.agency_finding = hr_api.g_varchar2) then

292: If (p_rec.statute = hr_api.g_varchar2) then
293: p_rec.statute :=
294: ghr_cba_shd.g_old_rec.statute;
295: End If;
296: If (p_rec.agency_finding = hr_api.g_varchar2) then
297: p_rec.agency_finding :=
298: ghr_cba_shd.g_old_rec.agency_finding;
299: End If;
300: If (p_rec.aj_finding = hr_api.g_varchar2) then

Line 300: If (p_rec.aj_finding = hr_api.g_varchar2) then

296: If (p_rec.agency_finding = hr_api.g_varchar2) then
297: p_rec.agency_finding :=
298: ghr_cba_shd.g_old_rec.agency_finding;
299: End If;
300: If (p_rec.aj_finding = hr_api.g_varchar2) then
301: p_rec.aj_finding :=
302: ghr_cba_shd.g_old_rec.aj_finding;
303: End If;
304: --

Line 362: ,p_compl_claim_id in number default hr_api.g_number

358: Procedure upd
359: (p_effective_date in date
360: ,p_compl_basis_id in number
361: ,p_object_version_number in out nocopy number
362: ,p_compl_claim_id in number default hr_api.g_number
363: ,p_basis in varchar2 default hr_api.g_varchar2
364: ,p_value in varchar2 default hr_api.g_varchar2
365: ,p_statute in varchar2 default hr_api.g_varchar2
366: ,p_agency_finding in varchar2 default hr_api.g_varchar2

Line 363: ,p_basis in varchar2 default hr_api.g_varchar2

359: (p_effective_date in date
360: ,p_compl_basis_id in number
361: ,p_object_version_number in out nocopy number
362: ,p_compl_claim_id in number default hr_api.g_number
363: ,p_basis in varchar2 default hr_api.g_varchar2
364: ,p_value in varchar2 default hr_api.g_varchar2
365: ,p_statute in varchar2 default hr_api.g_varchar2
366: ,p_agency_finding in varchar2 default hr_api.g_varchar2
367: ,p_aj_finding in varchar2 default hr_api.g_varchar2

Line 364: ,p_value in varchar2 default hr_api.g_varchar2

360: ,p_compl_basis_id in number
361: ,p_object_version_number in out nocopy number
362: ,p_compl_claim_id in number default hr_api.g_number
363: ,p_basis in varchar2 default hr_api.g_varchar2
364: ,p_value in varchar2 default hr_api.g_varchar2
365: ,p_statute in varchar2 default hr_api.g_varchar2
366: ,p_agency_finding in varchar2 default hr_api.g_varchar2
367: ,p_aj_finding in varchar2 default hr_api.g_varchar2
368: ) is

Line 365: ,p_statute in varchar2 default hr_api.g_varchar2

361: ,p_object_version_number in out nocopy number
362: ,p_compl_claim_id in number default hr_api.g_number
363: ,p_basis in varchar2 default hr_api.g_varchar2
364: ,p_value in varchar2 default hr_api.g_varchar2
365: ,p_statute in varchar2 default hr_api.g_varchar2
366: ,p_agency_finding in varchar2 default hr_api.g_varchar2
367: ,p_aj_finding in varchar2 default hr_api.g_varchar2
368: ) is
369: --

Line 366: ,p_agency_finding in varchar2 default hr_api.g_varchar2

362: ,p_compl_claim_id in number default hr_api.g_number
363: ,p_basis in varchar2 default hr_api.g_varchar2
364: ,p_value in varchar2 default hr_api.g_varchar2
365: ,p_statute in varchar2 default hr_api.g_varchar2
366: ,p_agency_finding in varchar2 default hr_api.g_varchar2
367: ,p_aj_finding in varchar2 default hr_api.g_varchar2
368: ) is
369: --
370: l_rec ghr_cba_shd.g_rec_type;

Line 367: ,p_aj_finding in varchar2 default hr_api.g_varchar2

363: ,p_basis in varchar2 default hr_api.g_varchar2
364: ,p_value in varchar2 default hr_api.g_varchar2
365: ,p_statute in varchar2 default hr_api.g_varchar2
366: ,p_agency_finding in varchar2 default hr_api.g_varchar2
367: ,p_aj_finding in varchar2 default hr_api.g_varchar2
368: ) is
369: --
370: l_rec ghr_cba_shd.g_rec_type;
371: l_proc varchar2(72) := g_package||'upd';