APPS.HR_API_HOOK_INTERNAL dependencies on HR_API

Line 1: Package Body hr_api_hook_internal as

1: Package Body hr_api_hook_internal as
2: /* $Header: peahkbsi.pkb 115.1 2002/12/03 16:24:43 apholt ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' hr_api_hook_internal.';

2: /* $Header: peahkbsi.pkb 115.1 2002/12/03 16:24:43 apholt ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_api_hook_internal.';
7: --
8: -- ------------------------------------------------------------------------
9: -- |--------------------------< create_api_hook >----------------------------|
10: -- ------------------------------------------------------------------------

Line 30: l_api_hook_id hr_api_hooks.api_hook_id%TYPE;

26: l_effective_date date;
27: --
28: -- Out variables
29: --
30: l_api_hook_id hr_api_hooks.api_hook_id%TYPE;
31: l_proc varchar2(72) := g_package||'create_api_hook';
32: --
33: --
34: -- Declare a cursor that will check whether the passed

Line 37: select api_hook_id from hr_api_hooks hah

33: --
34: -- Declare a cursor that will check whether the passed
35: -- in hook package and hook procedure form a unique combination
36: cursor csr_valid_combo is
37: select api_hook_id from hr_api_hooks hah
38: where hah.hook_package = p_hook_package
39: and hah.hook_procedure = p_hook_procedure;
40:
41: begin

Line 94: raise hr_api.validate_enabled;

90: --
91: -- When in validation only mode raise the Validate_Enabled exception
92: --
93: if p_validate then
94: raise hr_api.validate_enabled;
95: end if;
96: --
97: -- Set all output arguments
98: --

Line 103: when hr_api.validate_enabled then

99: p_api_hook_id := l_api_hook_id;
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 100);
102: exception
103: when hr_api.validate_enabled then
104: --
105: -- Only set output warning arguments
106: -- (Any key or derived arguments must be set to null
107: -- when validation only mode is being used.)

Line 157: raise hr_api.validate_enabled;

153: --
154: -- When in validation only mode raise the Validate_Enabled exception
155: --
156: if p_validate then
157: raise hr_api.validate_enabled;
158: end if;
159: --
160: hr_utility.set_location(' Leaving:'||l_proc, 100);
161: exception

Line 162: when hr_api.validate_enabled then

158: end if;
159: --
160: hr_utility.set_location(' Leaving:'||l_proc, 100);
161: exception
162: when hr_api.validate_enabled then
163: --
164: -- As the Validate_Enabled exception has been raised
165: -- we must rollback to the savepoint
166: --

Line 179: p_api_hook_type in varchar2 default hr_api.g_varchar2,

175: procedure update_api_hook
176: (p_validate in boolean default false,
177: p_effective_date in date,
178: p_api_hook_id in number,
179: p_api_hook_type in varchar2 default hr_api.g_varchar2,
180: p_hook_package in varchar2 default hr_api.g_varchar2,
181: p_hook_procedure in varchar2 default hr_api.g_varchar2,
182: p_legislation_package in varchar2 default hr_api.g_varchar2,
183: p_legislation_function in varchar2 default hr_api.g_varchar2

Line 180: p_hook_package in varchar2 default hr_api.g_varchar2,

176: (p_validate in boolean default false,
177: p_effective_date in date,
178: p_api_hook_id in number,
179: p_api_hook_type in varchar2 default hr_api.g_varchar2,
180: p_hook_package in varchar2 default hr_api.g_varchar2,
181: p_hook_procedure in varchar2 default hr_api.g_varchar2,
182: p_legislation_package in varchar2 default hr_api.g_varchar2,
183: p_legislation_function in varchar2 default hr_api.g_varchar2
184: )

Line 181: p_hook_procedure in varchar2 default hr_api.g_varchar2,

177: p_effective_date in date,
178: p_api_hook_id in number,
179: p_api_hook_type in varchar2 default hr_api.g_varchar2,
180: p_hook_package in varchar2 default hr_api.g_varchar2,
181: p_hook_procedure in varchar2 default hr_api.g_varchar2,
182: p_legislation_package in varchar2 default hr_api.g_varchar2,
183: p_legislation_function in varchar2 default hr_api.g_varchar2
184: )
185: is

Line 182: p_legislation_package in varchar2 default hr_api.g_varchar2,

178: p_api_hook_id in number,
179: p_api_hook_type in varchar2 default hr_api.g_varchar2,
180: p_hook_package in varchar2 default hr_api.g_varchar2,
181: p_hook_procedure in varchar2 default hr_api.g_varchar2,
182: p_legislation_package in varchar2 default hr_api.g_varchar2,
183: p_legislation_function in varchar2 default hr_api.g_varchar2
184: )
185: is
186: --

Line 183: p_legislation_function in varchar2 default hr_api.g_varchar2

179: p_api_hook_type in varchar2 default hr_api.g_varchar2,
180: p_hook_package in varchar2 default hr_api.g_varchar2,
181: p_hook_procedure in varchar2 default hr_api.g_varchar2,
182: p_legislation_package in varchar2 default hr_api.g_varchar2,
183: p_legislation_function in varchar2 default hr_api.g_varchar2
184: )
185: is
186: --
187: -- Declare cursors and local variables

Line 193: l_api_hook_id hr_api_hooks.api_hook_id%TYPE;

189: l_effective_date date;
190: --
191: -- Out variables
192: --
193: l_api_hook_id hr_api_hooks.api_hook_id%TYPE;
194: --
195: l_proc varchar2(72) := g_package||'update_api_hook';
196: --
197: begin

Line 232: raise hr_api.validate_enabled;

228: --
229: -- When in validation only mode raise the Validate_Enabled exception
230: --
231: if p_validate then
232: raise hr_api.validate_enabled;
233: end if;
234: --
235: -- Set all output arguments
236: --

Line 239: when hr_api.validate_enabled then

235: -- Set all output arguments
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 100);
238: exception
239: when hr_api.validate_enabled then
240: --
241: -- As the Validate_Enabled exception has been raised
242: -- we must rollback to the savepoint
243: --

Line 248: end hr_api_hook_internal;

244: ROLLBACK TO update_api_hook;
245: --
246: end update_api_hook;
247: --
248: end hr_api_hook_internal;