DBA Data[Home] [Help]

PACKAGE: APPS.PAY_CA_ARCHIVE_UTILS

Source


1 PACKAGE pay_ca_archive_utils AUTHID CURRENT_USER AS
2 /* $Header: pycaroep.pkh 120.2 2011/01/04 05:55:34 emunisek ship $ */
3 
4 --
5 -- Function/Procedures (See Package Body for detailed description)
6 --
7 
8 
9 FUNCTION get_archive_value	(p_archive_action_id 	in NUMBER,
10 				       p_db_name 	in VARCHAR2)
11 RETURN VARCHAR2;
12 
13 --
14 PRAGMA RESTRICT_REFERENCES(get_archive_value, WNDS);
15 --
16 
17 FUNCTION get_archive_value	(p_asg_action_id 	in NUMBER,
18 				       p_context		in VARCHAR2,
19 					 p_context_name   in VARCHAR2,
20 					 p_db_name        in VARCHAR2)
21 RETURN VARCHAR2;
22 
23 PRAGMA RESTRICT_REFERENCES(get_archive_value, WNDS);
24 
25 FUNCTION get_enable_template_flag (p_report_type       in    pay_payroll_actions.report_type%TYPE,
26                                    p_reporting_year    in    VARCHAR2,
27                                    p_business_group_id in    pay_payroll_actions.business_group_id%TYPE,
28                                    p_tax_unit_id       in    pay_assignment_actions.tax_unit_id%TYPE,
29                                    p_report_mode       in    VARCHAR2,
30                                    p_province          in    VARCHAR2)
31 RETURN VARCHAR2;
32 
33 FUNCTION get_enable_template_flag (p_report_type       in    pay_payroll_actions.report_type%TYPE,
34                                    p_reporting_year    in    VARCHAR2,
35                                    p_business_group_id in    pay_payroll_actions.business_group_id%TYPE,
36                                    p_tax_unit_id       in    pay_assignment_actions.tax_unit_id%TYPE,
37                                    p_report_mode       in    VARCHAR2)
38 RETURN VARCHAR2;
39 
40 end pay_ca_archive_utils;
41