DBA Data[Home] [Help]

APPS.GHR_PRE_UPD dependencies on GHR_PRE_SHD

Line 48: Procedure update_dml(p_rec in out NOCOPY ghr_pre_shd.g_rec_type) is

44: -- Internal Table Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out NOCOPY ghr_pre_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 79: ghr_pre_shd.constraint_error

75: --
76: Exception
77: When hr_api.check_integrity_violated Then
78: -- A check constraint has been violated
79: ghr_pre_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: ghr_pre_shd.constraint_error

Line 83: ghr_pre_shd.constraint_error

79: ghr_pre_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: ghr_pre_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then
86: -- Unique integrity has been violated
87: ghr_pre_shd.constraint_error

Line 87: ghr_pre_shd.constraint_error

83: ghr_pre_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then
86: -- Unique integrity has been violated
87: ghr_pre_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When Others Then
90: Raise;
91: End update_dml;

Line 125: Procedure pre_update(p_rec in ghr_pre_shd.g_rec_type) is

121: -- Internal Table Handler Use Only.
122: --
123: -- {End Of Comments}
124: -- ----------------------------------------------------------------------------
125: Procedure pre_update(p_rec in ghr_pre_shd.g_rec_type) is
126: --
127: l_proc varchar2(72) := g_package||'pre_update';
128: --
129: Begin

Line 167: Procedure post_update(p_rec in ghr_pre_shd.g_rec_type) is

163: -- Internal Table Handler Use Only.
164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure post_update(p_rec in ghr_pre_shd.g_rec_type) is
168: --
169: l_proc varchar2(72) := g_package||'post_update';
170: --
171: Begin

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

184: p_remark_code_information3 => p_rec.remark_code_information3,
185: p_remark_code_information4 => p_rec.remark_code_information4,
186: p_remark_code_information5 => p_rec.remark_code_information5,
187: p_object_version_number => p_rec.object_version_number ,
188: p_pa_request_id_o => ghr_pre_shd.g_old_rec.pa_request_id,
189: p_remark_id_o => ghr_pre_shd.g_old_rec.remark_id,
190: p_description_o => ghr_pre_shd.g_old_rec.description,
191: p_remark_code_information1_o =>
192: ghr_pre_shd.g_old_rec.remark_code_information1,

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

185: p_remark_code_information4 => p_rec.remark_code_information4,
186: p_remark_code_information5 => p_rec.remark_code_information5,
187: p_object_version_number => p_rec.object_version_number ,
188: p_pa_request_id_o => ghr_pre_shd.g_old_rec.pa_request_id,
189: p_remark_id_o => ghr_pre_shd.g_old_rec.remark_id,
190: p_description_o => ghr_pre_shd.g_old_rec.description,
191: p_remark_code_information1_o =>
192: ghr_pre_shd.g_old_rec.remark_code_information1,
193: p_remark_code_information2_o =>

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

186: p_remark_code_information5 => p_rec.remark_code_information5,
187: p_object_version_number => p_rec.object_version_number ,
188: p_pa_request_id_o => ghr_pre_shd.g_old_rec.pa_request_id,
189: p_remark_id_o => ghr_pre_shd.g_old_rec.remark_id,
190: p_description_o => ghr_pre_shd.g_old_rec.description,
191: p_remark_code_information1_o =>
192: ghr_pre_shd.g_old_rec.remark_code_information1,
193: p_remark_code_information2_o =>
194: ghr_pre_shd.g_old_rec.remark_code_information2,

Line 192: ghr_pre_shd.g_old_rec.remark_code_information1,

188: p_pa_request_id_o => ghr_pre_shd.g_old_rec.pa_request_id,
189: p_remark_id_o => ghr_pre_shd.g_old_rec.remark_id,
190: p_description_o => ghr_pre_shd.g_old_rec.description,
191: p_remark_code_information1_o =>
192: ghr_pre_shd.g_old_rec.remark_code_information1,
193: p_remark_code_information2_o =>
194: ghr_pre_shd.g_old_rec.remark_code_information2,
195: p_remark_code_information3_o =>
196: ghr_pre_shd.g_old_rec.remark_code_information3,

Line 194: ghr_pre_shd.g_old_rec.remark_code_information2,

190: p_description_o => ghr_pre_shd.g_old_rec.description,
191: p_remark_code_information1_o =>
192: ghr_pre_shd.g_old_rec.remark_code_information1,
193: p_remark_code_information2_o =>
194: ghr_pre_shd.g_old_rec.remark_code_information2,
195: p_remark_code_information3_o =>
196: ghr_pre_shd.g_old_rec.remark_code_information3,
197: p_remark_code_information4_o =>
198: ghr_pre_shd.g_old_rec.remark_code_information4,

Line 196: ghr_pre_shd.g_old_rec.remark_code_information3,

