76:
77: function ReportTotal(Amount_Array in AP_WEB_PARENT_PKG.MiniString_Array)
78: return number;
79:
80: function ReportTotal2(ExpLine_Array in AP_WEB_DFLEX_PKG.ExpReportLines_A)
81: return number;
82:
83: function isValidCurrency (p_currency_code IN AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode)
84: return boolean;
87: procedure getFlexFieldGlobalSegments(p_user_id in NUMBER, -- Bug 2242176
88: p_segments in out nocopy FND_DFLEX.SEGMENTS_DR);
89:
90: procedure getAllSegmentPrompts(p_user_id in NUMBER, -- Bug 2242176
91: p_report_header_info in AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
92: p_segmentPromptTable in out nocopy segmentPrompt_table);
93:
94: procedure checkValidFlexFieldPrompt(p_fld in varchar2,
95: p_segmentPromptTable in segmentPrompt_table,
96: p_expIndexTable in expIndex_table,
97: p_number in out nocopy number);
98:
99: procedure initIndexAndDflexTable(p_segmentPromptTable in segmentPrompt_table ,
100: p_dflexTable in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
101: p_expIndexTable in out nocopy expIndex_table);
102:
103: procedure setupIndexAndDflexTable(p_expType in varchar2,
104: p_segmentPromptTable in segmentPrompt_table ,
101: p_expIndexTable in out nocopy expIndex_table);
102:
103: procedure setupIndexAndDflexTable(p_expType in varchar2,
104: p_segmentPromptTable in segmentPrompt_table ,
105: p_dflexTable in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
106: p_expIndexTable in out nocopy expIndex_table);
107:
108: --------------------------------
109: /* Fills the disc_prompts_table with the prompts retrieved from p_reg_code
354: (p_user_id IN NUMBER, -- Bug 2242176, fnd user id
355: p_text IN OUT NOCOPY LONG,
356: p_table IN OUT NOCOPY disc_prompts_table,
357: p_def_costcenter IN VARCHAR2,
358: p_header IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
359: p_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.expError) IS
360: l_label_text VARCHAR2(300) := '';
361: l_label_code VARCHAR2(100) := '';
362: l_label_index NUMBER;
1095: END PopulateXtypeIndex;
1096:
1097: ---------------------------------------------------
1098: PROCEDURE SerializeHeader(
1099: p_header in AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1100: p_index in varchar2,
1101: p_xtype in varchar2,
1102: p_recCurr in varchar2,
1103: p_rate in varchar2,
1134: PROCEDURE parseExpReportReceipts(p_user_id IN NUMBER, -- Bug 2242176, fnd user id
1135: p_exp IN OUT NOCOPY LONG,
1136: p_table IN disc_prompts_table,
1137: P_IsSessionProjectEnabled IN VARCHAR2,
1138: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1139: p_receipts OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
1140: Custom1_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1141: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1142: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1135: p_exp IN OUT NOCOPY LONG,
1136: p_table IN disc_prompts_table,
1137: P_IsSessionProjectEnabled IN VARCHAR2,
1138: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1139: p_receipts OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
1140: Custom1_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1141: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1142: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1143: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1136: p_table IN disc_prompts_table,
1137: P_IsSessionProjectEnabled IN VARCHAR2,
1138: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1139: p_receipts OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
1140: Custom1_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1141: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1142: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1143: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1144: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1137: P_IsSessionProjectEnabled IN VARCHAR2,
1138: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1139: p_receipts OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
1140: Custom1_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1141: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1142: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1143: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1144: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1145: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1138: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1139: p_receipts OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
1140: Custom1_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1141: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1142: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1143: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1144: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1145: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1146: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1139: p_receipts OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
1140: Custom1_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1141: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1142: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1143: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1144: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1145: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1146: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1147: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1140: Custom1_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1141: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1142: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1143: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1144: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1145: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1146: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1147: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1148: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1141: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1142: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1143: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1144: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1145: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1146: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1147: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1148: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1149: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1142: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1143: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1144: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1145: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1146: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1147: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1148: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1149: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1150: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1143: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1144: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1145: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1146: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1147: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1148: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1149: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1150: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1151: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1144: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1145: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1146: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1147: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1148: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1149: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1150: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1151: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1152: Custom13_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1145: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1146: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1147: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1148: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1149: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1150: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1151: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1152: Custom13_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1153: Custom14_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1146: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1147: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1148: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1149: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1150: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1151: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1152: Custom13_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1153: Custom14_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1154: Custom15_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1147: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1148: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1149: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1150: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1151: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1152: Custom13_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1153: Custom14_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1154: Custom15_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1155: p_receipt_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
1148: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1149: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1150: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1151: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1152: Custom13_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1153: Custom14_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1154: Custom15_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1155: p_receipt_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
1156: p_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.expError, /*Bug No: 3075093*/
1149: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1150: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1151: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1152: Custom13_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1153: Custom14_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1154: Custom15_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1155: p_receipt_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
1156: p_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.expError, /*Bug No: 3075093*/
1157: p_error_type IN OUT NOCOPY VARCHAR2) IS
1150: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1151: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1152: Custom13_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1153: Custom14_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1154: Custom15_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1155: p_receipt_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
1156: p_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.expError, /*Bug No: 3075093*/
1157: p_error_type IN OUT NOCOPY VARCHAR2) IS
1158: i NUMBER;
1194: l_segmentPromptTable segmentPrompt_table; /*to keep segment data for ALL segments*/
1195: l_expIndexTable expIndex_table; /*index to l_segmentPromptTable for a given Expense type*/
1196:
1197: /*to store FlexField data for a receipt by the 'correct order'*/
1198: l_dflexTable AP_WEB_DFLEX_PKG.CustomFields_A;
1199: ---
1200: --- Used to determine if the receipt currency user provided is a recognized
1201: --- one. Took away the where clause since receipt can be in any currency,
1202: --- whereas reimbursement currency should be restricted.
1802: rec_count := rec_count - 1;
1803: else -- the receipt is good
1804: -- copy dflfexTable to the customfield array
1805: l_binNumber := rec_count; -- since Propogate... take BINARY_INTEGER
1806: AP_WEB_DFLEX_PKG.propogateReceiptCustFldsInfo(l_dflexTable,
1807: l_binNumber,
1808: Custom1_Array,
1809: Custom2_Array,
1810: Custom3_Array,
1885: END parseExpReportReceipts;
1886:
1887:
1888: PROCEDURE discValidateExpLines(
1889: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1890: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
1891: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1892: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1893: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1886:
1887:
1888: PROCEDURE discValidateExpLines(
1889: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1890: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
1891: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1892: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1893: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1894: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1887:
1888: PROCEDURE discValidateExpLines(
1889: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1890: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
1891: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1892: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1893: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1894: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1895: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1888: PROCEDURE discValidateExpLines(
1889: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1890: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
1891: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1892: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1893: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1894: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1895: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1896: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1889: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1890: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
1891: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1892: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1893: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1894: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1895: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1896: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1897: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1890: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
1891: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1892: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1893: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1894: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1895: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1896: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1897: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1898: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1891: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1892: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1893: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1894: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1895: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1896: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1897: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1898: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1899: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1892: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1893: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1894: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1895: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1896: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1897: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1898: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1899: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1900: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1893: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1894: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1895: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1896: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1897: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1898: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1899: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1900: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1901: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1894: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1895: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1896: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1897: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1898: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1899: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1900: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1901: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1902: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1895: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1896: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1897: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1898: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1899: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1900: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1901: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1902: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1903: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1896: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1897: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1898: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1899: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1900: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1901: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1902: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1903: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1904: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1897: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1898: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1899: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1900: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1901: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1902: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1903: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1904: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1905: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1898: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1899: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1900: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1901: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1902: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1903: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1904: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1905: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1906: p_has_core_field_errors OUT NOCOPY BOOLEAN,
1899: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1900: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1901: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1902: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1903: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1904: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1905: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1906: p_has_core_field_errors OUT NOCOPY BOOLEAN,
1907: p_has_custom_field_errors OUT NOCOPY BOOLEAN,
1900: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1901: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1902: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1903: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1904: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1905: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1906: p_has_core_field_errors OUT NOCOPY BOOLEAN,
1907: p_has_custom_field_errors OUT NOCOPY BOOLEAN,
1908: p_receipts_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
1901: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1902: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1903: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1904: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1905: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1906: p_has_core_field_errors OUT NOCOPY BOOLEAN,
1907: p_has_custom_field_errors OUT NOCOPY BOOLEAN,
1908: p_receipts_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
1909: p_receipts_with_errors_count OUT NOCOPY BINARY_INTEGER,
1942: V_DateTemp DATE; -- For PATC: Scratch variable
1943: V_DateFormat VARCHAR2(30);
1944:
1945: I INTEGER;
1946: l_report_line_rec AP_WEB_DFLEX_PKG.ExpReportLineRec;
1947: l_temp_array OIE_PDM_NUMBER_T; -- bug 5358186
1948: BEGIN
1949:
1950: -- Convert number of maximum number of flexfield segments used
1949:
1950: -- Convert number of maximum number of flexfield segments used
1951: l_receipt_count := TO_NUMBER(p_report_header_info.receipt_count);
1952:
1953: AP_WEB_DFLEX_PKG.IsSessionTaxEnabled(
1954: V_IsSessionTaxEnabled);
1955:
1956:
1957: -- For core case, do NOT assume that the error table is empty. Certain
2145: APP_EXCEPTION.RAISE_EXCEPTION;
2146: END discValidateExpLines;
2147:
2148: PROCEDURE Serialize(P_IsSessionProjectEnabled IN VARCHAR2,
2149: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2150: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2151: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2152: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2153: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2146: END discValidateExpLines;
2147:
2148: PROCEDURE Serialize(P_IsSessionProjectEnabled IN VARCHAR2,
2149: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2150: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2151: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2152: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2153: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2154: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2147:
2148: PROCEDURE Serialize(P_IsSessionProjectEnabled IN VARCHAR2,
2149: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2150: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2151: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2152: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2153: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2154: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2155: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2148: PROCEDURE Serialize(P_IsSessionProjectEnabled IN VARCHAR2,
2149: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2150: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2151: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2152: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2153: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2154: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2155: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2156: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2149: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2150: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2151: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2152: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2153: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2154: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2155: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2156: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2157: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2150: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2151: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2152: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2153: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2154: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2155: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2156: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2157: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2158: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2151: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2152: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2153: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2154: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2155: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2156: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2157: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2158: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2159: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2152: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2153: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2154: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2155: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2156: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2157: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2158: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2159: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2160: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2153: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2154: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2155: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2156: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2157: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2158: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2159: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2160: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2161: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2154: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2155: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2156: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2157: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2158: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2159: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2160: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2161: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2162: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2155: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2156: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2157: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2158: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2159: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2160: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2161: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2162: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2163: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2156: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2157: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2158: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2159: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2160: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2161: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2162: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2163: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2164: ReportHdrInfo IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2157: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2158: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2159: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2160: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2161: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2162: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2163: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2164: ReportHdrInfo IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2165: ExpReportLineInfo IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
2158: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2159: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2160: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2161: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2162: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2163: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2164: ReportHdrInfo IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2165: ExpReportLineInfo IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
2166: ReportLine OUT NOCOPY LONG,
2159: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2160: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2161: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2162: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2163: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2164: ReportHdrInfo IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2165: ExpReportLineInfo IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
2166: ReportLine OUT NOCOPY LONG,
2167: p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack) IS
2160: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2161: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2162: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2163: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2164: ReportHdrInfo IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2165: ExpReportLineInfo IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
2166: ReportLine OUT NOCOPY LONG,
2167: p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack) IS
2168:
2161: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2162: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2163: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
2164: ReportHdrInfo IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2165: ExpReportLineInfo IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
2166: ReportLine OUT NOCOPY LONG,
2167: p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack) IS
2168:
2169: l_index VARCHAR2(3) := '1';
2504: -- Returns the sum of ExpLines content.
2505: -- Raise INVALID_NUMBER exception if a value is not
2506: -- a number.
2507: ------------------------------------------
2508: Function ReportTotal2(ExpLine_Array in AP_WEB_DFLEX_PKG.ExpReportLines_A)
2509: Return NUMBER IS
2510: i NUMBER;
2511: l_total NUMBER := 0;
2512: l_num NUMBER;
2577: p_exp in LONG,
2578: p_table IN OUT NOCOPY disc_prompts_table,
2579: p_costcenter in VARCHAR2,
2580: P_IsSessionProjectEnabled IN VARCHAR2,
2581: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2582: p_report_lines_info OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2583: Custom1_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2578: p_table IN OUT NOCOPY disc_prompts_table,
2579: p_costcenter in VARCHAR2,
2580: P_IsSessionProjectEnabled IN VARCHAR2,
2581: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2582: p_report_lines_info OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2583: Custom1_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2579: p_costcenter in VARCHAR2,
2580: P_IsSessionProjectEnabled IN VARCHAR2,
2581: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2582: p_report_lines_info OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2583: Custom1_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2587: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2580: P_IsSessionProjectEnabled IN VARCHAR2,
2581: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2582: p_report_lines_info OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2583: Custom1_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2587: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2588: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2581: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2582: p_report_lines_info OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2583: Custom1_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2587: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2588: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2589: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2582: p_report_lines_info OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2583: Custom1_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2587: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2588: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2589: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2590: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2583: Custom1_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2587: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2588: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2589: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2590: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2591: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom2_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2587: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2588: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2589: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2590: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2591: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2592: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom3_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2587: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2588: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2589: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2590: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2591: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2592: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2593: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom4_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2587: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2588: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2589: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2590: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2591: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2592: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2593: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2594: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2587: Custom5_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2588: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2589: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2590: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2591: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2592: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2593: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2594: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2595: Custom13_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2588: Custom6_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2589: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2590: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2591: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2592: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2593: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2594: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2595: Custom13_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2596: Custom14_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2589: Custom7_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2590: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2591: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2592: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2593: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2594: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2595: Custom13_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2596: Custom14_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2597: Custom15_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2590: Custom8_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2591: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2592: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2593: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2594: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2595: Custom13_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2596: Custom14_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2597: Custom15_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2598: P_DataDefaultedUpdateable OUT NOCOPY BOOLEAN,
2591: Custom9_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2592: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2593: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2594: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2595: Custom13_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2596: Custom14_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2597: Custom15_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2598: P_DataDefaultedUpdateable OUT NOCOPY BOOLEAN,
2599: p_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
2592: Custom10_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2593: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2594: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2595: Custom13_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2596: Custom14_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2597: Custom15_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2598: P_DataDefaultedUpdateable OUT NOCOPY BOOLEAN,
2599: p_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
2600: p_receipt_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
2593: Custom11_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2594: Custom12_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2595: Custom13_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2596: Custom14_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2597: Custom15_Array OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2598: P_DataDefaultedUpdateable OUT NOCOPY BOOLEAN,
2599: p_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
2600: p_receipt_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
2601: p_error_type OUT NOCOPY VARCHAR2, -- Setup/data/no errors encountered
2639: --l_dflex_enabled := (NVL(l_tempChar, 'N') = 'Y');
2640: l_dflex_enabled := ((NVL(l_tempChar, 'N') = 'Y') OR (NVL(l_tempChar, 'N') = 'B'));
2641:
2642: -- Compute maximum number of flexfield segments
2643: p_report_header_info.number_max_flexfield := AP_WEB_DFLEX_PKG.GetMaxNumSegmentsUsed;
2644: V_NumMaxPseudoFlexField := AP_WEB_DFLEX_PKG.GetMaxNumPseudoSegmentsUsed(
2645: P_IsSessionProjectEnabled);
2646:
2647: -------------------------------------------------------
2640: l_dflex_enabled := ((NVL(l_tempChar, 'N') = 'Y') OR (NVL(l_tempChar, 'N') = 'B'));
2641:
2642: -- Compute maximum number of flexfield segments
2643: p_report_header_info.number_max_flexfield := AP_WEB_DFLEX_PKG.GetMaxNumSegmentsUsed;
2644: V_NumMaxPseudoFlexField := AP_WEB_DFLEX_PKG.GetMaxNumPseudoSegmentsUsed(
2645: P_IsSessionProjectEnabled);
2646:
2647: -------------------------------------------------------
2648: debug_info := 'parse exp report header';
2837: l_last_receipt_date := p_report_lines_info(I).start_date;
2838: END IF;
2839:
2840: /*
2841: AP_WEB_DFLEX_PKG.SetExpReportLineInfo(p_report_lines_info(I),
2842: I,
2843: Xdate1_Array(I),
2844: Xdate2_Array(I),
2845: Days_Array(I),
2893:
2894: if (not(l_dflex_enabled)) then -- get default values for custom fields
2895: debug_info := 'Populate Custom values with defaults';
2896: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_DISC_PKG', debug_info);
2897: AP_WEB_DFLEX_PKG.PopulateCustomDefaultValues( p_user_id,
2898: p_report_header_info,
2899: p_report_lines_info,
2900: l_receipt_count,
2901: Custom1_Array,
2920:
2921: -- Bug 2242176, passing fnd user id
2922: -- Bug 2812175, always default tax, regardless of AP_WEB_TAX_ENABLE
2923: -- profile option.
2924: -- AP_WEB_DFLEX_PKG.IsSessionTaxEnabled(l_tax_enabled, p_user_id);
2925: --if (l_tax_enabled = 'Y') then -- get default values for tax fields
2926: debug_info := 'Populate Pseudo values with defaults';
2927: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_DISC_PKG', debug_info);
2928: AP_WEB_DFLEX_PKG.PopulatePseudoDefaultValues( p_report_header_info,
2924: -- AP_WEB_DFLEX_PKG.IsSessionTaxEnabled(l_tax_enabled, p_user_id);
2925: --if (l_tax_enabled = 'Y') then -- get default values for tax fields
2926: debug_info := 'Populate Pseudo values with defaults';
2927: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_DISC_PKG', debug_info);
2928: AP_WEB_DFLEX_PKG.PopulatePseudoDefaultValues( p_report_header_info,
2929: p_report_lines_info,
2930: l_receipt_count,
2931: P_DataDefaultedUpdateable);
2932:
3121: l_DebugInfo VARCHAR2(100);
3122:
3123: begin
3124: p_segments.nsegments := 0;
3125: AP_WEB_DFLEX_PKG.GetExpenseLineDFlexInfo(p_user_id, -- 2242176
3126: l_DFlexField,
3127: l_DFlexInfo,
3128: l_Contexts,
3129: l_IsFlexFieldUsed);
3159: Date:
3160: 11/25/98
3161: */
3162: procedure getAllSegmentPrompts(p_user_id in NUMBER,
3163: p_report_header_info in AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
3164: p_segmentPromptTable in out nocopy segmentPrompt_table) is
3165: l_DFlexField FND_DFLEX.DFLEX_R;
3166: l_DFlexInfo FND_DFLEX.DFLEX_DR;
3167: l_Contexts FND_DFLEX.CONTEXTS_DR;
3171:
3172: l_segments FND_DFLEX.SEGMENTS_DR; -- For Flexfield global segments
3173: l_count number:=1;
3174: begin
3175: AP_WEB_DFLEX_PKG.GetExpenseLineDFlexInfo(p_user_id, l_DFlexField,
3176: l_DFlexInfo,
3177: l_Contexts,
3178: l_IsFlexFieldUsed);
3179:
3189: if (l_segments.is_enabled(i)) then
3190: p_segmentPromptTable(l_count).exptype := C_GLOBAL;
3191: p_segmentPromptTable(l_count).segment_num := l_segments.sequence(i);
3192: p_segmentPromptTable(l_count).prompt := l_segments.row_prompt(i);
3193: p_segmentPromptTable(l_count).default_value := AP_WEB_DFLEX_PKG.getSegmentDefault(
3194: l_Context.context_code,
3195: l_segments, i);
3196: p_segmentPromptTable(l_count).found := false;
3197: p_segmentPromptTable(l_count).webEnabled := AP_WEB_DFLEX_PKG.isSegmentWebEnabled(l_segments, i);
3193: p_segmentPromptTable(l_count).default_value := AP_WEB_DFLEX_PKG.getSegmentDefault(
3194: l_Context.context_code,
3195: l_segments, i);
3196: p_segmentPromptTable(l_count).found := false;
3197: p_segmentPromptTable(l_count).webEnabled := AP_WEB_DFLEX_PKG.isSegmentWebEnabled(l_segments, i);
3198: l_count := l_count+1;
3199: end if;
3200: END LOOP;
3201:
3207: FOR j in 1..l_segments.nsegments LOOP
3208: p_segmentPromptTable(l_count).exptype := l_Contexts.context_code(i);/*context_name?*/
3209: p_segmentPromptTable(l_count).segment_num := l_segments.sequence(j);
3210: p_segmentPromptTable(l_count).prompt := l_segments.row_prompt(j);
3211: p_segmentPromptTable(l_count).default_value := AP_WEB_DFLEX_PKG.getSegmentDefault(
3212: l_Context.context_code,
3213: l_segments, j);
3214:
3215: p_segmentPromptTable(l_count).found := false;
3212: l_Context.context_code,
3213: l_segments, j);
3214:
3215: p_segmentPromptTable(l_count).found := false;
3216: p_segmentPromptTable(l_count).webEnabled := AP_WEB_DFLEX_PKG.isSegmentWebEnabled(l_segments, j);
3217: l_count := l_count+1;
3218: END LOOP;
3219: end if;
3220: END LOOP;
3285: 12/02/98
3286: */
3287: procedure setupIndexAndDflexTable(p_expType in varchar2,
3288: p_segmentPromptTable in segmentPrompt_table ,
3289: p_dflexTable in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
3290: p_expIndexTable in out nocopy expIndex_table) IS
3291: l_count number;
3292: l_start number;
3293: BEGIN
3337: Date:
3338: 12/02/98
3339: */
3340: procedure initIndexAndDflexTable(p_segmentPromptTable in segmentPrompt_table ,
3341: p_dflexTable in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
3342: p_expIndexTable in out nocopy expIndex_table) IS
3343: l_count number;
3344: l_debug_info VARCHAR2(2000);
3345: BEGIN
3345: BEGIN
3346: /* Initialize first */
3347: l_debug_info := 'Initialize dflex table';
3348:
3349: FOR i in 1..AP_WEB_DFLEX_PKG.C_AbsoluteMaxFlexField LOOP
3350: p_dflexTable(i).prompt := null;
3351: p_dflexTable(i).user_prompt := null;
3352: p_dflexTable(i).value := null;
3353: p_expIndexTable(i) := 0;
3405: contain a valid number or the number '1'.
3406: Date:
3407: 24-Aug-2001
3408: */
3409: PROCEDURE InverseRates(p_receipts IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A) IS
3410:
3411: l_inverse_rate_profile VARCHAR2(1);
3412:
3413: temp_rate NUMBER; /* This holds temporary rate info. */
3457: Date:
3458: 30-Aug-2001
3459: */
3460: PROCEDURE ValidateForeignCurrencies(
3461: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
3462: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
3463: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack) IS
3464:
3465: l_reimbursement_currency_code AP_WEB_DFLEX_PKG.expLines_currCode;
3458: 30-Aug-2001
3459: */
3460: PROCEDURE ValidateForeignCurrencies(
3461: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
3462: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
3463: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack) IS
3464:
3465: l_reimbursement_currency_code AP_WEB_DFLEX_PKG.expLines_currCode;
3466: l_errors AP_WEB_UTILITIES_PKG.expError;
3461: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
3462: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
3463: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack) IS
3464:
3465: l_reimbursement_currency_code AP_WEB_DFLEX_PKG.expLines_currCode;
3466: l_errors AP_WEB_UTILITIES_PKG.expError;
3467: l_receipt_count BINARY_INTEGER;
3468: rec_count NUMBER := 1; /* receipt count */
3469: l_date_format VARCHAR2(30);