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.PQH_ATTRIBUTE_RANGES_API dependencies on HR_API

Line 76: when hr_api.cannot_find_prog_unit then

72: ,p_to_number => p_to_number
73: ,p_effective_date => trunc(p_effective_date)
74: );
75: exception
76: when hr_api.cannot_find_prog_unit then
77: hr_api.cannot_find_prog_unit_error
78: (
79: p_module_name => 'CREATE_ATTRIBUTE_RANGE'
80: ,p_hook_type => 'BP'

Line 77: hr_api.cannot_find_prog_unit_error

73: ,p_effective_date => trunc(p_effective_date)
74: );
75: exception
76: when hr_api.cannot_find_prog_unit then
77: hr_api.cannot_find_prog_unit_error
78: (
79: p_module_name => 'CREATE_ATTRIBUTE_RANGE'
80: ,p_hook_type => 'BP'
81: );

Line 135: when hr_api.cannot_find_prog_unit then

131: ,p_object_version_number => l_object_version_number
132: ,p_effective_date => trunc(p_effective_date)
133: );
134: exception
135: when hr_api.cannot_find_prog_unit then
136: hr_api.cannot_find_prog_unit_error
137: (p_module_name => 'CREATE_ATTRIBUTE_RANGE'
138: ,p_hook_type => 'AP'
139: );

Line 136: hr_api.cannot_find_prog_unit_error

132: ,p_effective_date => trunc(p_effective_date)
133: );
134: exception
135: when hr_api.cannot_find_prog_unit then
136: hr_api.cannot_find_prog_unit_error
137: (p_module_name => 'CREATE_ATTRIBUTE_RANGE'
138: ,p_hook_type => 'AP'
139: );
140: --

Line 150: raise hr_api.validate_enabled;

146: --
147: -- When in validation only mode raise the Validate_Enabled exception
148: --
149: if p_validate then
150: raise hr_api.validate_enabled;
151: end if;
152: --
153: -- Set all output arguments
154: --

Line 162: when hr_api.validate_enabled then

158: hr_utility.set_location(' Leaving:'||l_proc, 70);
159: --
160: exception
161: --
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 194: ,p_approver_flag in varchar2 default hr_api.g_varchar2

