DBA Data[Home] [Help]

APPS.PQP_EXR_API dependencies on HR_API

Line 20: ,p_language_code in varchar2 default hr_api.userenv_lang

16: ,p_variance_type in varchar2 default null
17: ,p_variance_value in number default null
18: ,p_comparison_type in varchar2 default null
19: ,p_comparison_value in number default null
20: ,p_language_code in varchar2 default hr_api.userenv_lang
21: ,p_exception_report_id out nocopy number
22: ,p_object_version_number out nocopy number
23: ,p_output_format_type in varchar2
24: ,p_variance_operator in varchar2

Line 33: ,p_exception_report_name in varchar2 default hr_api.g_varchar2

29: -- ----------------------------------------------------------------------------
30: --
31: procedure update_exception_report
32: (p_validate in boolean default false
33: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
34: ,p_legislation_code in varchar2 default hr_api.g_varchar2
35: ,p_business_group_id in number default hr_api.g_number
36: ,p_currency_code in varchar2 default hr_api.g_varchar2
37: ,p_balance_type_id in number default hr_api.g_number

Line 34: ,p_legislation_code in varchar2 default hr_api.g_varchar2

30: --
31: procedure update_exception_report
32: (p_validate in boolean default false
33: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
34: ,p_legislation_code in varchar2 default hr_api.g_varchar2
35: ,p_business_group_id in number default hr_api.g_number
36: ,p_currency_code in varchar2 default hr_api.g_varchar2
37: ,p_balance_type_id in number default hr_api.g_number
38: ,p_balance_dimension_id in number default hr_api.g_number

Line 35: ,p_business_group_id in number default hr_api.g_number

31: procedure update_exception_report
32: (p_validate in boolean default false
33: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
34: ,p_legislation_code in varchar2 default hr_api.g_varchar2
35: ,p_business_group_id in number default hr_api.g_number
36: ,p_currency_code in varchar2 default hr_api.g_varchar2
37: ,p_balance_type_id in number default hr_api.g_number
38: ,p_balance_dimension_id in number default hr_api.g_number
39: ,p_variance_type in varchar2 default hr_api.g_varchar2

Line 36: ,p_currency_code in varchar2 default hr_api.g_varchar2

32: (p_validate in boolean default false
33: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
34: ,p_legislation_code in varchar2 default hr_api.g_varchar2
35: ,p_business_group_id in number default hr_api.g_number
36: ,p_currency_code in varchar2 default hr_api.g_varchar2
37: ,p_balance_type_id in number default hr_api.g_number
38: ,p_balance_dimension_id in number default hr_api.g_number
39: ,p_variance_type in varchar2 default hr_api.g_varchar2
40: ,p_variance_value in number default hr_api.g_number

Line 37: ,p_balance_type_id in number default hr_api.g_number

33: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
34: ,p_legislation_code in varchar2 default hr_api.g_varchar2
35: ,p_business_group_id in number default hr_api.g_number
36: ,p_currency_code in varchar2 default hr_api.g_varchar2
37: ,p_balance_type_id in number default hr_api.g_number
38: ,p_balance_dimension_id in number default hr_api.g_number
39: ,p_variance_type in varchar2 default hr_api.g_varchar2
40: ,p_variance_value in number default hr_api.g_number
41: ,p_comparison_type in varchar2 default hr_api.g_varchar2

Line 38: ,p_balance_dimension_id in number default hr_api.g_number

34: ,p_legislation_code in varchar2 default hr_api.g_varchar2
35: ,p_business_group_id in number default hr_api.g_number
36: ,p_currency_code in varchar2 default hr_api.g_varchar2
37: ,p_balance_type_id in number default hr_api.g_number
38: ,p_balance_dimension_id in number default hr_api.g_number
39: ,p_variance_type in varchar2 default hr_api.g_varchar2
40: ,p_variance_value in number default hr_api.g_number
41: ,p_comparison_type in varchar2 default hr_api.g_varchar2
42: ,p_comparison_value in number default hr_api.g_number

Line 39: ,p_variance_type in varchar2 default hr_api.g_varchar2

35: ,p_business_group_id in number default hr_api.g_number
36: ,p_currency_code in varchar2 default hr_api.g_varchar2
37: ,p_balance_type_id in number default hr_api.g_number
38: ,p_balance_dimension_id in number default hr_api.g_number
39: ,p_variance_type in varchar2 default hr_api.g_varchar2
40: ,p_variance_value in number default hr_api.g_number
41: ,p_comparison_type in varchar2 default hr_api.g_varchar2
42: ,p_comparison_value in number default hr_api.g_number
43: ,p_exception_report_id in number default hr_api.g_number

Line 40: ,p_variance_value in number default hr_api.g_number

36: ,p_currency_code in varchar2 default hr_api.g_varchar2
37: ,p_balance_type_id in number default hr_api.g_number
38: ,p_balance_dimension_id in number default hr_api.g_number
39: ,p_variance_type in varchar2 default hr_api.g_varchar2
40: ,p_variance_value in number default hr_api.g_number
41: ,p_comparison_type in varchar2 default hr_api.g_varchar2
42: ,p_comparison_value in number default hr_api.g_number
43: ,p_exception_report_id in number default hr_api.g_number
44: ,p_language_code in varchar2 default hr_api.userenv_lang

Line 41: ,p_comparison_type in varchar2 default hr_api.g_varchar2

37: ,p_balance_type_id in number default hr_api.g_number
38: ,p_balance_dimension_id in number default hr_api.g_number
39: ,p_variance_type in varchar2 default hr_api.g_varchar2
40: ,p_variance_value in number default hr_api.g_number
41: ,p_comparison_type in varchar2 default hr_api.g_varchar2
42: ,p_comparison_value in number default hr_api.g_number
43: ,p_exception_report_id in number default hr_api.g_number
44: ,p_language_code in varchar2 default hr_api.userenv_lang
45: ,p_object_version_number in out nocopy number

Line 42: ,p_comparison_value in number default hr_api.g_number

38: ,p_balance_dimension_id in number default hr_api.g_number
39: ,p_variance_type in varchar2 default hr_api.g_varchar2
40: ,p_variance_value in number default hr_api.g_number
41: ,p_comparison_type in varchar2 default hr_api.g_varchar2
42: ,p_comparison_value in number default hr_api.g_number
43: ,p_exception_report_id in number default hr_api.g_number
44: ,p_language_code in varchar2 default hr_api.userenv_lang
45: ,p_object_version_number in out nocopy number
46: ,p_output_format_type in varchar2 default hr_api.g_varchar2

Line 43: ,p_exception_report_id in number default hr_api.g_number

39: ,p_variance_type in varchar2 default hr_api.g_varchar2
40: ,p_variance_value in number default hr_api.g_number
41: ,p_comparison_type in varchar2 default hr_api.g_varchar2
42: ,p_comparison_value in number default hr_api.g_number
43: ,p_exception_report_id in number default hr_api.g_number
44: ,p_language_code in varchar2 default hr_api.userenv_lang
45: ,p_object_version_number in out nocopy number
46: ,p_output_format_type in varchar2 default hr_api.g_varchar2
47: ,p_variance_operator in varchar2 default hr_api.g_varchar2

Line 44: ,p_language_code in varchar2 default hr_api.userenv_lang

40: ,p_variance_value in number default hr_api.g_number
41: ,p_comparison_type in varchar2 default hr_api.g_varchar2
42: ,p_comparison_value in number default hr_api.g_number
43: ,p_exception_report_id in number default hr_api.g_number
44: ,p_language_code in varchar2 default hr_api.userenv_lang
45: ,p_object_version_number in out nocopy number
46: ,p_output_format_type in varchar2 default hr_api.g_varchar2
47: ,p_variance_operator in varchar2 default hr_api.g_varchar2
48: );

Line 46: ,p_output_format_type in varchar2 default hr_api.g_varchar2

42: ,p_comparison_value in number default hr_api.g_number
43: ,p_exception_report_id in number default hr_api.g_number
44: ,p_language_code in varchar2 default hr_api.userenv_lang
45: ,p_object_version_number in out nocopy number
46: ,p_output_format_type in varchar2 default hr_api.g_varchar2
47: ,p_variance_operator in varchar2 default hr_api.g_varchar2
48: );
49: --
50: -- ----------------------------------------------------------------------------

Line 47: ,p_variance_operator in varchar2 default hr_api.g_varchar2

43: ,p_exception_report_id in number default hr_api.g_number
44: ,p_language_code in varchar2 default hr_api.userenv_lang
45: ,p_object_version_number in out nocopy number
46: ,p_output_format_type in varchar2 default hr_api.g_varchar2
47: ,p_variance_operator in varchar2 default hr_api.g_varchar2
48: );
49: --
50: -- ----------------------------------------------------------------------------
51: -- |---------------------< delete_exception_report >--------------------------|