[Home] [Help]
PACKAGE: APPS.PAY_HK_SOE_PKG
Source
1 package pay_hk_soe_pkg AUTHID CURRENT_USER as
2 /* $Header: pyhksoe.pkh 120.2.12010000.1 2008/07/27 22:48:58 appldev ship $ */
3
4 function get_balance_id
5 (p_balance_name in pay_balance_types.balance_name%type,
6 p_dimension_name in pay_balance_dimensions.dimension_name%type)
7 return pay_defined_balances.defined_balance_id%type;
8
9 procedure balance_totals
10 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
11 p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,
12 p_total_earnings_this_pay out nocopy number,
13 p_total_earnings_ytd out nocopy number,
14 p_total_deductions_this_pay out nocopy number,
15 p_total_deductions_ytd out nocopy number,
16 p_net_pay_this_pay out nocopy number,
17 p_net_pay_ytd out nocopy number,
18 p_direct_payments_this_pay out nocopy number,
19 p_direct_payments_ytd out nocopy number,
20 p_total_payment_this_pay out nocopy number,
21 p_total_payment_ytd out nocopy number);
22
23 function business_currency_code
24 (p_business_group_id in hr_organization_units.business_group_id%type)
25 return fnd_currencies.currency_code%type;
26
27 /* Bug 4210525, Added variables */
28 g_def_bal_id_populated_payment boolean;
29 g_def_bal_id_populated_ytd boolean;
30
31 --------------------------------------------------------------------------
32 -- --
33 -- Name : GET_EARNINGS --
34 -- Type : FUNCTION --
35 -- Access : Public --
36 -- Description : Function to return SQL for Earnings Region --
37 -- --
38 -- Parameters : --
39 -- IN : p_assignment_action_id NUMBER --
40 -- Bug 5396046 --
41 --------------------------------------------------------------------------
42 FUNCTION get_earnings(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
43 RETURN LONG;
44
45
46 --------------------------------------------------------------------------
47 -- --
48 -- Name : GET_DEDUCTIONS --
49 -- Type : FUNCTION --
50 -- Access : Public --
51 -- Description : Function to return SQL for Deductions Region --
52 -- --
53 -- Parameters : --
54 -- IN : p_assignment_action_id NUMBER --
55 -- Bug 5396046 --
56 --------------------------------------------------------------------------
57 FUNCTION get_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
58 RETURN LONG;
59
60
61 --------------------------------------------------------------------------
62 -- --
63 -- Name : GET_EMPLOYER_LIABILITIES --
64 -- Type : FUNCTION --
65 -- Access : Public --
66 -- Description : Function to return SQL for Employer Liabilities --
67 -- Region --
68 -- --
69 -- Parameters : --
70 -- IN : p_assignment_action_id NUMBER --
71 -- Bug 5396046 --
72 --------------------------------------------------------------------------
73 FUNCTION get_employer_liabilities(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
74 RETURN LONG;
75
76
77 --------------------------------------------------------------------------
78 -- --
79 -- Name : GET_BALANCES --
80 -- Type : FUNCTION --
81 -- Access : Public --
82 -- Description : Function to return SQL for balances --
83 -- Region --
84 -- --
85 -- Parameters : --
86 -- IN : p_assignment_action_id NUMBER --
87 -- Bug 5396046 --
88 --------------------------------------------------------------------------
89 FUNCTION get_balances(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
90 RETURN LONG;
91
92
93 --------------------------------------------------------------------------
94 -- --
95 -- Name : GET_BALANCES --
96 -- Type : FUNCTION --
97 -- Access : Public --
98 -- Description : Function to return SQL for balances --
99 -- Region --
100 -- --
101 -- Parameters : --
102 -- IN : p_assignment_action_id NUMBER --
103 -- Bug 5396046 --
104 --------------------------------------------------------------------------
105 FUNCTION get_payment_methods(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
106 RETURN LONG;
107
108 --------------------------------------------------------------------------
109 -- --
110 -- Name : GET_OTHER_ELEMENT_INFORMATION --
111 -- Type : FUNCTION --
112 -- Access : Public --
113 -- Description : Function to return SQL for Other Element --
114 -- Information Region --
115 -- --
116 -- Parameters : --
117 -- IN : p_assignment_action_id NUMBER --
118 -- Bug 5396046 --
119 --------------------------------------------------------------------------
120 FUNCTION get_other_element_information(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
121 RETURN LONG;
122
123 --------------------------------------------------------------------------
124 -- --
125 -- Name : GET_OTHER_BALANCE_INFORMATION --
126 -- Type : FUNCTION --
127 -- Access : Public --
128 -- Description : Function to return SQL for Other Balance --
129 -- Information Region --
130 -- --
131 -- Parameters : --
132 -- IN : p_assignment_action_id NUMBER --
133 -- Bug 5396046 --
134 --------------------------------------------------------------------------
135 FUNCTION get_other_balance_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
136 RETURN LONG;
137
138 --------------------------------------------------------------------------
139 -- --
140 -- Name : GET_ANNUAL_LEAVE_INFORMATION --
141 -- Type : FUNCTION --
142 -- Access : Public --
143 -- Description : Function to return SQL for Annual Leave --
144 -- Information Region --
145 -- --
146 -- Parameters : --
147 -- IN : p_assignment_action_id NUMBER --
148 -- Bug 5396046 --
149 --------------------------------------------------------------------------
150 FUNCTION get_annual_leave_info(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
151 RETURN LONG;
152
153 --------------------------------------------------------------------------
154 -- --
155 -- Name : GET_LEAVE_TAKEN --
156 -- Type : FUNCTION --
157 -- Access : Public --
158 -- Description : Function to return SQL for Leave Taken Region --
159 -- --
160 -- Parameters : --
161 -- IN : p_assignment_action_id NUMBER --
162 -- Bug 5396046 --
163 --------------------------------------------------------------------------
164 FUNCTION get_leave_taken(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
165 RETURN LONG;
166
167 end pay_hk_soe_pkg;