1 PACKAGE pay_in_prof_tax_pkg AS
2 /* $Header: pyinptax.pkh 120.3 2006/01/09 05:05 abhjain noship $*/
3
4 FUNCTION get_state (p_pt_org IN VARCHAR2)
5 RETURN VARCHAR2;
6
7 PROCEDURE check_pt_update
8 (p_effective_date IN DATE
9 ,p_dt_mode IN VARCHAR2
10 ,p_assignment_id IN NUMBER
11 ,p_pt_org IN VARCHAR2
12 ,p_message OUT NOCOPY VARCHAR2
13 );
14
15
16 PROCEDURE check_pt_exemptions
17 (p_organization_id IN NUMBER
18 ,p_org_information_id IN NUMBER
19 ,p_org_info_type_code IN VARCHAR2
20 ,p_state IN VARCHAR2
21 ,p_exemption_catg IN VARCHAR2
22 ,p_eff_start_date IN VARCHAR2
23 ,p_eff_end_date IN VARCHAR2
24 ,p_calling_procedure IN VARCHAR2
25 ,p_message_name OUT NOCOPY VARCHAR2
26 ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
27 ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
28
29 PROCEDURE check_pt_frequency
30 (p_organization_id IN NUMBER
31 ,p_org_information_id IN NUMBER
32 ,p_org_info_type_code IN VARCHAR2
33 ,p_state IN VARCHAR2
34 ,p_frequency IN VARCHAR2
35 ,p_eff_start_date IN VARCHAR2
36 ,p_eff_end_date IN VARCHAR2
37 ,p_calling_procedure IN VARCHAR2
38 ,p_message_name OUT NOCOPY VARCHAR2
39 ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
40 ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
41
42
43 PROCEDURE check_pt_challan_info
44 (p_organization_id IN NUMBER
45 ,p_org_info_type_code IN VARCHAR2
46 ,p_payment_month IN VARCHAR2
47 ,p_payment_date IN VARCHAR2
48 ,p_payment_mode IN VARCHAR2
49 ,p_voucher_number IN VARCHAR2
50 ,p_amount IN VARCHAR2
51 ,p_interest IN VARCHAR2
52 ,p_payment_year IN VARCHAR2
53 ,p_excess_tax IN VARCHAR2
54 ,p_calling_procedure IN VARCHAR2
55 ,p_message_name OUT NOCOPY VARCHAR2
56 ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
57 ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
58
59 PROCEDURE check_stat_setup_df
60 (p_organization_id IN NUMBER
61 ,p_org_info_type_code IN VARCHAR2
62 ,p_state_level_bal IN VARCHAR2
63 ,p_gratuity_coverage IN VARCHAR2
64 ,p_calling_procedure IN VARCHAR2
65 ,p_message_name OUT NOCOPY VARCHAR2
66 ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
67 ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
68
69 PROCEDURE check_pt_loc
70 (p_organization_id IN NUMBER
71 ,p_location_id IN NUMBER
72 ,p_calling_procedure IN VARCHAR2
73 ,p_message_name OUT NOCOPY VARCHAR2
74 ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
75 ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
76
77 PROCEDURE check_pt_org_class
78 (p_organization_id IN NUMBER
79 ,p_calling_procedure IN VARCHAR2
80 ,p_message_name OUT NOCOPY VARCHAR2
81 ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
82 ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
83
84 FUNCTION get_pt_balance(p_payroll_id IN NUMBER
85 ,p_assignment_id IN NUMBER
86 ,p_assignment_action_id IN NUMBER
87 ,p_balance_name IN VARCHAR2
88 ,p_year_start IN DATE
89 ,p_end_date IN DATE
90 ,p_tot_pay_periods IN NUMBER
91 ,p_period_num IN NUMBER
92 ,p_frequency IN NUMBER
93 ,p_state IN VARCHAR2
94 ,p_gross_salary OUT NOCOPY NUMBER
95 ,p_prepaid_tax OUT NOCOPY NUMBER
96 ,p_period_count OUT NOCOPY NUMBER
97 ,p_pt_org IN NUMBER)
98 RETURN VARCHAR2;
99
100 FUNCTION check_pt_input
101 (p_assignment_id IN NUMBER
102 ,p_state IN VARCHAR2
103 ,p_period_end_date IN DATE
104 ,p_prorate_end_date IN DATE
105 ,p_pt_salary IN OUT NOCOPY NUMBER)
106 RETURN VARCHAR2;
107
108 FUNCTION check_pt_state_end_date
109 (p_assignment_id IN NUMBER
110 ,p_date IN DATE
111 ,p_state IN VARCHAR2)
112 RETURN NUMBER ;
113
114 PROCEDURE check_srtc_state
115 (p_organization_id IN NUMBER
116 ,p_org_information_id IN NUMBER
117 ,p_org_info_type_code IN VARCHAR2
118 ,p_srtc IN VARCHAR2
119 ,p_calling_procedure IN VARCHAR2
120 ,p_message_name OUT NOCOPY VARCHAR2
121 ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
122 ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
123
124 FUNCTION get_projected_pt
125 (p_pt_dedn_ptd IN number
126 ,p_lrpp IN number
127 ,p_period_num IN number
128 ,p_std_ptax IN NUMBER
129 ,p_frequency IN NUMBER
130 ,p_state IN VARCHAR2)
131 RETURN NUMBER ;
132
133 g_count NUMBER := 0;
134
135 TYPE PTRec
136 IS RECORD
137 (
138 State VARCHAR2(240),
139 PT_Salary NUMBER
140 );
141
142 TYPE tPTTable IS TABLE OF PTRec INDEX BY BINARY_INTEGER;
143
144 gPTTable tPTTable;
145
146
147 END pay_in_prof_tax_pkg;