1 PACKAGE pay_us_emp_baladj_cleanup AS
2 /* $Header: payusbaladjclean.pkh 120.0 2005/05/29 11:53 appldev 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 : payusbaladjclean.pkh
21
22 Description :
23
24
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ----------- ---------- ------ ------- --------------------------
29 10-JUL-2004 ahanda 115.0 Created.
30 14-JUL-2004 ahanda 115.1 Added ltr_misc_er_tax_bal
31
32 ********************************************************************/
33
34 PROCEDURE get_payroll_action_info(
35 p_payroll_action_id in number
36 ,p_end_date out nocopy date
37 ,p_start_date out nocopy date
38 ,p_business_group_id out nocopy number
39 ,p_state_abbrev out nocopy varchar2
40 ,p_cons_set_id out nocopy number
41 ,p_payroll_id out nocopy number
42 );
43
44 FUNCTION get_input_value_id(p_element_type_id in number
45 ,p_input_value_name in varchar2
46 ,p_effective_date in date)
47 RETURN NUMBER;
48
49 PROCEDURE range_cursor(
50 p_payroll_action_id in number
51 ,p_sqlstr out nocopy varchar2);
52
53
54 PROCEDURE action_creation(
55 p_payroll_action_id in number
56 ,p_start_person_id in number
57 ,p_end_person_id in number
58 ,p_chunk in number);
59
60
61 PROCEDURE initialize(
62 p_payroll_action_id in number);
63
64
65 PROCEDURE deinitialize(
66 p_payroll_action_id in number);
67
68 PROCEDURE run_preprocess(
69 p_assignment_action_id number
70 ,p_effective_date in date);
71
72
73 TYPE balance_rec IS RECORD
74 ( balance_name varchar2(80)
75 ,ytd_def_bal_id number
76 ,element_name varchar2(50)
77 ,element_type_id number
78 ,input_name varchar2(50)
79 ,input_value_id number
80 );
81
82 TYPE balance_tab IS TABLE OF
83 balance_rec
84 INDEX BY BINARY_INTEGER;
85
86 ltr_sit_tax_bal balance_tab;
87 ltr_sdi_er_tax_bal balance_tab;
88 ltr_misc_er_tax_bal balance_tab;
89
90 g_adj_state_code VARCHAR2(2);
91 g_proc_init BOOLEAN;
92 g_min_chunk NUMBER;
93
94 end pay_us_emp_baladj_cleanup;