DBA Data[Home] [Help]

APPS.GHR_PRE_DEL dependencies on GHR_PRE_SHD

Line 45: Procedure delete_dml(p_rec in ghr_pre_shd.g_rec_type) is

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

Line 62: ghr_pre_shd.constraint_error

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;

Line 100: Procedure pre_delete(p_rec in ghr_pre_shd.g_rec_type) is

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

Line 142: Procedure post_delete(p_rec in ghr_pre_shd.g_rec_type) is

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

Line 154: p_pa_request_id_o => ghr_pre_shd.g_old_rec.pa_request_id,

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,

Line 155: p_remark_id_o => ghr_pre_shd.g_old_rec.remark_id,

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 =>

Line 156: p_description_o => ghr_pre_shd.g_old_rec.description,

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,

Line 158: ghr_pre_shd.g_old_rec.remark_code_information1,

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,

Line 160: ghr_pre_shd.g_old_rec.remark_code_information2,

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,

Line 162: ghr_pre_shd.g_old_rec.remark_code_information3,

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,

Line 164: ghr_pre_shd.g_old_rec.remark_code_information4,

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

Line 166: ghr_pre_shd.g_old_rec.remark_code_information5,

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:

Line 168: ghr_pre_shd.g_old_rec.object_version_number

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

Line 188: p_rec in ghr_pre_shd.g_rec_type,

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';

Line 209: ghr_pre_shd.lck

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: );

Line 260: l_rec ghr_pre_shd.g_rec_type;

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);