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_API_HOOK_CALL_API dependencies on HR_API

Line 1: Package Body hr_api_hook_call_api as

1: Package Body hr_api_hook_call_api as
2: /* $Header: peahcapi.pkb 120.1 2007/08/20 10:34:44 ande ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: peahcapi.pkb 120.1 2007/08/20 10:34:44 ande ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_api_hook_call.';
7: --
8: -- ------------------------------------------------------------------------
9: -- |---------------------< create_api_hook_call >-------------------------|
10: -- ------------------------------------------------------------------------

Line 30: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;

26: l_effective_date date;
27: --
28: -- Out variables
29: --
30: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;
31: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
32:
33: -- Temp variables
34: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;

Line 31: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;

27: --
28: -- Out variables
29: --
30: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;
31: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
32:
33: -- Temp variables
34: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
35: l_status hr_api_hook_calls.status%TYPE := 'N';

Line 34: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;

30: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;
31: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
32:
33: -- Temp variables
34: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
35: l_status hr_api_hook_calls.status%TYPE := 'N';
36: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
37: l_legislation_code hr_api_hook_calls.legislation_code%TYPE := null;
38: --

Line 35: l_status hr_api_hook_calls.status%TYPE := 'N';

31: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
32:
33: -- Temp variables
34: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
35: l_status hr_api_hook_calls.status%TYPE := 'N';
36: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
37: l_legislation_code hr_api_hook_calls.legislation_code%TYPE := null;
38: --
39: l_proc varchar2(72) := g_package||'create_api_hook_call';

Line 36: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;

32:
33: -- Temp variables
34: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
35: l_status hr_api_hook_calls.status%TYPE := 'N';
36: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
37: l_legislation_code hr_api_hook_calls.legislation_code%TYPE := null;
38: --
39: l_proc varchar2(72) := g_package||'create_api_hook_call';
40: --

Line 37: l_legislation_code hr_api_hook_calls.legislation_code%TYPE := null;

33: -- Temp variables
34: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
35: l_status hr_api_hook_calls.status%TYPE := 'N';
36: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
37: l_legislation_code hr_api_hook_calls.legislation_code%TYPE := null;
38: --
39: l_proc varchar2(72) := g_package||'create_api_hook_call';
40: --
41: begin

Line 88: raise hr_api.validate_enabled;

84: --
85: -- When in validation only mode raise the Validate_Enabled exception
86: --
87: if p_validate then
88: raise hr_api.validate_enabled;
89: end if;
90: --
91: -- Set all output arguments
92: --

Line 98: when hr_api.validate_enabled then

94: p_object_version_number := l_object_version_number;
95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 100);
97: exception
98: when hr_api.validate_enabled then
99: --
100: -- As the Validate_Enabled exception has been raised
101: -- we must rollback to the savepoint
102: --

Line 132: l_leg_code hr_api_hook_calls.legislation_code%TYPE;

128: p_object_version_number in number
129: ) is
130: --
131: l_proc varchar2(72) := g_package||'delete_api_hook_call';
132: l_leg_code hr_api_hook_calls.legislation_code%TYPE;
133: --
134: -- Setup a cursor to retrieve leg code for the hook call
135: --
136: Cursor csr_get_leg_code is

Line 138: from hr_api_hook_calls

134: -- Setup a cursor to retrieve leg code for the hook call
135: --
136: Cursor csr_get_leg_code is
137: Select legislation_code
138: from hr_api_hook_calls
139: where api_hook_call_id = p_api_hook_call_id;
140:
141: begin
142: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 173: raise hr_api.validate_enabled;

169: --
170: -- When in validation only mode raise the Validate_Enabled exception
171: --
172: if p_validate then
173: raise hr_api.validate_enabled;
174: end if;
175: --
176: hr_utility.set_location(' Leaving:'||l_proc, 100);
177: exception

Line 178: when hr_api.validate_enabled then

174: end if;
175: --
176: hr_utility.set_location(' Leaving:'||l_proc, 100);
177: exception
178: when hr_api.validate_enabled then
179: --
180: -- As the Validate_Enabled exception has been raised
181: -- we must rollback to the savepoint
182: --

Line 194: p_sequence in number default hr_api.g_number,

190: procedure update_api_hook_call
191: (p_validate in boolean default false,
192: p_effective_date in date,
193: p_api_hook_call_id in number,
194: p_sequence in number default hr_api.g_number,
195: p_enabled_flag in varchar2 default hr_api.g_varchar2,
196: p_call_package in varchar2 default hr_api.g_varchar2,
197: p_call_procedure in varchar2 default hr_api.g_varchar2,
198: p_object_version_number in out nocopy number

Line 195: p_enabled_flag in varchar2 default hr_api.g_varchar2,

191: (p_validate in boolean default false,
192: p_effective_date in date,
193: p_api_hook_call_id in number,
194: p_sequence in number default hr_api.g_number,
195: p_enabled_flag in varchar2 default hr_api.g_varchar2,
196: p_call_package in varchar2 default hr_api.g_varchar2,
197: p_call_procedure in varchar2 default hr_api.g_varchar2,
198: p_object_version_number in out nocopy number
199: ) is

Line 196: p_call_package in varchar2 default hr_api.g_varchar2,

192: p_effective_date in date,
193: p_api_hook_call_id in number,
194: p_sequence in number default hr_api.g_number,
195: p_enabled_flag in varchar2 default hr_api.g_varchar2,
196: p_call_package in varchar2 default hr_api.g_varchar2,
197: p_call_procedure in varchar2 default hr_api.g_varchar2,
198: p_object_version_number in out nocopy number
199: ) is
200: --

Line 197: p_call_procedure in varchar2 default hr_api.g_varchar2,

193: p_api_hook_call_id in number,
194: p_sequence in number default hr_api.g_number,
195: p_enabled_flag in varchar2 default hr_api.g_varchar2,
196: p_call_package in varchar2 default hr_api.g_varchar2,
197: p_call_procedure in varchar2 default hr_api.g_varchar2,
198: p_object_version_number in out nocopy number
199: ) is
200: --
201: l_proc varchar2(72) := g_package||'update_api_hook_call';

Line 209: l_leg_code hr_api_hook_calls.legislation_code%TYPE;

205: l_effective_date date;
206: --
207: l_object_version_number number;
208: --
209: l_leg_code hr_api_hook_calls.legislation_code%TYPE;
210: --
211: -- Setup a cursor to retrieve leg code for the hook call
212: --
213: Cursor csr_get_leg_code is

Line 215: from hr_api_hook_calls

211: -- Setup a cursor to retrieve leg code for the hook call
212: --
213: Cursor csr_get_leg_code is
214: Select legislation_code
215: from hr_api_hook_calls
216: where api_hook_call_id = p_api_hook_call_id;
217: --
218: begin
219: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 268: raise hr_api.validate_enabled;

264: --
265: -- When in validation only mode raise the Validate_Enabled exception
266: --
267: if p_validate then
268: raise hr_api.validate_enabled;
269: end if;
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 100);
272: exception

Line 273: when hr_api.validate_enabled then

269: end if;
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 100);
272: exception
273: when hr_api.validate_enabled then
274: --
275: -- Only set output warning arguments
276: -- (Any key or derived arguments must be set to null
277: -- when validation only mode is being used.)

Line 295: end hr_api_hook_call_api;

291: --
292: end update_api_hook_call;
293: --
294: --
295: end hr_api_hook_call_api;