13790: l_reimb_curr AP_WEB_DB_EXPRPT_PKG.expHdr_payemntCurrCode;
13791: l_over_threshold_distance NUMBER := 0;
13792: l_sh_distance_thresholds_flag VARCHAR2(1);
13793:
13794: l_report_header_info AP_WEB_DFLEX_PKG.ExpReportHeaderRec;
13795: l_custom_array AP_WEB_DFLEX_PKG.CustomFields_A;
13796: l_mileage_line AP_WEB_DFLEX_PKG.ExpReportLineRec;
13797: l_addon_rates OIE_ADDON_RATES_T;
13798: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13791: l_over_threshold_distance NUMBER := 0;
13792: l_sh_distance_thresholds_flag VARCHAR2(1);
13793:
13794: l_report_header_info AP_WEB_DFLEX_PKG.ExpReportHeaderRec;
13795: l_custom_array AP_WEB_DFLEX_PKG.CustomFields_A;
13796: l_mileage_line AP_WEB_DFLEX_PKG.ExpReportLineRec;
13797: l_addon_rates OIE_ADDON_RATES_T;
13798: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13799: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13792: l_sh_distance_thresholds_flag VARCHAR2(1);
13793:
13794: l_report_header_info AP_WEB_DFLEX_PKG.ExpReportHeaderRec;
13795: l_custom_array AP_WEB_DFLEX_PKG.CustomFields_A;
13796: l_mileage_line AP_WEB_DFLEX_PKG.ExpReportLineRec;
13797: l_addon_rates OIE_ADDON_RATES_T;
13798: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13799: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13800: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13794: l_report_header_info AP_WEB_DFLEX_PKG.ExpReportHeaderRec;
13795: l_custom_array AP_WEB_DFLEX_PKG.CustomFields_A;
13796: l_mileage_line AP_WEB_DFLEX_PKG.ExpReportLineRec;
13797: l_addon_rates OIE_ADDON_RATES_T;
13798: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13799: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13800: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13801: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13802: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13795: l_custom_array AP_WEB_DFLEX_PKG.CustomFields_A;
13796: l_mileage_line AP_WEB_DFLEX_PKG.ExpReportLineRec;
13797: l_addon_rates OIE_ADDON_RATES_T;
13798: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13799: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13800: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13801: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13802: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13803: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13796: l_mileage_line AP_WEB_DFLEX_PKG.ExpReportLineRec;
13797: l_addon_rates OIE_ADDON_RATES_T;
13798: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13799: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13800: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13801: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13802: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13803: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13804: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13797: l_addon_rates OIE_ADDON_RATES_T;
13798: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13799: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13800: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13801: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13802: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13803: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13804: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13805: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13798: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13799: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13800: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13801: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13802: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13803: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13804: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13805: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13806: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13799: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13800: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13801: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13802: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13803: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13804: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13805: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13806: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13807: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13800: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13801: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13802: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13803: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13804: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13805: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13806: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13807: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13808: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13801: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13802: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13803: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13804: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13805: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13806: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13807: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13808: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13809: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13802: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13803: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13804: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13805: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13806: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13807: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13808: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13809: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13810: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13803: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13804: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13805: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13806: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13807: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13808: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13809: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13810: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13811: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13804: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13805: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13806: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13807: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13808: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13809: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13810: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13811: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13812: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13805: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13806: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13807: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13808: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13809: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13810: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13811: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13812: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13813: k number;
13806: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13807: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13808: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13809: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13810: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13811: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13812: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13813: k number;
13814: cursor getAddonRates(l_report_line_id NUMBER) is select addon_rate_type
13807: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13808: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13809: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13810: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13811: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13812: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13813: k number;
13814: cursor getAddonRates(l_report_line_id NUMBER) is select addon_rate_type
13815: from oie_addon_mileage_rates
13808: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13809: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13810: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13811: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13812: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13813: k number;
13814: cursor getAddonRates(l_report_line_id NUMBER) is select addon_rate_type
13815: from oie_addon_mileage_rates
13816: where report_line_id = l_report_line_id;
14109: Custom1_Array(13).value := l_mileage_line_array(i).attribute13;
14110: Custom1_Array(14).value := l_mileage_line_array(i).attribute14;
14111: Custom1_Array(15).value := l_mileage_line_array(i).attribute15;
14112:
14113: AP_WEB_DFLEX_PKG.GetReceiptCustomFields(l_custom_array,
14114: 1, -- from ap_web_oa_mainflow_pkg.validatereceiptline
14115: Custom1_Array,
14116: Custom2_Array,
14117: Custom3_Array,
14152: END LOOP;
14153: CLOSE getAddonRates;
14154:
14155: -- Bug: 6617094, Expense Type not populated for CustomCalculateAmount.
14156: AP_WEB_DFLEX_PKG.PopulateExpTypeInLineRec(l_mileage_line);
14157: AP_WEB_CUST_DFLEX_PKG.CustomCalculateAmount( l_report_header_info -- can be null from wf perspective
14158: , l_mileage_line -- should contain all fields as defined in fdd
14159: , l_custom_array-- should contain all fields as defined in fdd
14160: , l_addon_rates -- should contain all fields as defined in fdd