192: ghr_pre_shd.g_old_rec.remark_code_information1,
193: p_remark_code_information2_o =>
194: ghr_pre_shd.g_old_rec.remark_code_information2,
195: p_remark_code_information3_o =>
196: ghr_pre_shd.g_old_rec.remark_code_information3,
197: p_remark_code_information4_o =>
198: ghr_pre_shd.g_old_rec.remark_code_information4,
199: p_remark_code_information5_o =>
200: ghr_pre_shd.g_old_rec.remark_code_information5,

Line 198: ghr_pre_shd.g_old_rec.remark_code_information4,

194: ghr_pre_shd.g_old_rec.remark_code_information2,
195: p_remark_code_information3_o =>
196: ghr_pre_shd.g_old_rec.remark_code_information3,
197: p_remark_code_information4_o =>
198: ghr_pre_shd.g_old_rec.remark_code_information4,
199: p_remark_code_information5_o =>
200: ghr_pre_shd.g_old_rec.remark_code_information5,
201: p_object_version_number_o =>
202: ghr_pre_shd.g_old_rec.object_version_number

Line 200: ghr_pre_shd.g_old_rec.remark_code_information5,

196: ghr_pre_shd.g_old_rec.remark_code_information3,
197: p_remark_code_information4_o =>
198: ghr_pre_shd.g_old_rec.remark_code_information4,
199: p_remark_code_information5_o =>
200: ghr_pre_shd.g_old_rec.remark_code_information5,
201: p_object_version_number_o =>
202: ghr_pre_shd.g_old_rec.object_version_number
203: );
204: exception

Line 202: ghr_pre_shd.g_old_rec.object_version_number

198: ghr_pre_shd.g_old_rec.remark_code_information4,
199: p_remark_code_information5_o =>
200: ghr_pre_shd.g_old_rec.remark_code_information5,
201: p_object_version_number_o =>
202: ghr_pre_shd.g_old_rec.object_version_number
203: );
204: exception
205: when hr_api.cannot_find_prog_unit then
206: hr_api.cannot_find_prog_unit_error

Line 260: Procedure convert_defs(p_rec in out NOCOPY ghr_pre_shd.g_rec_type) is

256: -- Internal Table Handler Use Only.
257: --
258: -- {End Of Comments}
259: -- ----------------------------------------------------------------------------
260: Procedure convert_defs(p_rec in out NOCOPY ghr_pre_shd.g_rec_type) is
261: --
262: l_proc varchar2(72) := g_package||'convert_defs';
263: --
264: Begin

Line 275: ghr_pre_shd.g_old_rec.pa_request_id;

271: -- is being used then we must set to the 'current' argument value.
272: --
273: If (p_rec.pa_request_id = hr_api.g_number) then
274: p_rec.pa_request_id :=
275: ghr_pre_shd.g_old_rec.pa_request_id;
276: End If;
277: If (p_rec.remark_id = hr_api.g_number) then
278: p_rec.remark_id :=
279: ghr_pre_shd.g_old_rec.remark_id;

Line 279: ghr_pre_shd.g_old_rec.remark_id;

275: ghr_pre_shd.g_old_rec.pa_request_id;
276: End If;
277: If (p_rec.remark_id = hr_api.g_number) then
278: p_rec.remark_id :=
279: ghr_pre_shd.g_old_rec.remark_id;
280: End If;
281: If (p_rec.description = hr_api.g_varchar2) then
282: p_rec.description :=
283: ghr_pre_shd.g_old_rec.description;

Line 283: ghr_pre_shd.g_old_rec.description;

279: ghr_pre_shd.g_old_rec.remark_id;
280: End If;
281: If (p_rec.description = hr_api.g_varchar2) then
282: p_rec.description :=
283: ghr_pre_shd.g_old_rec.description;
284: End If;
285:
286: --
287: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 296: p_rec in out NOCOPY ghr_pre_shd.g_rec_type,

292: -- |---------------------------------< upd >----------------------------------|
293: -- ----------------------------------------------------------------------------
294: Procedure upd
295: (
296: p_rec in out NOCOPY ghr_pre_shd.g_rec_type,
297: p_validate in boolean default false
298: ) is
299: --
300: l_proc varchar2(72) := g_package||'upd';

Line 316: ghr_pre_shd.lck

312: End If;
313: --
314: -- We must lock the row which we need to update.
315: --
316: ghr_pre_shd.lck
317: (
318: p_rec.pa_remark_id,
319: p_rec.object_version_number
320: );

Line 375: l_rec ghr_pre_shd.g_rec_type;

371: p_remark_code_information5 in varchar2 default hr_api.g_varchar2,
372: p_validate in boolean default false
373: ) is
374: --
375: l_rec ghr_pre_shd.g_rec_type;
376: l_proc varchar2(72) := g_package||'upd';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);

Line 385: ghr_pre_shd.convert_args

381: -- Call conversion function to turn arguments into the
382: -- l_rec structure.
383: --
384: l_rec :=
385: ghr_pre_shd.convert_args
386: (
387: p_pa_remark_id,
388: hr_api.g_number,
389: hr_api.g_number,