82: -- the rest of the string.
83: -----------------------------------
84: PROCEDURE String2PLSQL_Header(V_line in out nocopy long,
85: P_IsSessionProjectEnabled IN VARCHAR2,
86: ExpReportHeaderInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportHeaderRec) IS
87:
88: position number;
89: debug_info varchar2(200);
90: l_org_id AP_WEB_DB_HR_INT_PKG.empCurrent_orgID;
242: PROCEDURE String2PLSQL_Receipts(P_IsSessionTaxEnabled IN VARCHAR2,
243: P_IsSessionProjectEnabled IN VARCHAR2,
244: receipt_error_Array in out nocopy AP_WEB_UTILITIES_PKG.receipt_error_stack,
245: V_Line in out nocopy long,
246: ExpReportHeaderInfo in out nocopy AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
247: ExpReportLinesInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportLines_A,
248: Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
249: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
250: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
243: P_IsSessionProjectEnabled IN VARCHAR2,
244: receipt_error_Array in out nocopy AP_WEB_UTILITIES_PKG.receipt_error_stack,
245: V_Line in out nocopy long,
246: ExpReportHeaderInfo in out nocopy AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
247: ExpReportLinesInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportLines_A,
248: Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
249: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
250: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
251: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
244: receipt_error_Array in out nocopy AP_WEB_UTILITIES_PKG.receipt_error_stack,
245: V_Line in out nocopy long,
246: ExpReportHeaderInfo in out nocopy AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
247: ExpReportLinesInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportLines_A,
248: Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
249: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
250: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
251: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
252: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
245: V_Line in out nocopy long,
246: ExpReportHeaderInfo in out nocopy AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
247: ExpReportLinesInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportLines_A,
248: Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
249: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
250: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
251: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
252: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
253: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
246: ExpReportHeaderInfo in out nocopy AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
247: ExpReportLinesInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportLines_A,
248: Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
249: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
250: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
251: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
252: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
253: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
254: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
247: ExpReportLinesInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportLines_A,
248: Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
249: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
250: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
251: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
252: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
253: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
254: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
255: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
248: Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
249: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
250: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
251: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
252: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
253: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
254: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
255: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
256: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
249: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
250: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
251: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
252: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
253: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
254: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
255: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
256: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
257: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
250: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
251: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
252: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
253: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
254: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
255: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
256: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
257: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
258: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
251: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
252: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
253: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
254: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
255: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
256: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
257: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
258: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
259: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
252: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
253: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
254: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
255: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
256: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
257: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
258: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
259: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
260: Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
253: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
254: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
255: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
256: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
257: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
258: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
259: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
260: Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
261: Custom14_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
254: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
255: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
256: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
257: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
258: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
259: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
260: Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
261: Custom14_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
262: Custom15_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A)
255: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
256: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
257: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
258: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
259: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
260: Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
261: Custom14_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
262: Custom15_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A)
263: IS
256: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
257: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
258: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
259: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
260: Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
261: Custom14_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
262: Custom15_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A)
263: IS
264:
257: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
258: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
259: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
260: Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
261: Custom14_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
262: Custom15_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A)
263: IS
264:
265: debug_info varchar2(255) := '';
258: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
259: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
260: Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
261: Custom14_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
262: Custom15_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A)
263: IS
264:
265: debug_info varchar2(255) := '';
266: current_calling_sequence varchar2(255) :=
299: l_tax_code VARCHAR2(15);
300:
301: BEGIN
302:
303: V_NumMaxPseudoFlexField := AP_WEB_DFLEX_PKG.GetMaxNumPseudoSegmentsUsed(
304: P_IsSessionProjectEnabled);
305:
306:
307: LOOP
313: -- Increment Receipt Counter
314: V_ReceiptCount := V_ReceiptCount + 1;
315:
316: -- Initialize custom fields array
317: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom1_Array(V_ReceiptCount));
318: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom2_Array(V_ReceiptCount));
319: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom3_Array(V_ReceiptCount));
320: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom4_Array(V_ReceiptCount));
321: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom5_Array(V_ReceiptCount));
314: V_ReceiptCount := V_ReceiptCount + 1;
315:
316: -- Initialize custom fields array
317: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom1_Array(V_ReceiptCount));
318: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom2_Array(V_ReceiptCount));
319: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom3_Array(V_ReceiptCount));
320: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom4_Array(V_ReceiptCount));
321: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom5_Array(V_ReceiptCount));
322: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom6_Array(V_ReceiptCount));
315:
316: -- Initialize custom fields array
317: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom1_Array(V_ReceiptCount));
318: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom2_Array(V_ReceiptCount));
319: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom3_Array(V_ReceiptCount));
320: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom4_Array(V_ReceiptCount));
321: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom5_Array(V_ReceiptCount));
322: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom6_Array(V_ReceiptCount));
323: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom7_Array(V_ReceiptCount));
316: -- Initialize custom fields array
317: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom1_Array(V_ReceiptCount));
318: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom2_Array(V_ReceiptCount));
319: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom3_Array(V_ReceiptCount));
320: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom4_Array(V_ReceiptCount));
321: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom5_Array(V_ReceiptCount));
322: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom6_Array(V_ReceiptCount));
323: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom7_Array(V_ReceiptCount));
324: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom8_Array(V_ReceiptCount));
317: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom1_Array(V_ReceiptCount));
318: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom2_Array(V_ReceiptCount));
319: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom3_Array(V_ReceiptCount));
320: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom4_Array(V_ReceiptCount));
321: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom5_Array(V_ReceiptCount));
322: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom6_Array(V_ReceiptCount));
323: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom7_Array(V_ReceiptCount));
324: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom8_Array(V_ReceiptCount));
325: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom9_Array(V_ReceiptCount));
318: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom2_Array(V_ReceiptCount));
319: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom3_Array(V_ReceiptCount));
320: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom4_Array(V_ReceiptCount));
321: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom5_Array(V_ReceiptCount));
322: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom6_Array(V_ReceiptCount));
323: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom7_Array(V_ReceiptCount));
324: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom8_Array(V_ReceiptCount));
325: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom9_Array(V_ReceiptCount));
326: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom10_Array(V_ReceiptCount));
319: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom3_Array(V_ReceiptCount));
320: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom4_Array(V_ReceiptCount));
321: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom5_Array(V_ReceiptCount));
322: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom6_Array(V_ReceiptCount));
323: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom7_Array(V_ReceiptCount));
324: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom8_Array(V_ReceiptCount));
325: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom9_Array(V_ReceiptCount));
326: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom10_Array(V_ReceiptCount));
327: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom11_Array(V_ReceiptCount));
320: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom4_Array(V_ReceiptCount));
321: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom5_Array(V_ReceiptCount));
322: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom6_Array(V_ReceiptCount));
323: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom7_Array(V_ReceiptCount));
324: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom8_Array(V_ReceiptCount));
325: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom9_Array(V_ReceiptCount));
326: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom10_Array(V_ReceiptCount));
327: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom11_Array(V_ReceiptCount));
328: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom12_Array(V_ReceiptCount));
321: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom5_Array(V_ReceiptCount));
322: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom6_Array(V_ReceiptCount));
323: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom7_Array(V_ReceiptCount));
324: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom8_Array(V_ReceiptCount));
325: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom9_Array(V_ReceiptCount));
326: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom10_Array(V_ReceiptCount));
327: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom11_Array(V_ReceiptCount));
328: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom12_Array(V_ReceiptCount));
329: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom13_Array(V_ReceiptCount));
322: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom6_Array(V_ReceiptCount));
323: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom7_Array(V_ReceiptCount));
324: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom8_Array(V_ReceiptCount));
325: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom9_Array(V_ReceiptCount));
326: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom10_Array(V_ReceiptCount));
327: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom11_Array(V_ReceiptCount));
328: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom12_Array(V_ReceiptCount));
329: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom13_Array(V_ReceiptCount));
330: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom14_Array(V_ReceiptCount));
323: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom7_Array(V_ReceiptCount));
324: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom8_Array(V_ReceiptCount));
325: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom9_Array(V_ReceiptCount));
326: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom10_Array(V_ReceiptCount));
327: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom11_Array(V_ReceiptCount));
328: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom12_Array(V_ReceiptCount));
329: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom13_Array(V_ReceiptCount));
330: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom14_Array(V_ReceiptCount));
331: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom15_Array(V_ReceiptCount));
324: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom8_Array(V_ReceiptCount));
325: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom9_Array(V_ReceiptCount));
326: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom10_Array(V_ReceiptCount));
327: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom11_Array(V_ReceiptCount));
328: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom12_Array(V_ReceiptCount));
329: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom13_Array(V_ReceiptCount));
330: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom14_Array(V_ReceiptCount));
331: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom15_Array(V_ReceiptCount));
332:
325: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom9_Array(V_ReceiptCount));
326: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom10_Array(V_ReceiptCount));
327: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom11_Array(V_ReceiptCount));
328: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom12_Array(V_ReceiptCount));
329: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom13_Array(V_ReceiptCount));
330: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom14_Array(V_ReceiptCount));
331: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom15_Array(V_ReceiptCount));
332:
333: debug_info := 'Parsing Receipt '||to_char(V_ReceiptCount);
326: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom10_Array(V_ReceiptCount));
327: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom11_Array(V_ReceiptCount));
328: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom12_Array(V_ReceiptCount));
329: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom13_Array(V_ReceiptCount));
330: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom14_Array(V_ReceiptCount));
331: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom15_Array(V_ReceiptCount));
332:
333: debug_info := 'Parsing Receipt '||to_char(V_ReceiptCount);
334:
327: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom11_Array(V_ReceiptCount));
328: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom12_Array(V_ReceiptCount));
329: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom13_Array(V_ReceiptCount));
330: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom14_Array(V_ReceiptCount));
331: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(Custom15_Array(V_ReceiptCount));
332:
333: debug_info := 'Parsing Receipt '||to_char(V_ReceiptCount);
334:
335: -- Pull Detail-level values
628: PROCEDURE String2PLSQL(P_IsSessionTaxEnabled IN VARCHAR2,
629: P_IsSessionProjectEnabled IN VARCHAR2,
630: receipt_error_Array in out nocopy AP_WEB_UTILITIES_PKG.receipt_error_stack,
631: ParseThis in long,
632: ExpReportHeaderInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
633: ExpReportLinesInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportLines_A,
634: Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
635: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
636: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
629: P_IsSessionProjectEnabled IN VARCHAR2,
630: receipt_error_Array in out nocopy AP_WEB_UTILITIES_PKG.receipt_error_stack,
631: ParseThis in long,
632: ExpReportHeaderInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
633: ExpReportLinesInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportLines_A,
634: Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
635: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
636: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
637: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
630: receipt_error_Array in out nocopy AP_WEB_UTILITIES_PKG.receipt_error_stack,
631: ParseThis in long,
632: ExpReportHeaderInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
633: ExpReportLinesInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportLines_A,
634: Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
635: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
636: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
637: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
638: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
631: ParseThis in long,
632: ExpReportHeaderInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
633: ExpReportLinesInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportLines_A,
634: Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
635: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
636: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
637: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
638: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
639: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
632: ExpReportHeaderInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
633: ExpReportLinesInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportLines_A,
634: Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
635: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
636: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
637: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
638: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
639: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
640: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
633: ExpReportLinesInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportLines_A,
634: Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
635: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
636: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
637: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
638: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
639: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
640: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
641: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
634: Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
635: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
636: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
637: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
638: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
639: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
640: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
641: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
642: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
635: Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
636: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
637: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
638: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
639: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
640: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
641: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
642: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
643: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
636: Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
637: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
638: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
639: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
640: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
641: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
642: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
643: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
644: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
637: Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
638: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
639: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
640: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
641: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
642: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
643: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
644: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
645: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
638: Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
639: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
640: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
641: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
642: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
643: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
644: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
645: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
646: Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
639: Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
640: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
641: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
642: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
643: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
644: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
645: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
646: Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
647: Custom14_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
640: Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
641: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
642: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
643: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
644: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
645: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
646: Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
647: Custom14_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
648: Custom15_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A)
641: Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
642: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
643: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
644: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
645: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
646: Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
647: Custom14_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
648: Custom15_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A)
649: IS
642: Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
643: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
644: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
645: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
646: Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
647: Custom14_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
648: Custom15_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A)
649: IS
650: position number;
643: Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
644: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
645: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
646: Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
647: Custom14_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
648: Custom15_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A)
649: IS
650: position number;
651: V_line long := ParseThis;
644: Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
645: Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
646: Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
647: Custom14_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
648: Custom15_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A)
649: IS
650: position number;
651: V_line long := ParseThis;
652: debug_info varchar2(200);
711:
712:
713: PROCEDURE MapCustomArrayToColumn(
714: P_Index IN NUMBER,
715: ExpReportHeaderInfo IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
716: ExpReportLinesInfo IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
717: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
718: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
719: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
712:
713: PROCEDURE MapCustomArrayToColumn(
714: P_Index IN NUMBER,
715: ExpReportHeaderInfo IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
716: ExpReportLinesInfo IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
717: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
718: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
719: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
720: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
713: PROCEDURE MapCustomArrayToColumn(
714: P_Index IN NUMBER,
715: ExpReportHeaderInfo IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
716: ExpReportLinesInfo IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
717: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
718: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
719: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
720: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
721: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
714: P_Index IN NUMBER,
715: ExpReportHeaderInfo IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
716: ExpReportLinesInfo IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
717: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
718: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
719: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
720: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
721: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
722: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
715: ExpReportHeaderInfo IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
716: ExpReportLinesInfo IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
717: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
718: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
719: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
720: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
721: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
722: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
723: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
716: ExpReportLinesInfo IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
717: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
718: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
719: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
720: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
721: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
722: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
723: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
724: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
717: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
718: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
719: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
720: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
721: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
722: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
723: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
724: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
725: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
718: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
719: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
720: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
721: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
722: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
723: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
724: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
725: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
726: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
719: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
720: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
721: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
722: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
723: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
724: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
725: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
726: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
727: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
720: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
721: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
722: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
723: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
724: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
725: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
726: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
727: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
728: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
721: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
722: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
723: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
724: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
725: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
726: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
727: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
728: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
729: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
722: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
723: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
724: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
725: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
726: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
727: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
728: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
729: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
730: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
723: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
724: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
725: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
726: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
727: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
728: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
729: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
730: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
731: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
724: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
725: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
726: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
727: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
728: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
729: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
730: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
731: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
732: AttributeCol_Array IN OUT NOCOPY BigString_Array)
725: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
726: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
727: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
728: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
729: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
730: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
731: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
732: AttributeCol_Array IN OUT NOCOPY BigString_Array)
733: IS
726: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
727: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
728: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
729: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
730: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
731: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
732: AttributeCol_Array IN OUT NOCOPY BigString_Array)
733: IS
734:
727: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
728: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
729: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
730: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
731: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
732: AttributeCol_Array IN OUT NOCOPY BigString_Array)
733: IS
734:
735: V_CurrentCallingSequence VARCHAR2(2000);
813: AttributeCol_Array(I) := NULL;
814: END LOOP;
815:
816: -- Map values for index-th receipt
817: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom1_Array(P_Index)) THEN
818:
819: MapFlexFieldValueToColumn(Custom1_Array(P_Index).value,
820: Custom1_Array(P_Index).column_mapping,
821: AttributeCol_Array);
822:
823: END IF;
824:
825: -- Map values for index-th receipt
826: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom2_Array(P_Index)) THEN
827:
828: MapFlexFieldValueToColumn(Custom2_Array(P_Index).value,
829: Custom2_Array(P_Index).column_mapping,
830: AttributeCol_Array);
830: AttributeCol_Array);
831: END IF;
832:
833: -- Map values for index-th receipt
834: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom3_Array(P_Index)) THEN
835:
836: MapFlexFieldValueToColumn(Custom3_Array(P_Index).value,
837: Custom3_Array(P_Index).column_mapping,
838: AttributeCol_Array);
839:
840: END IF;
841:
842: -- Map values for index-th receipt
843: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom4_Array(P_Index)) THEN
844:
845: MapFlexFieldValueToColumn(Custom4_Array(P_Index).value,
846: Custom4_Array(P_Index).column_mapping,
847: AttributeCol_Array);
848:
849: END IF;
850:
851: -- Map values for index-th receipt
852: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom5_Array(P_Index)) THEN
853:
854: MapFlexFieldValueToColumn(Custom5_Array(P_Index).value,
855: Custom5_Array(P_Index).column_mapping,
856: AttributeCol_Array);
856: AttributeCol_Array);
857: END IF;
858:
859: -- Map values for index-th receipt
860: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom6_Array(P_Index)) THEN
861:
862: MapFlexFieldValueToColumn(Custom6_Array(P_Index).value,
863: Custom6_Array(P_Index).column_mapping,
864: AttributeCol_Array);
864: AttributeCol_Array);
865: END IF;
866:
867: -- Map values for index-th receipt
868: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom7_Array(P_Index)) THEN
869:
870: MapFlexFieldValueToColumn(Custom7_Array(P_Index).value,
871: Custom7_Array(P_Index).column_mapping,
872: AttributeCol_Array);
872: AttributeCol_Array);
873: END IF;
874:
875: -- Map values for index-th receipt
876: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom8_Array(P_Index)) THEN
877:
878: MapFlexFieldValueToColumn(Custom8_Array(P_Index).value,
879: Custom8_Array(P_Index).column_mapping,
880: AttributeCol_Array);
880: AttributeCol_Array);
881: END IF;
882:
883: -- Map values for index-th receipt
884: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom9_Array(P_Index)) THEN
885:
886: MapFlexFieldValueToColumn(Custom9_Array(P_Index).value,
887: Custom9_Array(P_Index).column_mapping,
888: AttributeCol_Array);
888: AttributeCol_Array);
889: END IF;
890:
891: -- Map values for index-th receipt
892: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom10_Array(P_Index)) THEN
893:
894: MapFlexFieldValueToColumn(Custom10_Array(P_Index).value,
895: Custom10_Array(P_Index).column_mapping,
896: AttributeCol_Array);
896: AttributeCol_Array);
897: END IF;
898:
899: -- Map values for index-th receipt
900: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom11_Array(P_Index)) THEN
901:
902: MapFlexFieldValueToColumn(Custom11_Array(P_Index).value,
903: Custom11_Array(P_Index).column_mapping,
904: AttributeCol_Array);
904: AttributeCol_Array);
905: END IF;
906:
907: -- Map values for index-th receipt
908: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom12_Array(P_Index)) THEN
909:
910: MapFlexFieldValueToColumn(Custom12_Array(P_Index).value,
911: Custom12_Array(P_Index).column_mapping,
912: AttributeCol_Array);
912: AttributeCol_Array);
913: END IF;
914:
915: -- Map values for index-th receipt
916: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom13_Array(P_Index)) THEN
917:
918: MapFlexFieldValueToColumn(Custom13_Array(P_Index).value,
919: Custom13_Array(P_Index).column_mapping,
920: AttributeCol_Array);
920: AttributeCol_Array);
921: END IF;
922:
923: -- Map values for index-th receipt
924: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom14_Array(P_Index)) THEN
925:
926: MapFlexFieldValueToColumn(Custom14_Array(P_Index).value,
927: Custom14_Array(P_Index).column_mapping,
928: AttributeCol_Array);
928: AttributeCol_Array);
929: END IF;
930:
931: -- Map values for index-th receipt
932: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(Custom15_Array(P_Index)) THEN
933:
934: MapFlexFieldValueToColumn(Custom15_Array(P_Index).value,
935: Custom15_Array(P_Index).column_mapping,
936: AttributeCol_Array);