1 PACKAGE AP_WEB_DFLEX_PKG AS
2 /* $Header: apwdflxs.pls 120.18.12010000.3 2009/01/23 07:18:47 stalasil ship $ */
3
4 SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;
5 SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;
6 SUBTYPE expHdr_headerID IS AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE;
7
8 -- Constants
9 C_CustValidResMsgTypeNone CONSTANT VARCHAR(20) := NULL;
10 C_CustValidResMsgTypeError CONSTANT VARCHAR(20) := 'ERROR';
11 C_CustValidResMsgTypeWarning CONSTANT VARCHAR(20) := 'WARNING';
12 C_AbsoluteMaxFlexField CONSTANT NUMBER := 15;
13
14 -- Descriptive flexfield data types
15 TYPE ExpReportHeaderRec IS RECORD (
16 report_header_id expHdr_headerID,
17 employee_id VARCHAR2(25),
18 cost_center VARCHAR2(30),
19 template_id VARCHAR2(25),
20 template_name VARCHAR2(100),
21 purpose VARCHAR2(240),
22 summary_start_date VARCHAR2(25),
23 summary_end_date VARCHAR2(25),
24 summary_xtype VARCHAR2(25),
25 receipt_index NUMBER,
26 last_receipt_date VARCHAR2(25),
27 last_update_date VARCHAR2(25),
28 receipt_count VARCHAR2(25),
29 transaction_currency_type VARCHAR2(25),
30 reimbursement_currency_code expLines_currCode,
31 reimbursement_currency_name VARCHAR2(80),
32 multi_currency_flag VARCHAR2(1),
33 inverse_rate_flag VARCHAR2(1),
34 override_approver_id VARCHAR2(25),
35 override_approver_name VARCHAR2(240),
36 expenditure_organization_id expLines_expOrgID,
37 number_max_flexfield NUMBER,
38 amt_due_employee NUMBER,
39 amt_due_ccCompany NUMBER, -- project accounting
40 default_currency_code VARCHAR2(15),
41 default_exchange_rate_type VARCHAR2(30),
42 attribute_category ap_expense_report_headers_all.attribute_category%type,
43 attribute1 ap_expense_report_headers_all.attribute1%type,
44 attribute2 ap_expense_report_headers_all.attribute2%type,
45 attribute3 ap_expense_report_headers_all.attribute3%type,
46 attribute4 ap_expense_report_headers_all.attribute4%type,
47 attribute5 ap_expense_report_headers_all.attribute5%type,
48 attribute6 ap_expense_report_headers_all.attribute6%type,
49 attribute7 ap_expense_report_headers_all.attribute7%type,
50 attribute8 ap_expense_report_headers_all.attribute8%type,
51 attribute9 ap_expense_report_headers_all.attribute9%type,
52 attribute10 ap_expense_report_headers_all.attribute10%type,
53 attribute11 ap_expense_report_headers_all.attribute11%type,
54 attribute12 ap_expense_report_headers_all.attribute12%type,
55 attribute13 ap_expense_report_headers_all.attribute13%type,
56 attribute14 ap_expense_report_headers_all.attribute14%type,
57 attribute15 ap_expense_report_headers_all.attribute15%type
58 );
59
60 TYPE ExpReportLineRec IS RECORD (
61 receipt_index NUMBER, -- index of receipt starting from 1
62 start_date DATE,
63 end_date DATE,
64 days VARCHAR2(25),
65 daily_amount VARCHAR2(50),--Bug 2646884.
66 receipt_amount VARCHAR2(50),
67 rate VARCHAR2(50),--Bug 4956830
68 amount VARCHAR2(50),
69 parameter_id AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE,
70 expense_type VARCHAR2(80),
71 currency_code VARCHAR2(25),
72
73 merchant varchar2(80),
74 merchantDoc varchar2(80),
75 taxReference varchar2(240),
76 taxRegNumber varchar2(80),
77 taxPayerId varchar2(80),
78 supplyCountry varchar2(5),
79 itemizeId number,
80 cCardTrxnId number,
81 category AP_CREDIT_CARD_TRXNS.category%type,
82
83 group_value VARCHAR2(80),
84 justification VARCHAR2(240),
85 receipt_missing_flag VARCHAR2(1),
86 validation_required VARCHAR2(1),
87 calculate_flag VARCHAR2(1),
88 calculated_amount VARCHAR2(50),
89 copy_calc_amt_into_receipt_amt VARCHAR2(1),
90 amount_includes_tax VARCHAR2(1),
91 tax_code AP_EXPENSE_REPORT_PARAMS.vat_code%TYPE,
92 taxOverrideFlag VARCHAR2(1),
93 taxId VARCHAR2(15),
94 project_id VARCHAR2(15),
95 project_number PA_PROJECTS_EXPEND_V.project_number%TYPE,
96 task_id VARCHAR2(15),
97 task_number PA_TASKS_EXPEND_V.task_number%TYPE,
98 expenditure_type VARCHAR2(30),
99 award_number gms_awards_all.award_number%TYPE,
100 award_id gms_awards_all.award_id%TYPE,
101 cost_center VARCHAR2(240),
102 category_code VARCHAR2(20), --Bug 2292854
103 -- Per Diem data
104 nFreeBreakfasts1 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
105 nFreeBreakfasts2 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
106 nFreeBreakfasts3 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
107 nFreeLunches1 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
108 nFreeLunches2 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
109 nFreeLunches3 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
110 nFreeDinners1 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
111 nFreeDinners2 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
112 nFreeDinners3 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
113 nFreeAccommodations1 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
114 nFreeAccommodations2 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
115 nFreeAccommodations3 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
116 location ap_expense_report_lines.LOCATION%type,
117 -- Bug 3600198
118 startTime VARCHAR(5), -- in HH24:MM format
119 endTime VARCHAR(5), -- in HH24:MM format
120 -- Mileage data
121 dailyDistance ap_expense_report_lines.DAILY_DISTANCE%type,
122 tripDistance ap_expense_report_lines.TRIP_DISTANCE%type,
123 mileageRate ap_expense_report_lines.AVG_MILEAGE_RATE%type,
124 vehicleCategory ap_expense_report_lines.VEHICLE_CATEGORY_CODE%type,
125 vehicleType ap_expense_report_lines.VEHICLE_TYPE%type,
126 fuelType ap_expense_report_lines.FUEL_TYPE%type,
127 numberPassengers ap_expense_report_lines.NUMBER_PEOPLE%type,
128 licensePlateNumber ap_expense_report_lines_all.license_plate_number%type,
129 passengerRateUsed ap_expense_report_lines_all.rate_per_passenger%type,
130 destinationFrom ap_expense_report_lines_all.destination_from%type,
131 destinationTo ap_expense_report_lines_all.destination_to%type,
132 distanceUnitCode ap_expense_report_lines_all.distance_unit_code%type,
133 report_line_id ap_expense_report_lines_all.report_line_id%type,
134 itemization_parent_id ap_expense_report_lines_all.itemization_parent_id%type,
135 emp_attendee_count NUMBER, -- Bug 6919132
136 nonemp_attendee_count NUMBER -- Bug 6919132
137 );
138
139 TYPE ExpReportLines_A IS TABLE OF ExpReportLineRec
140 INDEX BY BINARY_INTEGER;
141
142 TYPE CustomFieldRec IS RECORD (
143 -- chiho: 1170729: modify the data type:
144 prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE,
145 user_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE,
146 value fnd_descr_flex_col_usage_vl.default_value%TYPE,
147
148 column_mapping VARCHAR2(30),
149 displayed_flag VARCHAR2(1),
150 required_flag VARCHAR2(1),
151 display_size NUMBER,
152 value_set VARCHAR2(30));
153
154 TYPE CustomFields_A IS TABLE OF CustomFieldRec
155 INDEX BY BINARY_INTEGER;
156
157 TYPE PoplistValue IS RECORD (InternalValue VARCHAR2(240),
158 DisplayText VARCHAR2(240));
159 TYPE PoplistValues_A IS TABLE OF PoplistValue INDEX BY BINARY_INTEGER;
160
161 TYPE Binary_Integer_A IS TABLE OF BINARY_INTEGER
162 INDEX BY BINARY_INTEGER;
163
164 PROCEDURE GetExpenseLineDflexInfo(p_user_id IN NUMBER, -- 2242176
165 p_flexfield IN OUT NOCOPY FND_DFLEX.DFLEX_R,
166 p_flexinfo IN OUT NOCOPY FND_DFLEX.DFLEX_DR,
167 p_contexts IN OUT NOCOPY FND_DFLEX.CONTEXTS_DR,
168 p_is_custom_fields_feat_used IN OUT NOCOPY BOOLEAN);
169
170
171 PROCEDURE GetDFlexContextSegments(p_flexfield IN FND_DFLEX.DFLEX_R,
172 p_contexts IN FND_DFLEX.CONTEXTS_DR,
173 p_context_index IN BINARY_INTEGER,
174 p_segments IN OUT NOCOPY FND_DFLEX.SEGMENTS_DR);
175
176
177 PROCEDURE GetDFlexContextIndex(p_context_value IN VARCHAR2,
178 p_dflex_contexts IN FND_DFLEX.CONTEXTS_DR,
179 p_index IN OUT NOCOPY BINARY_INTEGER);
180
181
182 PROCEDURE GetIndexRefOrderedArray(p_sequence_array IN FND_DFLEX.SEQUENCE_A,
183 p_nelements IN NUMBER,
184 p_index_ref_ordered_array OUT NOCOPY BINARY_INTEGER_A);
185
186 FUNCTION GetNumOfEnabledSegments(P_Segments IN FND_DFLEX.SEGMENTS_DR) RETURN NUMBER;
187
188 FUNCTION GetCustomFieldValue(p_prompt IN VARCHAR2,
189 p_custom_fields_array IN CustomFields_A) RETURN VARCHAR2;
190
191 PROCEDURE GetReceiptCustomFields(
192 p_receipt_custom_fields_array IN OUT NOCOPY CustomFields_A,
193 p_receipt_index IN BINARY_INTEGER,
194 p_custom1_array IN CustomFields_A,
195 p_custom2_array IN CustomFields_A,
196 p_custom3_array IN CustomFields_A,
197 p_custom4_array IN CustomFields_A,
198 p_custom5_array IN CustomFields_A,
199 p_custom6_array IN CustomFields_A,
200 p_custom7_array IN CustomFields_A,
201 p_custom8_array IN CustomFields_A,
202 p_custom9_array IN CustomFields_A,
203 p_custom10_array IN CustomFields_A,
204 p_custom11_array IN CustomFields_A,
205 p_custom12_array IN CustomFields_A,
206 p_custom13_array IN CustomFields_A,
207 p_custom14_array IN CustomFields_A,
208 p_custom15_array IN CustomFields_A);
209
210 PROCEDURE PropogateReceiptCustFldsInfo(
211 p_receipt_custom_fields_array IN CustomFields_A,
212 p_receipt_index IN BINARY_INTEGER,
213 p_custom1_array IN OUT NOCOPY CustomFields_A,
214 p_custom2_array IN OUT NOCOPY CustomFields_A,
215 p_custom3_array IN OUT NOCOPY CustomFields_A,
216 p_custom4_array IN OUT NOCOPY CustomFields_A,
217 p_custom5_array IN OUT NOCOPY CustomFields_A,
218 p_custom6_array IN OUT NOCOPY CustomFields_A,
219 p_custom7_array IN OUT NOCOPY CustomFields_A,
220 p_custom8_array IN OUT NOCOPY CustomFields_A,
221 p_custom9_array IN OUT NOCOPY CustomFields_A,
222 p_custom10_array IN OUT NOCOPY CustomFields_A,
223 p_custom11_array IN OUT NOCOPY CustomFields_A,
224 p_custom12_array IN OUT NOCOPY CustomFields_A,
225 p_custom13_array IN OUT NOCOPY CustomFields_A,
226 p_custom14_array IN OUT NOCOPY CustomFields_A,
227 p_custom15_array IN OUT NOCOPY CustomFields_A);
228
229 PROCEDURE AssocCustFieldPromptsToValues(
230 p_dflex_segs IN FND_DFLEX.SEGMENTS_DR,
231 p_starting_index IN BINARY_INTEGER,
232 p_ending_index IN BINARY_INTEGER,
233 p_custom_fields_array IN OUT NOCOPY CustomFields_A);
234
235
236 PROCEDURE ProcessDFlexError(
237 p_custom_fields_array IN CustomFields_A,
238 p_num_of_global_fields IN BINARY_INTEGER,
239 p_num_of_context_fields IN BINARY_INTEGER,
240 p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
241 p_receipt_index IN BINARY_INTEGER DEFAULT NULL );
242
243
244 PROCEDURE CoreValidateDFlexValues(
245 p_dflex_name IN VARCHAR2,
246 p_dflex_contexts IN FND_DFLEX.CONTEXTS_DR,
247 p_context_index IN BINARY_INTEGER,
248 p_custom_fields_array IN CustomFields_A,
249 p_num_of_global_fields IN BINARY_INTEGER,
250 p_num_of_context_fields IN BINARY_INTEGER,
251 p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
252 p_receipt_index IN BINARY_INTEGER,
253 p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError);
254
255 PROCEDURE ValidateDFlexValues(
256 p_exp_header_info IN ExpReportHeaderRec,
257 p_exp_line_info IN ExpReportLineRec,
258 p_custom_fields_array IN CustomFields_A,
259 p_num_of_global_fields IN BINARY_INTEGER,
260 p_num_of_context_fields IN BINARY_INTEGER,
261 p_dflex_name IN VARCHAR2,
262 p_dflex_contexts IN FND_DFLEX.CONTEXTS_DR,
263 p_context_index IN BINARY_INTEGER,
264 p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
265 p_receipt_index IN BINARY_INTEGER,
266 p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError);
267
268 PROCEDURE PopulateExpTypeInLineRec(
269 p_exp_line_info IN OUT NOCOPY ExpReportLineRec);
270
271 PROCEDURE ValidateReceiptCustomFields(
272 p_userId IN NUMBER,
273 p_exp_header_info IN ExpReportHeaderRec,
274 p_exp_line_info IN OUT NOCOPY ExpReportLineRec,
275 p_custom_fields_array IN OUT NOCOPY CustomFields_A,
276 p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
277 p_receipt_index IN BINARY_INTEGER,
278 p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError );
279
280
281
282 FUNCTION IsFlexFieldUsed(
283 P_CustomField IN CustomFieldRec)
284 RETURN BOOLEAN;
285 PROCEDURE IsSessionTaxEnabled(P_Result OUT NOCOPY VARCHAR2,
286 p_user_id IN NUMBER DEFAULT NULL); -- 2242176
287 FUNCTION GetMaxNumSegmentsUsed (p_user_id IN NUMBER DEFAULT NULL)
288 RETURN NUMBER;
289 FUNCTION GetMaxNumPseudoSegmentsUsed(
290 P_IsSessionProjectEnabled IN VARCHAR2) -- 2242176
291 RETURN NUMBER;
292 PROCEDURE ClearCustomFieldRec(
293 P_CustomField OUT NOCOPY CustomFieldRec);
294 FUNCTION IsCustomFieldPopulated(P_ReceiptIndex IN NUMBER,
295 Custom1_Array IN CustomFields_A,
296 Custom2_Array IN CustomFields_A,
297 Custom3_Array IN CustomFields_A,
298 Custom4_Array IN CustomFields_A,
299 Custom5_Array IN CustomFields_A,
300 Custom6_Array IN CustomFields_A,
301 Custom7_Array IN CustomFields_A,
302 Custom8_Array IN CustomFields_A,
303 Custom9_Array IN CustomFields_A,
304 Custom10_Array IN CustomFields_A,
305 Custom11_Array IN CustomFields_A,
306 Custom12_Array IN CustomFields_A,
307 Custom13_Array IN CustomFields_A,
308 Custom14_Array IN CustomFields_A,
309 Custom15_Array IN CustomFields_A)
310 RETURN BOOLEAN;
311
312 PROCEDURE PopulateCustomDefaultValues(
313 p_user_id IN NUMBER, -- 2242176
314 P_ExpReportHeaderInfo IN ExpReportHeaderRec,
315 ExpReportLinesInfo IN OUT NOCOPY ExpReportLines_A,
316 P_ReceiptCount IN NUMBER,
317 Custom1_Array IN OUT NOCOPY CustomFields_A,
318 Custom2_Array IN OUT NOCOPY CustomFields_A,
319 Custom3_Array IN OUT NOCOPY CustomFields_A,
320 Custom4_Array IN OUT NOCOPY CustomFields_A,
321 Custom5_Array IN OUT NOCOPY CustomFields_A,
322 Custom6_Array IN OUT NOCOPY CustomFields_A,
326 Custom10_Array IN OUT NOCOPY CustomFields_A,
323 Custom7_Array IN OUT NOCOPY CustomFields_A,
324 Custom8_Array IN OUT NOCOPY CustomFields_A,
325 Custom9_Array IN OUT NOCOPY CustomFields_A,
327 Custom11_Array IN OUT NOCOPY CustomFields_A,
328 Custom12_Array IN OUT NOCOPY CustomFields_A,
329 Custom13_Array IN OUT NOCOPY CustomFields_A,
330 Custom14_Array IN OUT NOCOPY CustomFields_A,
331 Custom15_Array IN OUT NOCOPY CustomFields_A,
332 P_NumMaxFlexField IN NUMBER,
333 P_DataDefaultedUpdateable IN OUT NOCOPY BOOLEAN);
334
335 PROCEDURE PopulatePseudoDefaultValues(
336 P_ExpReportHeaderInfo IN ExpReportHeaderRec,
337 ExpReportLinesInfo IN OUT NOCOPY ExpReportLines_A,
338 P_ReceiptCount IN NUMBER,
339 P_DataDefaultedUpdateable IN OUT NOCOPY BOOLEAN);
340
341 PROCEDURE SetExpReportLineInfo(P_ExpReportLineInfo OUT NOCOPY ExpReportLineRec,
342 P_receipt_index IN NUMBER,
343 P_start_date IN DATE,
344 P_end_date IN DATE,
345 P_days IN VARCHAR2,
346 P_daily_amount IN VARCHAR2,
347 P_receipt_amount IN VARCHAR2,
348 P_rate IN VARCHAR2,
349 P_amount IN VARCHAR2,
350 P_parameter_id IN VARCHAR2,
351 P_expense_type IN VARCHAR2,
352 P_currency_code IN VARCHAR2,
353 P_group_value IN VARCHAR2,
354 P_justification IN VARCHAR2,
355 P_receipt_missing_flag IN VARCHAR2,
356 P_validation_required IN VARCHAR2,
357 P_calculate_flag IN VARCHAR2,
358 P_calculated_amount IN VARCHAR2,
359 P_copy_calc_amt_into_receipt IN VARCHAR2,
360 P_AmtInclTax IN VARCHAR2,
361 P_TaxCode IN VARCHAR2,
362 P_TaxOverrideFlag IN VARCHAR2,
363 P_TaxId IN VARCHAR2,
364 P_ProjectID IN VARCHAR2,
365 P_ProjectNumber IN VARCHAR2,
366 P_TaskID IN VARCHAR2,
367 P_TaskNumber IN VARCHAR2,
368 P_ExpenditureType IN VARCHAR2
369 );
370
371 PROCEDURE SetExpReportHeaderInfo(P_ExpReportHeaderInfo OUT NOCOPY ExpReportHeaderRec,
372 P_employee_id IN VARCHAR2,
373 P_cost_center IN VARCHAR2,
374 P_expense_report_id IN VARCHAR2,
375 P_template_name IN VARCHAR2,
376 P_purpose IN VARCHAR2,
377 P_last_receipt_date IN VARCHAR2,
378 P_receipt_count IN VARCHAR2,
379 P_transaction_currency_type IN VARCHAR2,
380 P_reimbursement_currency_code IN VARCHAR2,
381 P_reimbursement_currency_name IN VARCHAR2,
382 P_multi_currency_flag IN VARCHAR2,
383 P_inverse_rate_flag IN VARCHAR2,
384 P_approver_id IN VARCHAR2,
385 P_approver_name IN VARCHAR2,
386 P_expenditure_organization_id IN VARCHAR2 DEFAULT NULL);
387
388 PROCEDURE PopulateCustomFieldsInfo(
389 p_userId IN NUMBER,
390 p_exp_line_info IN OUT NOCOPY ExpReportLineRec,
391 p_custom_fields_array IN OUT NOCOPY CustomFields_A,
392 p_num_global_enabled_segs IN OUT NOCOPY NUMBER,
393 p_num_context_enabled_segs IN OUT NOCOPY NUMBER,
394 p_dflexfield IN OUT NOCOPY FND_DFLEX.DFLEX_R,
395 p_dflexinfo IN OUT NOCOPY FND_DFLEX.DFLEX_DR,
396 p_dflexfield_contexts IN OUT NOCOPY FND_DFLEX.CONTEXTS_DR,
397 p_context_index IN OUT NOCOPY NUMBER);
398 PROCEDURE PopulateCustomFieldsInfoAll(
399 p_report_lines_info IN OUT NOCOPY ExpReportLines_A,
400 p_custom1_array IN OUT NOCOPY CustomFields_A,
401 p_custom2_array IN OUT NOCOPY CustomFields_A,
402 p_custom3_array IN OUT NOCOPY CustomFields_A,
403 p_custom4_array IN OUT NOCOPY CustomFields_A,
404 p_custom5_array IN OUT NOCOPY CustomFields_A,
405 p_custom6_array IN OUT NOCOPY CustomFields_A,
406 p_custom7_array IN OUT NOCOPY CustomFields_A,
407 p_custom8_array IN OUT NOCOPY CustomFields_A,
408 p_custom9_array IN OUT NOCOPY CustomFields_A,
409 p_custom10_array IN OUT NOCOPY CustomFields_A,
410 p_custom11_array IN OUT NOCOPY CustomFields_A,
414 p_custom15_array IN OUT NOCOPY CustomFields_A,
411 p_custom12_array IN OUT NOCOPY CustomFields_A,
412 p_custom13_array IN OUT NOCOPY CustomFields_A,
413 p_custom14_array IN OUT NOCOPY CustomFields_A,
415 p_receipts_count IN BINARY_INTEGER);
416
417 FUNCTION GetSegmentDefault(P_ContextValue IN VARCHAR2,
418 P_Segments IN FND_DFLEX.SEGMENTS_DR,
419 P_SegIndex IN NUMBER) RETURN VARCHAR2;
420
421
422 FUNCTION IsSegmentWebEnabled(P_Segments IN FND_DFLEX.SEGMENTS_DR,
423 P_Index IN NUMBER) RETURN BOOLEAN;
424
425
426 function LOVButton (c_attribute_app_id in number,
427 c_attribute_code in varchar2,
428 c_region_app_id in number,
429 c_region_code in varchar2,
430 c_form_name in varchar2,
431 c_frame_name in varchar2 default null,
432 c_where_clause in varchar2 default null,
433 c_js_where_clause in varchar2 default null,
434 c_image_align in varchar2 default 'CENTER')
435 return varchar2;
436
437 PROCEDURE GetTaxPseudoSegmentDefaults(
438 P_ExpTypeID IN AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE,
439 P_ExpTypeTaxCodeUpdateable IN OUT NOCOPY VARCHAR2,
440 P_ExpTypeDefaultTaxCode IN OUT NOCOPY AP_TAX_CODES.name%TYPE,
441 P_OrgId IN NUMBER);
442
443
444 END AP_WEB_DFLEX_PKG;