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.BEN_PEI_UPD dependencies on BEN_PEI_SHD

Line 58: (p_rec in out nocopy ben_pei_shd.g_rec_type,

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_pei_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) is

Line 81: ben_pei_shd.g_api_dml := true; -- Set the api dml status

77: (p_base_table_name => 'ben_pl_extract_identifier_f',
78: p_base_key_column => 'pl_extract_identifier_id',
79: p_base_key_value => p_rec.pl_extract_identifier_id);
80: --
81: ben_pei_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_pl_f Row
84: --
85: update ben_pl_extract_identifier_f

Line 105: ben_pei_shd.g_api_dml := false; -- Unset the api dml status

101: where pl_extract_identifier_id = p_rec.pl_extract_identifier_id
102: and effective_start_date = p_validation_start_date
103: and effective_end_date = p_validation_end_date;
104: --
105: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
106: --
107: -- Set the effective start and end dates
108: --
109: p_rec.effective_start_date := p_validation_start_date;

Line 117: ben_pei_shd.g_api_dml := false; -- Unset the api dml status

113: hr_utility.set_location(' Leaving:'||l_proc, 15);
114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
118: ben_pei_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated

Line 118: ben_pei_shd.constraint_error

114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
118: ben_pei_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: ben_pei_shd.g_api_dml := false; -- Unset the api dml status

Line 122: ben_pei_shd.g_api_dml := false; -- Unset the api dml status

118: ben_pei_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
123: ben_pei_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: ben_pei_shd.g_api_dml := false; -- Unset the api dml status

Line 123: ben_pei_shd.constraint_error

119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
123: ben_pei_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
127: Raise;

Line 126: ben_pei_shd.g_api_dml := false; -- Unset the api dml status

122: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
123: ben_pei_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
127: Raise;
128: End dt_update_dml;
129: --
130: -- ----------------------------------------------------------------------------

