DBA Data[Home] [Help]

PACKAGE: APPS.PQP_EXR_API

Source


1 Package pqp_exr_api AUTHID CURRENT_USER as
2 /* $Header: pqexrapi.pkh 120.1 2005/06/30 11:58:11 rpinjala noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------< create_exception_report >--------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure create_exception_report
9   (p_validate                      in     boolean  default false
10   ,p_exception_report_name          in     varchar2
11   ,p_legislation_code               in     varchar2 default null
12   ,p_business_group_id              in     number   default null
13   ,p_currency_code                  in     varchar2 default null
14   ,p_balance_type_id                in     number   default null
15   ,p_balance_dimension_id           in     number   default null
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
25   );
26 --
27 -- ----------------------------------------------------------------------------
28 -- |---------------------< update_exception_report >--------------------------|
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
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
47   ,p_variance_operator	            in     varchar2 default hr_api.g_varchar2
48   );
49 --
50 -- ----------------------------------------------------------------------------
51 -- |---------------------< delete_exception_report >--------------------------|
52 --
53 procedure delete_exception_report
54   (p_validate                      in     boolean  default false
55   ,p_exception_report_id           in     number
56   ,p_object_version_number         in     number
57   );
58 --
59 end pqp_exr_api;