190: --
191: procedure update_ATTRIBUTE_RANGE
192: (p_validate in boolean default false
193: ,p_attribute_range_id in number
194: ,p_approver_flag in varchar2 default hr_api.g_varchar2
195: ,p_enable_flag in varchar2 default hr_api.g_varchar2
196: ,p_delete_flag in varchar2 default hr_api.g_varchar2
197: ,p_assignment_id in number default hr_api.g_number
198: ,p_attribute_id in number default hr_api.g_number

Line 195: ,p_enable_flag in varchar2 default hr_api.g_varchar2

191: procedure update_ATTRIBUTE_RANGE
192: (p_validate in boolean default false
193: ,p_attribute_range_id in number
194: ,p_approver_flag in varchar2 default hr_api.g_varchar2
195: ,p_enable_flag in varchar2 default hr_api.g_varchar2
196: ,p_delete_flag in varchar2 default hr_api.g_varchar2
197: ,p_assignment_id in number default hr_api.g_number
198: ,p_attribute_id in number default hr_api.g_number
199: ,p_from_char in varchar2 default hr_api.g_varchar2

Line 196: ,p_delete_flag in varchar2 default hr_api.g_varchar2

192: (p_validate in boolean default false
193: ,p_attribute_range_id in number
194: ,p_approver_flag in varchar2 default hr_api.g_varchar2
195: ,p_enable_flag in varchar2 default hr_api.g_varchar2
196: ,p_delete_flag in varchar2 default hr_api.g_varchar2
197: ,p_assignment_id in number default hr_api.g_number
198: ,p_attribute_id in number default hr_api.g_number
199: ,p_from_char in varchar2 default hr_api.g_varchar2
200: ,p_from_date in date default hr_api.g_date

Line 197: ,p_assignment_id in number default hr_api.g_number

193: ,p_attribute_range_id in number
194: ,p_approver_flag in varchar2 default hr_api.g_varchar2
195: ,p_enable_flag in varchar2 default hr_api.g_varchar2
196: ,p_delete_flag in varchar2 default hr_api.g_varchar2
197: ,p_assignment_id in number default hr_api.g_number
198: ,p_attribute_id in number default hr_api.g_number
199: ,p_from_char in varchar2 default hr_api.g_varchar2
200: ,p_from_date in date default hr_api.g_date
201: ,p_from_number in number default hr_api.g_number

Line 198: ,p_attribute_id in number default hr_api.g_number

194: ,p_approver_flag in varchar2 default hr_api.g_varchar2
195: ,p_enable_flag in varchar2 default hr_api.g_varchar2
196: ,p_delete_flag in varchar2 default hr_api.g_varchar2
197: ,p_assignment_id in number default hr_api.g_number
198: ,p_attribute_id in number default hr_api.g_number
199: ,p_from_char in varchar2 default hr_api.g_varchar2
200: ,p_from_date in date default hr_api.g_date
201: ,p_from_number in number default hr_api.g_number
202: ,p_position_id in number default hr_api.g_number

Line 199: ,p_from_char in varchar2 default hr_api.g_varchar2

195: ,p_enable_flag in varchar2 default hr_api.g_varchar2
196: ,p_delete_flag in varchar2 default hr_api.g_varchar2
197: ,p_assignment_id in number default hr_api.g_number
198: ,p_attribute_id in number default hr_api.g_number
199: ,p_from_char in varchar2 default hr_api.g_varchar2
200: ,p_from_date in date default hr_api.g_date
201: ,p_from_number in number default hr_api.g_number
202: ,p_position_id in number default hr_api.g_number
203: ,p_range_name in varchar2 default hr_api.g_varchar2

Line 200: ,p_from_date in date default hr_api.g_date

196: ,p_delete_flag in varchar2 default hr_api.g_varchar2
197: ,p_assignment_id in number default hr_api.g_number
198: ,p_attribute_id in number default hr_api.g_number
199: ,p_from_char in varchar2 default hr_api.g_varchar2
200: ,p_from_date in date default hr_api.g_date
201: ,p_from_number in number default hr_api.g_number
202: ,p_position_id in number default hr_api.g_number
203: ,p_range_name in varchar2 default hr_api.g_varchar2
204: ,p_routing_category_id in number default hr_api.g_number

Line 201: ,p_from_number in number default hr_api.g_number

197: ,p_assignment_id in number default hr_api.g_number
198: ,p_attribute_id in number default hr_api.g_number
199: ,p_from_char in varchar2 default hr_api.g_varchar2
200: ,p_from_date in date default hr_api.g_date
201: ,p_from_number in number default hr_api.g_number
202: ,p_position_id in number default hr_api.g_number
203: ,p_range_name in varchar2 default hr_api.g_varchar2
204: ,p_routing_category_id in number default hr_api.g_number
205: ,p_routing_list_member_id in number default hr_api.g_number

Line 202: ,p_position_id in number default hr_api.g_number

198: ,p_attribute_id in number default hr_api.g_number
199: ,p_from_char in varchar2 default hr_api.g_varchar2
200: ,p_from_date in date default hr_api.g_date
201: ,p_from_number in number default hr_api.g_number
202: ,p_position_id in number default hr_api.g_number
203: ,p_range_name in varchar2 default hr_api.g_varchar2
204: ,p_routing_category_id in number default hr_api.g_number
205: ,p_routing_list_member_id in number default hr_api.g_number
206: ,p_to_char in varchar2 default hr_api.g_varchar2

Line 203: ,p_range_name in varchar2 default hr_api.g_varchar2

199: ,p_from_char in varchar2 default hr_api.g_varchar2
200: ,p_from_date in date default hr_api.g_date
201: ,p_from_number in number default hr_api.g_number
202: ,p_position_id in number default hr_api.g_number
203: ,p_range_name in varchar2 default hr_api.g_varchar2
204: ,p_routing_category_id in number default hr_api.g_number
205: ,p_routing_list_member_id in number default hr_api.g_number
206: ,p_to_char in varchar2 default hr_api.g_varchar2
207: ,p_to_date in date default hr_api.g_date

Line 204: ,p_routing_category_id in number default hr_api.g_number

200: ,p_from_date in date default hr_api.g_date
201: ,p_from_number in number default hr_api.g_number
202: ,p_position_id in number default hr_api.g_number
203: ,p_range_name in varchar2 default hr_api.g_varchar2
204: ,p_routing_category_id in number default hr_api.g_number
205: ,p_routing_list_member_id in number default hr_api.g_number
206: ,p_to_char in varchar2 default hr_api.g_varchar2
207: ,p_to_date in date default hr_api.g_date
208: ,p_to_number in number default hr_api.g_number

Line 205: ,p_routing_list_member_id in number default hr_api.g_number

201: ,p_from_number in number default hr_api.g_number
202: ,p_position_id in number default hr_api.g_number
203: ,p_range_name in varchar2 default hr_api.g_varchar2
204: ,p_routing_category_id in number default hr_api.g_number
205: ,p_routing_list_member_id in number default hr_api.g_number
206: ,p_to_char in varchar2 default hr_api.g_varchar2
207: ,p_to_date in date default hr_api.g_date
208: ,p_to_number in number default hr_api.g_number
209: ,p_object_version_number in out nocopy number

Line 206: ,p_to_char in varchar2 default hr_api.g_varchar2

202: ,p_position_id in number default hr_api.g_number
203: ,p_range_name in varchar2 default hr_api.g_varchar2
204: ,p_routing_category_id in number default hr_api.g_number
205: ,p_routing_list_member_id in number default hr_api.g_number
206: ,p_to_char in varchar2 default hr_api.g_varchar2
207: ,p_to_date in date default hr_api.g_date
208: ,p_to_number in number default hr_api.g_number
209: ,p_object_version_number in out nocopy number
210: ,p_effective_date in date

Line 207: ,p_to_date in date default hr_api.g_date

203: ,p_range_name in varchar2 default hr_api.g_varchar2
204: ,p_routing_category_id in number default hr_api.g_number
205: ,p_routing_list_member_id in number default hr_api.g_number
206: ,p_to_char in varchar2 default hr_api.g_varchar2
207: ,p_to_date in date default hr_api.g_date
208: ,p_to_number in number default hr_api.g_number
209: ,p_object_version_number in out nocopy number
210: ,p_effective_date in date
211: ) is

Line 208: ,p_to_number in number default hr_api.g_number

204: ,p_routing_category_id in number default hr_api.g_number
205: ,p_routing_list_member_id in number default hr_api.g_number
206: ,p_to_char in varchar2 default hr_api.g_varchar2
207: ,p_to_date in date default hr_api.g_date
208: ,p_to_number in number default hr_api.g_number
209: ,p_object_version_number in out nocopy number
210: ,p_effective_date in date
211: ) is
212: --

Line 258: when hr_api.cannot_find_prog_unit then

254: ,p_object_version_number => p_object_version_number
255: ,p_effective_date => trunc(p_effective_date)
256: );
257: exception
258: when hr_api.cannot_find_prog_unit then
259: hr_api.cannot_find_prog_unit_error
260: (p_module_name => 'UPDATE_ATTRIBUTE_RANGE'
261: ,p_hook_type => 'BP'
262: );

