1 PACKAGE pqp_gb_tp_contribution_report AUTHID CURRENT_USER AS
2 /* $Header: pqpgbtpcontrep.pkh 120.6.12020000.1 2013/03/11 11:21:47 sgmaram noship $ */
3 PROCEDURE generate(p_employer NUMBER
4 ,p_payroll NUMBER
5 ,p_period NUMBER
6 ,p_template_name VARCHAR2
7 ,p_xml OUT NOCOPY CLOB);
8
9 FUNCTION TPS_Pension_tier( p_payroll_id NUMBER,
10 p_business_group_id NUMBER,
11 P_DATE_EARNED DATE,
12 p_assignment_id NUMBER,
13 p_assignment_action_id number,
14 p_rv_a IN OUT NOCOPY NUMBER,
15 p_rv_b IN OUT NOCOPY NUMBER,
16 p_rv_c IN OUT NOCOPY NUMBER)
17 return NUMBER;
18
19 FUNCTION TPS_Pension_input_values( p_payroll_id NUMBER,
20 p_business_group_id NUMBER,
21 P_DATE_EARNED DATE,
22 p_assignment_id NUMBER,
23 p_assignment_action_id number,
24 p_rv_a IN OUT NOCOPY NUMBER,
25 p_rv_b IN OUT NOCOPY NUMBER,
26 p_rv_c IN OUT NOCOPY NUMBER,
27 p_pp_a IN OUT NOCOPY NUMBER,
28 p_pp_b IN OUT NOCOPY NUMBER,
29 p_pp_c IN OUT NOCOPY NUMBER,
30 p_ee_a IN OUT NOCOPY NUMBER,
31 p_ee_b IN OUT NOCOPY NUMBER,
32 p_ee_c IN OUT NOCOPY NUMBER,
33 p_er_a IN OUT NOCOPY NUMBER,
34 p_er_b IN OUT NOCOPY NUMBER,
35 p_er_c IN OUT NOCOPY NUMBER,
36 p_af_a IN OUT NOCOPY NUMBER,
37 p_af_b IN OUT NOCOPY NUMBER,
38 p_af_c IN OUT NOCOPY NUMBER)
39 return NUMBER;
40
41 /* The below function will be used as a Formula function */
42 FUNCTION supply_pension_bands (
43 p_assignment_id in number,
44 p_business_group_id in number,
45 p_date_worked in date,
46 /* below input params for salary rates */
47 p_sal_rate1 in varchar2,
48 p_sal_rate2 in varchar2,
49 p_sal_rate3 in varchar2,
50 /* below input params for allowance rates */
51 p_allow_rate1 in varchar2,
52 p_allow_rate2 in varchar2,
53 p_allow_rate3 in varchar2,
54 /* below params for out */
55 p_tier in out nocopy number,
56 p_ee_percentage in out nocopy number,
57 p_er_percentage in out nocopy number,
58 p_annual_fte_rate in out nocopy number
59 ) return number ;
60
61
62
63 END pqp_gb_tp_contribution_report;