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_INS dependencies on HR_AHK_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy hr_ahk_shd.g_rec_type) is

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

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

57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: hr_ahk_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: hr_api_hooks
64: --
65: insert into hr_api_hooks

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

84: p_rec.legislation_function,
85: p_rec.encoded_error
86: );
87: --
88: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: Exception
92: When hr_api.check_integrity_violated Then

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

90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
95: hr_ahk_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_ahk_shd.constraint_error

91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
95: hr_ahk_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_ahk_shd.g_api_dml := false; -- Unset the api dml status

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

95: hr_ahk_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_ahk_shd.g_api_dml := false; -- Unset the api dml status
100: hr_ahk_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_ahk_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_ahk_shd.g_api_dml := false; -- Unset the api dml status
100: hr_ahk_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_ahk_shd.g_api_dml := false; -- Unset the api dml status

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

100: hr_ahk_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_ahk_shd.g_api_dml := false; -- Unset the api dml status
105: hr_ahk_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status

Line 105: hr_ahk_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_ahk_shd.g_api_dml := false; -- Unset the api dml status
105: hr_ahk_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
109: Raise;

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

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

Line 149: Procedure pre_insert(p_rec in out nocopy hr_ahk_shd.g_rec_type) is

145: -- Internal Row Handler Use Only.
146: --
147: -- {End Of Comments}
148: -- ----------------------------------------------------------------------------
149: Procedure pre_insert(p_rec in out nocopy hr_ahk_shd.g_rec_type) is
150: --
151: l_proc varchar2(72) := g_package||'pre_insert';
152: --
153: Cursor C_Sel1 is select hr_api_hooks_s.nextval from sys.dual;

Line 200: Procedure post_insert(p_rec in hr_ahk_shd.g_rec_type) is

196: -- Internal Row Handler Use Only.
197: --
198: -- {End Of Comments}
199: -- ----------------------------------------------------------------------------
200: Procedure post_insert(p_rec in hr_ahk_shd.g_rec_type) is
201: --
202: l_proc varchar2(72) := g_package||'post_insert';
203: --
204: Begin

Line 215: p_rec in out nocopy hr_ahk_shd.g_rec_type,

211: -- |---------------------------------< ins >----------------------------------|
212: -- ----------------------------------------------------------------------------
213: Procedure ins
214: (
215: p_rec in out nocopy hr_ahk_shd.g_rec_type,
216: p_effective_date in date
217: ) is
218: --
219: l_proc varchar2(72) := g_package||'ins';

Line 257: l_rec hr_ahk_shd.g_rec_type;

253: p_legislation_package in varchar2 default null,
254: p_legislation_function in varchar2 default null
255: ) is
256: --
257: l_rec hr_ahk_shd.g_rec_type;
258: l_proc varchar2(72) := g_package||'ins';
259: --
260: Begin
261: hr_utility.set_location('Entering:'||l_proc, 5);

Line 267: hr_ahk_shd.convert_args

263: -- Call conversion function to turn arguments into the
264: -- p_rec structure.
265: --
266: l_rec :=
267: hr_ahk_shd.convert_args
268: (
269: null,
270: p_api_module_id,
271: p_api_hook_type,