DBA Data[Home] [Help]

APPS.PER_PGS_DEL dependencies on PER_PGS_SHD

Line 54: (p_rec in out nocopy per_pgs_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy per_pgs_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

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

62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: per_pgs_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: per_pgs_shd.g_api_dml := false; -- Unset the api dml status

71: delete from per_grade_spines_f
72: where grade_spine_id = p_rec.grade_spine_id
73: and effective_start_date = p_validation_start_date;
74: --
75: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: per_pgs_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than

Line 77: per_pgs_shd.g_api_dml := true; -- Set the api dml status

73: and effective_start_date = p_validation_start_date;
74: --
75: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: per_pgs_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than
80: -- or equal to the validation start date.
81: --

Line 86: per_pgs_shd.g_api_dml := false; -- Unset the api dml status

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

Line 93: per_pgs_shd.g_api_dml := false; -- Unset the api dml status

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

Line 102: (p_rec in out nocopy per_pgs_shd.g_rec_type

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy per_pgs_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

Line 159: (p_rec in out nocopy per_pgs_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure dt_pre_delete
159: (p_rec in out nocopy per_pgs_shd.g_rec_type
160: ,p_effective_date in date
161: ,p_datetrack_mode in varchar2
162: ,p_validation_start_date in date
163: ,p_validation_end_date in date

Line 174: := per_pgs_shd.g_old_rec.effective_start_date;

170: --
171: If (p_datetrack_mode <> hr_api.g_zap) then
172: --
173: p_rec.effective_start_date
174: := per_pgs_shd.g_old_rec.effective_start_date;
175: --
176: If (p_datetrack_mode = hr_api.g_delete) then
177: p_rec.effective_end_date := p_validation_start_date - 1;
178: Else

Line 184: per_pgs_shd.upd_effective_end_date

180: End If;
181: --
182: -- Update the current effective end date record
183: --
184: per_pgs_shd.upd_effective_end_date
185: (p_effective_date => p_effective_date
186: ,p_base_key_value => p_rec.grade_spine_id
187: ,p_new_effective_end_date => p_rec.effective_end_date
188: ,p_validation_start_date => p_validation_start_date

Line 233: (p_rec in out nocopy per_pgs_shd.g_rec_type

229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure pre_delete
233: (p_rec in out nocopy per_pgs_shd.g_rec_type
234: ,p_effective_date in date
235: ,p_datetrack_mode in varchar2
236: ,p_validation_start_date in date
237: ,p_validation_end_date in date

Line 293: (p_rec in per_pgs_shd.g_rec_type

289: --
290: -- {End Of Comments}
291: -- ----------------------------------------------------------------------------
292: Procedure post_delete
293: (p_rec in per_pgs_shd.g_rec_type
294: ,p_effective_date in date
295: ,p_datetrack_mode in varchar2
296: ,p_validation_start_date in date
297: ,p_validation_end_date in date

Line 322: => per_pgs_shd.g_old_rec.effective_start_date

318: => p_rec.effective_start_date
319: ,p_effective_end_date
320: => p_rec.effective_end_date
321: ,p_effective_start_date_o
322: => per_pgs_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => per_pgs_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => per_pgs_shd.g_old_rec.business_group_id

Line 324: => per_pgs_shd.g_old_rec.effective_end_date

320: => p_rec.effective_end_date
321: ,p_effective_start_date_o
322: => per_pgs_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => per_pgs_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => per_pgs_shd.g_old_rec.business_group_id
327: ,p_parent_spine_id_o
328: => per_pgs_shd.g_old_rec.parent_spine_id

Line 326: => per_pgs_shd.g_old_rec.business_group_id

322: => per_pgs_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => per_pgs_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => per_pgs_shd.g_old_rec.business_group_id
327: ,p_parent_spine_id_o
328: => per_pgs_shd.g_old_rec.parent_spine_id
329: ,p_grade_id_o
330: => per_pgs_shd.g_old_rec.grade_id

Line 328: => per_pgs_shd.g_old_rec.parent_spine_id

324: => per_pgs_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => per_pgs_shd.g_old_rec.business_group_id
327: ,p_parent_spine_id_o
328: => per_pgs_shd.g_old_rec.parent_spine_id
329: ,p_grade_id_o
330: => per_pgs_shd.g_old_rec.grade_id
331: ,p_ceiling_step_id_o
332: => per_pgs_shd.g_old_rec.ceiling_step_id

Line 330: => per_pgs_shd.g_old_rec.grade_id

326: => per_pgs_shd.g_old_rec.business_group_id
327: ,p_parent_spine_id_o
328: => per_pgs_shd.g_old_rec.parent_spine_id
329: ,p_grade_id_o
330: => per_pgs_shd.g_old_rec.grade_id
331: ,p_ceiling_step_id_o
332: => per_pgs_shd.g_old_rec.ceiling_step_id
333: ,p_request_id_o
334: => per_pgs_shd.g_old_rec.request_id

Line 332: => per_pgs_shd.g_old_rec.ceiling_step_id

328: => per_pgs_shd.g_old_rec.parent_spine_id
329: ,p_grade_id_o
330: => per_pgs_shd.g_old_rec.grade_id
331: ,p_ceiling_step_id_o
332: => per_pgs_shd.g_old_rec.ceiling_step_id
333: ,p_request_id_o
334: => per_pgs_shd.g_old_rec.request_id
335: ,p_program_application_id_o
336: => per_pgs_shd.g_old_rec.program_application_id

Line 334: => per_pgs_shd.g_old_rec.request_id

330: => per_pgs_shd.g_old_rec.grade_id
331: ,p_ceiling_step_id_o
332: => per_pgs_shd.g_old_rec.ceiling_step_id
333: ,p_request_id_o
334: => per_pgs_shd.g_old_rec.request_id
335: ,p_program_application_id_o
336: => per_pgs_shd.g_old_rec.program_application_id
337: ,p_program_id_o
338: => per_pgs_shd.g_old_rec.program_id

Line 336: => per_pgs_shd.g_old_rec.program_application_id

332: => per_pgs_shd.g_old_rec.ceiling_step_id
333: ,p_request_id_o
334: => per_pgs_shd.g_old_rec.request_id
335: ,p_program_application_id_o
336: => per_pgs_shd.g_old_rec.program_application_id
337: ,p_program_id_o
338: => per_pgs_shd.g_old_rec.program_id
339: ,p_program_update_date_o
340: => per_pgs_shd.g_old_rec.program_update_date

Line 338: => per_pgs_shd.g_old_rec.program_id

334: => per_pgs_shd.g_old_rec.request_id
335: ,p_program_application_id_o
336: => per_pgs_shd.g_old_rec.program_application_id
337: ,p_program_id_o
338: => per_pgs_shd.g_old_rec.program_id
339: ,p_program_update_date_o
340: => per_pgs_shd.g_old_rec.program_update_date
341: ,p_object_version_number_o
342: => per_pgs_shd.g_old_rec.object_version_number

Line 340: => per_pgs_shd.g_old_rec.program_update_date

336: => per_pgs_shd.g_old_rec.program_application_id
337: ,p_program_id_o
338: => per_pgs_shd.g_old_rec.program_id
339: ,p_program_update_date_o
340: => per_pgs_shd.g_old_rec.program_update_date
341: ,p_object_version_number_o
342: => per_pgs_shd.g_old_rec.object_version_number
343: );
344: --

Line 342: => per_pgs_shd.g_old_rec.object_version_number

338: => per_pgs_shd.g_old_rec.program_id
339: ,p_program_update_date_o
340: => per_pgs_shd.g_old_rec.program_update_date
341: ,p_object_version_number_o
342: => per_pgs_shd.g_old_rec.object_version_number
343: );
344: --
345: exception
346: --

Line 364: ,p_rec in out nocopy per_pgs_shd.g_rec_type

360: -- ----------------------------------------------------------------------------
361: Procedure del
362: (p_effective_date in date
363: ,p_datetrack_mode in varchar2
364: ,p_rec in out nocopy per_pgs_shd.g_rec_type
365: ) is
366: --
367: l_proc varchar2(72) := g_package||'del';
368: l_validation_start_date date;

Line 380: per_pgs_shd.lck

376: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
377: --
378: -- We must lock the row which we need to delete.
379: --
380: per_pgs_shd.lck
381: (p_effective_date => p_effective_date
382: ,p_datetrack_mode => p_datetrack_mode
383: ,p_grade_spine_id => p_rec.grade_spine_id
384: ,p_object_version_number => p_rec.object_version_number

Line 449: l_rec per_pgs_shd.g_rec_type;

445: ,p_effective_start_date out nocopy date
446: ,p_effective_end_date out nocopy date
447: ) is
448: --
449: l_rec per_pgs_shd.g_rec_type;
450: l_proc varchar2(72) := g_package||'del';
451: --
452: Begin
453: hr_utility.set_location('Entering:'||l_proc, 5);