1 PACKAGE pay_cn_payslip AUTHID CURRENT_USER AS
2 /* $Header: pycnpslp.pkh 120.0.12010000.2 2008/12/05 06:09:12 rsaharay ship $ */
3
4 --------------------------------------------------------------------------
5 -- --
6 -- Name : CURRENT_AND_YTD_BALANCES --
7 -- Type : PROCEDURE --
8 -- Access : Public --
9 -- Description : Procedure to return PTD and YTD values of a balance --
10 -- for a given assignment_action_id --
11 -- --
12 -- Parameters : --
13 -- IN : p_prepaid_tag VARCHAR2 --
14 -- p_assignment_action_id NUMBER --
15 -- p_balance_name VARCHAR2 --
16 -- OUT : p_current_balance NUMBER --
17 -- p_ytd_balance NUMBER --
18 -- --
19 --------------------------------------------------------------------------
20 --
21 PROCEDURE current_and_ytd_balances
22 (
23 p_prepaid_tag IN VARCHAR2
24 ,p_assignment_action_id IN NUMBER
25 ,p_balance_name IN VARCHAR2
26 ,p_current_balance OUT NOCOPY NUMBER
27 ,p_ytd_balance OUT NOCOPY NUMBER
28 );
29
30 --
31
32 --------------------------------------------------------------------------
33 -- --
34 -- Name : BALANCE_TOTALS --
35 -- Type : PROCEDURE --
36 -- Access : Public --
37 -- Description : Procedure to return PTD and YTD values of the --
38 -- values of taxable_earnings,non_taxable_earnings, --
39 -- voluntary_deductions and statutory_deductions for a --
40 -- given assignment_action_id --
41 -- --
42 -- Parameters : --
43 -- IN : p_prepaid_tag VARCHAR2 --
44 -- p_assignment_action_id NUMBER --
45 -- OUT : p_taxable_earnings_current NUMBER --
46 -- p_non_taxable_earnings_current NUMBER --
47 -- p_voluntary_deductions_current NUMBER --
48 -- p_statutory_deductions_current NUMBER --
49 -- p_pre_tax_deductions_current NUMBER --
50 -- p_taxable_earnings_ytd NUMBER --
51 -- p_non_taxable_earnings_ytd NUMBER --
52 -- p_voluntary_deductions_ytd NUMBER --
53 -- p_statutory_deductions_ytd NUMBER --
54 -- p_pre_tax_deductions_ytd NUMBER --
55 -- --
56 --------------------------------------------------------------------------
57 --
58 PROCEDURE balance_totals
59 (
60 p_prepaid_tag IN VARCHAR2
61 ,p_assignment_action_id IN NUMBER
62 ,p_taxable_earnings_current OUT NOCOPY NUMBER
63 ,p_non_taxable_earnings_current OUT NOCOPY NUMBER
64 ,p_voluntary_deductions_current OUT NOCOPY NUMBER
65 ,p_statutory_deductions_current OUT NOCOPY NUMBER
66 ,p_pre_tax_deductions_current OUT NOCOPY NUMBER
67 ,p_taxable_earnings_ytd OUT NOCOPY NUMBER
68 ,p_non_taxable_earnings_ytd OUT NOCOPY NUMBER
69 ,p_voluntary_deductions_ytd OUT NOCOPY NUMBER
70 ,p_statutory_deductions_ytd OUT NOCOPY NUMBER
71 ,p_pre_tax_deductions_ytd OUT NOCOPY NUMBER
72 );
73
74 --------------------------------------------------------------------------
75 -- --
76 -- Name : GET_RUN_RESULT_VALUE --
77 -- Type : PROCEDURE --
78 -- Access : Public --
79 -- Description : Procedure to run_result_value of a given --
80 -- element name and input value name for a given --
81 -- payroll assignment_action_id --
82 -- --
83 -- Parameters : --
84 -- IN : --
85 -- p_assignment_action_id NUMBER --
86 -- p_element_name VARCHAR2 --
87 -- p_input_value_name VARCHAR2 --
88 -- OUT : p_value NUMBER --
89 -- --
90 --------------------------------------------------------------------------
91 --
92 PROCEDURE get_run_result_value
93 (
94 p_assignment_action_id IN NUMBER
95 ,p_element_name IN VARCHAR2
96 ,p_input_value_name IN VARCHAR2
97 ,p_value OUT NOCOPY NUMBER
98 );
99
100 --
101
102 --------------------------------------------------------------------------
103 -- --
104 -- Name : GET_EXCHANGE_RATE --
105 -- Type : FUNCTION --
106 -- Access : Public --
107 -- Description : Function to return the exchange rate for a given --
108 -- FROM and TO currency --
109 -- --
110 -- Parameters : --
111 -- IN : p_from_currency VARCHAR2 --
112 -- p_to_currency VARCHAR2 --
113 -- p_eff_date DATE --
114 -- p_business_group_id NUMBER --
115 -- OUT : N/A --
116 -- RETURN : NUMBER --
117 --------------------------------------------------------------------------
118 --
119 FUNCTION get_exchange_rate
120 (
121 p_from_currency IN VARCHAR2
122 ,p_to_currency IN VARCHAR2
123 ,p_eff_date IN DATE
124 ,p_business_group_id IN NUMBER
125 )
126 RETURN NUMBER;
127 --
128
129 --------------------------------------------------------------------------
130 -- --
131 -- Name : BUSINESS_CURRENCY_CODE --
132 -- Type : FUNCTION --
133 -- Access : Public --
134 -- Description : Function to return business_currency_code for --
135 -- given business_group_id --
136 -- --
137 -- Parameters : --
138 -- IN : p_business_group_id NUMBER --
139 -- OUT : N/A --
140 -- RETURN : VARCHAR2 --
141 --------------------------------------------------------------------------
142 --
143 FUNCTION business_currency_code
144 (
145 p_business_group_id IN NUMBER
146 )
147 RETURN VARCHAR2;
148 END pay_cn_payslip;