1 PACKAGE pay_in_payslip_utils AUTHID CURRENT_USER AS
2 /* $Header: pyinpslp.pkh 120.0 2005/05/29 05:52 appldev noship $ */
3
4 --------------------------------------------------------------------------
5 -- --
6 -- Name : YTD_BALANCE --
7 -- Type : PROCEDURE --
8 -- Access : Public --
9 -- Description : Procedure to YTD values of a balance --
10 -- for a given assignment_action_id --
11 -- --
12 -- Parameters : --
13 -- IN : p_assignment_action_id NUMBER --
14 -- p_balance_name VARCHAR2 --
15 -- OUT : p_ytd_balance NUMBER --
16 -- --
17 --------------------------------------------------------------------------
18 --
19 PROCEDURE ytd_balance
20 (
21 p_assignment_action_id IN NUMBER
22 ,p_balance_name IN VARCHAR2
23 ,p_ytd_balance OUT NOCOPY NUMBER
24 );
25
26 --
27
28 --------------------------------------------------------------------------
29 -- --
30 -- Name : BALANCE_TOTALS --
31 -- Type : PROCEDURE --
32 -- Access : Public --
33 -- Description : Procedure to return PTD and YTD values of the --
34 -- values of taxable_earnings,non_taxable_earnings, --
35 -- voluntary_deductions and statutory_deductions for a --
36 -- given assignment_action_id --
37 -- --
38 -- Parameters : --
39 -- IN : p_assignment_action_id NUMBER --
40 -- OUT : p_gross_salary_les_alw_ytd NUMBER --
41 -- p_deductions_us_16_ytd NUMBER --
42 -- p_gross_salary_ytd NUMBER --
43 -- p_deductions_chapter_VIa_ytd NUMBER --
44 -- p_total_income_ytd NUMBER --
45 -- p_tax_on_total_income_ytd NUMBER --
46 -- p_rebates_us_88_ytd NUMBER --
47 -- p_income_tax_ytd NUMBER --
48 -- p_statutory_deductions_ytd NUMBER --
49 -- --
50 --------------------------------------------------------------------------
51 --
52 PROCEDURE balance_totals
53 (
54 p_assignment_action_id IN NUMBER
55 ,p_gross_salary_les_alw_ytd OUT NOCOPY NUMBER
56 ,p_deductions_us_16_ytd OUT NOCOPY NUMBER
57 ,p_gross_salary_ytd OUT NOCOPY NUMBER
58 ,p_deductions_chapter_VIa_ytd OUT NOCOPY NUMBER
59 ,p_total_income_ytd OUT NOCOPY NUMBER
60 ,p_tax_on_total_income_ytd OUT NOCOPY NUMBER
61 ,p_rebates_us_88_ytd OUT NOCOPY NUMBER
62 ,p_income_tax_ytd OUT NOCOPY NUMBER
63 );
64
65
66 --------------------------------------------------------------------------
67 -- --
68 -- Name : GET_EXCHANGE_RATE --
69 -- Type : FUNCTION --
70 -- Access : Public --
71 -- Description : Function to return the exchange rate for a given --
72 -- FROM and TO currency --
73 -- --
74 -- Parameters : --
75 -- IN : p_from_currency VARCHAR2 --
76 -- p_to_currency VARCHAR2 --
77 -- p_eff_date DATE --
78 -- p_business_group_id NUMBER --
79 -- OUT : N/A --
80 -- RETURN : NUMBER --
81 --------------------------------------------------------------------------
82 --
83 FUNCTION get_exchange_rate
84 (
85 p_from_currency IN VARCHAR2
86 ,p_to_currency IN VARCHAR2
87 ,p_eff_date IN DATE
88 ,p_business_group_id IN NUMBER
89 )
90 RETURN NUMBER;
91 --
92
93 END pay_in_payslip_utils;