APPS.BEN_XWC_UPD dependencies on HR_API

Line 94: When hr_api.check_integrity_violated Then

90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: --
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
97: ben_xwc_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
97: ben_xwc_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
102: ben_xwc_shd.constraint_error

Line 99: When hr_api.parent_integrity_violated Then

95: -- A check constraint has been violated
96: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
97: ben_xwc_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
102: ben_xwc_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
102: ben_xwc_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
107: ben_xwc_shd.constraint_error

Line 104: When hr_api.unique_integrity_violated Then

100: -- Parent integrity has been violated
101: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
102: ben_xwc_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
107: ben_xwc_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
107: ben_xwc_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
111: Raise;
112: End update_dml;

Line 233: when hr_api.cannot_find_prog_unit then

229: );
230: --
231: exception
232: --
233: when hr_api.cannot_find_prog_unit then
234: --
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'ben_ext_where_clause'
237: ,p_hook_type => 'AU');

Line 235: hr_api.cannot_find_prog_unit_error

231: exception
232: --
233: when hr_api.cannot_find_prog_unit then
234: --
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'ben_ext_where_clause'
237: ,p_hook_type => 'AU');
238: --
239: end;

Line 303: If (p_rec.seq_num = hr_api.g_number) then

299: -- p_rec plsql record structure
300: -- to see if a system default is being used. If a system default
301: -- is being used then we must set to the 'current' argument value.
302: --
303: If (p_rec.seq_num = hr_api.g_number) then
304: p_rec.seq_num :=
305: ben_xwc_shd.g_old_rec.seq_num;
306: End If;
307: If (p_rec.oper_cd = hr_api.g_varchar2) then

Line 307: If (p_rec.oper_cd = hr_api.g_varchar2) then

303: If (p_rec.seq_num = hr_api.g_number) then
304: p_rec.seq_num :=
305: ben_xwc_shd.g_old_rec.seq_num;
306: End If;
307: If (p_rec.oper_cd = hr_api.g_varchar2) then
308: p_rec.oper_cd :=
309: ben_xwc_shd.g_old_rec.oper_cd;
310: End If;
311: If (p_rec.val = hr_api.g_varchar2) then

Line 311: If (p_rec.val = hr_api.g_varchar2) then

307: If (p_rec.oper_cd = hr_api.g_varchar2) then
308: p_rec.oper_cd :=
309: ben_xwc_shd.g_old_rec.oper_cd;
310: End If;
311: If (p_rec.val = hr_api.g_varchar2) then
312: p_rec.val :=
313: ben_xwc_shd.g_old_rec.val;
314: End If;
315: If (p_rec.and_or_cd = hr_api.g_varchar2) then

Line 315: If (p_rec.and_or_cd = hr_api.g_varchar2) then

311: If (p_rec.val = hr_api.g_varchar2) then
312: p_rec.val :=
313: ben_xwc_shd.g_old_rec.val;
314: End If;
315: If (p_rec.and_or_cd = hr_api.g_varchar2) then
316: p_rec.and_or_cd :=
317: ben_xwc_shd.g_old_rec.and_or_cd;
318: End If;
319: If (p_rec.ext_data_elmt_id = hr_api.g_number) then

Line 319: If (p_rec.ext_data_elmt_id = hr_api.g_number) then

315: If (p_rec.and_or_cd = hr_api.g_varchar2) then
316: p_rec.and_or_cd :=
317: ben_xwc_shd.g_old_rec.and_or_cd;
318: End If;
319: If (p_rec.ext_data_elmt_id = hr_api.g_number) then
320: p_rec.ext_data_elmt_id :=
321: ben_xwc_shd.g_old_rec.ext_data_elmt_id;
322: End If;
323: If (p_rec.cond_ext_data_elmt_id = hr_api.g_number) then

Line 323: If (p_rec.cond_ext_data_elmt_id = hr_api.g_number) then

