eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_AHK_UPD dependencies on HR_AHK_SHD

Line 54: Procedure update_dml(p_rec in out nocopy hr_ahk_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_ahk_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 62: hr_ahk_shd.g_api_dml := true; -- Set the api dml status

58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: --
62: hr_ahk_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Update the hr_api_hooks Row
65: --
66: update hr_api_hooks

Line 79: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status

75: legislation_function = p_rec.legislation_function,
76: encoded_error = p_rec.encoded_error
77: where api_hook_id = p_rec.api_hook_id;
78: --
79: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: Exception

Line 86: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status

82: --
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
87: hr_ahk_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated

Line 87: hr_ahk_shd.constraint_error

83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
87: hr_ahk_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status

Line 91: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status

87: hr_ahk_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
92: hr_ahk_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated

Line 92: hr_ahk_shd.constraint_error

88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
92: hr_ahk_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status

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

92: hr_ahk_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
97: hr_ahk_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status

Line 97: hr_ahk_shd.constraint_error

93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
97: hr_ahk_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;

Line 100: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status

96: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
97: hr_ahk_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;
102: End update_dml;
103: --
104: -- ----------------------------------------------------------------------------

Line 136: Procedure pre_update(p_rec in hr_ahk_shd.g_rec_type) is

132: -- Internal Row Handler Use Only.
133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_update(p_rec in hr_ahk_shd.g_rec_type) is
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin

Line 178: Procedure post_update(p_rec in hr_ahk_shd.g_rec_type) is

174: -- Internal Row Handler Use Only.
175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure post_update(p_rec in hr_ahk_shd.g_rec_type) is
179: --
180: l_proc varchar2(72) := g_package||'post_update';
181: --
182: Begin

Line 232: Procedure convert_defs(p_rec in out nocopy hr_ahk_shd.g_rec_type) is

228: -- Internal Row Handler Use Only.
229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure convert_defs(p_rec in out nocopy hr_ahk_shd.g_rec_type) is
233: --
234: l_proc varchar2(72) := g_package||'convert_defs';
235: --
236: Begin

Line 247: hr_ahk_shd.g_old_rec.api_module_id;

243: -- is being used then we must set to the 'current' argument value.
244: --
245: If (p_rec.api_module_id = hr_api.g_number) then
246: p_rec.api_module_id :=
247: hr_ahk_shd.g_old_rec.api_module_id;
248: End If;
249: If (p_rec.api_hook_type = hr_api.g_varchar2) then
250: p_rec.api_hook_type :=
251: hr_ahk_shd.g_old_rec.api_hook_type;

Line 251: hr_ahk_shd.g_old_rec.api_hook_type;

247: hr_ahk_shd.g_old_rec.api_module_id;
248: End If;
249: If (p_rec.api_hook_type = hr_api.g_varchar2) then
250: p_rec.api_hook_type :=
251: hr_ahk_shd.g_old_rec.api_hook_type;
252: End If;
253: If (p_rec.hook_package = hr_api.g_varchar2) then
254: p_rec.hook_package :=
255: hr_ahk_shd.g_old_rec.hook_package;

Line 255: hr_ahk_shd.g_old_rec.hook_package;

251: hr_ahk_shd.g_old_rec.api_hook_type;
252: End If;
253: If (p_rec.hook_package = hr_api.g_varchar2) then
254: p_rec.hook_package :=
255: hr_ahk_shd.g_old_rec.hook_package;
256: End If;
257: If (p_rec.hook_procedure = hr_api.g_varchar2) then
258: p_rec.hook_procedure :=
259: hr_ahk_shd.g_old_rec.hook_procedure;

Line 259: hr_ahk_shd.g_old_rec.hook_procedure;

255: hr_ahk_shd.g_old_rec.hook_package;
256: End If;
257: If (p_rec.hook_procedure = hr_api.g_varchar2) then
258: p_rec.hook_procedure :=
259: hr_ahk_shd.g_old_rec.hook_procedure;
260: End If;
261: If (p_rec.legislation_code = hr_api.g_varchar2) then
262: p_rec.legislation_code :=
263: hr_ahk_shd.g_old_rec.legislation_code;

Line 263: hr_ahk_shd.g_old_rec.legislation_code;

259: hr_ahk_shd.g_old_rec.hook_procedure;
260: End If;
261: If (p_rec.legislation_code = hr_api.g_varchar2) then
262: p_rec.legislation_code :=
263: hr_ahk_shd.g_old_rec.legislation_code;
264: End If;
265: If (p_rec.legislation_package = hr_api.g_varchar2) then
266: p_rec.legislation_package :=
267: hr_ahk_shd.g_old_rec.legislation_package;

Line 267: hr_ahk_shd.g_old_rec.legislation_package;

263: hr_ahk_shd.g_old_rec.legislation_code;
264: End If;
265: If (p_rec.legislation_package = hr_api.g_varchar2) then
266: p_rec.legislation_package :=
267: hr_ahk_shd.g_old_rec.legislation_package;
268: End If;
269: If (p_rec.legislation_function = hr_api.g_varchar2) then
270: p_rec.legislation_function :=
271: hr_ahk_shd.g_old_rec.legislation_function;

Line 271: hr_ahk_shd.g_old_rec.legislation_function;

267: hr_ahk_shd.g_old_rec.legislation_package;
268: End If;
269: If (p_rec.legislation_function = hr_api.g_varchar2) then
270: p_rec.legislation_function :=
271: hr_ahk_shd.g_old_rec.legislation_function;
272: End If;
273: If (p_rec.encoded_error = hr_api.g_varchar2) then
274: p_rec.encoded_error :=
275: hr_ahk_shd.g_old_rec.encoded_error;

Line 275: hr_ahk_shd.g_old_rec.encoded_error;

271: hr_ahk_shd.g_old_rec.legislation_function;
272: End If;
273: If (p_rec.encoded_error = hr_api.g_varchar2) then
274: p_rec.encoded_error :=
275: hr_ahk_shd.g_old_rec.encoded_error;
276: End If;
277: --
278: hr_utility.set_location(' Leaving:'||l_proc, 10);
279: --

Line 287: p_rec in out nocopy hr_ahk_shd.g_rec_type,

283: -- |---------------------------------< upd >----------------------------------|
284: -- ----------------------------------------------------------------------------
285: Procedure upd
286: (
287: p_rec in out nocopy hr_ahk_shd.g_rec_type,
288: p_effective_date in date
289: ) is
290: --
291: l_proc varchar2(72) := g_package||'upd';

Line 298: hr_ahk_shd.lck

294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: -- We must lock the row which we need to update.
297: --
298: hr_ahk_shd.lck
299: (
300: p_rec.api_hook_id
301: );
302: --

Line 340: l_rec hr_ahk_shd.g_rec_type;

336: p_legislation_function in varchar2 default hr_api.g_varchar2,
337: p_encoded_error in varchar2 default hr_api.g_varchar2
338: ) is
339: --
340: l_rec hr_ahk_shd.g_rec_type;
341: l_proc varchar2(72) := g_package||'upd';
342: --
343: Begin
344: hr_utility.set_location('Entering:'||l_proc, 5);

Line 350: hr_ahk_shd.convert_args

346: -- Call conversion function to turn arguments into the
347: -- l_rec structure.
348: --
349: l_rec :=
350: hr_ahk_shd.convert_args
351: (
352: p_api_hook_id,
353: hr_api.g_number,
354: p_api_hook_type,