[Home] [Help]
1017: V_DistLineNumber AP_WEB_DB_EXPLINE_PKG.expLines_distLineNum;
1018: l_report_distribution_id AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID;
1019: V_StartExpenseDate AP_WEB_DB_EXPLINE_PKG.expLines_startExpDate;
1020: V_Amount AP_WEB_DB_EXPLINE_PKG.expLines_amount;
1021: V_ExpenseType AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
1022: V_CreditCardTrxID AP_WEB_DB_EXPLINE_PKG.expLines_crdCardTrxID;
1023: V_ProjectID AP_WEB_DB_EXPLINE_PKG.expLines_projID;
1024: V_TaskID AP_WEB_DB_EXPLINE_PKG.expLines_taskID;
1025: -- Grants Integration
1031: V_ExpenditureOrganizationID AP_WEB_DB_EXPLINE_PKG.expLines_expOrgID;
1032: V_WebParamID AP_WEB_DB_EXPLINE_PKG.expLines_webParamID;
1033: V_AdjustmentReason AP_WEB_DB_EXPLINE_PKG.expLines_adjReason;
1034: V_CategoryCode AP_WEB_DB_EXPLINE_PKG.expLines_categorycode;
1035: V_FlexConcactenated AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;
1036: V_LineAttributeCategory AP_WEB_DB_EXPLINE_PKG.expLines_attrCategory;
1037: V_LineAttribute1 AP_WEB_DB_EXPLINE_PKG.expLines_attr1;
1038: V_LineAttribute2 AP_WEB_DB_EXPLINE_PKG.expLines_attr2;
1039: V_LineAttribute3 AP_WEB_DB_EXPLINE_PKG.expLines_attr3;
1943: l_dist_line_number AP_WEB_DB_EXPLINE_PKG.expLines_distLineNum;
1944: l_report_distribution_id AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID;
1945: V_StartExpenseDate AP_WEB_DB_EXPLINE_PKG.expLines_startExpDate;
1946: V_Amount AP_WEB_DB_EXPLINE_PKG.expLines_amount;
1947: V_ExpenseType AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
1948: V_CreditCardTrxID AP_WEB_DB_EXPLINE_PKG.expLines_crdCardTrxID;
1949: V_ProjectID AP_WEB_DB_EXPLINE_PKG.expLines_projID;
1950: V_TaskID AP_WEB_DB_EXPLINE_PKG.expLines_taskID;
1951: -- Grants Integration
1957: V_ExpenditureOrganizationID AP_WEB_DB_EXPLINE_PKG.expLines_expOrgID;
1958: l_exp_type_parameter_id AP_WEB_DB_EXPLINE_PKG.expLines_webParamID;
1959: V_AdjustmentReason AP_WEB_DB_EXPLINE_PKG.expLines_adjReason;
1960: V_CategoryCode AP_WEB_DB_EXPLINE_PKG.expLines_categorycode;
1961: V_FlexConcactenated AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;
1962: V_LineAttributeCategory AP_WEB_DB_EXPLINE_PKG.expLines_attrCategory;
1963: V_LineAttribute1 AP_WEB_DB_EXPLINE_PKG.expLines_attr1;
1964: V_LineAttribute2 AP_WEB_DB_EXPLINE_PKG.expLines_attr2;
1965: V_LineAttribute3 AP_WEB_DB_EXPLINE_PKG.expLines_attr3;
13063: l_currency_code AP_WEB_DB_EXPLINE_PKG.expLines_currCode;
13064: l_start_expense_date AP_WEB_DB_EXPLINE_PKG.expLines_startExpDate;
13065: l_end_expense_date AP_WEB_DB_EXPLINE_PKG.expLines_endExpDate;
13066: l_web_parameter_iD AP_WEB_DB_EXPLINE_PKG.expLines_webParamID;
13067: l_policy_id AP_EXPENSE_REPORT_PARAMS.COMPANY_POLICY_ID%TYPE;
13068: l_distance_uom AP_POL_HEADERS.DISTANCE_UOM%TYPE;
13069: l_employee_role_flag AP_POL_HEADERS.EMPLOYEE_ROLE_FLAG%TYPE;
13070: l_distance_thresholds_flag AP_POL_HEADERS.DISTANCE_THRESHOLDS_FLAG%TYPE;
13071: l_debug_info VARCHAR2(200);
13111: l_policy_id,
13112: l_currency_preference
13113: FROM ap_expense_report_lines XL,
13114: AP_EXPENSE_REPORT_HEADERS XH,
13115: AP_EXPENSE_REPORT_PARAMS XP,
13116: AP_POL_HEADERS SH
13117: WHERE XH.report_header_id = p_report_header_id
13118: AND XH.report_header_id = XL.report_header_id
13119: AND XL.distribution_line_number = p_distribution_line_number
14086:
14087: BEGIN
14088: SELECT CALCULATE_AMOUNT_FLAG
14089: INTO l_client_extension_enabled
14090: FROM ap_expense_report_params
14091: WHERE parameter_id = l_mileage_line_array(i).web_parameter_id;
14092: EXCEPTION WHEN OTHERS THEN
14093: l_client_extension_enabled := 'N';
14094: END;
15824:
15825: UPDATE ap_expense_report_lines_all aerl
15826: SET expenditure_type =
15827: (SELECT pa_expenditure_type
15828: FROM ap_expense_report_params_all
15829: WHERE parameter_id = aerl.web_parameter_id
15830: ),
15831: expenditure_item_date = NVL(end_expense_date, start_expense_date)
15832: WHERE report_header_id = p_report_header_id