319: If (p_rec.ext_data_elmt_id = hr_api.g_number) then
320: p_rec.ext_data_elmt_id :=
321: ben_xwc_shd.g_old_rec.ext_data_elmt_id;
322: End If;
323: If (p_rec.cond_ext_data_elmt_id = hr_api.g_number) then
324: p_rec.cond_ext_data_elmt_id :=
325: ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id;
326: End If;
327: If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then

Line 327: If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then

323: If (p_rec.cond_ext_data_elmt_id = hr_api.g_number) then
324: p_rec.cond_ext_data_elmt_id :=
325: ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id;
326: End If;
327: If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then
328: p_rec.ext_rcd_in_file_id :=
329: ben_xwc_shd.g_old_rec.ext_rcd_in_file_id;
330: End If;
331: If (p_rec.ext_data_elmt_in_rcd_id = hr_api.g_number) then

Line 331: If (p_rec.ext_data_elmt_in_rcd_id = hr_api.g_number) then

327: If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then
328: p_rec.ext_rcd_in_file_id :=
329: ben_xwc_shd.g_old_rec.ext_rcd_in_file_id;
330: End If;
331: If (p_rec.ext_data_elmt_in_rcd_id = hr_api.g_number) then
332: p_rec.ext_data_elmt_in_rcd_id :=
333: ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id;
334: End If;
335: If (p_rec.business_group_id = hr_api.g_number) then

Line 335: If (p_rec.business_group_id = hr_api.g_number) then

331: If (p_rec.ext_data_elmt_in_rcd_id = hr_api.g_number) then
332: p_rec.ext_data_elmt_in_rcd_id :=
333: ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id;
334: End If;
335: If (p_rec.business_group_id = hr_api.g_number) then
336: p_rec.business_group_id :=
337: ben_xwc_shd.g_old_rec.business_group_id;
338: End If;
339: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 339: If (p_rec.legislation_code = hr_api.g_varchar2) then

335: If (p_rec.business_group_id = hr_api.g_number) then
336: p_rec.business_group_id :=
337: ben_xwc_shd.g_old_rec.business_group_id;
338: End If;
339: If (p_rec.legislation_code = hr_api.g_varchar2) then
340: p_rec.legislation_code :=
341: ben_xwc_shd.g_old_rec.legislation_code;
342: End If;
343: If (p_rec.cond_ext_data_elmt_in_rcd_id = hr_api.g_number) then

Line 343: If (p_rec.cond_ext_data_elmt_in_rcd_id = hr_api.g_number) then

339: If (p_rec.legislation_code = hr_api.g_varchar2) then
340: p_rec.legislation_code :=
341: ben_xwc_shd.g_old_rec.legislation_code;
342: End If;
343: If (p_rec.cond_ext_data_elmt_in_rcd_id = hr_api.g_number) then
344: p_rec.cond_ext_data_elmt_in_rcd_id :=
345: ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id;
346: End If;
347: --

Line 405: p_seq_num in number default hr_api.g_number,

