1 PACKAGE pay_us_action_arch AS
2 /* $Header: pyusxfrp.pkh 120.0.12010000.1 2008/07/28 00:00:37 appldev ship $ */
3 --
4 /*
5 /*
6 ******************************************************************
7 * *
8 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
9 * Chertsey, England. *
10 * *
11 * All rights reserved. *
12 * *
13 * This material has been provided pursuant to an agreement *
14 * containing restrictions on its use. The material is also *
15 * protected by copyright law. No part of this material may *
16 * be copied or distributed, transmitted or transcribed, in *
17 * any form or by any means, electronic, mechanical, magnetic, *
18 * manual, or otherwise, or disclosed to third parties without *
19 * the express written permission of Oracle Corporation UK Ltd, *
20 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
21 * England. *
22 * *
23 ******************************************************************
24
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ----------- ---------- ----- ------- -----------------------------------
29 25-JAN-2001 Asasthan 115.0 Created.
30 04-APR-2001 Asasthan 115.4 Changed action29 to number.
31 13-JUN-2001 Asasthan 115.5 Added Effective date.
32 15-AUG-2001 Asasthan 115.6 Payslip changes.
33 22-JAN-2002 ahanda 115.5 Changed package to take care
34 of Multi Assignment Processing.
35 17-JUN-2002 ahanda 115.10 2365908 Changed package to populate tax
36 deductions if location has changed.
37 15-OCT-2002 tmehra 115.11 Added Function to check for Alien.
38 02-DEC-2002 ahanda 115.13 Changed package to fix GSCC warnings.
39 04-DEC-2003 vpandya 115.14 Added variable gv_act_param_val
40 which is being used in pyusxfrp.pkb
41 version 115.80 or above.
42 03-NOV-2004 ahanda 115.15 Changed parameter for action_creation
43 procedure.
44
45 */
46 --
47
48 PROCEDURE get_payroll_action_info(p_payroll_action_id in number
49 ,p_end_date out nocopy date
50 ,p_start_date out nocopy date
51 ,p_business_group_id out nocopy number
52 ,p_cons_set_id out nocopy number
53 ,p_payroll_id out nocopy number
54 );
55
56 PROCEDURE action_range_cursor(p_payroll_action_id in number
57 ,p_sqlstr out nocopy varchar2);
58
59 PROCEDURE action_action_creation(p_payroll_action_id in number
60 ,p_start_person_id in number
61 ,p_end_person_id in number
62 ,p_chunk in number);
63
64 PROCEDURE action_archive_data(p_xfr_action_id in number,
65 p_effective_date in date);
66
67
68 PROCEDURE action_archinit(p_payroll_action_id in number);
69
70 FUNCTION check_alien(
71 p_assignment_action_id in number)
72 RETURN VARCHAR2;
73
74
75 TYPE state_tax_info_rec IS RECORD
76 ( sit_exists varchar2(1)
77 ,sui_ee_exists varchar2(1)
78 ,sui_er_exists varchar2(1)
79 ,sdi_ee_exists varchar2(1)
80 ,sdi_er_exists varchar2(1)
81 );
82
83 TYPE state_tax_info_table IS TABLE OF
84 state_tax_info_rec
85 INDEX BY BINARY_INTEGER;
86
87 TYPE county_tax_info_rec IS RECORD
88 ( jurisdiction_code varchar2(11)
89 ,cnty_tax_exists varchar2(1)
90 ,cnty_head_tax_exists varchar2(1)
91 ,cnty_sd_tax_exists varchar2(1)
92 );
93
94 TYPE county_tax_info_table IS TABLE OF
95 county_tax_info_rec
96 INDEX BY BINARY_INTEGER;
97
98 TYPE jurisdiction_rec IS RECORD
99 ( action_info_category varchar2(25)
100 ,balance_name varchar2(80)
101 ,balance_type_id number
102 ,payment_def_bal_id number
103 ,asg_run_def_bal_id number
104 ,ytd_def_bal_id number
105 );
106
107 TYPE jurisdiction_tab IS TABLE OF
108 jurisdiction_rec
109 INDEX BY BINARY_INTEGER;
110
111 TYPE school_jd_rec IS RECORD
112 (school_jd varchar2(11));
113
114 TYPE school_jd_tab IS TABLE OF
115 school_jd_rec
116 INDEX BY BINARY_INTEGER;
117
118 ltr_state_tax_info state_tax_info_table;
119 ltr_county_tax_info county_tax_info_table;
120
121 ltr_fed_tax_bal jurisdiction_tab;
122 ltr_state_tax_bal jurisdiction_tab;
123 ltr_county_tax_bal jurisdiction_tab;
124 ltr_city_tax_bal jurisdiction_tab;
125 ltr_schdist_tax_bal jurisdiction_tab;
126
127 g_min_chunk number:= -1;
128 g_archive_flag varchar2(1) := 'N';
129 g_bal_act_id number:= -1;
130
131 gv_act_param_val varchar2(240);
132
133 END pay_us_action_arch;