APPS.GHR_NLA_UPD dependencies on HR_API

Line 82: When hr_api.check_integrity_violated Then

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

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

82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: p_rec := l_rec;
85: ghr_nla_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: p_rec := l_rec;
90: ghr_nla_shd.constraint_error

Line 87: When hr_api.parent_integrity_violated Then

83: -- A check constraint has been violated
84: p_rec := l_rec;
85: ghr_nla_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: p_rec := l_rec;
90: ghr_nla_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.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: p_rec := l_rec;
90: ghr_nla_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: p_rec := l_rec;
95: ghr_nla_shd.constraint_error

Line 92: When hr_api.unique_integrity_violated Then

88: -- Parent integrity has been violated
89: p_rec := l_rec;
90: ghr_nla_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: p_rec := l_rec;
95: ghr_nla_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.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: p_rec := l_rec;
95: ghr_nla_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: p_rec := l_rec;
99: Raise;
100: 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_noac_las'
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_noac_las'
219: ,p_hook_type => 'AU');
220: --
221: end;

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

284: -- p_rec plsql record structure
285: -- to see if a system default is being used. If a system default
286: -- is being used then we must set to the 'current' argument value.
287: --
288: If (p_rec.nature_of_action_id = hr_api.g_number) then
289: p_rec.nature_of_action_id :=
290: ghr_nla_shd.g_old_rec.nature_of_action_id;
291: End If;
292: If (p_rec.lac_lookup_code = hr_api.g_varchar2) then

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

288: If (p_rec.nature_of_action_id = hr_api.g_number) then
289: p_rec.nature_of_action_id :=
290: ghr_nla_shd.g_old_rec.nature_of_action_id;
291: End If;
292: If (p_rec.lac_lookup_code = hr_api.g_varchar2) then
293: p_rec.lac_lookup_code :=
294: ghr_nla_shd.g_old_rec.lac_lookup_code;
295: End If;
296: If (p_rec.enabled_flag = hr_api.g_varchar2) then

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

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

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

296: If (p_rec.enabled_flag = hr_api.g_varchar2) then
297: p_rec.enabled_flag :=
298: ghr_nla_shd.g_old_rec.enabled_flag;
299: End If;
300: If (p_rec.date_from = hr_api.g_date) then
301: p_rec.date_from :=
302: ghr_nla_shd.g_old_rec.date_from;
303: End If;
304: If (p_rec.date_to = hr_api.g_date) then

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

300: If (p_rec.date_from = hr_api.g_date) then
301: p_rec.date_from :=
302: ghr_nla_shd.g_old_rec.date_from;
303: End If;
304: If (p_rec.date_to = hr_api.g_date) then
305: p_rec.date_to :=
306: ghr_nla_shd.g_old_rec.date_to;
307: End If;
308: If (p_rec.valid_first_lac_flag = hr_api.g_varchar2) then

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

304: If (p_rec.date_to = hr_api.g_date) then
305: p_rec.date_to :=
306: ghr_nla_shd.g_old_rec.date_to;
307: End If;
308: If (p_rec.valid_first_lac_flag = hr_api.g_varchar2) then
309: p_rec.valid_first_lac_flag :=
310: ghr_nla_shd.g_old_rec.valid_first_lac_flag;
311: End If;
312: If (p_rec.valid_second_lac_flag = hr_api.g_varchar2) then

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

308: If (p_rec.valid_first_lac_flag = hr_api.g_varchar2) then
309: p_rec.valid_first_lac_flag :=
310: ghr_nla_shd.g_old_rec.valid_first_lac_flag;
311: End If;
312: If (p_rec.valid_second_lac_flag = hr_api.g_varchar2) then
313: p_rec.valid_second_lac_flag :=
314: ghr_nla_shd.g_old_rec.valid_second_lac_flag;
315: End If;
316: --

Line 385: p_nature_of_action_id in number default hr_api.g_number,

381: Procedure upd
382: (
383: p_effective_date in date,
384: p_noac_la_id in number,
385: p_nature_of_action_id in number default hr_api.g_number,
386: p_lac_lookup_code in varchar2 default hr_api.g_varchar2,
387: p_enabled_flag in varchar2 default hr_api.g_varchar2,
388: p_date_from in date default hr_api.g_date,
389: p_date_to in date default hr_api.g_date,

Line 386: p_lac_lookup_code in varchar2 default hr_api.g_varchar2,

382: (
383: p_effective_date in date,
384: p_noac_la_id in number,
385: p_nature_of_action_id in number default hr_api.g_number,
386: p_lac_lookup_code in varchar2 default hr_api.g_varchar2,
387: p_enabled_flag in varchar2 default hr_api.g_varchar2,
388: p_date_from in date default hr_api.g_date,
389: p_date_to in date default hr_api.g_date,
390: p_object_version_number in out NOCOPY number,

Line 387: p_enabled_flag in varchar2 default hr_api.g_varchar2,

383: p_effective_date in date,
384: p_noac_la_id in number,
385: p_nature_of_action_id in number default hr_api.g_number,
386: p_lac_lookup_code in varchar2 default hr_api.g_varchar2,
387: p_enabled_flag in varchar2 default hr_api.g_varchar2,
388: p_date_from in date default hr_api.g_date,
389: p_date_to in date default hr_api.g_date,
390: p_object_version_number in out NOCOPY number,
391: p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2,

Line 388: p_date_from in date default hr_api.g_date,

384: p_noac_la_id in number,
385: p_nature_of_action_id in number default hr_api.g_number,
386: p_lac_lookup_code in varchar2 default hr_api.g_varchar2,
387: p_enabled_flag in varchar2 default hr_api.g_varchar2,
388: p_date_from in date default hr_api.g_date,
389: p_date_to in date default hr_api.g_date,
390: p_object_version_number in out NOCOPY number,
391: p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2,
392: p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2

Line 389: p_date_to in date default hr_api.g_date,

385: p_nature_of_action_id in number default hr_api.g_number,
386: p_lac_lookup_code in varchar2 default hr_api.g_varchar2,
387: p_enabled_flag in varchar2 default hr_api.g_varchar2,
388: p_date_from in date default hr_api.g_date,
389: p_date_to in date default hr_api.g_date,
390: p_object_version_number in out NOCOPY number,
391: p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2,
392: p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
393: ) is

Line 391: p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2,

387: p_enabled_flag in varchar2 default hr_api.g_varchar2,
388: p_date_from in date default hr_api.g_date,
389: p_date_to in date default hr_api.g_date,
390: p_object_version_number in out NOCOPY number,
391: p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2,
392: p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
393: ) is
394: --
395: l_rec ghr_nla_shd.g_rec_type;

Line 392: p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2

388: p_date_from in date default hr_api.g_date,
389: p_date_to in date default hr_api.g_date,
390: p_object_version_number in out NOCOPY number,
391: p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2,
392: p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
393: ) is
394: --
395: l_rec ghr_nla_shd.g_rec_type;
396: l_proc varchar2(72);