1 PACKAGE pay_in_24q_archive AS
2 /* $Header: pyin24qa.pkh 120.3.12010000.1 2008/07/27 22:52:12 appldev ship $ */
3 TYPE t_asg_rec IS RECORD
4 (gre_id NUMBER
5 ,start_date DATE
6 ,end_date DATE
7 );
8
9 TYPE t_asg_tab IS TABLE OF t_asg_rec
10 INDEX BY BINARY_INTEGER;
11
12
13 TYPE t_bal_name_rec IS RECORD
14 (
15 balance_name VARCHAR2(240)
16 );
17
18 TYPE t_bal_name_tab IS TABLE OF t_bal_name_rec
19 INDEX BY BINARY_INTEGER;
20
21 TYPE t_input_value_rec IS RECORD
22 (input_value_id pay_input_values_f.input_value_id%TYPE);
23
24 TYPE t_input_table_type IS TABLE OF t_input_value_rec
25 INDEX BY binary_integer;
26
27 g_input_table_rec t_input_table_type;
28
29 g_package CONSTANT VARCHAR2(100) := 'pay_in_24q_archive';
30 g_debug BOOLEAN;
31
32 g_tax_year VARCHAR2(20);
33 g_year VARCHAR2(20);
34 g_gre_id VARCHAR2(20);
35 g_quarter VARCHAR2(2);
36 g_archive_ref_no VARCHAR2(50);
37 g_bg_id NUMBER;
38 g_start_date DATE;
39 g_fin_start_date DATE;
40 g_fin_end_date DATE;
41 g_qr_start_date DATE;
42 g_end_date DATE;
43
44 g_payroll_action_id NUMBER;
45 g_session_date DATE;
46 g_chln_element_id NUMBER;
47 g_index NUMBER;
48
49 g_asg_tab t_asg_tab;
50
51 -------------------------------------------------------------------------
52 -- These are PUBLIC procedures that are required by the Archive process.
53 -- There names are stored in PAY_REPORT_FORMAT_MAPPINGS_F so that
54 -- the archive process knows what code to execute for each step of
55 -- the archive.
56 --------------------------------------------------------------------------
57
58 --------------------------------------------------------------------------
59 -- --
60 -- Name : RANGE_CODE --
61 -- Type : PROCEDURE --
62 -- Access : Public --
63 -- Description : This procedure returns a sql string to select a --
64 -- range of assignments eligible for archival. --
65 -- --
66 -- Parameters : --
67 -- IN : p_payroll_action_id NUMBER --
68 -- OUT : p_sql VARCHAR2 --
69 -- --
70 --------------------------------------------------------------------------
71 --
72
73 PROCEDURE range_code
74 (
75 p_payroll_action_id IN NUMBER
76 ,p_sql OUT NOCOPY VARCHAR2
77 );
78 --
79
80 --------------------------------------------------------------------------
81 -- --
82 -- Name : INITIALIZATION_CODE --
83 -- Type : PROCEDURE --
84 -- Access : Public --
85 -- Description : This procedure is used to set global contexts. --
86 -- Store 1.Challan Element type id --
87 -- 2.Challan input value id in a PL/SQL table --
88 -- 3.legislative parameters --
89 -- Parameters : --
90 -- IN : p_payroll_action_id NUMBER --
91 -- OUT : N/A --
92 -- --
93 --------------------------------------------------------------------------
94 --
95 PROCEDURE initialization_code
96 (
97 p_payroll_action_id IN NUMBER
98 );
99 --
100
101 --------------------------------------------------------------------------
102 -- --
103 -- Name : ASSIGNMENT_ACTION_CODE --
104 -- Type : PROCEDURE --
105 -- Access : Public --
106 -- Description : This procedure further restricts the assignment_id's--
107 -- returned by range_code --
108 -- --
109 -- Parameters : --
110 -- IN : p_payroll_action_id NUMBER --
111 -- p_start_person NUMBER --
112 -- p_end_person NUMBER --
113 -- p_chunk NUMBER --
114 -- OUT : N/A --
115 --------------------------------------------------------------------------
116 --
117
118 PROCEDURE assignment_action_code
119 (
120 p_payroll_action_id IN NUMBER
121 ,p_start_person IN NUMBER
122 ,p_end_person IN NUMBER
123 ,p_chunk IN NUMBER
124 );
125 --
126
127 --------------------------------------------------------------------------
128 -- --
129 -- Name : ARCHIVE_CODE --
130 -- Type : PROCEDURE --
131 -- Access : Public --
132 -- Description : Procedure to call the internal procedures to --
133 -- actually archive the data. --
134 -- --
135 -- Parameters : --
136 -- IN : p_assignment_action_id NUMBER --
137 -- p_effective_date DATE --
138 -- OUT : N/A --
139 --------------------------------------------------------------------------
140 --
141
142 PROCEDURE archive_code
143 (
144 p_assignment_action_id IN NUMBER
145 ,p_effective_date IN DATE
146 );
147
148 --------------------------------------------------------------------------
149 -- --
150 -- Name : DEINITIALIZATION_CODE --
151 -- Type : PROCEDURE --
152 -- Access : Public --
153 -- Description : Procedure to call the internal procedures to --
154 -- actually archive the data. --
155 -- --
156 -- Parameters : --
157 -- IN : p_payroll_action_id NUMBER --
158 -- --
159 -- OUT : N/A --
160 --------------------------------------------------------------------------
161 PROCEDURE deinitialization_code
162 (
163 p_payroll_action_id IN number
164 );
165
166
167 END pay_in_24q_archive;