eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_EXPENSE_WF dependencies on AP_EXPENSE_REPORT_PARAMS

Line 1004: V_ExpenseType AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;

1000: V_DistLineNumber AP_WEB_DB_EXPLINE_PKG.expLines_distLineNum;
1001: l_report_distribution_id AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID;
1002: V_StartExpenseDate AP_WEB_DB_EXPLINE_PKG.expLines_startExpDate;
1003: V_Amount AP_WEB_DB_EXPLINE_PKG.expLines_amount;
1004: V_ExpenseType AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
1005: V_CreditCardTrxID AP_WEB_DB_EXPLINE_PKG.expLines_crdCardTrxID;
1006: V_ProjectID AP_WEB_DB_EXPLINE_PKG.expLines_projID;
1007: V_TaskID AP_WEB_DB_EXPLINE_PKG.expLines_taskID;
1008: -- Grants Integration

Line 1018: V_FlexConcactenated AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;

1014: V_ExpenditureOrganizationID AP_WEB_DB_EXPLINE_PKG.expLines_expOrgID;
1015: V_WebParamID AP_WEB_DB_EXPLINE_PKG.expLines_webParamID;
1016: V_AdjustmentReason AP_WEB_DB_EXPLINE_PKG.expLines_adjReason;
1017: V_CategoryCode AP_WEB_DB_EXPLINE_PKG.expLines_categorycode;
1018: V_FlexConcactenated AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;
1019: V_LineAttributeCategory AP_WEB_DB_EXPLINE_PKG.expLines_attrCategory;
1020: V_LineAttribute1 AP_WEB_DB_EXPLINE_PKG.expLines_attr1;
1021: V_LineAttribute2 AP_WEB_DB_EXPLINE_PKG.expLines_attr2;
1022: V_LineAttribute3 AP_WEB_DB_EXPLINE_PKG.expLines_attr3;

Line 1930: V_ExpenseType AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;

1926: l_dist_line_number AP_WEB_DB_EXPLINE_PKG.expLines_distLineNum;
1927: l_report_distribution_id AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID;
1928: V_StartExpenseDate AP_WEB_DB_EXPLINE_PKG.expLines_startExpDate;
1929: V_Amount AP_WEB_DB_EXPLINE_PKG.expLines_amount;
1930: V_ExpenseType AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
1931: V_CreditCardTrxID AP_WEB_DB_EXPLINE_PKG.expLines_crdCardTrxID;
1932: V_ProjectID AP_WEB_DB_EXPLINE_PKG.expLines_projID;
1933: V_TaskID AP_WEB_DB_EXPLINE_PKG.expLines_taskID;
1934: -- Grants Integration

Line 1944: V_FlexConcactenated AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;

1940: V_ExpenditureOrganizationID AP_WEB_DB_EXPLINE_PKG.expLines_expOrgID;
1941: l_exp_type_parameter_id AP_WEB_DB_EXPLINE_PKG.expLines_webParamID;
1942: V_AdjustmentReason AP_WEB_DB_EXPLINE_PKG.expLines_adjReason;
1943: V_CategoryCode AP_WEB_DB_EXPLINE_PKG.expLines_categorycode;
1944: V_FlexConcactenated AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;
1945: V_LineAttributeCategory AP_WEB_DB_EXPLINE_PKG.expLines_attrCategory;
1946: V_LineAttribute1 AP_WEB_DB_EXPLINE_PKG.expLines_attr1;
1947: V_LineAttribute2 AP_WEB_DB_EXPLINE_PKG.expLines_attr2;
1948: V_LineAttribute3 AP_WEB_DB_EXPLINE_PKG.expLines_attr3;

Line 12304: l_policy_id AP_EXPENSE_REPORT_PARAMS.COMPANY_POLICY_ID%TYPE;

12300: l_currency_code AP_WEB_DB_EXPLINE_PKG.expLines_currCode;
12301: l_start_expense_date AP_WEB_DB_EXPLINE_PKG.expLines_startExpDate;
12302: l_end_expense_date AP_WEB_DB_EXPLINE_PKG.expLines_endExpDate;
12303: l_web_parameter_iD AP_WEB_DB_EXPLINE_PKG.expLines_webParamID;
12304: l_policy_id AP_EXPENSE_REPORT_PARAMS.COMPANY_POLICY_ID%TYPE;
12305: l_distance_uom AP_POL_HEADERS.DISTANCE_UOM%TYPE;
12306: l_employee_role_flag AP_POL_HEADERS.EMPLOYEE_ROLE_FLAG%TYPE;
12307: l_distance_thresholds_flag AP_POL_HEADERS.DISTANCE_THRESHOLDS_FLAG%TYPE;
12308: l_debug_info VARCHAR2(200);

Line 12350: AP_EXPENSE_REPORT_PARAMS XP,

12346: l_policy_id,
12347: l_currency_preference
12348: FROM ap_expense_report_lines XL,
12349: AP_EXPENSE_REPORT_HEADERS XH,
12350: AP_EXPENSE_REPORT_PARAMS XP,
12351: AP_POL_HEADERS SH
12352: WHERE XH.report_header_id = p_report_header_id
12353: AND XH.report_header_id = XL.report_header_id
12354: AND XL.distribution_line_number = p_distribution_line_number

Line 13320: FROM ap_expense_report_params

13316:
13317: BEGIN
13318: SELECT CALCULATE_AMOUNT_FLAG
13319: INTO l_client_extension_enabled
13320: FROM ap_expense_report_params
13321: WHERE parameter_id = l_mileage_line_array(i).web_parameter_id;
13322: EXCEPTION WHEN OTHERS THEN
13323: l_client_extension_enabled := 'N';
13324: END;