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

Line 32: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;

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;

Line 33: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;

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';

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

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';

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

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: --

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

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

Line 46: select api_hook_call_id from hr_api_hook_calls

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')

Line 114: raise hr_api.validate_enabled;

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: --

Line 124: when hr_api.validate_enabled then

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: --

Line 180: raise hr_api.validate_enabled;

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

Line 185: when hr_api.validate_enabled then

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: --

Line 205: p_sequence in number default hr_api.g_number,

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

Line 206: p_enabled_flag in varchar2 default hr_api.g_varchar2,

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

Line 207: p_call_package in varchar2 default hr_api.g_varchar2,

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: --

Line 208: p_call_procedure in varchar2 default hr_api.g_varchar2,

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

Line 218: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;

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

Line 260: raise hr_api.validate_enabled;

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: --

Line 269: when hr_api.validate_enabled then

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.)