APPS.PQP_EXR_API dependencies on HR_API

Line 24: ,p_language_code in varchar2 default hr_api.userenv_lang

20: ,p_variance_type in varchar2 default null
21: ,p_variance_value in number default null
22: ,p_comparison_type in varchar2 default null
23: ,p_comparison_value in number default null
24: ,p_language_code in varchar2 default hr_api.userenv_lang
25: ,p_exception_report_id out nocopy number
26: ,p_object_version_number out nocopy number
27: ,p_output_format_type in varchar2
28: ,p_variance_operator in varchar2

Line 50: hr_api.validate_language_code(p_language_code => l_language_code);

46:
47: hr_utility.set_location(l_proc, 20);
48:
49: l_language_code := p_language_code;
50: hr_api.validate_language_code(p_language_code => l_language_code);
51:
52: --
53: -- Call Before Process User Hook
54: --

Line 71: when hr_api.cannot_find_prog_unit then

67: ,p_output_format_type => p_output_format_type
68: ,p_variance_operator => p_variance_operator
69: );
70: exception
71: when hr_api.cannot_find_prog_unit then
72: hr_api.cannot_find_prog_unit_error
73: (p_module_name => 'create_exception_report'
74: ,p_hook_type => 'BP'
75: );

Line 72: hr_api.cannot_find_prog_unit_error

68: ,p_variance_operator => p_variance_operator
69: );
70: exception
71: when hr_api.cannot_find_prog_unit then
72: hr_api.cannot_find_prog_unit_error
73: (p_module_name => 'create_exception_report'
74: ,p_hook_type => 'BP'
75: );
76: end;

Line 135: when hr_api.cannot_find_prog_unit then

131: ,p_output_format_type => p_output_format_type
132: ,p_variance_operator => p_variance_operator
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_exception_report'
138: ,p_hook_type => 'AP'
139: );

Line 136: hr_api.cannot_find_prog_unit_error

132: ,p_variance_operator => p_variance_operator
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_exception_report'
138: ,p_hook_type => 'AP'
139: );
140: end;

Line 146: raise hr_api.validate_enabled;

142: --
143: -- When in validation only mode raise the Validate_Enabled exception
144: --
145: if p_validate then
146: raise hr_api.validate_enabled;
147: end if;
148: --
149: -- Set all output arguments
150: --

Line 156: when hr_api.validate_enabled then

152: p_object_version_number := l_object_version_number;
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 70);
155: exception
156: when hr_api.validate_enabled then
157: --
158: -- As the Validate_Enabled exception has been raised
159: -- we must rollback to the savepoint
160: --

Line 187: ,p_exception_report_name in varchar2 default hr_api.g_varchar2

183: -- ----------------------------------------------------------------------------
184: --
185: procedure update_exception_report
186: (p_validate in boolean default false
187: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_business_group_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number

Line 188: ,p_legislation_code in varchar2 default hr_api.g_varchar2

184: --
185: procedure update_exception_report
186: (p_validate in boolean default false
187: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_business_group_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number

Line 189: ,p_business_group_id in number default hr_api.g_number

185: procedure update_exception_report
186: (p_validate in boolean default false
187: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_business_group_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2

Line 190: ,p_currency_code in varchar2 default hr_api.g_varchar2

186: (p_validate in boolean default false
187: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_business_group_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number

Line 191: ,p_balance_type_id in number default hr_api.g_number

187: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_business_group_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2

Line 192: ,p_balance_dimension_id in number default hr_api.g_number

188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_business_group_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
196: ,p_comparison_value in number default hr_api.g_number

Line 193: ,p_variance_type in varchar2 default hr_api.g_varchar2

189: ,p_business_group_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
196: ,p_comparison_value in number default hr_api.g_number
197: ,p_exception_report_id in number default hr_api.g_number

Line 194: ,p_variance_value in number default hr_api.g_number

190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
196: ,p_comparison_value in number default hr_api.g_number
197: ,p_exception_report_id in number default hr_api.g_number
198: ,p_language_code in varchar2 default hr_api.userenv_lang

Line 195: ,p_comparison_type in varchar2 default hr_api.g_varchar2

191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
196: ,p_comparison_value in number default hr_api.g_number
197: ,p_exception_report_id in number default hr_api.g_number
198: ,p_language_code in varchar2 default hr_api.userenv_lang
199: ,p_object_version_number in out nocopy number

Line 196: ,p_comparison_value in number default hr_api.g_number

192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
196: ,p_comparison_value in number default hr_api.g_number
197: ,p_exception_report_id in number default hr_api.g_number
198: ,p_language_code in varchar2 default hr_api.userenv_lang
199: ,p_object_version_number in out nocopy number
200: ,p_output_format_type in varchar2 default hr_api.g_varchar2

Line 197: ,p_exception_report_id in number default hr_api.g_number

193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
196: ,p_comparison_value in number default hr_api.g_number
197: ,p_exception_report_id in number default hr_api.g_number
198: ,p_language_code in varchar2 default hr_api.userenv_lang
199: ,p_object_version_number in out nocopy number
200: ,p_output_format_type in varchar2 default hr_api.g_varchar2
201: ,p_variance_operator in varchar2 default hr_api.g_varchar2

Line 198: ,p_language_code in varchar2 default hr_api.userenv_lang

194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
196: ,p_comparison_value in number default hr_api.g_number
197: ,p_exception_report_id in number default hr_api.g_number
198: ,p_language_code in varchar2 default hr_api.userenv_lang
199: ,p_object_version_number in out nocopy number
200: ,p_output_format_type in varchar2 default hr_api.g_varchar2
201: ,p_variance_operator in varchar2 default hr_api.g_varchar2
202:

Line 200: ,p_output_format_type in varchar2 default hr_api.g_varchar2

196: ,p_comparison_value in number default hr_api.g_number
197: ,p_exception_report_id in number default hr_api.g_number
198: ,p_language_code in varchar2 default hr_api.userenv_lang
199: ,p_object_version_number in out nocopy number
200: ,p_output_format_type in varchar2 default hr_api.g_varchar2
201: ,p_variance_operator in varchar2 default hr_api.g_varchar2
202:
203: ) is
204:

Line 201: ,p_variance_operator in varchar2 default hr_api.g_varchar2

197: ,p_exception_report_id in number default hr_api.g_number
198: ,p_language_code in varchar2 default hr_api.userenv_lang
199: ,p_object_version_number in out nocopy number
200: ,p_output_format_type in varchar2 default hr_api.g_varchar2
201: ,p_variance_operator in varchar2 default hr_api.g_varchar2
202:
203: ) is
204:
205: --

Line 222: hr_api.validate_language_code(p_language_code => l_language_code);

218:
219: hr_utility.set_location(l_proc, 20);
220:
221: l_language_code := p_language_code;
222: hr_api.validate_language_code(p_language_code => l_language_code);
223:
224: --
225: -- Call Before Process User Hook
226: --

Line 245: when hr_api.cannot_find_prog_unit then

241: ,p_output_format_type => p_output_format_type
242: ,p_variance_operator => p_variance_operator
243: );
244: exception
245: when hr_api.cannot_find_prog_unit then
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'update_exception_report'
248: ,p_hook_type => 'BP'
249: );

