41: -- Internal Table Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in ghr_pre_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin
58: --
59: Exception
60: When hr_api.child_integrity_violated then
61: -- Child integrity has been violated
62: ghr_pre_shd.constraint_error
63: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
64: When Others Then
65: Raise;
66: End delete_dml;
96: -- Internal Table Handler Use Only.
97: --
98: -- {End Of Comments}
99: -- ----------------------------------------------------------------------------
100: Procedure pre_delete(p_rec in ghr_pre_shd.g_rec_type) is
101: --
102: l_proc varchar2(72) := g_package||'pre_delete';
103: --
104: Begin
138: -- Internal table Handler Use Only.
139: --
140: -- {End Of Comments}
141: -- ----------------------------------------------------------------------------
142: Procedure post_delete(p_rec in ghr_pre_shd.g_rec_type) is
143: --
144: l_proc varchar2(72) := g_package||'post_delete';
145: --
146: Begin
150: --
151: begin
152: ghr_pre_rkd.after_delete (
153: p_pa_remark_id => p_rec.pa_remark_id,
154: p_pa_request_id_o => ghr_pre_shd.g_old_rec.pa_request_id,
155: p_remark_id_o => ghr_pre_shd.g_old_rec.remark_id,
156: p_description_o => ghr_pre_shd.g_old_rec.description,
157: p_remark_code_information1_o =>
158: ghr_pre_shd.g_old_rec.remark_code_information1,
151: begin
152: ghr_pre_rkd.after_delete (
153: p_pa_remark_id => p_rec.pa_remark_id,
154: p_pa_request_id_o => ghr_pre_shd.g_old_rec.pa_request_id,
155: p_remark_id_o => ghr_pre_shd.g_old_rec.remark_id,
156: p_description_o => ghr_pre_shd.g_old_rec.description,
157: p_remark_code_information1_o =>
158: ghr_pre_shd.g_old_rec.remark_code_information1,
159: p_remark_code_information2_o =>
152: ghr_pre_rkd.after_delete (
153: p_pa_remark_id => p_rec.pa_remark_id,
154: p_pa_request_id_o => ghr_pre_shd.g_old_rec.pa_request_id,
155: p_remark_id_o => ghr_pre_shd.g_old_rec.remark_id,
156: p_description_o => ghr_pre_shd.g_old_rec.description,
157: p_remark_code_information1_o =>
158: ghr_pre_shd.g_old_rec.remark_code_information1,
159: p_remark_code_information2_o =>
160: ghr_pre_shd.g_old_rec.remark_code_information2,
154: p_pa_request_id_o => ghr_pre_shd.g_old_rec.pa_request_id,
155: p_remark_id_o => ghr_pre_shd.g_old_rec.remark_id,
156: p_description_o => ghr_pre_shd.g_old_rec.description,
157: p_remark_code_information1_o =>
158: ghr_pre_shd.g_old_rec.remark_code_information1,
159: p_remark_code_information2_o =>
160: ghr_pre_shd.g_old_rec.remark_code_information2,
161: p_remark_code_information3_o =>
162: ghr_pre_shd.g_old_rec.remark_code_information3,
156: p_description_o => ghr_pre_shd.g_old_rec.description,
157: p_remark_code_information1_o =>
158: ghr_pre_shd.g_old_rec.remark_code_information1,
159: p_remark_code_information2_o =>
160: ghr_pre_shd.g_old_rec.remark_code_information2,
161: p_remark_code_information3_o =>
162: ghr_pre_shd.g_old_rec.remark_code_information3,
163: p_remark_code_information4_o =>
164: ghr_pre_shd.g_old_rec.remark_code_information4,
158: ghr_pre_shd.g_old_rec.remark_code_information1,
159: p_remark_code_information2_o =>
160: ghr_pre_shd.g_old_rec.remark_code_information2,
161: p_remark_code_information3_o =>
162: ghr_pre_shd.g_old_rec.remark_code_information3,
163: p_remark_code_information4_o =>
164: ghr_pre_shd.g_old_rec.remark_code_information4,
165: p_remark_code_information5_o =>
166: ghr_pre_shd.g_old_rec.remark_code_information5,
160: ghr_pre_shd.g_old_rec.remark_code_information2,
161: p_remark_code_information3_o =>
162: ghr_pre_shd.g_old_rec.remark_code_information3,
163: p_remark_code_information4_o =>
164: ghr_pre_shd.g_old_rec.remark_code_information4,
165: p_remark_code_information5_o =>
166: ghr_pre_shd.g_old_rec.remark_code_information5,
167: p_object_version_number_o =>
168: ghr_pre_shd.g_old_rec.object_version_number
162: ghr_pre_shd.g_old_rec.remark_code_information3,
163: p_remark_code_information4_o =>
164: ghr_pre_shd.g_old_rec.remark_code_information4,
165: p_remark_code_information5_o =>
166: ghr_pre_shd.g_old_rec.remark_code_information5,
167: p_object_version_number_o =>
168: ghr_pre_shd.g_old_rec.object_version_number
169: );
170:
164: ghr_pre_shd.g_old_rec.remark_code_information4,
165: p_remark_code_information5_o =>
166: ghr_pre_shd.g_old_rec.remark_code_information5,
167: p_object_version_number_o =>
168: ghr_pre_shd.g_old_rec.object_version_number
169: );
170:
171: exception
172: when hr_api.cannot_find_prog_unit then
184: -- |---------------------------------< del >----------------------------------|
185: -- ----------------------------------------------------------------------------
186: Procedure del
187: (
188: p_rec in ghr_pre_shd.g_rec_type,
189: p_validate in boolean default false
190: ) is
191: --
192: l_proc varchar2(72) := g_package||'del';
205: --
206: -- We must lock the row which we need to delete.
207: --
208:
209: ghr_pre_shd.lck
210: (
211: p_rec.pa_remark_id,
212: p_rec.object_version_number
213: );
256: p_object_version_number in number,
257: p_validate in boolean default false
258: ) is
259: --
260: l_rec ghr_pre_shd.g_rec_type;
261: l_proc varchar2(72) := g_package||'del';
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);