PACKAGE: APPS.PAY_ZA_EMP201

Source

1 PACKAGE PAY_ZA_EMP201 AUTHID CURRENT_USER AS
2 /* $Header: pyzae201.pkh 120.1.12020000.2 2013/01/28 10:13:06 abdash ship $ */
3 /* Copyright (c) Oracle Corporation 2005. All rights reserved. */
4 /*
5    PRODUCT
6       Oracle Payroll - ZA Localisation EMP201 Package
7 
8    NAME
9       pay_za_emp201.pkb
10 
11    DESCRIPTION
12       This is the ZA EMP201 package.  It contains
13       functions and procedures used by EMP201 Report.
14 
15    MODIFICATION HISTORY
16    Person    Date       Version      Bug     Comments
17    --------- ---------- ----------- ------- --------------------------------
18    R Babla  10/06/2009 115.0       8512751   Initial Version
19    A Dash   28/01/2013 120.0.12010000.3 16174886 Adding of legal entity parameter to ZA EMP201 Report.
20 */
21 
22  l_package_name CONSTANT VARCHAR2(30) := 'pay_za_emp201';
23 
24  --
25  -- -----------------------------------------------------------------------------
26  -- Data Types
27  -- -----------------------------------------------------------------------------
28  --
29 
30  TYPE t_xml_element_rec IS RECORD
31      (tagname  VARCHAR2(100)
32      ,tagvalue VARCHAR2(500)
33      );
34 
35  TYPE t_xml_element_table IS TABLE OF t_xml_element_rec INDEX BY BINARY_INTEGER;
36 
37  --
38  -- -----------------------------------------------------------------------------
39  -- Global Variables
40  -- -----------------------------------------------------------------------------
41  --
42  g_xml_element_table     t_xml_element_table;
43  g_payroll_action_id     NUMBER;
44 
45  --
46  -- -----------------------------------------------------------------------------
47  -- Procedures
48  -- -----------------------------------------------------------------------------
49  --
50    procedure range_cursor
51    (
52      pactid in  number,
53      sqlstr out nocopy varchar2
54    ) ;
55 
56    procedure archinit
57    (
58       p_payroll_action_id in number
59    ) ;
60 
61    procedure action_creation
62    (
63       pactid    in number,
64       stperson  in number,
65       endperson in number,
66       chunk     in number
67    ) ;
68 
69    procedure archive_data
70    (
71       p_assactid       in number,
72       p_archive_effective_date in date
73    ) ;
74 
75    procedure archdinit(pactid in number);
76 
77  PROCEDURE get_emp201_xml
78     (business_group_id  number
79     ,calendar_month   varchar2
80     ,calendar_month_hidden   varchar2
81     ,EMP201_FILE_PREPROCESS   varchar2
82     ,p_detail_flag   varchar2
83     ,p_template_name     IN VARCHAR2
84     ,p_xml               OUT NOCOPY CLOB) ;
85 
86 function get_parameter
87 (
88    name        in varchar2,
89    parameter_list varchar2
90 )  return varchar2;
91 
92 
93 function formatted_canonical(
94     canonical varchar2)
95 return varchar2;
96 
97 
98 END  PAY_ZA_EMP201 ;