1 PACKAGE pay_cn_payslip AS
2 /* $Header: pycnpslp.pkh 120.0.12010000.1 2008/07/27 22:21:25 appldev 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_taxable_earnings_ytd NUMBER --
50 -- p_non_taxable_earnings_ytd NUMBER --
51 -- p_voluntary_deductions_ytd NUMBER --
52 -- p_statutory_deductions_ytd NUMBER --
53 -- --
54 --------------------------------------------------------------------------
55 --
56 PROCEDURE balance_totals
57 (
58 p_prepaid_tag IN VARCHAR2
59 ,p_assignment_action_id IN NUMBER
60 ,p_taxable_earnings_current OUT NOCOPY NUMBER
61 ,p_non_taxable_earnings_current OUT NOCOPY NUMBER
62 ,p_voluntary_deductions_current OUT NOCOPY NUMBER
63 ,p_statutory_deductions_current OUT NOCOPY NUMBER
64 ,p_taxable_earnings_ytd OUT NOCOPY NUMBER
65 ,p_non_taxable_earnings_ytd OUT NOCOPY NUMBER
66 ,p_voluntary_deductions_ytd OUT NOCOPY NUMBER
67 ,p_statutory_deductions_ytd OUT NOCOPY NUMBER
68 );
69
70 --------------------------------------------------------------------------
71 -- --
72 -- Name : GET_RUN_RESULT_VALUE --
73 -- Type : PROCEDURE --
74 -- Access : Public --
75 -- Description : Procedure to run_result_value of a given --
76 -- element name and input value name for a given --
77 -- payroll assignment_action_id --
78 -- --
79 -- Parameters : --
80 -- IN : --
81 -- p_assignment_action_id NUMBER --
82 -- p_element_name VARCHAR2 --
83 -- p_input_value_name VARCHAR2 --
84 -- OUT : p_value NUMBER --
85 -- --
86 --------------------------------------------------------------------------
87 --
88 PROCEDURE get_run_result_value
89 (
90 p_assignment_action_id IN NUMBER
91 ,p_element_name IN VARCHAR2
92 ,p_input_value_name IN VARCHAR2
93 ,p_value OUT NOCOPY NUMBER
94 );
95
96 --
97
98 --------------------------------------------------------------------------
99 -- --
100 -- Name : GET_EXCHANGE_RATE --
101 -- Type : FUNCTION --
102 -- Access : Public --
103 -- Description : Function to return the exchange rate for a given --
104 -- FROM and TO currency --
105 -- --
106 -- Parameters : --
107 -- IN : p_from_currency VARCHAR2 --
108 -- p_to_currency VARCHAR2 --
109 -- p_eff_date DATE --
110 -- p_business_group_id NUMBER --
111 -- OUT : N/A --
112 -- RETURN : NUMBER --
113 --------------------------------------------------------------------------
114 --
115 FUNCTION get_exchange_rate
116 (
117 p_from_currency IN VARCHAR2
118 ,p_to_currency IN VARCHAR2
119 ,p_eff_date IN DATE
120 ,p_business_group_id IN NUMBER
121 )
122 RETURN NUMBER;
123 --
124
125 --------------------------------------------------------------------------
126 -- --
127 -- Name : BUSINESS_CURRENCY_CODE --
128 -- Type : FUNCTION --
129 -- Access : Public --
130 -- Description : Function to return business_currency_code for --
131 -- given business_group_id --
132 -- --
133 -- Parameters : --
134 -- IN : p_business_group_id NUMBER --
135 -- OUT : N/A --
136 -- RETURN : VARCHAR2 --
137 --------------------------------------------------------------------------
138 --
139 FUNCTION business_currency_code
140 (
141 p_business_group_id IN NUMBER
142 )
143 RETURN VARCHAR2;
144 END pay_cn_payslip;