29: --
30: --
31: -- Out variables
32: --
33: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;
34: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
35:
36: l_legislation_code hr_api_hook_calls.legislation_code%TYPE := null;
37: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
30: --
31: -- Out variables
32: --
33: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;
34: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
35:
36: l_legislation_code hr_api_hook_calls.legislation_code%TYPE := null;
37: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
38: l_status hr_api_hook_calls.status%TYPE := 'N';
32: --
33: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;
34: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
35:
36: l_legislation_code hr_api_hook_calls.legislation_code%TYPE := null;
37: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
38: l_status hr_api_hook_calls.status%TYPE := 'N';
39: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
40: --
33: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;
34: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
35:
36: l_legislation_code hr_api_hook_calls.legislation_code%TYPE := null;
37: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
38: l_status hr_api_hook_calls.status%TYPE := 'N';
39: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
40: --
41: l_proc varchar2(72) := g_package
34: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
35:
36: l_legislation_code hr_api_hook_calls.legislation_code%TYPE := null;
37: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
38: l_status hr_api_hook_calls.status%TYPE := 'N';
39: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
40: --
41: l_proc varchar2(72) := g_package
42: || 'create_app_api_hook_call';
35:
36: l_legislation_code hr_api_hook_calls.legislation_code%TYPE := null;
37: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
38: l_status hr_api_hook_calls.status%TYPE := 'N';
39: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
40: --
41: l_proc varchar2(72) := g_package
42: || 'create_app_api_hook_call';
43: --
45: -- in hook package and hook procedure form a unique combination
46:
47: cursor csr_valid_combo is
48: select api_hook_call_id, object_version_number
49: from hr_api_hook_calls
50: where api_hook_id = p_api_hook_id
51: and nvl(application_id,hr_api.g_number)
52: = nvl(p_application_id,hr_api.g_number)
53: and nvl(call_package, hr_api.g_varchar2)
47: cursor csr_valid_combo is
48: select api_hook_call_id, object_version_number
49: from hr_api_hook_calls
50: where api_hook_id = p_api_hook_id
51: and nvl(application_id,hr_api.g_number)
52: = nvl(p_application_id,hr_api.g_number)
53: and nvl(call_package, hr_api.g_varchar2)
54: = nvl(p_call_package,hr_api.g_varchar2)
55: and nvl(call_procedure, hr_api.g_varchar2)
48: select api_hook_call_id, object_version_number
49: from hr_api_hook_calls
50: where api_hook_id = p_api_hook_id
51: and nvl(application_id,hr_api.g_number)
52: = nvl(p_application_id,hr_api.g_number)
53: and nvl(call_package, hr_api.g_varchar2)
54: = nvl(p_call_package,hr_api.g_varchar2)
55: and nvl(call_procedure, hr_api.g_varchar2)
56: = nvl(p_call_procedure, hr_api.g_varchar2)
49: from hr_api_hook_calls
50: where api_hook_id = p_api_hook_id
51: and nvl(application_id,hr_api.g_number)
52: = nvl(p_application_id,hr_api.g_number)
53: and nvl(call_package, hr_api.g_varchar2)
54: = nvl(p_call_package,hr_api.g_varchar2)
55: and nvl(call_procedure, hr_api.g_varchar2)
56: = nvl(p_call_procedure, hr_api.g_varchar2)
57: and legislation_code IS NULL;
50: where api_hook_id = p_api_hook_id
51: and nvl(application_id,hr_api.g_number)
52: = nvl(p_application_id,hr_api.g_number)
53: and nvl(call_package, hr_api.g_varchar2)
54: = nvl(p_call_package,hr_api.g_varchar2)
55: and nvl(call_procedure, hr_api.g_varchar2)
56: = nvl(p_call_procedure, hr_api.g_varchar2)
57: and legislation_code IS NULL;
58:
51: and nvl(application_id,hr_api.g_number)
52: = nvl(p_application_id,hr_api.g_number)
53: and nvl(call_package, hr_api.g_varchar2)
54: = nvl(p_call_package,hr_api.g_varchar2)
55: and nvl(call_procedure, hr_api.g_varchar2)
56: = nvl(p_call_procedure, hr_api.g_varchar2)
57: and legislation_code IS NULL;
58:
59: begin
52: = nvl(p_application_id,hr_api.g_number)
53: and nvl(call_package, hr_api.g_varchar2)
54: = nvl(p_call_package,hr_api.g_varchar2)
55: and nvl(call_procedure, hr_api.g_varchar2)
56: = nvl(p_call_procedure, hr_api.g_varchar2)
57: and legislation_code IS NULL;
58:
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 5);
125: --
126: -- When in validation only mode raise the Validate_Enabled exception
127: --
128: if p_validate then
129: raise hr_api.validate_enabled;
130: end if;
131: --
132: -- Set all output arguments
133: --
135: p_object_version_number := l_object_version_number;
136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 100);
138: exception
139: when hr_api.validate_enabled then
140: --
141: -- As the Validate_Enabled exception has been raised
142: -- we must rollback to the savepoint
143: --
170: --
171: -- Cursor to check application_id
172: CURSOR csr_check_app IS
173: SELECT 'Y'
174: FROM hr_api_hook_calls
175: WHERE api_hook_call_id = p_api_hook_call_id
176: AND application_id IS NOT NULL;
177: --
178: -- Cursor to check hook call exists
177: --
178: -- Cursor to check hook call exists
179: CURSOR csr_check_exists IS
180: SELECT 'Y'
181: FROM hr_api_hook_calls
182: WHERE api_hook_call_id = p_api_hook_call_id;
183: --
184: l_exists varchar2(1);
185: --
230: --
231: -- When in validation only mode raise the Validate_Enabled exception
232: --
233: if p_validate then
234: raise hr_api.validate_enabled;
235: end if;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 100);
238: exception
235: end if;
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: --
256: (p_validate in boolean default false,
257: p_effective_date in date,
258: p_api_hook_call_id in number,
259: p_object_version_number in out nocopy number,
260: p_sequence in number default hr_api.g_number,
261: p_app_install_status in varchar2 default hr_api.g_varchar2,
262: p_enabled_flag in varchar2 default hr_api.g_varchar2,
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
257: p_effective_date in date,
258: p_api_hook_call_id in number,
259: p_object_version_number in out nocopy number,
260: p_sequence in number default hr_api.g_number,
261: p_app_install_status in varchar2 default hr_api.g_varchar2,
262: p_enabled_flag in varchar2 default hr_api.g_varchar2,
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
265: p_pre_processor_date in date default hr_api.g_date,
258: p_api_hook_call_id in number,
259: p_object_version_number in out nocopy number,
260: p_sequence in number default hr_api.g_number,
261: p_app_install_status in varchar2 default hr_api.g_varchar2,
262: p_enabled_flag in varchar2 default hr_api.g_varchar2,
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
265: p_pre_processor_date in date default hr_api.g_date,
266: p_encoded_error in varchar2 default hr_api.g_varchar2,
259: p_object_version_number in out nocopy number,
260: p_sequence in number default hr_api.g_number,
261: p_app_install_status in varchar2 default hr_api.g_varchar2,
262: p_enabled_flag in varchar2 default hr_api.g_varchar2,
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
265: p_pre_processor_date in date default hr_api.g_date,
266: p_encoded_error in varchar2 default hr_api.g_varchar2,
267: p_status in varchar2 default hr_api.g_varchar2
260: p_sequence in number default hr_api.g_number,
261: p_app_install_status in varchar2 default hr_api.g_varchar2,
262: p_enabled_flag in varchar2 default hr_api.g_varchar2,
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
265: p_pre_processor_date in date default hr_api.g_date,
266: p_encoded_error in varchar2 default hr_api.g_varchar2,
267: p_status in varchar2 default hr_api.g_varchar2
268: ) is
261: p_app_install_status in varchar2 default hr_api.g_varchar2,
262: p_enabled_flag in varchar2 default hr_api.g_varchar2,
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
265: p_pre_processor_date in date default hr_api.g_date,
266: p_encoded_error in varchar2 default hr_api.g_varchar2,
267: p_status in varchar2 default hr_api.g_varchar2
268: ) is
269: --
262: p_enabled_flag in varchar2 default hr_api.g_varchar2,
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
265: p_pre_processor_date in date default hr_api.g_date,
266: p_encoded_error in varchar2 default hr_api.g_varchar2,
267: p_status in varchar2 default hr_api.g_varchar2
268: ) is
269: --
270: -- Declare cursors and local variables
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
265: p_pre_processor_date in date default hr_api.g_date,
266: p_encoded_error in varchar2 default hr_api.g_varchar2,
267: p_status in varchar2 default hr_api.g_varchar2
268: ) is
269: --
270: -- Declare cursors and local variables
271: --
272: l_effective_date date;
273: --
274: -- Out variables
275: --
276: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
277:
278: l_proc varchar2(72) := g_package||'update_app_api_hook_call';
279: --
280: -- Cursor to check application_id
279: --
280: -- Cursor to check application_id
281: CURSOR csr_check_app IS
282: SELECT 'Y'
283: FROM hr_api_hook_calls
284: WHERE api_hook_call_id = p_api_hook_call_id
285: AND application_id IS NOT NULL;
286: --
287: -- Cursor to check hook call exists
286: --
287: -- Cursor to check hook call exists
288: CURSOR csr_check_exists IS
289: SELECT 'Y'
290: FROM hr_api_hook_calls
291: WHERE api_hook_call_id = p_api_hook_call_id;
292: --
293: l_exists varchar2(1);
294: --
356: --
357: -- When in validation only mode raise the Validate_Enabled exception
358: --
359: if p_validate then
360: raise hr_api.validate_enabled;
361: end if;
362: --
363: -- Set all output arguments
364: --
365: p_object_version_number := l_object_version_number;
366: --
367: hr_utility.set_location(' Leaving:'||l_proc, 100);
368: exception
369: when hr_api.validate_enabled then
370: --
371: -- Only set output warning arguments
372: -- (Any key or derived arguments must be set to null
373: -- when validation only mode is being used.)