1 PACKAGE pay_es_twr_calc_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyestwrc.pkh 120.3 2005/07/20 04:08:24 grchandr noship $ */
3 --
4 TYPE XMLRec IS RECORD(
5 TagName VARCHAR2(240),
6 TagValue VARCHAR2(240));
7 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
8 vXMLTable tXMLTable;
9 vCtr NUMBER;
10 --
11 FUNCTION get_payment_key(passignment_id NUMBER
12 ,peffective_date DATE ) RETURN VARCHAR2;
13 --
14 FUNCTION get_no_contacts(passignment_id IN NUMBER
15 ,pbusiness_gr_id IN NUMBER
16 ,peffective_date IN DATE
17 ,pno_descendant OUT NOCOPY NUMBER
18 ,pno_descendant_less_3 OUT NOCOPY NUMBER
19 ,pno_descendant_bet_3_25 OUT NOCOPY NUMBER
20 ,pno_desc_disability_33_64 OUT NOCOPY NUMBER
21 ,pno_desc_disability_gr_65 OUT NOCOPY NUMBER
22 ,pno_desc_reduced_mobility OUT NOCOPY NUMBER
23 ,pno_desc_single_parent OUT NOCOPY NUMBER
24 ,pno_ascendant OUT NOCOPY NUMBER
25 ,pno_ascendant_gr_75 OUT NOCOPY NUMBER
26 ,pno_asc_disability_33_64 OUT NOCOPY NUMBER
27 ,pno_asc_disability_gr_65 OUT NOCOPY NUMBER
28 ,pno_asc_reduced_mobility OUT NOCOPY NUMBER
29 ,pno_asc_single_descendant OUT NOCOPY NUMBER
30 ,pdescendant_dis_amt OUT NOCOPY NUMBER
31 ,pdescendant_sp_assistance_amt OUT NOCOPY NUMBER
32 ,pascendant_dis_amt OUT NOCOPY NUMBER
33 ,pascendant_sp_assistance_amt OUT NOCOPY NUMBER
34 ,pascendant_age_deduction_amt OUT NOCOPY NUMBER
35 ,pno_independent_siblings OUT NOCOPY NUMBER
36 ,psingle_parent OUT NOCOPY VARCHAR2
37 ,pno_descendant_adopt_less_3 OUT NOCOPY NUMBER)
38 RETURN NUMBER;
39 --
40 FUNCTION get_marital_status(passignment_id IN NUMBER
41 ,peffective_date IN DATE
42 ,passignment_number OUT NOCOPY VARCHAR2
43 ,pmarital_status_code OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
44 --
45 FUNCTION get_spouse_info(pperson_id NUMBER
46 ,peffective_date DATE ) RETURN VARCHAR2;
47 --
48 FUNCTION get_disability_info(passignment_id IN NUMBER
49 ,peffective_date IN DATE
50 ,pdegree OUT NOCOPY NUMBER
51 ,pspecial_care_flag OUT NOCOPY VARCHAR2)
52 RETURN VARCHAR2;
53 --
54 FUNCTION get_disability_detail(pperson_id IN NUMBER
55 ,peffective_date IN DATE
56 ,pdegree OUT NOCOPY NUMBER
57 ,pspecial_care_flag OUT NOCOPY VARCHAR2)
58 RETURN VARCHAR2;
59 --
60 FUNCTION get_table_value(bus_group_id IN NUMBER
61 ,ptab_name IN VARCHAR2
62 ,pcol_name IN VARCHAR2
63 ,prow_value IN VARCHAR2
64 ,peffective_date IN DATE )RETURN NUMBER;
65 --
66 FUNCTION get_parameter_value(p_payroll_action_id IN NUMBER
67 ,p_token_name IN VARCHAR2) RETURN VARCHAR2;
68 --
69 FUNCTION Emp_Address_chk(passignment_id IN NUMBER
70 ,peffective_date IN DATE ) RETURN VARCHAR2 ;
71 --
72 FUNCTION get_effective_date(p_payroll_action_id IN NUMBER
73 ,p_assignment_id IN NUMBER
74 ,p_date_earned IN DATE
75 ,p_run_type OUT NOCOPY VARCHAR2
76 ,p_process_twr_flag OUT NOCOPY VARCHAR2) RETURN DATE;
77 --
78 FUNCTION get_pay_period_number(payroll_id IN NUMBER
79 ,peffective_date IN DATE) RETURN NUMBER;
80 --
81 FUNCTION get_proration_factor(passignment_id IN NUMBER
82 ,payroll_id IN NUMBER
83 ,peffective_date IN DATE
84 ,phire_date IN DATE
85 ,ptermination_date IN DATE
86 ,ppay_periods_per_year IN NUMBER
87 ,ppay_proc_period_number IN NUMBER
88 ,pchk_new_emp IN VARCHAR2
89 ,p_run_type IN VARCHAR2) RETURN NUMBER;
90 --
91 FUNCTION chk_new_employee(passignment_id IN NUMBER
92 ,peffective_date IN DATE) RETURN VARCHAR2;
93 --
94 FUNCTION get_user_table_upper_value(pvalue IN NUMBER
95 ,peffective_date IN DATE) RETURN NUMBER;
96 --
97 FUNCTION get_previous_twr_run_values(passignment_id IN NUMBER
98 ,peffective_date IN DATE
99 ,ptax_base OUT NOCOPY NUMBER
100 ,pcont_earnings OUT NOCOPY NUMBER) RETURN NUMBER;
101 --
102 PROCEDURE populate_TWR_Report(p_request_id IN NUMBER
103 ,p_payroll_action_id NUMBER
104 ,p_legal_employer NUMBER
105 ,p_person_id NUMBER
106 ,p_xfdf_blob OUT NOCOPY BLOB);
107 --
108 PROCEDURE fetch_pdf_blob (p_pdf_blob OUT NOCOPY BLOB);
109 --
110 FUNCTION get_name(p_payroll_action_id IN NUMBER
111 ,p_action_type IN VARCHAR2
112 ,p_effective_date IN DATE) RETURN VARCHAR2;
113
114 --
115 PROCEDURE populate_plsql_table(p_request_id IN NUMBER
116 ,p_payroll_action_id NUMBER
117 ,p_legal_employer NUMBER
118 ,p_person_id NUMBER);
119 --
120 PROCEDURE clob_to_blob (p_clob clob,
121 p_blob IN OUT NOCOPY Blob);
122 --
123 PROCEDURE WritetoCLOB (p_xfdf_blob OUT NOCOPY blob
124 ,p_xfdf_string OUT NOCOPY clob);
125 --
126 FUNCTION get_contractual_earnings(p_assignment_id IN NUMBER
127 ,p_calculation_date IN DATE
128 ,p_name IN VARCHAR2
129 ,p_rt_element IN VARCHAR2
130 ,p_to_time_dim IN VARCHAR2
131 ,p_rate IN OUT NOCOPY NUMBER
132 ,p_error_message IN OUT NOCOPY VARCHAR2) RETURN NUMBER;
133 --
134 FUNCTION calc_withholding_quota(p_business_gr_id IN NUMBER
135 ,p_effective_date IN DATE
136 ,p_tax_base IN NUMBER) RETURN NUMBER;
137 --
138 FUNCTION get_contract_end_date(p_assignment_id IN NUMBER
139 ,p_effective_date IN DATE) RETURN DATE;
140 --
141 FUNCTION get_contractual_deductions(p_assignment_id IN NUMBER
142 ,p_calculation_date IN DATE
143 ,p_period_start_date IN DATE
144 ,p_period_end_date IN DATE
145 ,p_pay_periods_per_year IN NUMBER
146 ,p_pay_proc_period_number IN NUMBER
147 ,p_child_support_amt OUT NOCOPY NUMBER
148 ,p_spouse_alimony_amt OUT NOCOPY NUMBER) RETURN NUMBER;
149 --
150 END pay_es_twr_calc_pkg;