13002: l_reimb_curr AP_WEB_DB_EXPRPT_PKG.expHdr_payemntCurrCode;
13003: l_over_threshold_distance NUMBER := 0;
13004: l_sh_distance_thresholds_flag VARCHAR2(1);
13005:
13006: l_report_header_info AP_WEB_DFLEX_PKG.ExpReportHeaderRec;
13007: l_custom_array AP_WEB_DFLEX_PKG.CustomFields_A;
13008: l_mileage_line AP_WEB_DFLEX_PKG.ExpReportLineRec;
13009: l_addon_rates OIE_ADDON_RATES_T;
13010: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13003: l_over_threshold_distance NUMBER := 0;
13004: l_sh_distance_thresholds_flag VARCHAR2(1);
13005:
13006: l_report_header_info AP_WEB_DFLEX_PKG.ExpReportHeaderRec;
13007: l_custom_array AP_WEB_DFLEX_PKG.CustomFields_A;
13008: l_mileage_line AP_WEB_DFLEX_PKG.ExpReportLineRec;
13009: l_addon_rates OIE_ADDON_RATES_T;
13010: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13011: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13004: l_sh_distance_thresholds_flag VARCHAR2(1);
13005:
13006: l_report_header_info AP_WEB_DFLEX_PKG.ExpReportHeaderRec;
13007: l_custom_array AP_WEB_DFLEX_PKG.CustomFields_A;
13008: l_mileage_line AP_WEB_DFLEX_PKG.ExpReportLineRec;
13009: l_addon_rates OIE_ADDON_RATES_T;
13010: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13011: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13012: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13006: l_report_header_info AP_WEB_DFLEX_PKG.ExpReportHeaderRec;
13007: l_custom_array AP_WEB_DFLEX_PKG.CustomFields_A;
13008: l_mileage_line AP_WEB_DFLEX_PKG.ExpReportLineRec;
13009: l_addon_rates OIE_ADDON_RATES_T;
13010: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13011: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13012: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13013: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13014: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13007: l_custom_array AP_WEB_DFLEX_PKG.CustomFields_A;
13008: l_mileage_line AP_WEB_DFLEX_PKG.ExpReportLineRec;
13009: l_addon_rates OIE_ADDON_RATES_T;
13010: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13011: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13012: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13013: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13014: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13015: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13008: l_mileage_line AP_WEB_DFLEX_PKG.ExpReportLineRec;
13009: l_addon_rates OIE_ADDON_RATES_T;
13010: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13011: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13012: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13013: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13014: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13015: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13016: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13009: l_addon_rates OIE_ADDON_RATES_T;
13010: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13011: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13012: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13013: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13014: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13015: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13016: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13017: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13010: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13011: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13012: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13013: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13014: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13015: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13016: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13017: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13018: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13011: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13012: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13013: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13014: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13015: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13016: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13017: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13018: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13019: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13012: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13013: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13014: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13015: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13016: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13017: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13018: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13019: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13020: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13013: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13014: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13015: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13016: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13017: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13018: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13019: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13020: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13021: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13014: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13015: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13016: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13017: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13018: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13019: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13020: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13021: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13022: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13015: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13016: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13017: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13018: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13019: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13020: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13021: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13022: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13023: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13016: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13017: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13018: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13019: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13020: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13021: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13022: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13023: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13024: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13017: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13018: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13019: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13020: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13021: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13022: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13023: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13024: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13025: k number;
13018: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13019: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13020: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13021: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13022: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13023: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13024: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13025: k number;
13026: cursor getAddonRates(l_report_line_id NUMBER) is select addon_rate_type
13019: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13020: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13021: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13022: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13023: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13024: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13025: k number;
13026: cursor getAddonRates(l_report_line_id NUMBER) is select addon_rate_type
13027: from oie_addon_mileage_rates
13020: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13021: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13022: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13023: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13024: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
13025: k number;
13026: cursor getAddonRates(l_report_line_id NUMBER) is select addon_rate_type
13027: from oie_addon_mileage_rates
13028: where report_line_id = l_report_line_id;
13339: Custom1_Array(13).value := l_mileage_line_array(i).attribute13;
13340: Custom1_Array(14).value := l_mileage_line_array(i).attribute14;
13341: Custom1_Array(15).value := l_mileage_line_array(i).attribute15;
13342:
13343: AP_WEB_DFLEX_PKG.GetReceiptCustomFields(l_custom_array,
13344: 1, -- from ap_web_oa_mainflow_pkg.validatereceiptline
13345: Custom1_Array,
13346: Custom2_Array,
13347: Custom3_Array,
13382: END LOOP;
13383: CLOSE getAddonRates;
13384:
13385: -- Bug: 6617094, Expense Type not populated for CustomCalculateAmount.
13386: AP_WEB_DFLEX_PKG.PopulateExpTypeInLineRec(l_mileage_line);
13387: AP_WEB_CUST_DFLEX_PKG.CustomCalculateAmount( l_report_header_info -- can be null from wf perspective
13388: , l_mileage_line -- should contain all fields as defined in fdd
13389: , l_custom_array-- should contain all fields as defined in fdd
13390: , l_addon_rates -- should contain all fields as defined in fdd