1 PACKAGE pay_se_alecta AS
2 /* $Header: pysealer.pkh 120.0.12010000.1 2008/07/27 23:36:46 appldev ship $ */
3 /* ############################################################# */
4 -- For Archive
5 FUNCTION get_parameter (
6 p_parameter_string IN VARCHAR2
7 ,p_token IN VARCHAR2
8 ,p_segment_number IN NUMBER DEFAULT NULL
9 )
10 RETURN VARCHAR2;
11
12 PROCEDURE get_all_parameters (
13 p_payroll_action_id IN NUMBER -- In parameter
14 ,p_business_group_id OUT NOCOPY NUMBER -- Core parameter
15 ,p_effective_date OUT NOCOPY DATE -- Core parameter
16 ,p_legal_employer_id OUT NOCOPY NUMBER -- User parameter
17 ,p_request_for_all_or_not OUT NOCOPY VARCHAR2 -- User parameter
18 ,p_year OUT NOCOPY NUMBER -- User parameter
19 ,p_month OUT NOCOPY VARCHAR2
20 ,p_sent_from OUT NOCOPY VARCHAR2
21 ,p_sent_to OUT NOCOPY VARCHAR2
22 ,p_production OUT NOCOPY VARCHAR2
23 );
24
25 PROCEDURE range_code (
26 p_payroll_action_id IN NUMBER
27 ,p_sql OUT NOCOPY VARCHAR2
28 );
29
30 PROCEDURE assignment_action_code (
31 p_payroll_action_id IN NUMBER
32 ,p_start_person IN NUMBER
33 ,p_end_person IN NUMBER
34 ,p_chunk IN NUMBER
35 );
36
37 PROCEDURE initialization_code (p_payroll_action_id IN NUMBER);
38
39 FUNCTION get_defined_balance_id (p_user_name IN VARCHAR2)
40 RETURN NUMBER;
41
42 PROCEDURE archive_code (
43 p_assignment_action_id IN NUMBER
44 ,p_effective_date IN DATE
45 );
46
47 /* ############################################################# */
48 -- For Report
49 -- Record for PL/sql Table which contains XMl tag and Value
50 TYPE xmlrec IS RECORD (
51 tagname VARCHAR2 (240)
52 ,tagvalue VARCHAR2 (240)
53 ,eventnumber NUMBER
54 );
55
56 TYPE hpdxml IS TABLE OF xmlrec
57 INDEX BY BINARY_INTEGER;
58
59 ghpd_data hpdxml;
60
61 -- Record for PL/sql Table which contains XMl tag and Value
62 TYPE event_row IS RECORD (
63 event_code VARCHAR (240)
64 ,bal_ele VARCHAR2 (240)
65 ,balance_type_id VARCHAR2 (240)
66 ,element_type_id VARCHAR2 (240)
67 ,input_value_id VARCHAR2 (240)
68 );
69
70 TYPE event_rows IS TABLE OF event_row
71 INDEX BY VARCHAR2 (64);
72
73 TYPE FIELD IS RECORD (
74 disp_name VARCHAR (240)
75 ,events_row event_rows
76 );
77
78 TYPE FIELDS IS TABLE OF FIELD
79 INDEX BY VARCHAR2 (64);
80
81 TYPE each_le IS RECORD (
82 organization_id VARCHAR2 (240)
83 ,field_code FIELDS
84 );
85
86 TYPE each_le_record IS TABLE OF each_le
87 INDEX BY BINARY_INTEGER;
88
89 record_legal_employer each_le_record;
90
91 -- Proc to Populate the Tag and value into Pl/sql Table
92 PROCEDURE get_xml_for_report (
93 p_business_group_id IN NUMBER
94 ,p_payroll_action_id IN VARCHAR2
95 ,p_template_name IN VARCHAR2
96 ,p_xml OUT NOCOPY CLOB
97 );
98
99 -- Proc to Populate the Tag and value into Pl/sql Table
100 -- Proc to Convert the Pl/sql Table to Clob
101 PROCEDURE writetoclob (p_xfdf_clob OUT NOCOPY CLOB);
102
103 -- Proc to Convert the Pl/sql Table to Clob
104 /* ############################################################# */
105 FUNCTION get_defined_balance_value (
106 p_balance_type_id IN NUMBER
107 ,p_dimension IN VARCHAR2
108 ,p_in_assignment_id IN NUMBER
109 ,p_in_virtual_date IN DATE
110 )
111 RETURN NUMBER;
112
113 PROCEDURE logger (p_display IN VARCHAR2, p_value IN VARCHAR2);
114
115 g_start_date DATE;
116 g_end_date DATE;
117
118 PROCEDURE get_assignment_lvl_info (
119 p_assignment_id IN NUMBER
120 ,p_effective_date IN DATE
121 ,p_organization_number OUT NOCOPY VARCHAR2
122 ,p_cost_centre OUT NOCOPY VARCHAR2
123 );
124
125 PROCEDURE get_person_lvl_info (
126 p_assignment_id IN NUMBER
127 ,p_effective_date IN DATE
128 ,p_pin OUT NOCOPY VARCHAR2
129 ,p_first_name OUT NOCOPY VARCHAR2
130 ,p_last_name OUT NOCOPY VARCHAR2
131 ,p_born_1979 OUT NOCOPY VARCHAR2
132 );
133
134 PROCEDURE get_in_time_of_event (
135 p_assignment_id IN NUMBER
136 ,p_effective_date IN DATE
137 ,p_event_date OUT NOCOPY DATE
138 );
139
140 PROCEDURE get_salary (
141 p_assignment_id IN NUMBER
142 ,p_effective_date IN DATE
143 ,p_before_after IN VARCHAR2
144 ,p_event IN VARCHAR2
145 ,p_monthly_salary OUT NOCOPY NUMBER
146 ,p_yearly_salary OUT NOCOPY NUMBER
147 );
148
149 PROCEDURE get_org_lvl_info (
150 p_assignment_id IN NUMBER
151 ,p_effective_date IN DATE
152 ,p_local_unit_id OUT NOCOPY NUMBER
153 ,p_legal_employer_id OUT NOCOPY NUMBER
154 ,p_location_id OUT NOCOPY NUMBER
155 );
156
157 PROCEDURE get_absence_lvl_info (
158 p_assignment_id IN NUMBER
159 ,p_effective_date IN DATE
160 ,p_fully_capable OUT NOCOPY VARCHAR2
161 ,p_inability_to_work OUT NOCOPY VARCHAR2
162 );
163
164 PROCEDURE get_salary_change_or_not (
165 p_assignment_id IN NUMBER
166 ,p_new_salary OUT NOCOPY VARCHAR2
167 ,p_event_time OUT NOCOPY DATE
168 );
169
170 PROCEDURE get_salary_cut (
171 p_assignment_id IN NUMBER
172 ,p_effective_date IN DATE
173 ,p_salary_cut OUT NOCOPY VARCHAR2
174 );
175
176 PROCEDURE get_end_employment_or_not (
177 p_assignment_id IN NUMBER
178 ,p_withdrawl OUT NOCOPY VARCHAR2
179 ,p_event_time OUT NOCOPY DATE
180 ,p_reason OUT NOCOPY VARCHAR2
181 ,p_effective_date OUT NOCOPY DATE
182 );
183
184 PROCEDURE get_termination_or_not (
185 p_assignment_id IN NUMBER
186 ,p_field_code IN VARCHAR2
187 ,p_withdrawl OUT NOCOPY VARCHAR2
188 ,p_event_time OUT NOCOPY DATE
189 ,p_reason OUT NOCOPY VARCHAR2
190 ,p_effective_date OUT NOCOPY DATE
191 ,p_parental_start_date OUT NOCOPY DATE
192 );
193 END pay_se_alecta;