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

Line 79: When hr_api.check_integrity_violated Then

75: --
76: hr_utility.set_location(' Leaving:'||l_proc, 10);
77: --
78: Exception
79: When hr_api.check_integrity_violated Then
80: -- A check constraint has been violated
81: ghr_nla_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.parent_integrity_violated Then

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

78: Exception
79: When hr_api.check_integrity_violated Then
80: -- A check constraint has been violated
81: ghr_nla_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.parent_integrity_violated Then
84: -- Parent integrity has been violated
85: ghr_nla_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 83: When hr_api.parent_integrity_violated Then

79: When hr_api.check_integrity_violated Then
80: -- A check constraint has been violated
81: ghr_nla_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.parent_integrity_violated Then
84: -- Parent integrity has been violated
85: ghr_nla_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then

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

82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.parent_integrity_violated Then
84: -- Parent integrity has been violated
85: ghr_nla_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then
88: -- Unique integrity has been violated
89: ghr_nla_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 87: When hr_api.unique_integrity_violated Then

83: When hr_api.parent_integrity_violated Then
84: -- Parent integrity has been violated
85: ghr_nla_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then
88: -- Unique integrity has been violated
89: ghr_nla_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When Others Then

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

86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then
88: -- Unique integrity has been violated
89: ghr_nla_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When Others Then
92: Raise;
93: End update_dml;
94: --

Line 206: when hr_api.cannot_find_prog_unit then

202: );
203: --
204: exception
205: --
206: when hr_api.cannot_find_prog_unit then
207: --
208: hr_api.cannot_find_prog_unit_error
209: (p_module_name => 'ghr_noac_las'
210: ,p_hook_type => 'AU');

Line 208: hr_api.cannot_find_prog_unit_error

204: exception
205: --
206: when hr_api.cannot_find_prog_unit then
207: --
208: hr_api.cannot_find_prog_unit_error
209: (p_module_name => 'ghr_noac_las'
210: ,p_hook_type => 'AU');
211: --
212: end;

Line 276: If (p_rec.nature_of_action_id = hr_api.g_number) then

272: -- p_rec plsql record structure
273: -- to see if a system default is being used. If a system default
274: -- is being used then we must set to the 'current' argument value.
275: --
276: If (p_rec.nature_of_action_id = hr_api.g_number) then
277: p_rec.nature_of_action_id :=
278: ghr_nla_shd.g_old_rec.nature_of_action_id;
279: End If;
280: If (p_rec.lac_lookup_code = hr_api.g_varchar2) then

Line 280: If (p_rec.lac_lookup_code = hr_api.g_varchar2) then

276: If (p_rec.nature_of_action_id = hr_api.g_number) then
277: p_rec.nature_of_action_id :=
278: ghr_nla_shd.g_old_rec.nature_of_action_id;
279: End If;
280: If (p_rec.lac_lookup_code = hr_api.g_varchar2) then
281: p_rec.lac_lookup_code :=
282: ghr_nla_shd.g_old_rec.lac_lookup_code;
283: End If;
284: If (p_rec.enabled_flag = hr_api.g_varchar2) then

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

280: If (p_rec.lac_lookup_code = hr_api.g_varchar2) then
281: p_rec.lac_lookup_code :=
282: ghr_nla_shd.g_old_rec.lac_lookup_code;
283: End If;
284: If (p_rec.enabled_flag = hr_api.g_varchar2) then
285: p_rec.enabled_flag :=
286: ghr_nla_shd.g_old_rec.enabled_flag;
287: End If;
288: If (p_rec.date_from = hr_api.g_date) then

Line 288: If (p_rec.date_from = hr_api.g_date) then

284: If (p_rec.enabled_flag = hr_api.g_varchar2) then
285: p_rec.enabled_flag :=
286: ghr_nla_shd.g_old_rec.enabled_flag;
287: End If;
288: If (p_rec.date_from = hr_api.g_date) then
289: p_rec.date_from :=
290: ghr_nla_shd.g_old_rec.date_from;
291: End If;
292: If (p_rec.date_to = hr_api.g_date) then

Line 292: If (p_rec.date_to = hr_api.g_date) then

