DBA Data[Home] [Help]

APPS.PQP_EXR_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_exception_report >-----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_exception_report
12: (p_validate in number default hr_api.g_false_num
13: ,p_exception_report_name in varchar2
14: ,p_legislation_code in varchar2 default null
15: ,p_business_group_id in number default null
16: ,p_currency_code in varchar2 default null

Line 55: hr_api.constant_to_boolean

51: --
52: -- Convert constant values to their corresponding boolean value
53: --
54: l_validate :=
55: hr_api.constant_to_boolean
56: (p_constant_value => p_validate);
57: --
58: -- Register Surrogate ID or user key values
59: --

Line 136: (p_validate in number default hr_api.g_false_num

132: -- ----------------------------------------------------------------------------
133: -- |------------------------< delete_exception_report >-----------------------|
134: -- ----------------------------------------------------------------------------
135: PROCEDURE delete_exception_report
136: (p_validate in number default hr_api.g_false_num
137: ,p_exception_report_id in number
138: ,p_object_version_number in number
139: ,p_return_status out nocopy varchar2
140: ) is

Line 166: hr_api.constant_to_boolean

162: --
163: -- Convert constant values to their corresponding boolean value
164: --
165: l_validate :=
166: hr_api.constant_to_boolean
167: (p_constant_value => p_validate);
168: --
169: -- Register Surrogate ID or user key values
170: --

Line 230: (p_validate in number default hr_api.g_false_num

226: -- ----------------------------------------------------------------------------
227: -- |------------------------< update_exception_report >-----------------------|
228: -- ----------------------------------------------------------------------------
229: PROCEDURE update_exception_report
230: (p_validate in number default hr_api.g_false_num
231: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
232: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 231: ,p_exception_report_name in varchar2 default hr_api.g_varchar2

227: -- |------------------------< update_exception_report >-----------------------|
228: -- ----------------------------------------------------------------------------
229: PROCEDURE update_exception_report
230: (p_validate in number default hr_api.g_false_num
231: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
232: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number

Line 232: ,p_legislation_code in varchar2 default hr_api.g_varchar2

228: -- ----------------------------------------------------------------------------
229: PROCEDURE update_exception_report
230: (p_validate in number default hr_api.g_false_num
231: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
232: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number

Line 233: ,p_business_group_id in number default hr_api.g_number

229: PROCEDURE update_exception_report
230: (p_validate in number default hr_api.g_false_num
231: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
232: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2

Line 234: ,p_currency_code in varchar2 default hr_api.g_varchar2

230: (p_validate in number default hr_api.g_false_num
231: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
232: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number

Line 235: ,p_balance_type_id in number default hr_api.g_number

231: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
232: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2

Line 236: ,p_balance_dimension_id in number default hr_api.g_number

232: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
240: ,p_comparison_value in number default hr_api.g_number

Line 237: ,p_variance_type in varchar2 default hr_api.g_varchar2

233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
240: ,p_comparison_value in number default hr_api.g_number
241: ,p_exception_report_id in number default hr_api.g_number

Line 238: ,p_variance_value in number default hr_api.g_number

234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
240: ,p_comparison_value in number default hr_api.g_number
241: ,p_exception_report_id in number default hr_api.g_number
242: ,p_language_code in varchar2 default hr_api.g_varchar2

Line 239: ,p_comparison_type in varchar2 default hr_api.g_varchar2

235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
240: ,p_comparison_value in number default hr_api.g_number
241: ,p_exception_report_id in number default hr_api.g_number
242: ,p_language_code in varchar2 default hr_api.g_varchar2
243: ,p_object_version_number in out nocopy number

Line 240: ,p_comparison_value in number default hr_api.g_number

236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
240: ,p_comparison_value in number default hr_api.g_number
241: ,p_exception_report_id in number default hr_api.g_number
242: ,p_language_code in varchar2 default hr_api.g_varchar2
243: ,p_object_version_number in out nocopy number
244: ,p_output_format_type in varchar2 default hr_api.g_varchar2

Line 241: ,p_exception_report_id in number default hr_api.g_number

237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
240: ,p_comparison_value in number default hr_api.g_number
241: ,p_exception_report_id in number default hr_api.g_number
242: ,p_language_code in varchar2 default hr_api.g_varchar2
243: ,p_object_version_number in out nocopy number
244: ,p_output_format_type in varchar2 default hr_api.g_varchar2
245: ,p_variance_operator in varchar2 default hr_api.g_varchar2

Line 242: ,p_language_code in varchar2 default hr_api.g_varchar2

238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
240: ,p_comparison_value in number default hr_api.g_number
241: ,p_exception_report_id in number default hr_api.g_number
242: ,p_language_code in varchar2 default hr_api.g_varchar2
243: ,p_object_version_number in out nocopy number
244: ,p_output_format_type in varchar2 default hr_api.g_varchar2
245: ,p_variance_operator in varchar2 default hr_api.g_varchar2
246: ,p_return_status out nocopy varchar2

Line 244: ,p_output_format_type in varchar2 default hr_api.g_varchar2

240: ,p_comparison_value in number default hr_api.g_number
241: ,p_exception_report_id in number default hr_api.g_number
242: ,p_language_code in varchar2 default hr_api.g_varchar2
243: ,p_object_version_number in out nocopy number
244: ,p_output_format_type in varchar2 default hr_api.g_varchar2
245: ,p_variance_operator in varchar2 default hr_api.g_varchar2
246: ,p_return_status out nocopy varchar2
247: ) is
248: --

Line 245: ,p_variance_operator in varchar2 default hr_api.g_varchar2

241: ,p_exception_report_id in number default hr_api.g_number
242: ,p_language_code in varchar2 default hr_api.g_varchar2
243: ,p_object_version_number in out nocopy number
244: ,p_output_format_type in varchar2 default hr_api.g_varchar2
245: ,p_variance_operator in varchar2 default hr_api.g_varchar2
246: ,p_return_status out nocopy varchar2
247: ) is
248: --
249: -- Variables for API Boolean parameters

Line 275: hr_api.constant_to_boolean

271: --
272: -- Convert constant values to their corresponding boolean value
273: --
274: l_validate :=
275: hr_api.constant_to_boolean
276: (p_constant_value => p_validate);
277: --
278: -- Register Surrogate ID or user key values
279: --

Line 356: p_validate in number default hr_api.g_false_num

352: -- ----------------------------------------------------------------------------
353: -- |------------------------< submit_request_set >-----------------------|
354: -- ----------------------------------------------------------------------------
355: procedure submit_request_set(
356: p_validate in number default hr_api.g_false_num
357: ,p_exception_report_id in number
358: ,p_legislation_code in varchar2 default null
359: ,p_business_group_id in number default null
360: ,p_consolidation_set_id in number default null