DBA Data[Home] [Help]

APPS.HR_AHC_UPD dependencies on HR_AHC_SHD

Line 54: Procedure update_dml(p_rec in out nocopy hr_ahc_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy hr_ahc_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: hr_ahc_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: hr_ahc_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the hr_api_hook_calls Row
68: --
69: update hr_api_hook_calls

Line 87: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status

83: application_id = p_rec.application_id,
84: app_install_status = p_rec.app_install_status
85: where api_hook_call_id = p_rec.api_hook_call_id;
86: --
87: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 10);
90: --
91: Exception

Line 94: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status

90: --
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
95: hr_ahc_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated

Line 95: hr_ahc_shd.constraint_error

91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
95: hr_ahc_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status

Line 99: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status

95: hr_ahc_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
100: hr_ahc_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated

Line 100: hr_ahc_shd.constraint_error

96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
100: hr_ahc_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status

Line 104: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status

100: hr_ahc_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
105: hr_ahc_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status

Line 105: hr_ahc_shd.constraint_error

101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
105: hr_ahc_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
109: Raise;

Line 108: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status

104: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
105: hr_ahc_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
109: Raise;
110: End update_dml;
111: --
112: -- ----------------------------------------------------------------------------

Line 144: Procedure pre_update(p_rec in hr_ahc_shd.g_rec_type) is

140: -- Internal Row Handler Use Only.
141: --
142: -- {End Of Comments}
143: -- ----------------------------------------------------------------------------
144: Procedure pre_update(p_rec in hr_ahc_shd.g_rec_type) is
145: --
146: l_proc varchar2(72) := g_package||'pre_update';
147: --
148: Begin

Line 186: Procedure post_update(p_rec in hr_ahc_shd.g_rec_type) is

182: -- Internal Row Handler Use Only.
183: --
184: -- {End Of Comments}
185: -- ----------------------------------------------------------------------------
186: Procedure post_update(p_rec in hr_ahc_shd.g_rec_type) is
187: --
188: l_proc varchar2(72) := g_package||'post_update';
189: --
190: Begin

Line 240: Procedure convert_defs(p_rec in out nocopy hr_ahc_shd.g_rec_type) is

236: -- Internal Row Handler Use Only.
237: --
238: -- {End Of Comments}
239: -- ----------------------------------------------------------------------------
240: Procedure convert_defs(p_rec in out nocopy hr_ahc_shd.g_rec_type) is
241: --
242: l_proc varchar2(72) := g_package||'convert_defs';
243: --
244: Begin

Line 255: hr_ahc_shd.g_old_rec.api_hook_id;

251: -- is being used then we must set to the 'current' argument value.
252: --
253: If (p_rec.api_hook_id = hr_api.g_number) then
254: p_rec.api_hook_id :=
255: hr_ahc_shd.g_old_rec.api_hook_id;
256: End If;
257: If (p_rec.api_hook_call_type = hr_api.g_varchar2) then
258: p_rec.api_hook_call_type :=
259: hr_ahc_shd.g_old_rec.api_hook_call_type;

Line 259: hr_ahc_shd.g_old_rec.api_hook_call_type;

255: hr_ahc_shd.g_old_rec.api_hook_id;
256: End If;
257: If (p_rec.api_hook_call_type = hr_api.g_varchar2) then
258: p_rec.api_hook_call_type :=
259: hr_ahc_shd.g_old_rec.api_hook_call_type;
260: End If;
261: If (p_rec.legislation_code = hr_api.g_varchar2) then
262: p_rec.legislation_code :=
263: hr_ahc_shd.g_old_rec.legislation_code;

Line 263: hr_ahc_shd.g_old_rec.legislation_code;

259: hr_ahc_shd.g_old_rec.api_hook_call_type;
260: End If;
261: If (p_rec.legislation_code = hr_api.g_varchar2) then
262: p_rec.legislation_code :=
263: hr_ahc_shd.g_old_rec.legislation_code;
264: End If;
265: If (p_rec.sequence = hr_api.g_number) then
266: p_rec.sequence :=
267: hr_ahc_shd.g_old_rec.sequence;

Line 267: hr_ahc_shd.g_old_rec.sequence;

263: hr_ahc_shd.g_old_rec.legislation_code;
264: End If;
265: If (p_rec.sequence = hr_api.g_number) then
266: p_rec.sequence :=
267: hr_ahc_shd.g_old_rec.sequence;
268: End If;
269: If (p_rec.enabled_flag = hr_api.g_varchar2) then
270: p_rec.enabled_flag :=
271: hr_ahc_shd.g_old_rec.enabled_flag;

Line 271: hr_ahc_shd.g_old_rec.enabled_flag;

267: hr_ahc_shd.g_old_rec.sequence;
268: End If;
269: If (p_rec.enabled_flag = hr_api.g_varchar2) then
270: p_rec.enabled_flag :=
271: hr_ahc_shd.g_old_rec.enabled_flag;
272: End If;
273: If (p_rec.call_package = hr_api.g_varchar2) then
274: p_rec.call_package :=
275: hr_ahc_shd.g_old_rec.call_package;

