1 PACKAGE pa_online_exp AS
2 /* $Header: PAXONTES.pls 120.1 2005/08/09 04:31:38 avajain noship $ */
3
4 PROCEDURE BUILD_DENORM_TABLE(X_exp_id IN NUMBER,
5 X_exp_class_code IN VARCHAR2,
6 X_exp_status_code IN VARCHAR2,
7 X_exp_source_code IN VARCHAR2,
8 X_person_id IN NUMBER);
9
10 PROCEDURE SET_DAY;
11
12 FUNCTION GET_DAY(X_matrix_column IN NUMBER) return varchar2 ;
13 PRAGMA RESTRICT_REFERENCES ( get_day, WNDS, WNPS );
14
15 PROCEDURE GET_NUM_DAYOFWEEK (X_name_dayof_week IN VARCHAR2,
16 X_num_dayof_week OUT NOCOPY VARCHAR2);
17
18 PROCEDURE FIND_DELETE_EXP_ITEMS(x_denorm_id IN NUMBER, X_COLUMN IN NUMBER,X_status OUT NOCOPY NUMBER);
19
20 FUNCTION GET_LAST_RTE_COMMENT(X_exp_id IN NUMBER) RETURN VARCHAR2 ;
21 PRAGMA RESTRICT_REFERENCES ( GET_LAST_RTE_COMMENT, WNDS, WNPS ) ;
22
23 FUNCTION GET_EXP_TOTAL_HOURS( X_exp_id IN NUMBER,
24 X_exp_class_code IN VARCHAR2) RETURN NUMBER ;
25 PRAGMA RESTRICT_REFERENCES ( GET_EXP_TOTAL_HOURS, WNDS, WNPS ) ;
26
27 FUNCTION GET_EI_TOTAL_HOURS( X_exp_id IN NUMBER,
28 X_exp_class_code IN VARCHAR2) RETURN NUMBER ;
29 PRAGMA RESTRICT_REFERENCES ( GET_EI_TOTAL_HOURS, WNDS, WNPS ) ;
30
31 FUNCTION GET_DENORM_TOTAL_HOURS (x_exp_id IN NUMBER,
32 x_exp_class_code IN VARCHAR2) RETURN NUMBER ;
33 PRAGMA RESTRICT_REFERENCES ( GET_DENORM_TOTAL_HOURS, WNDS, WNPS ) ;
34
35 FUNCTION GET_EXP_TOTAL_COST( X_exp_id IN NUMBER,
36 X_exp_class_code IN VARCHAR2) RETURN NUMBER ;
37 PRAGMA RESTRICT_REFERENCES ( GET_EXP_TOTAL_COST, WNDS, WNPS ) ;
38
39 FUNCTION GET_EI_TOTAL_COST( X_exp_id IN NUMBER,
40 X_exp_class_code IN VARCHAR2) RETURN NUMBER ;
41 PRAGMA RESTRICT_REFERENCES ( GET_EI_TOTAL_COST, WNDS, WNPS ) ;
42
43 FUNCTION GET_DENORM_TOTAL_COST ( X_exp_id IN NUMBER,
44 X_exp_class_code IN VARCHAR2) RETURN NUMBER ;
45 PRAGMA RESTRICT_REFERENCES ( GET_DENORM_TOTAL_COST, WNDS, WNPS ) ;
46
47 FUNCTION GET_EXP_TRANS( X_exp_class_code IN VARCHAR2) RETURN VARCHAR2 ;
48 -- pa_lookups purity level has been changed to WNDS only, so modifying
49 -- functions that use pa_lookups to purity level WNDS, however in 8i
50 -- there is no need to explicitly define purity level, so removing the
51 -- purity level all togeather.
52 --PRAGMA RESTRICT_REFERENCES ( GET_EXP_TRANS, WNDS, WNPS ) ;
53
54 FUNCTION GET_EXP_SRC(X_exp_class_code IN VARCHAR2,
55 X_exp_group IN VARCHAR2,
56 X_pte_ref IN NUMBER) RETURN VARCHAR2 ;
57 -- pa_lookups purity level has been changed to WNDS only, so modifying
58 -- functions that use pa_lookups to purity level WNDS, however in 8i
59 -- there is no need to explicitly define purity level, so removing the
60 -- purity level all togeather.
61 --PRAGMA RESTRICT_REFERENCES ( GET_EXP_SRC, WNDS, WNPS ) ;
62
63 FUNCTION GET_EXP_SRC_CODE(X_exp_class_code IN VARCHAR2,
64 X_exp_group IN VARCHAR2,
65 X_pte_ref IN NUMBER) RETURN VARCHAR2 ;
66
67 -- pa_lookups purity level has been changed to WNDS only, so modifying
68 -- functions that use pa_lookups to purity level WNDS, however in 8i
69 -- there is no need to explicitly define purity level, so removing the
70 -- purity level all togeather.
71 --PRAGMA RESTRICT_REFERENCES ( GET_EXP_SRC_CODE, WNDS, WNPS ) ;
72
73 PROCEDURE STORE_REVERSE_ITEMS (X_exp_item_id IN NUMBER);
74
75 PROCEDURE PROCESS_REVERSE_ITEMS (X_Exp_id IN NUMBER,
76 X_entered_by_person_id IN NUMBER,
77 X_user_id IN NUMBER,
78 X_new_exp_id in NUMBER,
79 X_status OUT NOCOPY VARCHAR2);
80
81 FUNCTION GET_OLD_EI_COMMENT(x_exp_item_id IN NUMBER) RETURN VARCHAR2;
82 PRAGMA RESTRICT_REFERENCES ( GET_OLD_EI_COMMENT, WNDS, WNPS ) ;
83
84 FUNCTION GET_EXPREP_PAID_AMT (X_exp_id IN NUMBER) RETURN NUMBER;
85 PRAGMA RESTRICT_REFERENCES ( GET_EXPREP_PAID_AMT, WNDS, WNPS ) ;
86
87 PROCEDURE SET_ADMIN_PERSON_ID (X_person_id IN NUMBER);
88
89 FUNCTION GetAdminPersonId RETURN NUMBER;
90 PRAGMA RESTRICT_REFERENCES ( GetAdminPersonId, WNDS, WNPS ) ;
91
92 FUNCTION Get_wte_reference (X_exp_group IN VARCHAR2,
93 X_exp_class_code IN VARCHAR2 )RETURN VARCHAR2;
94 PRAGMA RESTRICT_REFERENCES (Get_Wte_Reference, WNDS, WNPS ) ;
95
96 PROCEDURE INSERT_PA_EI_DENORM_REC (
97 x_exp_id IN NUMBER,
98 x_denorm_id IN NUMBER,
99 x_person_id IN NUMBER,
100 x_project_id IN NUMBER,
101 x_task_id IN NUMBER,
102 x_billable_flag IN VARCHAR2,
103 x_expenditure_type IN VARCHAR2,
104 x_default_sys_link_func IN VARCHAR2,
105 x_unit_of_measure_code IN VARCHAR2,
106 x_unit_of_measure IN VARCHAR2,
107 x_expenditure_item_id_1 IN NUMBER,
108 x_expenditure_item_date_1 IN DATE,
109 x_quantity_1 IN NUMBER,
110 x_system_linkage_function_1 IN VARCHAR2,
111 x_non_labor_resource_1 IN VARCHAR2,
112 x_organization_id_1 IN NUMBER,
113 x_override_to_org_id_1 IN NUMBER,
114 x_raw_cost_1 IN NUMBER,
115 x_raw_cost_rate_1 IN NUMBER,
116 x_attribute_category_1 IN VARCHAR2,
117 x_attribute1_1 IN VARCHAR2,
118 x_attribute1_2 IN VARCHAR2,
119 x_attribute1_3 IN VARCHAR2,
120 x_attribute1_4 IN VARCHAR2,
121 x_attribute1_5 IN VARCHAR2,
122 x_attribute1_6 IN VARCHAR2,
123 x_attribute1_7 IN VARCHAR2,
124 x_attribute1_8 IN VARCHAR2,
125 x_attribute1_9 IN VARCHAR2,
126 x_attribute1_10 IN VARCHAR2,
127 x_orig_transaction_reference_1 IN VARCHAR2,
128 x_adj_expenditure_item_id_1 IN NUMBER,
129 x_net_zero_adjustment_flag_1 IN VARCHAR2,
130 x_expenditure_comment_1 IN VARCHAR2,
131 x_expenditure_item_id_2 IN NUMBER,
132 x_expenditure_item_date_2 IN DATE,
133 x_quantity_2 IN NUMBER,
134 x_system_linkage_function_2 IN VARCHAR2,
135 x_non_labor_resource_2 IN VARCHAR2,
136 x_organization_id_2 IN NUMBER,
137 x_override_to_org_id_2 IN NUMBER,
138 x_raw_cost_2 IN NUMBER,
139 x_raw_cost_rate_2 IN NUMBER,
140 x_attribute_category_2 IN VARCHAR2,
141 x_attribute2_1 IN VARCHAR2,
142 x_attribute2_2 IN VARCHAR2,
143 x_attribute2_3 IN VARCHAR2,
144 x_attribute2_4 IN VARCHAR2,
145 x_attribute2_5 IN VARCHAR2,
146 x_attribute2_6 IN VARCHAR2,
147 x_attribute2_7 IN VARCHAR2,
148 x_attribute2_8 IN VARCHAR2,
149 x_attribute2_9 IN VARCHAR2,
150 x_attribute2_10 IN VARCHAR2,
151 x_orig_transaction_reference_2 IN VARCHAR2,
152 x_adj_expenditure_item_id_2 IN NUMBER,
153 x_net_zero_adjustment_flag_2 IN VARCHAR2,
154 x_expenditure_comment_2 IN VARCHAR2,
155 x_expenditure_item_id_3 IN NUMBER,
156 x_expenditure_item_date_3 IN DATE,
157 x_quantity_3 IN NUMBER,
158 x_system_linkage_function_3 IN VARCHAR2,
159 x_non_labor_resource_3 IN VARCHAR2,
160 x_organization_id_3 IN NUMBER,
161 x_override_to_org_id_3 IN NUMBER,
162 x_raw_cost_3 IN NUMBER,
163 x_raw_cost_rate_3 IN NUMBER,
164 x_attribute_category_3 IN VARCHAR2,
165 x_attribute3_1 IN VARCHAR2,
166 x_attribute3_2 IN VARCHAR2,
167 x_attribute3_3 IN VARCHAR2,
168 x_attribute3_4 IN VARCHAR2,
169 x_attribute3_5 IN VARCHAR2,
170 x_attribute3_6 IN VARCHAR2,
171 x_attribute3_7 IN VARCHAR2,
172 x_attribute3_8 IN VARCHAR2,
173 x_attribute3_9 IN VARCHAR2,
174 x_attribute3_10 IN VARCHAR2,
175 x_orig_transaction_reference_3 IN VARCHAR2,
176 x_adj_expenditure_item_id_3 IN NUMBER,
177 x_net_zero_adjustment_flag_3 IN VARCHAR2,
178 x_expenditure_comment_3 IN VARCHAR2,
179 x_expenditure_item_id_4 IN NUMBER,
180 x_expenditure_item_date_4 IN DATE,
181 x_quantity_4 IN NUMBER,
182 x_system_linkage_function_4 IN VARCHAR2,
183 x_non_labor_resource_4 IN VARCHAR2,
184 x_organization_id_4 IN NUMBER,
185 x_override_to_org_id_4 IN NUMBER,
186 x_raw_cost_4 IN NUMBER,
187 x_raw_cost_rate_4 IN NUMBER,
188 x_attribute_category_4 IN VARCHAR2,
189 x_attribute4_1 IN VARCHAR2,
190 x_attribute4_2 IN VARCHAR2,
191 x_attribute4_3 IN VARCHAR2,
192 x_attribute4_4 IN VARCHAR2,
193 x_attribute4_5 IN VARCHAR2,
194 x_attribute4_6 IN VARCHAR2,
195 x_attribute4_7 IN VARCHAR2,
196 x_attribute4_8 IN VARCHAR2,
197 x_attribute4_9 IN VARCHAR2,
198 x_attribute4_10 IN VARCHAR2,
199 x_orig_transaction_reference_4 IN VARCHAR2,
200 x_adj_expenditure_item_id_4 IN NUMBER,
201 x_net_zero_adjustment_flag_4 IN VARCHAR2,
202 x_expenditure_comment_4 IN VARCHAR2,
203 x_expenditure_item_id_5 IN NUMBER,
204 x_expenditure_item_date_5 IN DATE,
205 x_quantity_5 IN NUMBER,
206 x_system_linkage_function_5 IN VARCHAR2,
207 x_non_labor_resource_5 IN VARCHAR2,
208 x_organization_id_5 IN NUMBER,
209 x_override_to_org_id_5 IN NUMBER,
210 x_raw_cost_5 IN NUMBER,
211 x_raw_cost_rate_5 IN NUMBER,
212 x_attribute_category_5 IN VARCHAR2,
213 x_attribute5_1 IN VARCHAR2,
214 x_attribute5_2 IN VARCHAR2,
215 x_attribute5_3 IN VARCHAR2,
216 x_attribute5_4 IN VARCHAR2,
217 x_attribute5_5 IN VARCHAR2,
218 x_attribute5_6 IN VARCHAR2,
219 x_attribute5_7 IN VARCHAR2,
220 x_attribute5_8 IN VARCHAR2,
221 x_attribute5_9 IN VARCHAR2,
222 x_attribute5_10 IN VARCHAR2,
223 x_orig_transaction_reference_5 IN VARCHAR2,
224 x_adj_expenditure_item_id_5 IN NUMBER,
225 x_net_zero_adjustment_flag_5 IN VARCHAR2,
226 x_expenditure_comment_5 IN VARCHAR2,
227 x_expenditure_item_id_6 IN NUMBER,
228 x_expenditure_item_date_6 IN DATE,
229 x_quantity_6 IN NUMBER,
230 x_system_linkage_function_6 IN VARCHAR2,
231 x_non_labor_resource_6 IN VARCHAR2,
232 x_organization_id_6 IN NUMBER,
233 x_override_to_org_id_6 IN NUMBER,
234 x_raw_cost_6 IN NUMBER,
235 x_raw_cost_rate_6 IN NUMBER,
236 x_attribute_category_6 IN VARCHAR2,
237 x_attribute6_1 IN VARCHAR2,
238 x_attribute6_2 IN VARCHAR2,
239 x_attribute6_3 IN VARCHAR2,
240 x_attribute6_4 IN VARCHAR2,
241 x_attribute6_5 IN VARCHAR2,
242 x_attribute6_6 IN VARCHAR2,
243 x_attribute6_7 IN VARCHAR2,
244 x_attribute6_8 IN VARCHAR2,
245 x_attribute6_9 IN VARCHAR2,
246 x_attribute6_10 IN VARCHAR2,
247 x_orig_transaction_reference_6 IN VARCHAR2,
248 x_adj_expenditure_item_id_6 IN NUMBER,
249 x_net_zero_adjustment_flag_6 IN VARCHAR2,
250 x_expenditure_comment_6 IN VARCHAR2,
251 x_expenditure_item_id_7 IN NUMBER,
252 x_expenditure_item_date_7 IN DATE,
253 x_quantity_7 IN NUMBER,
254 x_system_linkage_function_7 IN VARCHAR2,
255 x_non_labor_resource_7 IN VARCHAR2,
256 x_organization_id_7 IN NUMBER,
257 x_override_to_org_id_7 IN NUMBER,
258 x_raw_cost_7 IN NUMBER,
259 x_raw_cost_rate_7 IN NUMBER,
260 x_attribute_category_7 IN VARCHAR2,
261 x_attribute7_1 IN VARCHAR2,
262 x_attribute7_2 IN VARCHAR2,
263 x_attribute7_3 IN VARCHAR2,
264 x_attribute7_4 IN VARCHAR2,
265 x_attribute7_5 IN VARCHAR2,
266 x_attribute7_6 IN VARCHAR2,
267 x_attribute7_7 IN VARCHAR2,
268 x_attribute7_8 IN VARCHAR2,
269 x_attribute7_9 IN VARCHAR2,
270 x_attribute7_10 IN VARCHAR2,
271 x_orig_transaction_reference_7 IN VARCHAR2,
272 x_adj_expenditure_item_id_7 IN NUMBER,
273 x_net_zero_adjustment_flag_7 IN VARCHAR2,
274 x_expenditure_comment_7 IN VARCHAR2,
275 x_total_qty IN NUMBER,
276 x_total_amount IN NUMBER,
277 x_created_by IN NUMBER,
278 x_creation_date IN DATE,
279 x_last_update_date IN DATE,
280 x_last_updated_by IN NUMBER,
281 x_last_update_login IN NUMBER,
282 x_job_id_1 IN NUMBER,
283 x_job_id_2 IN NUMBER,
284 x_job_id_3 IN NUMBER,
285 x_job_id_4 IN NUMBER,
286 x_job_id_5 IN NUMBER,
287 x_job_id_6 IN NUMBER,
288 x_job_id_7 IN NUMBER);
289
290 END pa_online_exp;