APPS.BEN_BMN_UPD dependencies on HR_API

Line 100: When hr_api.check_integrity_violated Then

96: --
97: hr_utility.set_location(' Leaving:'||l_proc, 10);
98: --
99: Exception
100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
102: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
103: ben_bmn_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 105: When hr_api.parent_integrity_violated Then

101: -- A check constraint has been violated
102: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
103: ben_bmn_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.parent_integrity_violated Then
106: -- Parent integrity has been violated
107: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
108: ben_bmn_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

105: When hr_api.parent_integrity_violated Then
106: -- Parent integrity has been violated
107: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
108: ben_bmn_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
113: ben_bmn_shd.constraint_error

Line 110: When hr_api.unique_integrity_violated Then

106: -- Parent integrity has been violated
107: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
108: ben_bmn_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
113: ben_bmn_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
113: ben_bmn_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When Others Then
116: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
117: Raise;
118: End update_dml;

Line 260: If (p_rec.benefit_action_id = hr_api.g_number) then

256: -- p_rec plsql record structure
257: -- to see if a system default is being used. If a system default
258: -- is being used then we must set to the 'current' argument value.
259: --
260: If (p_rec.benefit_action_id = hr_api.g_number) then
261: p_rec.benefit_action_id :=
262: ben_bmn_shd.g_old_rec.benefit_action_id;
263: End If;
264: If (p_rec.thread_id = hr_api.g_number) then

Line 264: If (p_rec.thread_id = hr_api.g_number) then

260: If (p_rec.benefit_action_id = hr_api.g_number) then
261: p_rec.benefit_action_id :=
262: ben_bmn_shd.g_old_rec.benefit_action_id;
263: End If;
264: If (p_rec.thread_id = hr_api.g_number) then
265: p_rec.thread_id :=
266: ben_bmn_shd.g_old_rec.thread_id;
267: End If;
268: If (p_rec.sequence = hr_api.g_number) then

Line 268: If (p_rec.sequence = hr_api.g_number) then

264: If (p_rec.thread_id = hr_api.g_number) then
265: p_rec.thread_id :=
266: ben_bmn_shd.g_old_rec.thread_id;
267: End If;
268: If (p_rec.sequence = hr_api.g_number) then
269: p_rec.sequence :=
270: ben_bmn_shd.g_old_rec.sequence;
271: End If;
272: If (p_rec.rep_typ_cd = hr_api.g_varchar2) then

Line 272: If (p_rec.rep_typ_cd = hr_api.g_varchar2) then

268: If (p_rec.sequence = hr_api.g_number) then
269: p_rec.sequence :=
270: ben_bmn_shd.g_old_rec.sequence;
271: End If;
272: If (p_rec.rep_typ_cd = hr_api.g_varchar2) then
273: p_rec.rep_typ_cd :=
274: ben_bmn_shd.g_old_rec.rep_typ_cd;
275: End If;
276: If (p_rec.error_message_code = hr_api.g_varchar2) then

Line 276: If (p_rec.error_message_code = hr_api.g_varchar2) then

272: If (p_rec.rep_typ_cd = hr_api.g_varchar2) then
273: p_rec.rep_typ_cd :=
274: ben_bmn_shd.g_old_rec.rep_typ_cd;
275: End If;
276: If (p_rec.error_message_code = hr_api.g_varchar2) then
277: p_rec.error_message_code :=
278: ben_bmn_shd.g_old_rec.error_message_code;
279: End If;
280: If (p_rec.national_identifier = hr_api.g_varchar2) then

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

276: If (p_rec.error_message_code = hr_api.g_varchar2) then
277: p_rec.error_message_code :=
278: ben_bmn_shd.g_old_rec.error_message_code;
279: End If;
280: If (p_rec.national_identifier = hr_api.g_varchar2) then
281: p_rec.national_identifier :=
282: ben_bmn_shd.g_old_rec.national_identifier;
283: End If;
284: If (p_rec.related_person_ler_id = hr_api.g_number) then

Line 284: If (p_rec.related_person_ler_id = hr_api.g_number) then

280: If (p_rec.national_identifier = hr_api.g_varchar2) then
281: p_rec.national_identifier :=
282: ben_bmn_shd.g_old_rec.national_identifier;
283: End If;
284: If (p_rec.related_person_ler_id = hr_api.g_number) then
285: p_rec.related_person_ler_id :=
286: ben_bmn_shd.g_old_rec.related_person_ler_id;
287: End If;
288: If (p_rec.temporal_ler_id = hr_api.g_number) then

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