288: If (p_rec.date_from = hr_api.g_date) then
289: p_rec.date_from :=
290: ghr_nla_shd.g_old_rec.date_from;
291: End If;
292: If (p_rec.date_to = hr_api.g_date) then
293: p_rec.date_to :=
294: ghr_nla_shd.g_old_rec.date_to;
295: End If;
296: If (p_rec.valid_first_lac_flag = hr_api.g_varchar2) then

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

292: If (p_rec.date_to = hr_api.g_date) then
293: p_rec.date_to :=
294: ghr_nla_shd.g_old_rec.date_to;
295: End If;
296: If (p_rec.valid_first_lac_flag = hr_api.g_varchar2) then
297: p_rec.valid_first_lac_flag :=
298: ghr_nla_shd.g_old_rec.valid_first_lac_flag;
299: End If;
300: If (p_rec.valid_second_lac_flag = hr_api.g_varchar2) then

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

296: If (p_rec.valid_first_lac_flag = hr_api.g_varchar2) then
297: p_rec.valid_first_lac_flag :=
298: ghr_nla_shd.g_old_rec.valid_first_lac_flag;
299: End If;
300: If (p_rec.valid_second_lac_flag = hr_api.g_varchar2) then
301: p_rec.valid_second_lac_flag :=
302: ghr_nla_shd.g_old_rec.valid_second_lac_flag;
303: End If;
304: --

Line 362: p_nature_of_action_id in number default hr_api.g_number,

358: Procedure upd
359: (
360: p_effective_date in date,
361: p_noac_la_id in number,
362: p_nature_of_action_id in number default hr_api.g_number,
363: p_lac_lookup_code in varchar2 default hr_api.g_varchar2,
364: p_enabled_flag in varchar2 default hr_api.g_varchar2,
365: p_date_from in date default hr_api.g_date,
366: p_date_to in date default hr_api.g_date,

Line 363: p_lac_lookup_code in varchar2 default hr_api.g_varchar2,

359: (
360: p_effective_date in date,
361: p_noac_la_id in number,
362: p_nature_of_action_id in number default hr_api.g_number,
363: p_lac_lookup_code in varchar2 default hr_api.g_varchar2,
364: p_enabled_flag in varchar2 default hr_api.g_varchar2,
365: p_date_from in date default hr_api.g_date,
366: p_date_to in date default hr_api.g_date,
367: p_object_version_number in out number,

Line 364: p_enabled_flag in varchar2 default hr_api.g_varchar2,

360: p_effective_date in date,
361: p_noac_la_id in number,
362: p_nature_of_action_id in number default hr_api.g_number,
363: p_lac_lookup_code in varchar2 default hr_api.g_varchar2,
364: p_enabled_flag in varchar2 default hr_api.g_varchar2,
365: p_date_from in date default hr_api.g_date,
366: p_date_to in date default hr_api.g_date,
367: p_object_version_number in out number,
368: p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2,

Line 365: p_date_from in date default hr_api.g_date,

361: p_noac_la_id in number,
362: p_nature_of_action_id in number default hr_api.g_number,
363: p_lac_lookup_code in varchar2 default hr_api.g_varchar2,
364: p_enabled_flag in varchar2 default hr_api.g_varchar2,
365: p_date_from in date default hr_api.g_date,
366: p_date_to in date default hr_api.g_date,
367: p_object_version_number in out number,
368: p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2,
369: p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2

Line 366: p_date_to in date default hr_api.g_date,

362: p_nature_of_action_id in number default hr_api.g_number,
363: p_lac_lookup_code in varchar2 default hr_api.g_varchar2,
364: p_enabled_flag in varchar2 default hr_api.g_varchar2,
365: p_date_from in date default hr_api.g_date,
366: p_date_to in date default hr_api.g_date,
367: p_object_version_number in out number,
368: p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2,
369: p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
370: ) is

Line 368: p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2,

364: p_enabled_flag in varchar2 default hr_api.g_varchar2,
365: p_date_from in date default hr_api.g_date,
366: p_date_to in date default hr_api.g_date,
367: p_object_version_number in out number,
368: p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2,
369: p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
370: ) is
371: --
372: l_rec ghr_nla_shd.g_rec_type;

Line 369: p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2

365: p_date_from in date default hr_api.g_date,
366: p_date_to in date default hr_api.g_date,
367: p_object_version_number in out number,
368: p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2,
369: p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
370: ) is
371: --
372: l_rec ghr_nla_shd.g_rec_type;
373: l_proc varchar2(72) := g_package||'upd';