[Home] [Help]
PACKAGE: APPS.PAY_JP_UITE_ARCH_PKG
Source
1 PACKAGE pay_jp_uite_arch_pkg AUTHID CURRENT_USER AS
2 -- $Header: pyjpuiar.pkh 120.1 2010/05/21 13:44:50 pmatamsr noship $
3 -- *************************************************************************
4 -- * Copyright (c) Oracle Corporation Japan,2009 Product Development.
5 -- * All rights reserved
6 -- *************************************************************************
7 -- *
8 -- * PROGRAM NAME
9 -- * pyjpuiar.pkh
10 -- *
11 -- * DESCRIPTION
12 -- * This script creates the package specification of pay_jp_uite_arch_pkg
13 -- *
14 -- * USAGE
15 -- * To install sqlplus <apps_user>/<apps_pwd> @pyjpuiar.pkh
16 -- * To Execute sqlplus <apps_user>/<apps_pwd> EXEC pay_jp_uite_arch_pkg.<procedure name>
17 -- *
18 -- * PROGRAM LIST
19 -- * ==========
20 -- * NAME DESCRIPTION
21 -- * ----------------- --------------------------------------------------
22 -- * RANGE_CODE
23 -- * INITIALIZATION_CODE
24 -- * ASSIGNMENT_ACTION_CODE
25 -- * ARCHIVE_CODE
26 -- *
27 -- * DEPENDENCIES
28 -- * None
29 -- *
30 -- * CALLED BY
31 -- * Concurrent Program
32 -- *
33 -- * LAST UPDATE DATE 08-Feb-2010
34 -- * Date the program has been modified for the last time
35 -- *
36 -- * HISTORY
37 -- * =======
38 -- *
39 -- * VERSION DATE AUTHOR(S) DESCRIPTION
40 -- * ------- ----------- ----------------- -----------------------------
41 -- * 120.0.12010000.1 08-Feb-2010 RDARASI Creation
42 -- * 120.0.12010000.2 16-Apr-2010 RDARASI Modified as per review comments
43 -- * 120.0.12010000.3 23-Apr-2010 RDARASI To Fix bug #
44 -- *************************************************************************
45
46 TYPE parameters IS RECORD (business_group_id NUMBER
47 ,start_date DATE
48 ,end_date DATE
49 ,effective_date DATE
50 ,assignment_id NUMBER
51 ,labor_insorg_id NUMBER
52 ,termination_date_from DATE
53 ,termination_date_to DATE
54 ,assignment_set_id NUMBER
55 );
56 --
57 gr_parameters parameters;
58
59 --+=====================================================================+
60 --| |
61 --|Name : range_code |
62 --| |
63 --|Description : This is the range code |
64 --| |
65 --|Parameters : |
66 --| |
67 --| p_payroll_action_id IN NUMBER |
68 --| p_sql OUT VARCHAR2 |
69 --+=====================================================================+
70 PROCEDURE range_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
71 ,p_sql OUT NOCOPY VARCHAR2
72 );
73 --+=====================================================================+
74 --| |
75 --|Name : initialization_code |
76 --| |
77 --|Description : This is the initialization_code procedure |
78 --| |
79 --|Parameters : |
80 --| |
81 --| p_payroll_action_id IN NUMBER |
82 --+=====================================================================+
83 PROCEDURE initialization_code (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE);
84 --+=====================================================================+
85 --| |
86 --|Name : assignment_action_code |
87 --| |
88 --|Description : This is the assignment_action_code procedure |
89 --| |
90 --|Parameters : |
91 --| |
92 --| p_payroll_action_id IN NUMBER |
93 --| p_start_person IN NUMBER |
94 --| p_end_oerson IN NUMBER |
95 --| p_chunk IN NUMBER |
96 --+=====================================================================+
97 PROCEDURE assignment_action_code (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
98 ,p_start_person in per_all_people_f.person_id%TYPE
99 ,p_end_person in per_all_people_f.person_id%TYPE
100 ,p_chunk in NUMBER
101 );
102 --+=====================================================================+
103 --| |
104 --|Name : archive_code |
105 --| |
106 --|Description : This is the archive_code procedure |
107 --| |
108 --|Parameters : |
109 --| |
110 --| p_assignment_action_id IN NUMBER |
111 --| p_payroll_action_id IN NUMBER |
112 --| p_effective_date IN DATE |
113 --+=====================================================================+
114 PROCEDURE archive_code( p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
115 , p_effective_date in pay_payroll_actions.effective_date%TYPE
116 );
117
118 --
119 --+=====================================================================+
120 --| |
121 --|Name : deinitialize_code |
122 --| |
123 --|Description : This is the deinitialise_code procedure |
124 --| |
125 --|Parameters : |
126 --| |
127 --| p_payroll_action_id IN NUMBER |
128 --+=====================================================================+
129 PROCEDURE deinitialize_code (p_payroll_action_id IN NUMBER);
130 --+=====================================================================+
131 --| |
132 --|Name : get_life_ins_org_id |
133 --| |
134 --|Description : to get the Labor Insurance Employer |
135 --| |
136 --|Parameters : |
137 --| p_assignment_id IN NUMBER |
138 --| p_effective_date IN DATE |
139 --+=====================================================================+
140
141 FUNCTION get_life_ins_org_id(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
142 ,p_effective_date IN DATE)
143 RETURN NUMBER;
144 --+=====================================================================+
145 --| |
146 --|Name : get_ui_num |
147 --| |
148 --|Description : to get the unemployment insurance number |
149 --| |
150 --|Parameters : |
151 --| |
152 --| p_assignment_id IN NUMBER |
153 --| p_effective_date IN DATE |
154 --+=====================================================================+
155
156 FUNCTION get_ui_num(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
157 ,p_effective_date IN DATE)
158 RETURN VARCHAR2;
159 --+=====================================================================+
160 --| |
161 --|Name : get_ei_type |
162 --| |
163 --|Description : to get the Employee Insurance Type |
164 --| |
165 --|Parameters : |
166 --| |
167 --| p_assignment_id IN NUMBER |
168 --| p_effective_date IN DATE |
169 --+=====================================================================+
170
171 FUNCTION get_ei_type(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
172 ,p_effective_date IN DATE)
173 RETURN VARCHAR2;
174 --+=====================================================================+
175 --| |
176 --|Name : get_term_rpt_flag |
177 --| |
178 --|Description : to get the Need Separation Notice flag |
179 --| |
180 --|Parameters : |
181 --| |
182 --| p_assignment_id IN NUMBER |
183 --| p_effective_date IN DATE |
184 --+=====================================================================+
185
186 FUNCTION get_term_rpt_flag(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
187 ,p_effective_date IN DATE)
188 RETURN VARCHAR2;
189 --
190 --+=====================================================================+
191 --| |
192 --|Name : get_ei_qualify_date |
193 --| |
194 --|Description : to get the Employee Insurance Qualify Date |
195 --| |
196 --|Parameters : |
197 --| |
198 --| p_assignment_id IN NUMBER |
199 --| p_effective_date IN DATE |
200 --+=====================================================================+
201 FUNCTION get_ei_qualify_date(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
202 ,p_effective_date IN DATE)
203 RETURN DATE;
204 --+=====================================================================+
205 --| |
206 --|Name : get_ei_dis_qual_date |
207 --| |
208 --|Description : to get the Employee Insurance disqualified date |
209 --| |
210 --|Parameters : |
211 --| |
212 --| p_assignment_id IN NUMBER |
213 --| p_effective_date IN DATE |
214 --+=====================================================================+
215
216 FUNCTION get_ei_dis_qual_date(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
217 ,p_effective_date IN DATE)
218 RETURN DATE;
219 --
220 END pay_jp_uite_arch_pkg;