284: If (p_rec.related_person_ler_id = hr_api.g_number) then
285: p_rec.related_person_ler_id :=
286: ben_bmn_shd.g_old_rec.related_person_ler_id;
287: End If;
288: If (p_rec.temporal_ler_id = hr_api.g_number) then
289: p_rec.temporal_ler_id :=
290: ben_bmn_shd.g_old_rec.temporal_ler_id;
291: End If;
292: If (p_rec.ler_id = hr_api.g_number) then

Line 292: If (p_rec.ler_id = hr_api.g_number) then

288: If (p_rec.temporal_ler_id = hr_api.g_number) then
289: p_rec.temporal_ler_id :=
290: ben_bmn_shd.g_old_rec.temporal_ler_id;
291: End If;
292: If (p_rec.ler_id = hr_api.g_number) then
293: p_rec.ler_id :=
294: ben_bmn_shd.g_old_rec.ler_id;
295: End If;
296: If (p_rec.person_id = hr_api.g_number) then

Line 296: If (p_rec.person_id = hr_api.g_number) then

292: If (p_rec.ler_id = hr_api.g_number) then
293: p_rec.ler_id :=
294: ben_bmn_shd.g_old_rec.ler_id;
295: End If;
296: If (p_rec.person_id = hr_api.g_number) then
297: p_rec.person_id :=
298: ben_bmn_shd.g_old_rec.person_id;
299: End If;
300: If (p_rec.pgm_id = hr_api.g_number) then

Line 300: If (p_rec.pgm_id = hr_api.g_number) then

296: If (p_rec.person_id = hr_api.g_number) then
297: p_rec.person_id :=
298: ben_bmn_shd.g_old_rec.person_id;
299: End If;
300: If (p_rec.pgm_id = hr_api.g_number) then
301: p_rec.pgm_id :=
302: ben_bmn_shd.g_old_rec.pgm_id;
303: End If;
304: If (p_rec.pl_id = hr_api.g_number) then

Line 304: If (p_rec.pl_id = hr_api.g_number) then

300: If (p_rec.pgm_id = hr_api.g_number) then
301: p_rec.pgm_id :=
302: ben_bmn_shd.g_old_rec.pgm_id;
303: End If;
304: If (p_rec.pl_id = hr_api.g_number) then
305: p_rec.pl_id :=
306: ben_bmn_shd.g_old_rec.pl_id;
307: End If;
308: If (p_rec.related_person_id = hr_api.g_number) then

Line 308: If (p_rec.related_person_id = hr_api.g_number) then

304: If (p_rec.pl_id = hr_api.g_number) then
305: p_rec.pl_id :=
306: ben_bmn_shd.g_old_rec.pl_id;
307: End If;
308: If (p_rec.related_person_id = hr_api.g_number) then
309: p_rec.related_person_id :=
310: ben_bmn_shd.g_old_rec.related_person_id;
311: End If;
312: If (p_rec.oipl_id = hr_api.g_number) then

Line 312: If (p_rec.oipl_id = hr_api.g_number) then

308: If (p_rec.related_person_id = hr_api.g_number) then
309: p_rec.related_person_id :=
310: ben_bmn_shd.g_old_rec.related_person_id;
311: End If;
312: If (p_rec.oipl_id = hr_api.g_number) then
313: p_rec.oipl_id :=
314: ben_bmn_shd.g_old_rec.oipl_id;
315: End If;
316: If (p_rec.pl_typ_id = hr_api.g_number) then

Line 316: If (p_rec.pl_typ_id = hr_api.g_number) then

312: If (p_rec.oipl_id = hr_api.g_number) then
313: p_rec.oipl_id :=
314: ben_bmn_shd.g_old_rec.oipl_id;
315: End If;
316: If (p_rec.pl_typ_id = hr_api.g_number) then
317: p_rec.pl_typ_id :=
318: ben_bmn_shd.g_old_rec.pl_typ_id;
319: End If;
320:

Line 321: If (p_rec.actl_prem_id = hr_api.g_number) then

317: p_rec.pl_typ_id :=
318: ben_bmn_shd.g_old_rec.pl_typ_id;
319: End If;
320:
321: If (p_rec.actl_prem_id = hr_api.g_number) then
322: p_rec.actl_prem_id :=
323: ben_bmn_shd.g_old_rec.actl_prem_id;
324: End If;
325: If (p_rec.val = hr_api.g_number) then

