[Home] [Help]
PACKAGE: APPS.PAY_CN_SOE
Source
1 PACKAGE pay_cn_soe AS
2 /* $Header: pycnsoe.pkh 120.2 2006/02/28 21:38 sukukuma noship $ */
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_VOLUNTARY_DEDUCTIONS --
51 -- Type : FUNCTION --
52 -- Access : Public --
53 -- Description : Function to return SQL for Voluntary Deductions --
54 -- Region --
55 -- --
56 -- Parameters : --
57 -- IN : p_assignment_action_id NUMBER --
58 -- --
59 --------------------------------------------------------------------------
60 FUNCTION get_voluntary_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
61 RETURN LONG;
62
63 --------------------------------------------------------------------------
64 -- --
65 -- Name : GET_BALANCES --
66 -- Type : FUNCTION --
67 -- Access : Public --
68 -- Description : Function to return SQL for Balances Region --
69 -- --
70 -- Parameters : --
71 -- IN : p_assignment_action_id NUMBER --
72 -- --
73 --------------------------------------------------------------------------
74 FUNCTION get_balances( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
75 RETURN LONG;
76
77 --------------------------------------------------------------------------
78 -- --
79 -- Name : GET_PAYMENT_METHODS --
80 -- Type : FUNCTION --
81 -- Access : Public --
82 -- Description : Function to return SQL for Payments Method Region --
83 -- --
84 -- Parameters : --
85 -- IN : p_assignment_action_id NUMBER --
86 -- --
87 --------------------------------------------------------------------------
88 FUNCTION get_payment_methods(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
89 RETURN LONG;
90
91 --------------------------------------------------------------------------
92 -- --
93 -- Name : GET_OTHER_ELEMENT_INFORMATION --
94 -- Type : FUNCTION --
95 -- Access : Public --
96 -- Description : Function to return SQL for Other Element --
97 -- Information Region --
98 -- --
99 -- Parameters : --
100 -- IN : p_assignment_action_id NUMBER --
101 -- --
102 --------------------------------------------------------------------------
103 FUNCTION get_other_element_information(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
104 RETURN LONG;
105
106 --------------------------------------------------------------------------
107 -- --
108 -- Name : GET_OTHER_BALANCE_INFORMATION --
109 -- Type : FUNCTION --
110 -- Access : Public --
111 -- Description : Function to return SQL for Other Balance --
112 -- Information Region --
113 -- --
114 -- Parameters : --
115 -- IN : p_assignment_action_id NUMBER --
116 -- --
117 --------------------------------------------------------------------------
118 FUNCTION get_other_balance_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
119 RETURN LONG;
120
121 --------------------------------------------------------------------------
122 -- --
123 -- Name : GET_ANNUAL_LEAVE_INFORMATION --
124 -- Type : FUNCTION --
125 -- Access : Public --
126 -- Description : Function to return SQL for Annual Leave --
127 -- Information Region --
128 -- --
129 -- Parameters : --
130 -- IN : p_assignment_action_id NUMBER --
131 -- --
132 --------------------------------------------------------------------------
133 FUNCTION get_annual_leave_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
134 RETURN LONG;
135
136 --------------------------------------------------------------------------
137 -- --
138 -- Name : GET_LEAVE_TAKEN --
139 -- Type : FUNCTION --
140 -- Access : Public --
141 -- Description : Function to return SQL for Leave Taken Region --
142 -- --
143 -- Parameters : --
144 -- IN : p_assignment_action_id NUMBER --
145 -- --
146 --------------------------------------------------------------------------
147 FUNCTION get_leave_taken(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
148 RETURN LONG;
149
150 --------------------------------------------------------------------------
151 -- --
152 -- Name : GET_MESSAGES --
153 -- Type : FUNCTION --
154 -- Access : Public --
155 -- Description : Function to return SQL for Messages Region --
156 -- --
157 -- Parameters : --
158 -- IN : p_assignment_action_id NUMBER --
159 -- --
160 --------------------------------------------------------------------------
161 FUNCTION get_messages(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
162 RETURN LONG;
163
164 END pay_cn_soe;