Line 246: hr_api.cannot_find_prog_unit_error

242: ,p_variance_operator => p_variance_operator
243: );
244: exception
245: when hr_api.cannot_find_prog_unit then
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'update_exception_report'
248: ,p_hook_type => 'BP'
249: );
250: end;

Line 310: when hr_api.cannot_find_prog_unit then

306: ,p_output_format_type => p_output_format_type
307: ,p_variance_operator => p_variance_operator
308: );
309: exception
310: when hr_api.cannot_find_prog_unit then
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'update_exception_report'
313: ,p_hook_type => 'AP'
314: );

Line 311: hr_api.cannot_find_prog_unit_error

307: ,p_variance_operator => p_variance_operator
308: );
309: exception
310: when hr_api.cannot_find_prog_unit then
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'update_exception_report'
313: ,p_hook_type => 'AP'
314: );
315: end;

Line 321: raise hr_api.validate_enabled;

317: --
318: -- When in validation only mode raise the Validate_Enabled exception
319: --
320: if p_validate then
321: raise hr_api.validate_enabled;
322: end if;
323: --
324: -- Set all output arguments
325: --

Line 330: when hr_api.validate_enabled then

326: p_object_version_number := l_object_version_number;
327: --
328: hr_utility.set_location(' Leaving:'||l_proc, 70);
329: exception
330: when hr_api.validate_enabled then
331: --
332: -- As the Validate_Enabled exception has been raised
333: -- we must rollback to the savepoint
334: --

Line 397: when hr_api.cannot_find_prog_unit then

393: ,p_business_group_id => l_business_group_id
394: ,p_object_version_number => p_object_version_number
395: );
396: exception
397: when hr_api.cannot_find_prog_unit then
398: hr_api.cannot_find_prog_unit_error
399: (p_module_name => 'delete_exception_report'
400: ,p_hook_type => 'BP'
401: );

Line 398: hr_api.cannot_find_prog_unit_error

394: ,p_object_version_number => p_object_version_number
395: );
396: exception
397: when hr_api.cannot_find_prog_unit then
398: hr_api.cannot_find_prog_unit_error
399: (p_module_name => 'delete_exception_report'
400: ,p_hook_type => 'BP'
401: );
402: end;

Line 435: when hr_api.cannot_find_prog_unit then

431: ,p_business_group_id => l_business_group_id
432: ,p_object_version_number => p_object_version_number
433: );
434: exception
435: when hr_api.cannot_find_prog_unit then
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'delete_exception_report'
438: ,p_hook_type => 'AP'
439: );

Line 436: hr_api.cannot_find_prog_unit_error

432: ,p_object_version_number => p_object_version_number
433: );
434: exception
435: when hr_api.cannot_find_prog_unit then
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'delete_exception_report'
438: ,p_hook_type => 'AP'
439: );
440: end;

Line 446: raise hr_api.validate_enabled;

442: --
443: -- When in validation only mode raise the Validate_Enabled exception
444: --
445: if p_validate then
446: raise hr_api.validate_enabled;
447: end if;
448: --
449: -- Set all output arguments
450: --

Line 454: when hr_api.validate_enabled then

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