28: --
29: --
30: -- Out variables
31: --
32: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;
33: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
34:
35: -- Temp variables
36: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
29: --
30: -- Out variables
31: --
32: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;
33: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
34:
35: -- Temp variables
36: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
37: l_status hr_api_hook_calls.status%TYPE := 'N';
32: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;
33: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
34:
35: -- Temp variables
36: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
37: l_status hr_api_hook_calls.status%TYPE := 'N';
38: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
39: --
40: l_proc varchar2(72) := g_package||'create_leg_api_hook_call';
33: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
34:
35: -- Temp variables
36: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
37: l_status hr_api_hook_calls.status%TYPE := 'N';
38: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
39: --
40: l_proc varchar2(72) := g_package||'create_leg_api_hook_call';
41: --
34:
35: -- Temp variables
36: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
37: l_status hr_api_hook_calls.status%TYPE := 'N';
38: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
39: --
40: l_proc varchar2(72) := g_package||'create_leg_api_hook_call';
41: --
42: -- Declare a cursor that will check whether the passed
42: -- Declare a cursor that will check whether the passed
43: -- in hook package and hook procedure form a unique combination
44:
45: cursor csr_valid_combo is
46: select api_hook_call_id from hr_api_hook_calls
47: where api_hook_id = p_api_hook_id
48: and nvl(legislation_code,'x') = nvl(p_legislation_code,'x')
49: and nvl(call_package, 'x') = nvl(p_call_package,'x')
50: and nvl(call_procedure, 'x') = nvl(p_call_procedure, 'x')
110: --
111: -- When in validation only mode raise the Validate_Enabled exception
112: --
113: if p_validate then
114: raise hr_api.validate_enabled;
115: end if;
116: --
117: -- Set all output arguments
118: --
120: p_object_version_number := l_object_version_number;
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 100);
123: exception
124: when hr_api.validate_enabled then
125: --
126: -- As the Validate_Enabled exception has been raised
127: -- we must rollback to the savepoint
128: --
176: --
177: -- When in validation only mode raise the Validate_Enabled exception
178: --
179: if p_validate then
180: raise hr_api.validate_enabled;
181: end if;
182: --
183: hr_utility.set_location(' Leaving:'||l_proc, 100);
184: exception
181: end if;
182: --
183: hr_utility.set_location(' Leaving:'||l_proc, 100);
184: exception
185: when hr_api.validate_enabled then
186: --
187: -- As the Validate_Enabled exception has been raised
188: -- we must rollback to the savepoint
189: --
201: procedure update_leg_api_hook_call
202: (p_validate in boolean default false,
203: p_effective_date in date,
204: p_api_hook_call_id in number,
205: p_sequence in number default hr_api.g_number,
206: p_enabled_flag in varchar2 default hr_api.g_varchar2,
207: p_call_package in varchar2 default hr_api.g_varchar2,
208: p_call_procedure in varchar2 default hr_api.g_varchar2,
209: p_object_version_number in out nocopy number
202: (p_validate in boolean default false,
203: p_effective_date in date,
204: p_api_hook_call_id in number,
205: p_sequence in number default hr_api.g_number,
206: p_enabled_flag in varchar2 default hr_api.g_varchar2,
207: p_call_package in varchar2 default hr_api.g_varchar2,
208: p_call_procedure in varchar2 default hr_api.g_varchar2,
209: p_object_version_number in out nocopy number
210: ) is
203: p_effective_date in date,
204: p_api_hook_call_id in number,
205: p_sequence in number default hr_api.g_number,
206: p_enabled_flag in varchar2 default hr_api.g_varchar2,
207: p_call_package in varchar2 default hr_api.g_varchar2,
208: p_call_procedure in varchar2 default hr_api.g_varchar2,
209: p_object_version_number in out nocopy number
210: ) is
211: --
204: p_api_hook_call_id in number,
205: p_sequence in number default hr_api.g_number,
206: p_enabled_flag in varchar2 default hr_api.g_varchar2,
207: p_call_package in varchar2 default hr_api.g_varchar2,
208: p_call_procedure in varchar2 default hr_api.g_varchar2,
209: p_object_version_number in out nocopy number
210: ) is
211: --
212: -- Declare cursors and local variables
214: l_effective_date date;
215: --
216: -- Out variables
217: --
218: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
219:
220: l_proc varchar2(72) := g_package||'update_leg_api_hook_call';
221: --
222: begin
256: --
257: -- When in validation only mode raise the Validate_Enabled exception
258: --
259: if p_validate then
260: raise hr_api.validate_enabled;
261: end if;
262: --
263: -- Set all output arguments
264: --
265: p_object_version_number := l_object_version_number;
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 100);
268: exception
269: when hr_api.validate_enabled then
270: --
271: -- Only set output warning arguments
272: -- (Any key or derived arguments must be set to null
273: -- when validation only mode is being used.)