[Home] [Help]
PACKAGE: APPS.PAY_CN_SOE
Source
1 PACKAGE pay_cn_soe AUTHID CURRENT_USER AS
2 /* $Header: pycnsoe.pkh 120.4.12020000.1 2012/06/28 17:26:19 appldev ship $ */
3
4 --------------------------------------------------------------------------
5 -- --
6 -- Name : GET_TAXABLE_EARNINGS --
7 -- Type : FUNCTION --
8 -- Access : Public --
9 -- Description : Function to return SQL for Earnings Region --
10 -- --
11 -- Parameters : --
12 -- IN : p_assignment_action_id NUMBER --
13 -- --
14 --------------------------------------------------------------------------
15 FUNCTION get_taxable_earnings(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
16 RETURN LONG;
17
18 --------------------------------------------------------------------------
19 -- --
20 -- Name : GET_NON_TAXABLE_EARNINGS --
21 -- Type : FUNCTION --
22 -- Access : Public --
23 -- Description : Function to return SQL for Non Taxable Earnings --
24 -- Region --
25 -- --
26 -- Parameters : --
27 -- IN : p_assignment_action_id NUMBER --
28 -- --
29 --------------------------------------------------------------------------
30 FUNCTION get_non_taxable_earnings(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
31 RETURN LONG;
32
33 --------------------------------------------------------------------------
34 -- --
35 -- Name : GET_STATUTORY_DEDUCTIONS --
36 -- Type : FUNCTION --
37 -- Access : Public --
38 -- Description : Function to return SQL for Statutory Deductions --
39 -- Region --
40 -- --
41 -- Parameters : --
42 -- IN : p_assignment_action_id NUMBER --
43 -- --
44 --------------------------------------------------------------------------
45 FUNCTION get_statutory_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
46 RETURN LONG;
47
48 --------------------------------------------------------------------------
49 -- --
50 -- Name : GET_NON_STATUTORY_DEDUCTIONS --
51 -- Type : FUNCTION --
52 -- Access : Public --
53 -- Description : Function to return SQL for Statutory Deductions --
54 -- Region --
55 -- --
56 -- Parameters : --
57 -- IN : p_assignment_action_id NUMBER --
58 -- --
59 --------------------------------------------------------------------------
60 FUNCTION get_non_statutory_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
61 RETURN LONG;
62
63
64 --------------------------------------------------------------------------
65 -- --
66 -- Name : GET_VOLUNTARY_DEDUCTIONS --
67 -- Type : FUNCTION --
68 -- Access : Public --
69 -- Description : Function to return SQL for Voluntary Deductions --
70 -- Region --
71 -- --
72 -- Parameters : --
73 -- IN : p_assignment_action_id NUMBER --
74 -- --
75 --------------------------------------------------------------------------
76 FUNCTION get_voluntary_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
77 RETURN LONG;
78
79 --------------------------------------------------------------------------
80 -- --
81 -- Name : GET_BALANCES --
82 -- Type : FUNCTION --
83 -- Access : Public --
84 -- Description : Function to return SQL for Balances Region --
85 -- --
86 -- Parameters : --
87 -- IN : p_assignment_action_id NUMBER --
88 -- --
89 --------------------------------------------------------------------------
90 FUNCTION get_balances( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
91 RETURN LONG;
92
93 --------------------------------------------------------------------------
94 -- --
95 -- Name : GET_PAYMENT_METHODS --
96 -- Type : FUNCTION --
97 -- Access : Public --
98 -- Description : Function to return SQL for Payments Method Region --
99 -- --
100 -- Parameters : --
101 -- IN : p_assignment_action_id NUMBER --
102 -- --
103 --------------------------------------------------------------------------
104 FUNCTION get_payment_methods(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
105 RETURN LONG;
106
107 --------------------------------------------------------------------------
108 -- --
109 -- Name : GET_OTHER_ELEMENT_INFORMATION --
110 -- Type : FUNCTION --
111 -- Access : Public --
112 -- Description : Function to return SQL for Other Element --
113 -- Information Region --
114 -- --
115 -- Parameters : --
116 -- IN : p_assignment_action_id NUMBER --
117 -- --
118 --------------------------------------------------------------------------
119 FUNCTION get_other_element_information(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
120 RETURN LONG;
121
122 --------------------------------------------------------------------------
123 -- --
124 -- Name : GET_OTHER_BALANCE_INFORMATION --
125 -- Type : FUNCTION --
126 -- Access : Public --
127 -- Description : Function to return SQL for Other Balance --
128 -- Information Region --
129 -- --
130 -- Parameters : --
131 -- IN : p_assignment_action_id NUMBER --
132 -- --
133 --------------------------------------------------------------------------
134 FUNCTION get_other_balance_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
135 RETURN LONG;
136
137 --------------------------------------------------------------------------
138 -- --
139 -- Name : GET_ANNUAL_LEAVE_INFORMATION --
140 -- Type : FUNCTION --
141 -- Access : Public --
142 -- Description : Function to return SQL for Annual Leave --
143 -- Information Region --
144 -- --
145 -- Parameters : --
146 -- IN : p_assignment_action_id NUMBER --
147 -- --
148 --------------------------------------------------------------------------
149 FUNCTION get_annual_leave_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
150 RETURN LONG;
151
152 --------------------------------------------------------------------------
153 -- --
154 -- Name : GET_LEAVE_TAKEN --
155 -- Type : FUNCTION --
156 -- Access : Public --
157 -- Description : Function to return SQL for Leave Taken Region --
158 -- --
159 -- Parameters : --
160 -- IN : p_assignment_action_id NUMBER --
161 -- --
162 --------------------------------------------------------------------------
163 FUNCTION get_leave_taken(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
164 RETURN LONG;
165
166 --------------------------------------------------------------------------
167 -- --
168 -- Name : GET_MESSAGES --
169 -- Type : FUNCTION --
170 -- Access : Public --
171 -- Description : Function to return SQL for Messages Region --
172 -- --
173 -- Parameters : --
174 -- IN : p_assignment_action_id NUMBER --
175 -- --
176 --------------------------------------------------------------------------
177 FUNCTION get_messages(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
178 RETURN LONG;
179
180 END pay_cn_soe;