1 PACKAGE pay_apac_payslip_archive AS
2 /* $Header: pyapacps.pkh 120.1 2006/12/13 07:49:41 aaagarwa noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : pay_apac_payslip_archive
21
22 Description : This is a common package to archive the payroll
23 action level data for APAC countries SS payslip.
24 Different procedures defined are called by the
25 APAC countries legislative Payslip Data Archiver.
26
27
28
29 Change List
30 -----------
31 Date Name Vers Bug No Description
32 ----------- ---------- ------ ------- --------------------------
33 22-APR-2002 kaverma 115.0 Created.
34 23-APR-2002 kaverma 115.1 2306309 Changes after code review comments
35 30-APR-2002 kaverma 115.2 2306309 added p_archive to get_eit_definitions
36 02-MAY-2002 kaverma 115.3 added range_code procedure
37 03-NOV-2002 Ragovind 115.4 2689226 Added NOCOPY for function get_legislative_parameters.
38 19-Apr-2004 bramajey 115.5 3578040 Renamed procedure range_code to
39 archive_payroll_level_data
40 04-May-2004 bramajey 115.6 3604206 Reverted back changes done for bug 3578040
41 02-Jul-2004 punmehta 115.7 3731940 Modified for GSCC warnings
42 12-Dec-2006 aaagarwa 115.8 5048802 Added deinitialization_code
43 *******************************************************************/
44
45
46 TYPE balance_rec IS RECORD (
47 balance_type_id NUMBER,
48 balance_dimension_id NUMBER,
49 defined_balance_id NUMBER,
50 balance_narrative VARCHAR2(150),
51 balance_name pay_balance_types.reporting_name%TYPE,
52 database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE,
53 legislation_code pay_balance_dimensions.legislation_code%TYPE);
54
55 TYPE element_rec IS RECORD (
56 element_type_id NUMBER,
57 input_value_id NUMBER,
58 formula_id NUMBER,
59 element_narrative VARCHAR2(100));
60
61
62 TYPE balance_table IS TABLE OF balance_rec INDEX BY BINARY_INTEGER;
63 TYPE element_table IS TABLE OF element_rec INDEX BY BINARY_INTEGER;
64
65 g_user_balance_table balance_table;
66 g_element_table element_table;
67
68 g_max_user_element_index PLS_INTEGER; --3731940
69 g_max_user_balance_index PLS_INTEGER; -- 3731940
70
71
72 g_balance_context VARCHAR2(30); --3731940
73 g_element_context VARCHAR2(30);
74
75 g_bg_context VARCHAR2(30); --3731940
76
77
78 -- Bug 3604206
79
80 /*********************************************************************
81 Name : range_code
82 Purpose : Calls private procedure the process_eit to archive the EIT details and
83 also archives the payroll level data -
84 Messages and Emploer address details.
85 *********************************************************************/
86
87 PROCEDURE range_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE);
88
89
90
91 /*********************************************************************
92 Name : initialization_code
93 Purpose : Calls the private procedure process_eit to populate EIT values into
94 golbal tables.
95 *********************************************************************/
96
97 PROCEDURE initialization_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%type);
98
99
100
101 /*********************************************************************
102 Name : archive_user_elements
103 Purpose : Archives the EIT values for input values defined in the
104 EIT definition
105 *********************************************************************/
106
107 PROCEDURE archive_user_elements(p_arch_assignment_action_id IN NUMBER,
108 p_pre_assignment_action_id IN NUMBER,
109 p_latest_run_assact_id IN NUMBER,
110 p_pre_effective_date IN DATE);
111
112
113
114 /*********************************************************************
115 Name : archive_user_balances
116 Purpose : Archives the EIT values for the defined balances dimension
117 *********************************************************************/
118
119 PROCEDURE archive_user_balances(p_arch_assignment_action_id IN NUMBER,
120 p_run_assignment_action_id IN NUMBER,
121 p_pre_effective_date IN DATE);
122
123
124
125 /*********************************************************************
126 Name : get_eit_definitions
127 Purpose : Archives the payroll level information ofuser defined
128 elements and balances defined using EIT
129 *********************************************************************/
130
131
132 PROCEDURE get_eit_definitions(p_payroll_action_id IN NUMBER,
133 p_business_group_id IN NUMBER,
134 p_pre_payroll_action_id IN NUMBER,
135 p_pre_effective_date IN DATE,
136 p_archive IN VARCHAR2 );
137
138
139
140 --------------------------------------------------------------------------
141 -- --
142 -- Name : DEINITIALIZATION_CODE --
143 -- Type : PROCEDURE --
144 -- Access : Public --
145 -- Description : Procedure to archive the PA level data if quick --
146 -- archive has been run. --
147 -- called are --
148 -- Parameters : --
149 -- IN : p_payroll_action_id NUMBER --
150 -- OUT : N/A --
151 -- Change History : --
152 --------------------------------------------------------------------------
153 -- Rev# Date Userid Description --
154 --------------------------------------------------------------------------
155 -- 115.0 06-Dec-2006 aaagarwa Initial Version --
156 --------------------------------------------------------------------------
157 PROCEDURE deinitialization_code
158 (
159 p_payroll_action_id IN NUMBER
160 );
161
162 /*********************************************************************
163 Name : get_legislative_parameters
164 Purpose : gets the value of legislative parameters from the
165 Archive run.
166 *********************************************************************/
167
168
169 PROCEDURE get_legislative_parameters(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%type,
170 p_payroll_id OUT NOCOPY NUMBER,
171 p_consolidation OUT NOCOPY NUMBER,
172 p_business_group_id OUT NOCOPY NUMBER,
173 p_start_date OUT NOCOPY VARCHAR2,
174 p_end_date OUT NOCOPY VARCHAR2);
175
176
177 END pay_apac_payslip_archive;