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_DEL dependencies on BEN_PEI_SHD

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

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_pei_shd.g_rec_type,
55: p_effective_date in date,
56: p_datetrack_mode in varchar2,
57: p_validation_start_date in date,
58: p_validation_end_date in date) is

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

62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: ben_pei_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

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

71: delete from ben_pl_extract_identifier_f
72: where pl_extract_identifier_id = p_rec.pl_extract_identifier_id
73: and effective_start_date = p_validation_start_date;
74: --
75: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_pei_shd.g_api_dml := true; -- Set the api dml status
79: --

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

74: --
75: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_pei_shd.g_api_dml := true; -- Set the api dml status
79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.
82: --

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

83: delete from ben_pl_extract_identifier_f
84: where pl_extract_identifier_id = p_rec.pl_extract_identifier_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
88: End If;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --

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

90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --
92: Exception
93: When Others Then
94: ben_pei_shd.g_api_dml := false; -- Unset the api dml status
95: Raise;
96: End dt_delete_dml;
97: --
98: -- ----------------------------------------------------------------------------

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

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy ben_pei_shd.g_rec_type,
103: p_effective_date in date,
104: p_datetrack_mode in varchar2,
105: p_validation_start_date in date,
106: p_validation_end_date in date) is

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

152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure dt_pre_delete
156: (p_rec in out nocopy ben_pei_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) is

Line 169: p_rec.effective_start_date := ben_pei_shd.g_old_rec.effective_start_date;

165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: If (p_datetrack_mode <> 'ZAP') then
168: --
169: p_rec.effective_start_date := ben_pei_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = 'DELETE') then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else

Line 179: ben_pei_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ben_pei_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date,
181: p_base_key_value => p_rec.pl_extract_identifier_id,
182: p_new_effective_end_date => p_rec.effective_end_date,
183: p_validation_start_date => p_validation_start_date,

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

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

Line 285: (p_rec in ben_pei_shd.g_rec_type,

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_pei_shd.g_rec_type,
286: p_effective_date in date,
287: p_datetrack_mode in varchar2,
288: p_validation_start_date in date,
289: p_validation_end_date in date) is

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

305: ,p_validation_start_date => p_validation_start_date
306: ,p_validation_end_date => p_validation_end_date
307: ,p_effective_start_date => p_rec.effective_start_date
308: ,p_effective_end_date => p_rec.effective_end_date
309: ,p_pl_id_o => ben_pei_shd.g_old_rec.pl_id
310: ,p_plip_id_o => ben_pei_shd.g_old_rec.plip_id
311: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id
312: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
313: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id

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

306: ,p_validation_end_date => p_validation_end_date
307: ,p_effective_start_date => p_rec.effective_start_date
308: ,p_effective_end_date => p_rec.effective_end_date
309: ,p_pl_id_o => ben_pei_shd.g_old_rec.pl_id
310: ,p_plip_id_o => ben_pei_shd.g_old_rec.plip_id
311: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id
312: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
313: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
314: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id

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

307: ,p_effective_start_date => p_rec.effective_start_date
308: ,p_effective_end_date => p_rec.effective_end_date
309: ,p_pl_id_o => ben_pei_shd.g_old_rec.pl_id
310: ,p_plip_id_o => ben_pei_shd.g_old_rec.plip_id
311: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id
312: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
313: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
314: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
315: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id

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

308: ,p_effective_end_date => p_rec.effective_end_date
309: ,p_pl_id_o => ben_pei_shd.g_old_rec.pl_id
310: ,p_plip_id_o => ben_pei_shd.g_old_rec.plip_id
311: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id
312: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
313: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
314: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
315: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
316: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id

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

309: ,p_pl_id_o => ben_pei_shd.g_old_rec.pl_id
310: ,p_plip_id_o => ben_pei_shd.g_old_rec.plip_id
311: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id
312: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
313: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
314: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
315: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
316: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
317: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id

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

310: ,p_plip_id_o => ben_pei_shd.g_old_rec.plip_id
311: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id
312: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
313: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
314: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
315: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
316: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
317: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
318: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id

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