Line 259: hr_api.cannot_find_prog_unit_error

255: ,p_effective_date => trunc(p_effective_date)
256: );
257: exception
258: when hr_api.cannot_find_prog_unit then
259: hr_api.cannot_find_prog_unit_error
260: (p_module_name => 'UPDATE_ATTRIBUTE_RANGE'
261: ,p_hook_type => 'BP'
262: );
263: --

Line 316: when hr_api.cannot_find_prog_unit then

312: ,p_object_version_number => l_object_version_number
313: ,p_effective_date => trunc(p_effective_date)
314: );
315: exception
316: when hr_api.cannot_find_prog_unit then
317: hr_api.cannot_find_prog_unit_error
318: (p_module_name => 'UPDATE_ATTRIBUTE_RANGE'
319: ,p_hook_type => 'AP'
320: );

Line 317: hr_api.cannot_find_prog_unit_error

313: ,p_effective_date => trunc(p_effective_date)
314: );
315: exception
316: when hr_api.cannot_find_prog_unit then
317: hr_api.cannot_find_prog_unit_error
318: (p_module_name => 'UPDATE_ATTRIBUTE_RANGE'
319: ,p_hook_type => 'AP'
320: );
321: --

Line 331: raise hr_api.validate_enabled;

327: --
328: -- When in validation only mode raise the Validate_Enabled exception
329: --
330: if p_validate then
331: raise hr_api.validate_enabled;
332: end if;
333: --
334: -- Set all output arguments
335: --

