1 PACKAGE AP_WEB_DFLEX_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwdflxs.pls 120.21.12020000.4 2012/11/15 09:19:48 preshukl 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(240),
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 location_id ap_expense_report_lines_all.location_id%type -- Bug: 14769423, location id in custom hoooks
138 );
139
140 TYPE ExpReportLines_A IS TABLE OF ExpReportLineRec
141 INDEX BY BINARY_INTEGER;
142
143 TYPE CustomFieldRec IS RECORD (
144 -- chiho: 1170729: modify the data type:
145 prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE,
146 user_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE,
147 value fnd_descr_flex_col_usage_vl.default_value%TYPE,
148
149 column_mapping VARCHAR2(30),
150 displayed_flag VARCHAR2(1),
151 required_flag VARCHAR2(1),
152 display_size NUMBER,
153 value_set VARCHAR2(30));
154
155 TYPE CustomFields_A IS TABLE OF CustomFieldRec
156 INDEX BY BINARY_INTEGER;
157
158 TYPE PoplistValue IS RECORD (InternalValue VARCHAR2(240),
159 DisplayText VARCHAR2(240));
160 TYPE PoplistValues_A IS TABLE OF PoplistValue INDEX BY BINARY_INTEGER;
161
162 TYPE Binary_Integer_A IS TABLE OF BINARY_INTEGER
163 INDEX BY BINARY_INTEGER;
164
165 PROCEDURE GetExpenseLineDflexInfo(p_user_id IN NUMBER, -- 2242176
166 p_flexfield IN OUT NOCOPY FND_DFLEX.DFLEX_R,
167 p_flexinfo IN OUT NOCOPY FND_DFLEX.DFLEX_DR,
168 p_contexts IN OUT NOCOPY FND_DFLEX.CONTEXTS_DR,
169 p_is_custom_fields_feat_used IN OUT NOCOPY BOOLEAN);
170
171
172 PROCEDURE GetDFlexContextSegments(p_flexfield IN FND_DFLEX.DFLEX_R,
173 p_contexts IN FND_DFLEX.CONTEXTS_DR,
174 p_context_index IN BINARY_INTEGER,
175 p_segments IN OUT NOCOPY FND_DFLEX.SEGMENTS_DR);
176
177
178 PROCEDURE GetDFlexContextIndex(p_context_value IN VARCHAR2,
179 p_dflex_contexts IN FND_DFLEX.CONTEXTS_DR,
180 p_index IN OUT NOCOPY BINARY_INTEGER);
181
182
183 PROCEDURE GetIndexRefOrderedArray(p_sequence_array IN FND_DFLEX.SEQUENCE_A,
184 p_nelements IN NUMBER,
185 p_index_ref_ordered_array OUT NOCOPY BINARY_INTEGER_A);
186
187 FUNCTION GetNumOfEnabledSegments(P_Segments IN FND_DFLEX.SEGMENTS_DR) RETURN NUMBER;
188
189 FUNCTION GetCustomFieldValue(p_prompt IN VARCHAR2,
190 p_custom_fields_array IN CustomFields_A) RETURN VARCHAR2;
191
192 PROCEDURE GetReceiptCustomFields(
193 p_receipt_custom_fields_array IN OUT NOCOPY CustomFields_A,
194 p_receipt_index IN BINARY_INTEGER,
195 p_custom1_array IN CustomFields_A,
196 p_custom2_array IN CustomFields_A,
197 p_custom3_array IN CustomFields_A,
198 p_custom4_array IN CustomFields_A,
199 p_custom5_array IN CustomFields_A,
200 p_custom6_array IN CustomFields_A,
201 p_custom7_array IN CustomFields_A,
202 p_custom8_array IN CustomFields_A,
203 p_custom9_array IN CustomFields_A,
204 p_custom10_array IN CustomFields_A,
205 p_custom11_array IN CustomFields_A,
206 p_custom12_array IN CustomFields_A,
207 p_custom13_array IN CustomFields_A,
208 p_custom14_array IN CustomFields_A,
209 p_custom15_array IN CustomFields_A);
210
211 PROCEDURE PropogateReceiptCustFldsInfo(
212 p_receipt_custom_fields_array IN CustomFields_A,
213 p_receipt_index IN BINARY_INTEGER,
214 p_custom1_array IN OUT NOCOPY CustomFields_A,
215 p_custom2_array IN OUT NOCOPY CustomFields_A,
216 p_custom3_array IN OUT NOCOPY CustomFields_A,
217 p_custom4_array IN OUT NOCOPY CustomFields_A,
218 p_custom5_array IN OUT NOCOPY CustomFields_A,
219 p_custom6_array IN OUT NOCOPY CustomFields_A,
220 p_custom7_array IN OUT NOCOPY CustomFields_A,
221 p_custom8_array IN OUT NOCOPY CustomFields_A,
222 p_custom9_array IN OUT NOCOPY CustomFields_A,
223 p_custom10_array IN OUT NOCOPY CustomFields_A,
224 p_custom11_array IN OUT NOCOPY CustomFields_A,
225 p_custom12_array IN OUT NOCOPY CustomFields_A,
226 p_custom13_array IN OUT NOCOPY CustomFields_A,
227 p_custom14_array IN OUT NOCOPY CustomFields_A,
228 p_custom15_array IN OUT NOCOPY CustomFields_A);
229
230 PROCEDURE AssocCustFieldPromptsToValues(
231 p_dflex_segs IN FND_DFLEX.SEGMENTS_DR,
232 p_starting_index IN BINARY_INTEGER,
233 p_ending_index IN BINARY_INTEGER,
234 p_custom_fields_array IN OUT NOCOPY CustomFields_A);
235
236
237 PROCEDURE ProcessDFlexError(
238 p_custom_fields_array IN CustomFields_A,
239 p_num_of_global_fields IN BINARY_INTEGER,
240 p_num_of_context_fields IN BINARY_INTEGER,
241 p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
242 p_receipt_index IN BINARY_INTEGER DEFAULT NULL );
243
244
245 PROCEDURE CoreValidateDFlexValues(
246 p_dflex_name IN VARCHAR2,
247 p_dflex_contexts IN FND_DFLEX.CONTEXTS_DR,
248 p_context_index IN BINARY_INTEGER,
249 p_custom_fields_array IN CustomFields_A,
250 p_num_of_global_fields IN BINARY_INTEGER,
251 p_num_of_context_fields IN BINARY_INTEGER,
252 p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
253 p_receipt_index IN BINARY_INTEGER,
254 p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError);
255
256 PROCEDURE ValidateDFlexValues(
257 p_exp_header_info IN ExpReportHeaderRec,
258 p_exp_line_info IN ExpReportLineRec,
259 p_custom_fields_array IN CustomFields_A,
260 p_num_of_global_fields IN BINARY_INTEGER,
261 p_num_of_context_fields IN BINARY_INTEGER,
262 p_dflex_name IN VARCHAR2,
263 p_dflex_contexts IN FND_DFLEX.CONTEXTS_DR,
264 p_context_index IN BINARY_INTEGER,
265 p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
266 p_receipt_index IN BINARY_INTEGER,
267 p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError);
268
269 PROCEDURE PopulateExpTypeInLineRec(
270 p_exp_line_info IN OUT NOCOPY ExpReportLineRec);
271
272 PROCEDURE ValidateReceiptCustomFields(
273 p_userId IN NUMBER,
274 p_exp_header_info IN ExpReportHeaderRec,
275 p_exp_line_info IN OUT NOCOPY ExpReportLineRec,
276 p_custom_fields_array IN OUT NOCOPY CustomFields_A,
277 p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
278 p_receipt_index IN BINARY_INTEGER,
279 p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError );
280
281
282
283 FUNCTION IsFlexFieldUsed(
284 P_CustomField IN CustomFieldRec)
285 RETURN BOOLEAN;
286 PROCEDURE IsSessionTaxEnabled(P_Result OUT NOCOPY VARCHAR2,
287 p_user_id IN NUMBER DEFAULT NULL); -- 2242176
288 FUNCTION GetMaxNumSegmentsUsed (p_user_id IN NUMBER DEFAULT NULL)
289 RETURN NUMBER;
290 FUNCTION GetMaxNumPseudoSegmentsUsed(
291 P_IsSessionProjectEnabled IN VARCHAR2) -- 2242176
292 RETURN NUMBER;
293 PROCEDURE ClearCustomFieldRec(
294 P_CustomField OUT NOCOPY CustomFieldRec);
295 FUNCTION IsCustomFieldPopulated(P_ReceiptIndex IN NUMBER,
296 Custom1_Array IN CustomFields_A,
297 Custom2_Array IN CustomFields_A,
298 Custom3_Array IN CustomFields_A,
299 Custom4_Array IN CustomFields_A,
300 Custom5_Array IN CustomFields_A,
301 Custom6_Array IN CustomFields_A,
302 Custom7_Array IN CustomFields_A,
303 Custom8_Array IN CustomFields_A,
304 Custom9_Array IN CustomFields_A,
305 Custom10_Array IN CustomFields_A,
306 Custom11_Array IN CustomFields_A,
307 Custom12_Array IN CustomFields_A,
308 Custom13_Array IN CustomFields_A,
309 Custom14_Array IN CustomFields_A,
310 Custom15_Array IN CustomFields_A)
311 RETURN BOOLEAN;
312
313 PROCEDURE PopulateCustomDefaultValues(
314 p_user_id IN NUMBER, -- 2242176
315 P_ExpReportHeaderInfo IN ExpReportHeaderRec,
316 ExpReportLinesInfo IN OUT NOCOPY ExpReportLines_A,
317 P_ReceiptCount IN NUMBER,
318 Custom1_Array IN OUT NOCOPY CustomFields_A,
319 Custom2_Array IN OUT NOCOPY CustomFields_A,
320 Custom3_Array IN OUT NOCOPY CustomFields_A,
321 Custom4_Array IN OUT NOCOPY CustomFields_A,
322 Custom5_Array IN OUT NOCOPY CustomFields_A,
323 Custom6_Array IN OUT NOCOPY CustomFields_A,
324 Custom7_Array IN OUT NOCOPY CustomFields_A,
325 Custom8_Array IN OUT NOCOPY CustomFields_A,
326 Custom9_Array IN OUT NOCOPY CustomFields_A,
327 Custom10_Array IN OUT NOCOPY CustomFields_A,
328 Custom11_Array IN OUT NOCOPY CustomFields_A,
329 Custom12_Array IN OUT NOCOPY CustomFields_A,
330 Custom13_Array IN OUT NOCOPY CustomFields_A,
331 Custom14_Array IN OUT NOCOPY CustomFields_A,
332 Custom15_Array IN OUT NOCOPY CustomFields_A,
333 P_NumMaxFlexField IN NUMBER,
334 P_DataDefaultedUpdateable IN OUT NOCOPY BOOLEAN);
335
336 PROCEDURE PopulatePseudoDefaultValues(
337 P_ExpReportHeaderInfo IN ExpReportHeaderRec,
338 ExpReportLinesInfo IN OUT NOCOPY ExpReportLines_A,
339 P_ReceiptCount IN NUMBER,
340 P_DataDefaultedUpdateable IN OUT NOCOPY BOOLEAN);
341
342 PROCEDURE SetExpReportLineInfo(P_ExpReportLineInfo OUT NOCOPY ExpReportLineRec,
343 P_receipt_index IN NUMBER,
344 P_start_date IN DATE,
345 P_end_date IN DATE,
346 P_days IN VARCHAR2,
347 P_daily_amount IN VARCHAR2,
348 P_receipt_amount IN VARCHAR2,
349 P_rate IN VARCHAR2,
350 P_amount IN VARCHAR2,
351 P_parameter_id IN VARCHAR2,
352 P_expense_type IN VARCHAR2,
353 P_currency_code IN VARCHAR2,
354 P_group_value IN VARCHAR2,
355 P_justification IN VARCHAR2,
356 P_receipt_missing_flag IN VARCHAR2,
357 P_validation_required IN VARCHAR2,
358 P_calculate_flag IN VARCHAR2,
359 P_calculated_amount IN VARCHAR2,
360 P_copy_calc_amt_into_receipt IN VARCHAR2,
361 P_AmtInclTax IN VARCHAR2,
362 P_TaxCode IN VARCHAR2,
363 P_TaxOverrideFlag IN VARCHAR2,
364 P_TaxId IN VARCHAR2,
365 P_ProjectID IN VARCHAR2,
366 P_ProjectNumber IN VARCHAR2,
367 P_TaskID IN VARCHAR2,
368 P_TaskNumber IN VARCHAR2,
369 P_ExpenditureType IN VARCHAR2
370 );
371
372 PROCEDURE SetExpReportHeaderInfo(P_ExpReportHeaderInfo OUT NOCOPY ExpReportHeaderRec,
373 P_employee_id IN VARCHAR2,
374 P_cost_center IN VARCHAR2,
375 P_expense_report_id IN VARCHAR2,
376 P_template_name IN VARCHAR2,
377 P_purpose IN VARCHAR2,
378 P_last_receipt_date IN VARCHAR2,
379 P_receipt_count IN VARCHAR2,
380 P_transaction_currency_type IN VARCHAR2,
381 P_reimbursement_currency_code IN VARCHAR2,
382 P_reimbursement_currency_name IN VARCHAR2,
383 P_multi_currency_flag IN VARCHAR2,
384 P_inverse_rate_flag IN VARCHAR2,
385 P_approver_id IN VARCHAR2,
386 P_approver_name IN VARCHAR2,
387 P_expenditure_organization_id IN VARCHAR2 DEFAULT NULL);
388
389 PROCEDURE PopulateCustomFieldsInfo(
390 p_userId IN NUMBER,
391 p_exp_line_info IN OUT NOCOPY ExpReportLineRec,
392 p_custom_fields_array IN OUT NOCOPY CustomFields_A,
393 p_num_global_enabled_segs IN OUT NOCOPY NUMBER,
394 p_num_context_enabled_segs IN OUT NOCOPY NUMBER,
395 p_dflexfield IN OUT NOCOPY FND_DFLEX.DFLEX_R,
396 p_dflexinfo IN OUT NOCOPY FND_DFLEX.DFLEX_DR,
397 p_dflexfield_contexts IN OUT NOCOPY FND_DFLEX.CONTEXTS_DR,
398 p_context_index IN OUT NOCOPY NUMBER);
399 PROCEDURE PopulateCustomFieldsInfoAll(
400 p_report_lines_info IN OUT NOCOPY ExpReportLines_A,
401 p_custom1_array IN OUT NOCOPY CustomFields_A,
402 p_custom2_array IN OUT NOCOPY CustomFields_A,
403 p_custom3_array IN OUT NOCOPY CustomFields_A,
404 p_custom4_array IN OUT NOCOPY CustomFields_A,
405 p_custom5_array IN OUT NOCOPY CustomFields_A,
406 p_custom6_array IN OUT NOCOPY CustomFields_A,
407 p_custom7_array IN OUT NOCOPY CustomFields_A,
408 p_custom8_array IN OUT NOCOPY CustomFields_A,
409 p_custom9_array IN OUT NOCOPY CustomFields_A,
410 p_custom10_array IN OUT NOCOPY CustomFields_A,
411 p_custom11_array IN OUT NOCOPY CustomFields_A,
412 p_custom12_array IN OUT NOCOPY CustomFields_A,
413 p_custom13_array IN OUT NOCOPY CustomFields_A,
414 p_custom14_array IN OUT NOCOPY CustomFields_A,
415 p_custom15_array IN OUT NOCOPY CustomFields_A,
416 p_receipts_count IN BINARY_INTEGER);
417
418 FUNCTION GetSegmentDefault(P_ContextValue IN VARCHAR2,
419 P_Segments IN FND_DFLEX.SEGMENTS_DR,
420 P_SegIndex IN NUMBER) RETURN VARCHAR2;
421
422
423 FUNCTION IsSegmentWebEnabled(P_Segments IN FND_DFLEX.SEGMENTS_DR,
424 P_Index IN NUMBER) RETURN BOOLEAN;
425
426
427 function LOVButton (c_attribute_app_id in number,
428 c_attribute_code in varchar2,
429 c_region_app_id in number,
430 c_region_code in varchar2,
431 c_form_name in varchar2,
432 c_frame_name in varchar2 default null,
433 c_where_clause in varchar2 default null,
434 c_js_where_clause in varchar2 default null,
435 c_image_align in varchar2 default 'CENTER')
436 return varchar2;
437
438 PROCEDURE GetTaxPseudoSegmentDefaults(
439 P_ExpTypeID IN AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE,
440 P_ExpTypeTaxCodeUpdateable IN OUT NOCOPY VARCHAR2,
441 P_ExpTypeDefaultTaxCode IN OUT NOCOPY ZX_WEBEXP_CLASSIFICATIONS_V.LOOKUP_CODE%TYPE,--bug#14798565
442 P_OrgId IN NUMBER);
443
444
445 END AP_WEB_DFLEX_PKG;