Line 275: hr_ahc_shd.g_old_rec.call_package;

271: hr_ahc_shd.g_old_rec.enabled_flag;
272: End If;
273: If (p_rec.call_package = hr_api.g_varchar2) then
274: p_rec.call_package :=
275: hr_ahc_shd.g_old_rec.call_package;
276: End If;
277: If (p_rec.call_procedure = hr_api.g_varchar2) then
278: p_rec.call_procedure :=
279: hr_ahc_shd.g_old_rec.call_procedure;

Line 279: hr_ahc_shd.g_old_rec.call_procedure;

275: hr_ahc_shd.g_old_rec.call_package;
276: End If;
277: If (p_rec.call_procedure = hr_api.g_varchar2) then
278: p_rec.call_procedure :=
279: hr_ahc_shd.g_old_rec.call_procedure;
280: End If;
281: If (p_rec.pre_processor_date = hr_api.g_date) then
282: p_rec.pre_processor_date :=
283: hr_ahc_shd.g_old_rec.pre_processor_date;

Line 283: hr_ahc_shd.g_old_rec.pre_processor_date;

279: hr_ahc_shd.g_old_rec.call_procedure;
280: End If;
281: If (p_rec.pre_processor_date = hr_api.g_date) then
282: p_rec.pre_processor_date :=
283: hr_ahc_shd.g_old_rec.pre_processor_date;
284: End If;
285: If (p_rec.encoded_error = hr_api.g_varchar2) then
286: p_rec.encoded_error :=
287: hr_ahc_shd.g_old_rec.encoded_error;

Line 287: hr_ahc_shd.g_old_rec.encoded_error;

283: hr_ahc_shd.g_old_rec.pre_processor_date;
284: End If;
285: If (p_rec.encoded_error = hr_api.g_varchar2) then
286: p_rec.encoded_error :=
287: hr_ahc_shd.g_old_rec.encoded_error;
288: End If;
289: If (p_rec.status = hr_api.g_varchar2) then
290: p_rec.status :=
291: hr_ahc_shd.g_old_rec.status;

Line 291: hr_ahc_shd.g_old_rec.status;

287: hr_ahc_shd.g_old_rec.encoded_error;
288: End If;
289: If (p_rec.status = hr_api.g_varchar2) then
290: p_rec.status :=
291: hr_ahc_shd.g_old_rec.status;
292: End If;
293: If (p_rec.application_id = hr_api.g_number) then
294: p_rec.application_id :=
295: hr_ahc_shd.g_old_rec.application_id;

Line 295: hr_ahc_shd.g_old_rec.application_id;

291: hr_ahc_shd.g_old_rec.status;
292: End If;
293: If (p_rec.application_id = hr_api.g_number) then
294: p_rec.application_id :=
295: hr_ahc_shd.g_old_rec.application_id;
296: End If;
297: If (p_rec.app_install_status = hr_api.g_varchar2) then
298: p_rec.app_install_status :=
299: hr_ahc_shd.g_old_rec.app_install_status;

Line 299: hr_ahc_shd.g_old_rec.app_install_status;

295: hr_ahc_shd.g_old_rec.application_id;
296: End If;
297: If (p_rec.app_install_status = hr_api.g_varchar2) then
298: p_rec.app_install_status :=
299: hr_ahc_shd.g_old_rec.app_install_status;
300: End If;
301: --
302: hr_utility.set_location(' Leaving:'||l_proc, 10);
303: --

Line 311: p_rec in out nocopy hr_ahc_shd.g_rec_type ,

307: -- |---------------------------------< upd >----------------------------------|
308: -- ----------------------------------------------------------------------------
309: Procedure upd
310: (
311: p_rec in out nocopy hr_ahc_shd.g_rec_type ,
312: p_effective_date in date
313: ) is
314: --
315: l_proc varchar2(72) := g_package||'upd';

Line 322: hr_ahc_shd.lck

318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: -- We must lock the row which we need to update.
321: --
322: hr_ahc_shd.lck
323: (
324: p_rec.api_hook_call_id,
325: p_rec.object_version_number
326: );

Line 367: l_rec hr_ahc_shd.g_rec_type;

363: p_status in varchar2 default hr_api.g_varchar2,
364: p_object_version_number in out nocopy number
365: ) is
366: --
367: l_rec hr_ahc_shd.g_rec_type;
368: l_proc varchar2(72) := g_package||'upd';
369: --
370: Begin
371: hr_utility.set_location('Entering:'||l_proc, 5);

Line 377: hr_ahc_shd.convert_args

373: -- Call conversion function to turn arguments into the
374: -- l_rec structure.
375: --
376: l_rec :=
377: hr_ahc_shd.convert_args
378: (
379: p_api_hook_call_id,
380: hr_api.g_number,
381: hr_api.g_varchar2,