APPS.GHR_DUT_DEL dependencies on GHR_DUT_SHD

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

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ghr_dut_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: ghr_dut_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: ghr_dut_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 76: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status

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

Line 79: ghr_dut_shd.g_api_dml := true; -- Set the api dml status

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

Line 89: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status

85: delete from ghr_duty_stations_f
86: where duty_station_id = p_rec.duty_station_id
87: and effective_start_date >= p_validation_start_date;
88: --
89: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
90: End If;
91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 20);
93: --

Line 96: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status

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

Line 104: (p_rec in out nocopy ghr_dut_shd.g_rec_type,

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

Line 158: (p_rec in out nocopy ghr_dut_shd.g_rec_type,

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

Line 171: p_rec.effective_start_date := ghr_dut_shd.g_old_rec.effective_start_date;

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

Line 181: ghr_dut_shd.upd_effective_end_date

177: End If;
178: --
179: -- Update the current effective end date record
180: --
181: ghr_dut_shd.upd_effective_end_date
182: (p_effective_date => p_effective_date,
183: p_base_key_value => p_rec.duty_station_id,
184: p_new_effective_end_date => p_rec.effective_end_date,
185: p_validation_start_date => p_validation_start_date,

Line 229: (p_rec in out nocopy ghr_dut_shd.g_rec_type,

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

Line 287: (p_rec in ghr_dut_shd.g_rec_type,

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

Line 310: p_rec in out nocopy ghr_dut_shd.g_rec_type,

306: -- |---------------------------------< del >----------------------------------|
307: -- ----------------------------------------------------------------------------
308: Procedure del
309: (
310: p_rec in out nocopy ghr_dut_shd.g_rec_type,
311: p_effective_date in date,
312: p_datetrack_mode in varchar2
313: ) is
314: --

Line 328: ghr_dut_shd.lck

324: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
325: --
326: -- We must lock the row which we need to delete.
327: --
328: ghr_dut_shd.lck
329: (p_effective_date => p_effective_date,
330: p_datetrack_mode => p_datetrack_mode,
331: p_duty_station_id => p_rec.duty_station_id,
332: p_object_version_number => p_rec.object_version_number,

Line 387: l_rec ghr_dut_shd.g_rec_type;

383: p_effective_date in date,
384: p_datetrack_mode in varchar2
385: ) is
386: --
387: l_rec ghr_dut_shd.g_rec_type;
388: l_proc varchar2(72) := g_package||'del';
389: --
390: Begin
391: hr_utility.set_location('Entering:'||l_proc, 5);