DBA Data[Home] [Help]

APPS.BEN_BEO_UPD dependencies on BEN_BEO_SHD

Line 58: (p_rec in out nocopy ben_beo_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_beo_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 112: ben_beo_shd.constraint_error

108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: --
112: ben_beo_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: --

Line 117: ben_beo_shd.constraint_error

113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: --
117: ben_beo_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: --
121: Raise;

Line 156: (p_rec in out nocopy ben_beo_shd.g_rec_type

152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure update_dml
156: (p_rec in out nocopy ben_beo_shd.g_rec_type
157: ,p_effective_date in date
158: ,p_datetrack_mode in varchar2
159: ,p_validation_start_date in date
160: ,p_validation_end_date in date

Line 223: (p_rec in out nocopy ben_beo_shd.g_rec_type

219: --
220: -- {End Of Comments}
221: -- ----------------------------------------------------------------------------
222: Procedure dt_pre_update
223: (p_rec in out nocopy ben_beo_shd.g_rec_type
224: ,p_effective_date in date
225: ,p_datetrack_mode in varchar2
226: ,p_validation_start_date in date
227: ,p_validation_end_date in date

Line 239: ben_beo_shd.upd_effective_end_date

235: If (p_datetrack_mode <> hr_api.g_correction) then
236: --
237: -- Update the current effective end date
238: --
239: ben_beo_shd.upd_effective_end_date
240: (p_effective_date => p_effective_date
241: ,p_base_key_value => p_rec.elig_obj_id
242: ,p_new_effective_end_date => (p_validation_start_date - 1)
243: ,p_validation_start_date => p_validation_start_date

Line 308: (p_rec in out nocopy ben_beo_shd.g_rec_type

304: --
305: -- {End Of Comments}
306: -- ----------------------------------------------------------------------------
307: Procedure pre_update
308: (p_rec in out nocopy ben_beo_shd.g_rec_type
309: ,p_effective_date in date
310: ,p_datetrack_mode in varchar2
311: ,p_validation_start_date in date
312: ,p_validation_end_date in date

Line 366: (p_rec in ben_beo_shd.g_rec_type

362: --
363: -- {End Of Comments}
364: -- ----------------------------------------------------------------------------
365: Procedure post_update
366: (p_rec in ben_beo_shd.g_rec_type
367: ,p_effective_date in date
368: ,p_datetrack_mode in varchar2
369: ,p_validation_start_date in date
370: ,p_validation_end_date in date

Line 405: => ben_beo_shd.g_old_rec.effective_start_date

401: => p_rec.business_group_id
402: ,p_object_version_number
403: => p_rec.object_version_number
404: ,p_effective_start_date_o
405: => ben_beo_shd.g_old_rec.effective_start_date
406: ,p_effective_end_date_o
407: => ben_beo_shd.g_old_rec.effective_end_date
408: ,p_table_name_o
409: => ben_beo_shd.g_old_rec.table_name

Line 407: => ben_beo_shd.g_old_rec.effective_end_date

403: => p_rec.object_version_number
404: ,p_effective_start_date_o
405: => ben_beo_shd.g_old_rec.effective_start_date
406: ,p_effective_end_date_o
407: => ben_beo_shd.g_old_rec.effective_end_date
408: ,p_table_name_o
409: => ben_beo_shd.g_old_rec.table_name
410: ,p_column_name_o
411: => ben_beo_shd.g_old_rec.column_name

Line 409: => ben_beo_shd.g_old_rec.table_name

405: => ben_beo_shd.g_old_rec.effective_start_date
406: ,p_effective_end_date_o
407: => ben_beo_shd.g_old_rec.effective_end_date
408: ,p_table_name_o
409: => ben_beo_shd.g_old_rec.table_name
410: ,p_column_name_o
411: => ben_beo_shd.g_old_rec.column_name
412: ,p_column_value_o
413: => ben_beo_shd.g_old_rec.column_value

Line 411: => ben_beo_shd.g_old_rec.column_name

407: => ben_beo_shd.g_old_rec.effective_end_date
408: ,p_table_name_o
409: => ben_beo_shd.g_old_rec.table_name
410: ,p_column_name_o
411: => ben_beo_shd.g_old_rec.column_name
412: ,p_column_value_o
413: => ben_beo_shd.g_old_rec.column_value
414: ,p_business_group_id_o
415: => ben_beo_shd.g_old_rec.business_group_id

Line 413: => ben_beo_shd.g_old_rec.column_value

409: => ben_beo_shd.g_old_rec.table_name
410: ,p_column_name_o
411: => ben_beo_shd.g_old_rec.column_name
412: ,p_column_value_o
413: => ben_beo_shd.g_old_rec.column_value
414: ,p_business_group_id_o
415: => ben_beo_shd.g_old_rec.business_group_id
416: ,p_object_version_number_o
417: => ben_beo_shd.g_old_rec.object_version_number

Line 415: => ben_beo_shd.g_old_rec.business_group_id

411: => ben_beo_shd.g_old_rec.column_name
412: ,p_column_value_o
413: => ben_beo_shd.g_old_rec.column_value
414: ,p_business_group_id_o
415: => ben_beo_shd.g_old_rec.business_group_id
416: ,p_object_version_number_o
417: => ben_beo_shd.g_old_rec.object_version_number
418: );
419: --

Line 417: => ben_beo_shd.g_old_rec.object_version_number

413: => ben_beo_shd.g_old_rec.column_value
414: ,p_business_group_id_o
415: => ben_beo_shd.g_old_rec.business_group_id
416: ,p_object_version_number_o
417: => ben_beo_shd.g_old_rec.object_version_number
418: );
419: --
420: exception
421: --

Line 477: (p_rec in out nocopy ben_beo_shd.g_rec_type

473: --
474: -- {End Of Comments}
475: -- ----------------------------------------------------------------------------
476: Procedure convert_defs
477: (p_rec in out nocopy ben_beo_shd.g_rec_type
478: ) is
479: --
480: Begin
481: --

Line 489: ben_beo_shd.g_old_rec.table_name;

485: -- is being used then we must set to the 'current' argument value.
486: --
487: If (p_rec.table_name = hr_api.g_varchar2) then
488: p_rec.table_name :=
489: ben_beo_shd.g_old_rec.table_name;
490: End If;
491: If (p_rec.column_name = hr_api.g_varchar2) then
492: p_rec.column_name :=
493: ben_beo_shd.g_old_rec.column_name;

Line 493: ben_beo_shd.g_old_rec.column_name;

489: ben_beo_shd.g_old_rec.table_name;
490: End If;
491: If (p_rec.column_name = hr_api.g_varchar2) then
492: p_rec.column_name :=
493: ben_beo_shd.g_old_rec.column_name;
494: End If;
495: If (p_rec.column_value = hr_api.g_varchar2) then
496: p_rec.column_value :=
497: ben_beo_shd.g_old_rec.column_value;

Line 497: ben_beo_shd.g_old_rec.column_value;

493: ben_beo_shd.g_old_rec.column_name;
494: End If;
495: If (p_rec.column_value = hr_api.g_varchar2) then
496: p_rec.column_value :=
497: ben_beo_shd.g_old_rec.column_value;
498: End If;
499: If (p_rec.business_group_id = hr_api.g_number) then
500: p_rec.business_group_id :=
501: ben_beo_shd.g_old_rec.business_group_id;

Line 501: ben_beo_shd.g_old_rec.business_group_id;

497: ben_beo_shd.g_old_rec.column_value;
498: End If;
499: If (p_rec.business_group_id = hr_api.g_number) then
500: p_rec.business_group_id :=
501: ben_beo_shd.g_old_rec.business_group_id;
502: End If;
503: --
504: End convert_defs;
505: --

Line 512: ,p_rec in out nocopy ben_beo_shd.g_rec_type

508: -- ----------------------------------------------------------------------------
509: Procedure upd
510: (p_effective_date in date
511: ,p_datetrack_mode in varchar2
512: ,p_rec in out nocopy ben_beo_shd.g_rec_type
513: ) is
514: --
515: l_proc varchar2(72) := g_package||'upd';
516: l_validation_start_date date;

Line 528: ben_beo_shd.lck

524: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
525: --
526: -- We must lock the row which we need to update.
527: --
528: ben_beo_shd.lck
529: (p_effective_date => p_effective_date
530: ,p_datetrack_mode => p_datetrack_mode
531: ,p_elig_obj_id => p_rec.elig_obj_id
532: ,p_object_version_number => p_rec.object_version_number

Line 606: l_rec ben_beo_shd.g_rec_type;

602: ,p_effective_start_date out nocopy date
603: ,p_effective_end_date out nocopy date
604: ) is
605: --
606: l_rec ben_beo_shd.g_rec_type;
607: l_proc varchar2(72) := g_package||'upd';
608: --
609: Begin
610: hr_utility.set_location('Entering:'||l_proc, 5);

Line 616: ben_beo_shd.convert_args

612: -- Call conversion function to turn arguments into the
613: -- l_rec structure.
614: --
615: l_rec :=
616: ben_beo_shd.convert_args
617: (p_elig_obj_id
618: ,null
619: ,null
620: ,p_table_name