[Home] [Help]
PACKAGE: APPS.PYJPEXC
Source
1 package pyjpexc as
2 /* $Header: pyjpexc.pkh 120.1.12000000.2 2007/03/05 08:54:30 keyazawa noship $ */
3 --
4 -- Constants
5 --
6 c_asg_run constant pay_balance_dimensions.dimension_name%type := '_ASG_RUN';
7 c_asg_ptd constant pay_balance_dimensions.dimension_name%type := '_ASG_PTD';
8 c_asg_mtd constant pay_balance_dimensions.dimension_name%type := '_ASG_MTD_RUN EFFECTIVE_DATE 01-01 RESET 12';
9 c_asg_ytd constant pay_balance_dimensions.dimension_name%type := '_ASG_YTD_RUN EFFECTIVE_DATE 01-01 RESET 01';
10 c_asg_aprtd constant pay_balance_dimensions.dimension_name%type := '_ASG_APRTD EFFECTIVE_DATE 01-04 RESET 01';
11 c_asg_jultd constant pay_balance_dimensions.dimension_name%type := '_ASG_JULTD_RUN EFFECTIVE_DATE 01-07 RESET 01';
12 c_asg_augtd constant pay_balance_dimensions.dimension_name%type := '_ASG_AUGTD_RUN EFFECTIVE_DATE 01-08 RESET 01';
13 c_asg_fytd constant pay_balance_dimensions.dimension_name%type := '_ASG_BYTD_RUN';
14 c_asg_fytd_de constant pay_balance_dimensions.dimension_name%type := '_ASG_FYTD_RUN DATE_EARNED RESET 01';
15 c_asg_ltd constant pay_balance_dimensions.dimension_name%type := '_ASG_HTD_RUN';
16 c_element_ptd constant pay_balance_dimensions.dimension_name%type := '_ELM_PTD_RUN';
17 c_element_ltd constant pay_balance_dimensions.dimension_name%type := '_ELM_LTD_RUN';
18 c_asg_retro constant pay_balance_dimensions.dimension_name%type := '_ASG_RETRO_PAY';
19 c_payments constant pay_balance_dimensions.dimension_name%type := '_PAYMENTS';
20 --
21 function asg_run return varchar2;
22 function asg_ptd return varchar2;
23 function asg_mtd return varchar2;
24 function asg_ytd return varchar2;
25 function asg_aprtd return varchar2;
26 function asg_jultd return varchar2;
27 function asg_fytd return varchar2;
28 function asg_ltd return varchar2;
29 function element_ptd return varchar2;
30 function element_ltd return varchar2;
31 function asg_retro return varchar2;
32 function payments return varchar2;
33 --
34 procedure ptd_ec(
35 p_owner_payroll_action_id in number,
36 p_user_payroll_action_id in number,
37 p_owner_assignment_action_id in number,
38 p_user_assignment_action_id in number,
39 p_owner_effective_date in date,
40 p_user_effective_date in date,
41 p_dimension_name in varchar2,
42 p_expiry_information out nocopy number);
43 --
44 procedure ptd_ec(
45 p_owner_payroll_action_id in number,
46 p_user_payroll_action_id in number,
47 p_owner_assignment_action_id in number,
48 p_user_assignment_action_id in number,
49 p_owner_effective_date in date,
50 p_user_effective_date in date,
51 p_dimension_name in varchar2,
52 p_expiry_information out nocopy date);
53 --
54 procedure mtd_ec(
55 p_owner_payroll_action_id in number,
56 p_user_payroll_action_id in number,
57 p_owner_assignment_action_id in number,
58 p_user_assignment_action_id in number,
59 p_owner_effective_date in date,
60 p_user_effective_date in date,
61 p_dimension_name in varchar2,
62 p_expiry_information out nocopy number);
63 --
64 procedure mtd_ec(
65 p_owner_payroll_action_id in number,
66 p_user_payroll_action_id in number,
67 p_owner_assignment_action_id in number,
68 p_user_assignment_action_id in number,
69 p_owner_effective_date in date,
70 p_user_effective_date in date,
71 p_dimension_name in varchar2,
72 p_expiry_information out nocopy date);
73 --
74 procedure qtd_ec(
75 p_owner_payroll_action_id in number,
76 p_user_payroll_action_id in number,
77 p_owner_assignment_action_id in number,
78 p_user_assignment_action_id in number,
79 p_owner_effective_date in date,
80 p_user_effective_date in date,
81 p_dimension_name in varchar2,
82 p_expiry_information out nocopy number);
83 --
84 procedure qtd_ec(
85 p_owner_payroll_action_id in number,
86 p_user_payroll_action_id in number,
87 p_owner_assignment_action_id in number,
88 p_user_assignment_action_id in number,
89 p_owner_effective_date in date,
90 p_user_effective_date in date,
91 p_dimension_name in varchar2,
92 p_expiry_information out nocopy date);
93 --
94 procedure ytd_ec(
95 p_owner_payroll_action_id in number,
96 p_user_payroll_action_id in number,
97 p_owner_assignment_action_id in number,
98 p_user_assignment_action_id in number,
99 p_owner_effective_date in date,
100 p_user_effective_date in date,
101 p_dimension_name in varchar2,
102 p_expiry_information out nocopy number);
103 --
104 procedure ytd_ec(
105 p_owner_payroll_action_id in number,
106 p_user_payroll_action_id in number,
107 p_owner_assignment_action_id in number,
108 p_user_assignment_action_id in number,
109 p_owner_effective_date in date,
110 p_user_effective_date in date,
111 p_dimension_name in varchar2,
112 p_expiry_information out nocopy date);
113 --
114 procedure aprtd_ec(
115 p_owner_payroll_action_id in number,
116 p_user_payroll_action_id in number,
117 p_owner_assignment_action_id in number,
118 p_user_assignment_action_id in number,
119 p_owner_effective_date in date,
120 p_user_effective_date in date,
121 p_dimension_name in varchar2,
122 p_expiry_information out nocopy number);
123 --
124 procedure aprtd_ec(
125 p_owner_payroll_action_id in number,
126 p_user_payroll_action_id in number,
127 p_owner_assignment_action_id in number,
128 p_user_assignment_action_id in number,
129 p_owner_effective_date in date,
130 p_user_effective_date in date,
131 p_dimension_name in varchar2,
132 p_expiry_information out nocopy date);
133 --
134 procedure aprtd_sd(
135 p_effective_date in date,
136 p_start_date out nocopy date,
137 p_payroll_id in number,
138 p_bus_grp in number,
139 p_asg_action in number);
140 --
141 procedure jultd_ec(
142 p_owner_payroll_action_id in number,
143 p_user_payroll_action_id in number,
144 p_owner_assignment_action_id in number,
145 p_user_assignment_action_id in number,
146 p_owner_effective_date in date,
147 p_user_effective_date in date,
148 p_dimension_name in varchar2,
149 p_expiry_information out nocopy number);
150 --
151 procedure jultd_ec(
152 p_owner_payroll_action_id in number,
153 p_user_payroll_action_id in number,
154 p_owner_assignment_action_id in number,
155 p_user_assignment_action_id in number,
156 p_owner_effective_date in date,
157 p_user_effective_date in date,
158 p_dimension_name in varchar2,
159 p_expiry_information out nocopy date);
160 --
161 procedure jultd_sd(
162 p_effective_date in date,
163 p_start_date out nocopy date,
164 p_payroll_id in number,
165 p_bus_grp in number,
166 p_asg_action in number);
167 --
168 procedure augtd_ec(
169 p_owner_payroll_action_id in number,
170 p_user_payroll_action_id in number,
171 p_owner_assignment_action_id in number,
172 p_user_assignment_action_id in number,
173 p_owner_effective_date in date,
174 p_user_effective_date in date,
175 p_dimension_name in varchar2,
176 p_expiry_information out nocopy number);
177 --
178 procedure augtd_ec(
179 p_owner_payroll_action_id in number,
180 p_user_payroll_action_id in number,
181 p_owner_assignment_action_id in number,
182 p_user_assignment_action_id in number,
183 p_owner_effective_date in date,
184 p_user_effective_date in date,
185 p_dimension_name in varchar2,
186 p_expiry_information out nocopy date);
187 --
188 procedure augtd_sd(
189 p_effective_date in date,
190 p_start_date out nocopy date,
191 p_payroll_id in number,
192 p_bus_grp in number,
193 p_asg_action in number);
194 --
195 function fy_start_date(p_business_group_id in number) return date;
196 --
197 procedure fqtd_ec(
198 p_owner_payroll_action_id in number,
199 p_user_payroll_action_id in number,
200 p_owner_assignment_action_id in number,
201 p_user_assignment_action_id in number,
202 p_owner_effective_date in date,
203 p_user_effective_date in date,
204 p_dimension_name in varchar2,
205 p_expiry_information out nocopy number);
206 --
207 procedure fqtd_ec(
208 p_owner_payroll_action_id in number,
209 p_user_payroll_action_id in number,
210 p_owner_assignment_action_id in number,
211 p_user_assignment_action_id in number,
212 p_owner_effective_date in date,
213 p_user_effective_date in date,
214 p_dimension_name in varchar2,
215 p_expiry_information out nocopy date);
216 --
217 procedure fytd_ec(
218 p_owner_payroll_action_id in number,
219 p_user_payroll_action_id in number,
220 p_owner_assignment_action_id in number,
221 p_user_assignment_action_id in number,
222 p_owner_effective_date in date,
223 p_user_effective_date in date,
224 p_dimension_name in varchar2,
225 p_expiry_information out nocopy number);
226 --
227 procedure fytd_ec(
228 p_owner_payroll_action_id in number,
229 p_user_payroll_action_id in number,
230 p_owner_assignment_action_id in number,
231 p_user_assignment_action_id in number,
232 p_owner_effective_date in date,
233 p_user_effective_date in date,
234 p_dimension_name in varchar2,
235 p_expiry_information out nocopy date);
236 --
237 /*
238 procedure show_dim_periods(
239 p_business_group_id in number,
240 p_dimension_name in varchar2,
241 p_start_date in date,
242 p_end_date in date);
243 */
244 --
245 end pyjpexc;