[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