401: Procedure upd
402: (
403: p_effective_date in date,
404: p_ext_where_clause_id in number,
405: p_seq_num in number default hr_api.g_number,
406: p_oper_cd in varchar2 default hr_api.g_varchar2,
407: p_val in varchar2 default hr_api.g_varchar2,
408: p_and_or_cd in varchar2 default hr_api.g_varchar2,
409: p_ext_data_elmt_id in number default hr_api.g_number,

Line 406: p_oper_cd in varchar2 default hr_api.g_varchar2,

402: (
403: p_effective_date in date,
404: p_ext_where_clause_id in number,
405: p_seq_num in number default hr_api.g_number,
406: p_oper_cd in varchar2 default hr_api.g_varchar2,
407: p_val in varchar2 default hr_api.g_varchar2,
408: p_and_or_cd in varchar2 default hr_api.g_varchar2,
409: p_ext_data_elmt_id in number default hr_api.g_number,
410: p_cond_ext_data_elmt_id in number default hr_api.g_number,

Line 407: p_val in varchar2 default hr_api.g_varchar2,

403: p_effective_date in date,
404: p_ext_where_clause_id in number,
405: p_seq_num in number default hr_api.g_number,
406: p_oper_cd in varchar2 default hr_api.g_varchar2,
407: p_val in varchar2 default hr_api.g_varchar2,
408: p_and_or_cd in varchar2 default hr_api.g_varchar2,
409: p_ext_data_elmt_id in number default hr_api.g_number,
410: p_cond_ext_data_elmt_id in number default hr_api.g_number,
411: p_ext_rcd_in_file_id in number default hr_api.g_number,

Line 408: p_and_or_cd in varchar2 default hr_api.g_varchar2,

404: p_ext_where_clause_id in number,
405: p_seq_num in number default hr_api.g_number,
406: p_oper_cd in varchar2 default hr_api.g_varchar2,
407: p_val in varchar2 default hr_api.g_varchar2,
408: p_and_or_cd in varchar2 default hr_api.g_varchar2,
409: p_ext_data_elmt_id in number default hr_api.g_number,
410: p_cond_ext_data_elmt_id in number default hr_api.g_number,
411: p_ext_rcd_in_file_id in number default hr_api.g_number,
412: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,

Line 409: p_ext_data_elmt_id in number default hr_api.g_number,

405: p_seq_num in number default hr_api.g_number,
406: p_oper_cd in varchar2 default hr_api.g_varchar2,
407: p_val in varchar2 default hr_api.g_varchar2,
408: p_and_or_cd in varchar2 default hr_api.g_varchar2,
409: p_ext_data_elmt_id in number default hr_api.g_number,
410: p_cond_ext_data_elmt_id in number default hr_api.g_number,
411: p_ext_rcd_in_file_id in number default hr_api.g_number,
412: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
413: p_business_group_id in number default hr_api.g_number,

Line 410: p_cond_ext_data_elmt_id in number default hr_api.g_number,

406: p_oper_cd in varchar2 default hr_api.g_varchar2,
407: p_val in varchar2 default hr_api.g_varchar2,
408: p_and_or_cd in varchar2 default hr_api.g_varchar2,
409: p_ext_data_elmt_id in number default hr_api.g_number,
410: p_cond_ext_data_elmt_id in number default hr_api.g_number,
411: p_ext_rcd_in_file_id in number default hr_api.g_number,
412: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
413: p_business_group_id in number default hr_api.g_number,
414: p_legislation_code in varchar2 default hr_api.g_varchar2,

Line 411: p_ext_rcd_in_file_id in number default hr_api.g_number,

407: p_val in varchar2 default hr_api.g_varchar2,
408: p_and_or_cd in varchar2 default hr_api.g_varchar2,
409: p_ext_data_elmt_id in number default hr_api.g_number,
410: p_cond_ext_data_elmt_id in number default hr_api.g_number,
411: p_ext_rcd_in_file_id in number default hr_api.g_number,
412: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
413: p_business_group_id in number default hr_api.g_number,
414: p_legislation_code in varchar2 default hr_api.g_varchar2,
415: p_last_update_date in date default hr_api.g_date,

Line 412: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,

408: p_and_or_cd in varchar2 default hr_api.g_varchar2,
409: p_ext_data_elmt_id in number default hr_api.g_number,
410: p_cond_ext_data_elmt_id in number default hr_api.g_number,
411: p_ext_rcd_in_file_id in number default hr_api.g_number,
412: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
413: p_business_group_id in number default hr_api.g_number,
414: p_legislation_code in varchar2 default hr_api.g_varchar2,
415: p_last_update_date in date default hr_api.g_date,
416: p_creation_date in date default hr_api.g_date,

Line 413: p_business_group_id in number default hr_api.g_number,

409: p_ext_data_elmt_id in number default hr_api.g_number,
410: p_cond_ext_data_elmt_id in number default hr_api.g_number,
411: p_ext_rcd_in_file_id in number default hr_api.g_number,
412: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
413: p_business_group_id in number default hr_api.g_number,
414: p_legislation_code in varchar2 default hr_api.g_varchar2,
415: p_last_update_date in date default hr_api.g_date,
416: p_creation_date in date default hr_api.g_date,
417: p_last_updated_by in number default hr_api.g_number,

Line 414: p_legislation_code in varchar2 default hr_api.g_varchar2,

410: p_cond_ext_data_elmt_id in number default hr_api.g_number,
411: p_ext_rcd_in_file_id in number default hr_api.g_number,
412: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
413: p_business_group_id in number default hr_api.g_number,
414: p_legislation_code in varchar2 default hr_api.g_varchar2,
415: p_last_update_date in date default hr_api.g_date,
416: p_creation_date in date default hr_api.g_date,
417: p_last_updated_by in number default hr_api.g_number,
418: p_last_update_login in number default hr_api.g_number,

Line 415: p_last_update_date in date default hr_api.g_date,

411: p_ext_rcd_in_file_id in number default hr_api.g_number,
412: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
413: p_business_group_id in number default hr_api.g_number,
414: p_legislation_code in varchar2 default hr_api.g_varchar2,
415: p_last_update_date in date default hr_api.g_date,
416: p_creation_date in date default hr_api.g_date,
417: p_last_updated_by in number default hr_api.g_number,
418: p_last_update_login in number default hr_api.g_number,
419: p_created_by in number default hr_api.g_number,

Line 416: p_creation_date in date default hr_api.g_date,

412: p_ext_data_elmt_in_rcd_id in number default hr_api.g_number,
413: p_business_group_id in number default hr_api.g_number,
414: p_legislation_code in varchar2 default hr_api.g_varchar2,
415: p_last_update_date in date default hr_api.g_date,
416: p_creation_date in date default hr_api.g_date,
417: p_last_updated_by in number default hr_api.g_number,
418: p_last_update_login in number default hr_api.g_number,
419: p_created_by in number default hr_api.g_number,
420: p_object_version_number in out nocopy number,

Line 417: p_last_updated_by in number default hr_api.g_number,

413: p_business_group_id in number default hr_api.g_number,
414: p_legislation_code in varchar2 default hr_api.g_varchar2,
415: p_last_update_date in date default hr_api.g_date,
416: p_creation_date in date default hr_api.g_date,
417: p_last_updated_by in number default hr_api.g_number,
418: p_last_update_login in number default hr_api.g_number,
419: p_created_by in number default hr_api.g_number,
420: p_object_version_number in out nocopy number,
421: p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number

Line 418: p_last_update_login in number default hr_api.g_number,

414: p_legislation_code in varchar2 default hr_api.g_varchar2,
415: p_last_update_date in date default hr_api.g_date,
416: p_creation_date in date default hr_api.g_date,
417: p_last_updated_by in number default hr_api.g_number,
418: p_last_update_login in number default hr_api.g_number,
419: p_created_by in number default hr_api.g_number,
420: p_object_version_number in out nocopy number,
421: p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
422: ) is

Line 419: p_created_by in number default hr_api.g_number,

415: p_last_update_date in date default hr_api.g_date,
416: p_creation_date in date default hr_api.g_date,
417: p_last_updated_by in number default hr_api.g_number,
418: p_last_update_login in number default hr_api.g_number,
419: p_created_by in number default hr_api.g_number,
420: p_object_version_number in out nocopy number,
421: p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
422: ) is
423: --

Line 421: p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number

417: p_last_updated_by in number default hr_api.g_number,
418: p_last_update_login in number default hr_api.g_number,
419: p_created_by in number default hr_api.g_number,
420: p_object_version_number in out nocopy number,
421: p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
422: ) is
423: --
424: l_rec ben_xwc_shd.g_rec_type;
425: l_proc varchar2(72) := g_package||'upd';