Line 325: If (p_rec.val = hr_api.g_number) then

321: If (p_rec.actl_prem_id = hr_api.g_number) then
322: p_rec.actl_prem_id :=
323: ben_bmn_shd.g_old_rec.actl_prem_id;
324: End If;
325: If (p_rec.val = hr_api.g_number) then
326: p_rec.val :=
327: ben_bmn_shd.g_old_rec.val;
328: End If;
329: If (p_rec.mo_num = hr_api.g_number) then

Line 329: If (p_rec.mo_num = hr_api.g_number) then

325: If (p_rec.val = hr_api.g_number) then
326: p_rec.val :=
327: ben_bmn_shd.g_old_rec.val;
328: End If;
329: If (p_rec.mo_num = hr_api.g_number) then
330: p_rec.mo_num :=
331: ben_bmn_shd.g_old_rec.mo_num;
332: End If;
333: If (p_rec.yr_num = hr_api.g_number) then

Line 333: If (p_rec.yr_num = hr_api.g_number) then

329: If (p_rec.mo_num = hr_api.g_number) then
330: p_rec.mo_num :=
331: ben_bmn_shd.g_old_rec.mo_num;
332: End If;
333: If (p_rec.yr_num = hr_api.g_number) then
334: p_rec.yr_num :=
335: ben_bmn_shd.g_old_rec.yr_num;
336: End If;
337:

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

335: ben_bmn_shd.g_old_rec.yr_num;
336: End If;
337:
338:
339: If (p_rec.text = hr_api.g_varchar2) then
340: p_rec.text :=
341: ben_bmn_shd.g_old_rec.text;
342: End If;
343:

Line 398: p_benefit_action_id in number default hr_api.g_number,