Line 162: (p_rec in out nocopy ben_pei_shd.g_rec_type,

158: --
159: -- {End Of Comments}
160: -- ----------------------------------------------------------------------------
161: Procedure update_dml
162: (p_rec in out nocopy ben_pei_shd.g_rec_type,
163: p_effective_date in date,
164: p_datetrack_mode in varchar2,
165: p_validation_start_date in date,
166: p_validation_end_date in date) is

Line 226: (p_rec in out nocopy ben_pei_shd.g_rec_type,

222: --
223: -- {End Of Comments}
224: -- ----------------------------------------------------------------------------
225: Procedure dt_pre_update
226: (p_rec in out nocopy ben_pei_shd.g_rec_type,
227: p_effective_date in date,
228: p_datetrack_mode in varchar2,
229: p_validation_start_date in date,
230: p_validation_end_date in date) is

Line 242: ben_pei_shd.upd_effective_end_date

238: hr_utility.set_location(l_proc, 10);
239: --
240: -- Update the current effective end date
241: --
242: ben_pei_shd.upd_effective_end_date
243: (p_effective_date => p_effective_date,
244: p_base_key_value => p_rec.pl_extract_identifier_id,
245: p_new_effective_end_date => (p_validation_start_date - 1),
246: p_validation_start_date => p_validation_start_date,

Line 312: (p_rec in out nocopy ben_pei_shd.g_rec_type,

308: --
309: -- {End Of Comments}
310: -- ----------------------------------------------------------------------------
311: Procedure pre_update
312: (p_rec in out nocopy ben_pei_shd.g_rec_type,
313: p_effective_date in date,
314: p_datetrack_mode in varchar2,
315: p_validation_start_date in date,
316: p_validation_end_date in date) is

Line 368: (p_rec in ben_pei_shd.g_rec_type,

364: --
365: -- {End Of Comments}
366: -- ----------------------------------------------------------------------------
367: Procedure post_update
368: (p_rec in ben_pei_shd.g_rec_type,
369: p_effective_date in date,
370: p_datetrack_mode in varchar2,
371: p_validation_start_date in date,
372: p_validation_end_date in date) is

Line 407: ,p_pl_id_o => ben_pei_shd.g_old_rec.pl_id

403: ,p_effective_date => p_effective_date
404: ,p_datetrack_mode => p_datetrack_mode
405: ,p_validation_start_date => p_validation_start_date
406: ,p_validation_end_date => p_validation_end_date
407: ,p_pl_id_o => ben_pei_shd.g_old_rec.pl_id
408: ,p_plip_id_o => ben_pei_shd.g_old_rec.plip_id
409: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id
410: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
411: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id

Line 408: ,p_plip_id_o => ben_pei_shd.g_old_rec.plip_id

404: ,p_datetrack_mode => p_datetrack_mode
405: ,p_validation_start_date => p_validation_start_date
406: ,p_validation_end_date => p_validation_end_date
407: ,p_pl_id_o => ben_pei_shd.g_old_rec.pl_id
408: ,p_plip_id_o => ben_pei_shd.g_old_rec.plip_id
409: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id
410: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
411: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
412: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id

Line 409: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id

405: ,p_validation_start_date => p_validation_start_date
406: ,p_validation_end_date => p_validation_end_date
407: ,p_pl_id_o => ben_pei_shd.g_old_rec.pl_id
408: ,p_plip_id_o => ben_pei_shd.g_old_rec.plip_id
409: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id
410: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
411: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
412: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
413: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id

Line 410: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier

406: ,p_validation_end_date => p_validation_end_date
407: ,p_pl_id_o => ben_pei_shd.g_old_rec.pl_id
408: ,p_plip_id_o => ben_pei_shd.g_old_rec.plip_id
409: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id
410: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
411: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
412: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
413: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
414: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id

Line 411: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id

407: ,p_pl_id_o => ben_pei_shd.g_old_rec.pl_id
408: ,p_plip_id_o => ben_pei_shd.g_old_rec.plip_id
409: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id
410: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
411: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
412: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
413: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
414: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
415: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id

Line 412: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id

408: ,p_plip_id_o => ben_pei_shd.g_old_rec.plip_id
409: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id
410: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
411: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
412: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
413: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
414: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
415: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
416: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id

Line 413: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id

409: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id
410: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
411: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
412: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
413: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
414: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
415: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
416: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
417: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state

Line 414: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id

410: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
411: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
412: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
413: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
414: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
415: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
416: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
417: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
418: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip

Line 415: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id

411: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
412: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
413: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
414: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
415: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
416: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
417: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
418: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
419: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date

Line 416: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id

412: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
413: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
414: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
415: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
416: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
417: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
418: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
419: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date
420: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date

Line 417: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state

413: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
414: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
415: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
416: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
417: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
418: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
419: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date
420: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date
421: ,p_object_version_number_o => ben_pei_shd.g_old_rec.object_version_number

Line 418: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip

414: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
415: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
416: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
417: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
418: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
419: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date
420: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date
421: ,p_object_version_number_o => ben_pei_shd.g_old_rec.object_version_number
422: ,p_business_group_id_o => ben_pei_shd.g_old_rec.business_group_id

Line 419: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date

415: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
416: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
417: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
418: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
419: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date
420: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date
421: ,p_object_version_number_o => ben_pei_shd.g_old_rec.object_version_number
422: ,p_business_group_id_o => ben_pei_shd.g_old_rec.business_group_id
423: );

Line 420: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date

416: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
417: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
418: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
419: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date
420: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date
421: ,p_object_version_number_o => ben_pei_shd.g_old_rec.object_version_number
422: ,p_business_group_id_o => ben_pei_shd.g_old_rec.business_group_id
423: );
424: --

Line 421: ,p_object_version_number_o => ben_pei_shd.g_old_rec.object_version_number

417: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
418: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
419: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date
420: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date
421: ,p_object_version_number_o => ben_pei_shd.g_old_rec.object_version_number
422: ,p_business_group_id_o => ben_pei_shd.g_old_rec.business_group_id
423: );
424: --
425: exception

Line 422: ,p_business_group_id_o => ben_pei_shd.g_old_rec.business_group_id

418: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
419: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date
420: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date
421: ,p_object_version_number_o => ben_pei_shd.g_old_rec.object_version_number
422: ,p_business_group_id_o => ben_pei_shd.g_old_rec.business_group_id
423: );
424: --
425: exception
426: --

Line 446: p_rec in out nocopy ben_pei_shd.g_rec_type,

442: -- |---------------------------------< upd >----------------------------------|
443: -- ----------------------------------------------------------------------------
444: Procedure upd
445: (
446: p_rec in out nocopy ben_pei_shd.g_rec_type,
447: p_effective_date in date,
448: p_datetrack_mode in varchar2
449: ) is
450: --

Line 464: ben_pei_shd.lck

460: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
461: --
462: -- We must lock the row which we need to update.
463: --
464: ben_pei_shd.lck
465: (p_effective_date => p_effective_date,
466: p_datetrack_mode => p_datetrack_mode,
467: p_pl_extract_identifier_id => p_rec.pl_extract_identifier_id,
468: p_object_version_number => p_rec.object_version_number,

Line 540: l_rec ben_pei_shd.g_rec_type;

536: p_effective_date in date,
537: p_datetrack_mode in varchar2
538: ) is
539: --
540: l_rec ben_pei_shd.g_rec_type;
541: l_proc varchar2(72) := g_package||'upd';
542: --
543: Begin
544: hr_utility.set_location('Entering:'||l_proc, 5);

Line 550: ben_pei_shd.convert_args

546: -- Call conversion function to turn arguments into the
547: -- l_rec structure.
548: --
549: l_rec :=
550: ben_pei_shd.convert_args
551: (
552: p_pl_extract_identifier_id
553: ,p_pl_id
554: ,p_plip_id