311: ,p_oipl_id_o => ben_pei_shd.g_old_rec.oipl_id
312: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
313: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
314: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
315: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
316: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
317: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
318: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
319: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state

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

312: ,p_third_party_identifier_o => ben_pei_shd.g_old_rec.third_party_identifier
313: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
314: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
315: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
316: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
317: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
318: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
319: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
320: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip

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

313: ,p_organization_id_o => ben_pei_shd.g_old_rec.organization_id
314: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
315: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
316: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
317: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
318: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
319: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
320: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
321: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date

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

314: ,p_job_id_o => ben_pei_shd.g_old_rec.job_id
315: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
316: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
317: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
318: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
319: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
320: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
321: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date
322: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date

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

315: ,p_position_id_o => ben_pei_shd.g_old_rec.position_id
316: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
317: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
318: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
319: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
320: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
321: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date
322: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date
323: ,p_object_version_number_o => ben_pei_shd.g_old_rec.object_version_number

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

316: ,p_people_group_id_o => ben_pei_shd.g_old_rec.people_group_id
317: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
318: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
319: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
320: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
321: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date
322: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date
323: ,p_object_version_number_o => ben_pei_shd.g_old_rec.object_version_number
324: ,p_business_group_id_o => ben_pei_shd.g_old_rec.business_group_id

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

317: ,p_grade_id_o => ben_pei_shd.g_old_rec.grade_id
318: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
319: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
320: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
321: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date
322: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date
323: ,p_object_version_number_o => ben_pei_shd.g_old_rec.object_version_number
324: ,p_business_group_id_o => ben_pei_shd.g_old_rec.business_group_id
325: );

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

318: ,p_payroll_id_o => ben_pei_shd.g_old_rec.payroll_id
319: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
320: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
321: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date
322: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date
323: ,p_object_version_number_o => ben_pei_shd.g_old_rec.object_version_number
324: ,p_business_group_id_o => ben_pei_shd.g_old_rec.business_group_id
325: );
326: --

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

319: ,p_home_state_o => ben_pei_shd.g_old_rec.home_state
320: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
321: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date
322: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date
323: ,p_object_version_number_o => ben_pei_shd.g_old_rec.object_version_number
324: ,p_business_group_id_o => ben_pei_shd.g_old_rec.business_group_id
325: );
326: --
327: exception

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

320: ,p_home_zip_o => ben_pei_shd.g_old_rec.home_zip
321: ,p_effective_start_date_o => ben_pei_shd.g_old_rec.effective_start_date
322: ,p_effective_end_date_o => ben_pei_shd.g_old_rec.effective_end_date
323: ,p_object_version_number_o => ben_pei_shd.g_old_rec.object_version_number
324: ,p_business_group_id_o => ben_pei_shd.g_old_rec.business_group_id
325: );
326: --
327: exception
328: --

Line 347: p_rec in out nocopy ben_pei_shd.g_rec_type,

343: -- |---------------------------------< del >----------------------------------|
344: -- ----------------------------------------------------------------------------
345: Procedure del
346: (
347: p_rec in out nocopy ben_pei_shd.g_rec_type,
348: p_effective_date in date,
349: p_datetrack_mode in varchar2
350: ) is
351: --

Line 365: ben_pei_shd.lck

361: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
362: --
363: -- We must lock the row which we need to delete.
364: --
365: ben_pei_shd.lck
366: (p_effective_date => p_effective_date,
367: p_datetrack_mode => p_datetrack_mode,
368: p_pl_extract_identifier_id => p_rec.pl_extract_identifier_id,
369: p_object_version_number => p_rec.object_version_number,

Line 423: l_rec ben_pei_shd.g_rec_type;

419: p_effective_date in date,
420: p_datetrack_mode in varchar2
421: ) is
422: --
423: l_rec ben_pei_shd.g_rec_type;
424: l_proc varchar2(72) := g_package||'del';
425: --
426: Begin
427: hr_utility.set_location('Entering:'||l_proc, 5);