394: -- ----------------------------------------------------------------------------
395: Procedure upd
396: (
397: p_reporting_id in number,
398: p_benefit_action_id in number default hr_api.g_number,
399: p_thread_id in number default hr_api.g_number,
400: p_sequence in number default hr_api.g_number,
401: p_text in varchar2 default hr_api.g_varchar2,
402: p_rep_typ_cd in varchar2 default hr_api.g_varchar2,

Line 399: p_thread_id in number default hr_api.g_number,

395: Procedure upd
396: (
397: p_reporting_id in number,
398: p_benefit_action_id in number default hr_api.g_number,
399: p_thread_id in number default hr_api.g_number,
400: p_sequence in number default hr_api.g_number,
401: p_text in varchar2 default hr_api.g_varchar2,
402: p_rep_typ_cd in varchar2 default hr_api.g_varchar2,
403: p_error_message_code in varchar2 default hr_api.g_varchar2,

Line 400: p_sequence in number default hr_api.g_number,

396: (
397: p_reporting_id in number,
398: p_benefit_action_id in number default hr_api.g_number,
399: p_thread_id in number default hr_api.g_number,
400: p_sequence in number default hr_api.g_number,
401: p_text in varchar2 default hr_api.g_varchar2,
402: p_rep_typ_cd in varchar2 default hr_api.g_varchar2,
403: p_error_message_code in varchar2 default hr_api.g_varchar2,
404: p_national_identifier in varchar2 default hr_api.g_varchar2,

Line 401: p_text in varchar2 default hr_api.g_varchar2,

397: p_reporting_id in number,
398: p_benefit_action_id in number default hr_api.g_number,
399: p_thread_id in number default hr_api.g_number,
400: p_sequence in number default hr_api.g_number,
401: p_text in varchar2 default hr_api.g_varchar2,
402: p_rep_typ_cd in varchar2 default hr_api.g_varchar2,
403: p_error_message_code in varchar2 default hr_api.g_varchar2,
404: p_national_identifier in varchar2 default hr_api.g_varchar2,
405: p_related_person_ler_id in number default hr_api.g_number,

Line 402: p_rep_typ_cd in varchar2 default hr_api.g_varchar2,

398: p_benefit_action_id in number default hr_api.g_number,
399: p_thread_id in number default hr_api.g_number,
400: p_sequence in number default hr_api.g_number,
401: p_text in varchar2 default hr_api.g_varchar2,
402: p_rep_typ_cd in varchar2 default hr_api.g_varchar2,
403: p_error_message_code in varchar2 default hr_api.g_varchar2,
404: p_national_identifier in varchar2 default hr_api.g_varchar2,
405: p_related_person_ler_id in number default hr_api.g_number,
406: p_temporal_ler_id in number default hr_api.g_number,

Line 403: p_error_message_code in varchar2 default hr_api.g_varchar2,

399: p_thread_id in number default hr_api.g_number,
400: p_sequence in number default hr_api.g_number,
401: p_text in varchar2 default hr_api.g_varchar2,
402: p_rep_typ_cd in varchar2 default hr_api.g_varchar2,
403: p_error_message_code in varchar2 default hr_api.g_varchar2,
404: p_national_identifier in varchar2 default hr_api.g_varchar2,
405: p_related_person_ler_id in number default hr_api.g_number,
406: p_temporal_ler_id in number default hr_api.g_number,
407: p_ler_id in number default hr_api.g_number,

Line 404: p_national_identifier in varchar2 default hr_api.g_varchar2,

400: p_sequence in number default hr_api.g_number,
401: p_text in varchar2 default hr_api.g_varchar2,
402: p_rep_typ_cd in varchar2 default hr_api.g_varchar2,
403: p_error_message_code in varchar2 default hr_api.g_varchar2,
404: p_national_identifier in varchar2 default hr_api.g_varchar2,
405: p_related_person_ler_id in number default hr_api.g_number,
406: p_temporal_ler_id in number default hr_api.g_number,
407: p_ler_id in number default hr_api.g_number,
408: p_person_id in number default hr_api.g_number,

Line 405: p_related_person_ler_id in number default hr_api.g_number,

401: p_text in varchar2 default hr_api.g_varchar2,
402: p_rep_typ_cd in varchar2 default hr_api.g_varchar2,
403: p_error_message_code in varchar2 default hr_api.g_varchar2,
404: p_national_identifier in varchar2 default hr_api.g_varchar2,
405: p_related_person_ler_id in number default hr_api.g_number,
406: p_temporal_ler_id in number default hr_api.g_number,
407: p_ler_id in number default hr_api.g_number,
408: p_person_id in number default hr_api.g_number,
409: p_pgm_id in number default hr_api.g_number,

Line 406: p_temporal_ler_id in number default hr_api.g_number,

402: p_rep_typ_cd in varchar2 default hr_api.g_varchar2,
403: p_error_message_code in varchar2 default hr_api.g_varchar2,
404: p_national_identifier in varchar2 default hr_api.g_varchar2,
405: p_related_person_ler_id in number default hr_api.g_number,
406: p_temporal_ler_id in number default hr_api.g_number,
407: p_ler_id in number default hr_api.g_number,
408: p_person_id in number default hr_api.g_number,
409: p_pgm_id in number default hr_api.g_number,
410: p_pl_id in number default hr_api.g_number,

Line 407: p_ler_id in number default hr_api.g_number,

403: p_error_message_code in varchar2 default hr_api.g_varchar2,
404: p_national_identifier in varchar2 default hr_api.g_varchar2,
405: p_related_person_ler_id in number default hr_api.g_number,
406: p_temporal_ler_id in number default hr_api.g_number,
407: p_ler_id in number default hr_api.g_number,
408: p_person_id in number default hr_api.g_number,
409: p_pgm_id in number default hr_api.g_number,
410: p_pl_id in number default hr_api.g_number,
411: p_related_person_id in number default hr_api.g_number,

Line 408: p_person_id in number default hr_api.g_number,

404: p_national_identifier in varchar2 default hr_api.g_varchar2,
405: p_related_person_ler_id in number default hr_api.g_number,
406: p_temporal_ler_id in number default hr_api.g_number,
407: p_ler_id in number default hr_api.g_number,
408: p_person_id in number default hr_api.g_number,
409: p_pgm_id in number default hr_api.g_number,
410: p_pl_id in number default hr_api.g_number,
411: p_related_person_id in number default hr_api.g_number,
412: p_oipl_id in number default hr_api.g_number,

Line 409: p_pgm_id in number default hr_api.g_number,

405: p_related_person_ler_id in number default hr_api.g_number,
406: p_temporal_ler_id in number default hr_api.g_number,
407: p_ler_id in number default hr_api.g_number,
408: p_person_id in number default hr_api.g_number,
409: p_pgm_id in number default hr_api.g_number,
410: p_pl_id in number default hr_api.g_number,
411: p_related_person_id in number default hr_api.g_number,
412: p_oipl_id in number default hr_api.g_number,
413: p_pl_typ_id in number default hr_api.g_number,

Line 410: p_pl_id in number default hr_api.g_number,

406: p_temporal_ler_id in number default hr_api.g_number,
407: p_ler_id in number default hr_api.g_number,
408: p_person_id in number default hr_api.g_number,
409: p_pgm_id in number default hr_api.g_number,
410: p_pl_id in number default hr_api.g_number,
411: p_related_person_id in number default hr_api.g_number,
412: p_oipl_id in number default hr_api.g_number,
413: p_pl_typ_id in number default hr_api.g_number,
414: p_actl_prem_id in number default hr_api.g_number,

Line 411: p_related_person_id in number default hr_api.g_number,

407: p_ler_id in number default hr_api.g_number,
408: p_person_id in number default hr_api.g_number,
409: p_pgm_id in number default hr_api.g_number,
410: p_pl_id in number default hr_api.g_number,
411: p_related_person_id in number default hr_api.g_number,
412: p_oipl_id in number default hr_api.g_number,
413: p_pl_typ_id in number default hr_api.g_number,
414: p_actl_prem_id in number default hr_api.g_number,
415: p_val in number default hr_api.g_number,

Line 412: p_oipl_id in number default hr_api.g_number,

408: p_person_id in number default hr_api.g_number,
409: p_pgm_id in number default hr_api.g_number,
410: p_pl_id in number default hr_api.g_number,
411: p_related_person_id in number default hr_api.g_number,
412: p_oipl_id in number default hr_api.g_number,
413: p_pl_typ_id in number default hr_api.g_number,
414: p_actl_prem_id in number default hr_api.g_number,
415: p_val in number default hr_api.g_number,
416: p_mo_num in number default hr_api.g_number,

Line 413: p_pl_typ_id in number default hr_api.g_number,

409: p_pgm_id in number default hr_api.g_number,
410: p_pl_id in number default hr_api.g_number,
411: p_related_person_id in number default hr_api.g_number,
412: p_oipl_id in number default hr_api.g_number,
413: p_pl_typ_id in number default hr_api.g_number,
414: p_actl_prem_id in number default hr_api.g_number,
415: p_val in number default hr_api.g_number,
416: p_mo_num in number default hr_api.g_number,
417: p_yr_num in number default hr_api.g_number,

Line 414: p_actl_prem_id in number default hr_api.g_number,

410: p_pl_id in number default hr_api.g_number,
411: p_related_person_id in number default hr_api.g_number,
412: p_oipl_id in number default hr_api.g_number,
413: p_pl_typ_id in number default hr_api.g_number,
414: p_actl_prem_id in number default hr_api.g_number,
415: p_val in number default hr_api.g_number,
416: p_mo_num in number default hr_api.g_number,
417: p_yr_num in number default hr_api.g_number,
418: p_object_version_number in out nocopy number

Line 415: p_val in number default hr_api.g_number,

411: p_related_person_id in number default hr_api.g_number,
412: p_oipl_id in number default hr_api.g_number,
413: p_pl_typ_id in number default hr_api.g_number,
414: p_actl_prem_id in number default hr_api.g_number,
415: p_val in number default hr_api.g_number,
416: p_mo_num in number default hr_api.g_number,
417: p_yr_num in number default hr_api.g_number,
418: p_object_version_number in out nocopy number
419: ) is

Line 416: p_mo_num in number default hr_api.g_number,

412: p_oipl_id in number default hr_api.g_number,
413: p_pl_typ_id in number default hr_api.g_number,
414: p_actl_prem_id in number default hr_api.g_number,
415: p_val in number default hr_api.g_number,
416: p_mo_num in number default hr_api.g_number,
417: p_yr_num in number default hr_api.g_number,
418: p_object_version_number in out nocopy number
419: ) is
420: --

Line 417: p_yr_num in number default hr_api.g_number,

413: p_pl_typ_id in number default hr_api.g_number,
414: p_actl_prem_id in number default hr_api.g_number,
415: p_val in number default hr_api.g_number,
416: p_mo_num in number default hr_api.g_number,
417: p_yr_num in number default hr_api.g_number,
418: p_object_version_number in out nocopy number
419: ) is
420: --
421: l_rec ben_bmn_shd.g_rec_type;