Line 342: when hr_api.validate_enabled then

338: hr_utility.set_location(' Leaving:'||l_proc, 70);
339: --
340: exception
341: --
342: when hr_api.validate_enabled then
343: --
344: -- As the Validate_Enabled exception has been raised
345: -- we must rollback to the savepoint
346: --

Line 406: when hr_api.cannot_find_prog_unit then

402: ,p_object_version_number => p_object_version_number
403: ,p_effective_date => trunc(p_effective_date)
404: );
405: exception
406: when hr_api.cannot_find_prog_unit then
407: hr_api.cannot_find_prog_unit_error
408: (p_module_name => 'DELETE_ATTRIBUTE_RANGE'
409: ,p_hook_type => 'BP'
410: );

Line 407: hr_api.cannot_find_prog_unit_error

403: ,p_effective_date => trunc(p_effective_date)
404: );
405: exception
406: when hr_api.cannot_find_prog_unit then
407: hr_api.cannot_find_prog_unit_error
408: (p_module_name => 'DELETE_ATTRIBUTE_RANGE'
409: ,p_hook_type => 'BP'
410: );
411: --

Line 434: when hr_api.cannot_find_prog_unit then

430: ,p_object_version_number => l_object_version_number
431: ,p_effective_date => trunc(p_effective_date)
432: );
433: exception
434: when hr_api.cannot_find_prog_unit then
435: hr_api.cannot_find_prog_unit_error
436: (p_module_name => 'DELETE_ATTRIBUTE_RANGE'
437: ,p_hook_type => 'AP'
438: );

Line 435: hr_api.cannot_find_prog_unit_error

431: ,p_effective_date => trunc(p_effective_date)
432: );
433: exception
434: when hr_api.cannot_find_prog_unit then
435: hr_api.cannot_find_prog_unit_error
436: (p_module_name => 'DELETE_ATTRIBUTE_RANGE'
437: ,p_hook_type => 'AP'
438: );
439: --

Line 449: raise hr_api.validate_enabled;

445: --
446: -- When in validation only mode raise the Validate_Enabled exception
447: --
448: if p_validate then
449: raise hr_api.validate_enabled;
450: end if;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 70);
453: --

Line 456: when hr_api.validate_enabled then

452: hr_utility.set_location(' Leaving:'||l_proc, 70);
453: --
454: exception
455: --
456: when hr_api.validate_enabled then
457: --
458: -- As the Validate_Enabled exception has been raised
459: -- we must rollback to the savepoint
460: --