[Home] [Help]
PACKAGE: APPS.PAY_ZA_TAX_REG_AR
Source
1 PACKAGE PAY_ZA_TAX_REG_AR AUTHID CURRENT_USER AS
2 /* $Header: pyzatxreg.pkh 120.1.12020000.2 2013/02/05 15:03:56 abdash noship $ */
3 /* Copyright (c) 2001 Oracle Corporation Redwood Shores, California, USA */
4 /* All rights reserved.
5
6 Change List:
7 ------------
8
9 Name Date Version Bug Text
10 -------------- ----------- ------- ------- -----------------------
11 NCHINNAM 29-NOv-2011 120.0.12010000.1 Initial Version
12 ABDASH 31-JAN-2013 120.0.12010000.3 16174886 ADDING OF LEGAL ENTITY PARAMETER TO TAX REGISTER REPORT(XML)
13 */
14
15 -------------------------------------------------------------------------------
16 -- PACKAGE SPECIFICATION --
17 -------------------------------------------------------------------------------
18
19 ------------------
20 -- Package Globals
21 ------------------
22
23 --Parameters for BI Publisher report
24
25 p_legal_entity_id NUMBER;
26 p_payroll_id pay_payrolls_f.payroll_id%type;
27 p_start_period_id per_time_periods.time_period_id%type;
28 p_end_period_id per_time_periods.time_period_id%type;
29 p_payroll_name pay_payrolls_f.payroll_name%type;
30 -- p_period_end_date per_time_periods.end_date%type;
31 p_period_end_date VARCHAR2(100);
32 p_include VARCHAR2(1);
33 p_assignment_id per_all_assignments_f.assignment_id%TYPE;
34 p_retrieve_ptd VARCHAR2(1);
35 p_retrieve_mtd VARCHAR2(1);
36 p_retrieve_ytd VARCHAR2(1);
37 p_sort_1 VARCHAR2(100);
38 p_sort_2 VARCHAR2(100);
39 p_sort_3 VARCHAR2(100);
40 p_detail VARCHAR2(1);
41 p_payroll_action_id VARCHAR2(100);
42 p_legal_entity_name VARCHAR2(240);
43 sort_order VARCHAR2(240):=' ';
44
45 c_period_start VARCHAR2(100);
46 c_period_end VARCHAR2(100);
47 c_period_num per_time_periods.period_num%TYPE;
48 CP_Total_Employees NUMBER;
49 CP_Total_Assignments NUMBER;
50
51 FUNCTION BEFOREREPORT RETURN BOOLEAN;
52 FUNCTION AFTERREPORT RETURN BOOLEAN;
53
54
55 procedure range_cursor(pactid in number,
56 sqlstr out nocopy varchar2);
57
58 procedure action_creation(pactid in number,
59 stperson in number,
60 endperson in number,
61 chunk in number) ;
62
63 procedure archinit(p_payroll_action_id in number);
64
65 procedure archive_code(p_assactid in number,
66 p_effective_date in date);
67
68 procedure deinit_code(pactid in number);
69
70 end pay_za_tax_reg_ar;