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_MANAGEMENT_REPORTS_PKG dependencies on AP_EXPENSE_REPORT_HEADERS

Line 324: employee_id ap_expense_report_headers.EMPLOYEE_ID%TYPE,

320: P_QryType IN VARCHAR2 ) AS
321:
322: -- Declare program variables
323: TYPE ByManagerRecType IS RECORD (
324: employee_id ap_expense_report_headers.EMPLOYEE_ID%TYPE,
325: full_name per_workforce_x.FULL_NAME%TYPE,
326: total_expenses NUMBER,
327: violation_line_amount NUMBER,
328: violation_amount NUMBER,

Line 345: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;

341: -- Local Variables
342: L_ByManagerTab ByManagerTabType;
343:
344: L_TabIndex BINARY_INTEGER := 0;
345: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
346: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
347: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
348: L_ExpenseAmount NUMBER := 0;
349: L_ViolationLineAmount NUMBER;

Line 356: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;

352: L_StartDate DATE;
353: L_EndDate DATE;
354: L_EffectiveStartDate DATE;
355: L_EffectiveEndDate DATE;
356: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
357: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
358: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
359: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
360: L_NumberOfViolations NUMBER;

Line 357: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;

353: L_EndDate DATE;
354: L_EffectiveStartDate DATE;
355: L_EffectiveEndDate DATE;
356: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
357: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
358: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
359: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
360: L_NumberOfViolations NUMBER;
361:

Line 456: FROM ap_expense_report_headers_all aerh,

452: P_ExchangeRateType,
453: apv.exceeded_amount
454: )) as violation_amount,
455: 1 as number_of_violations
456: FROM ap_expense_report_headers_all aerh,
457: ap_pol_violations_all apv
458: WHERE aerh.report_header_id = apv.report_header_id
459: AND apv.distribution_line_number = -1
460: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)

Line 518: FROM ap_expense_report_headers_all aerh,

514: UNION ALL
515: /* Count all the violations for Daily Sum Limit */
516: SELECT 1 as number_of_violations,
517: alc.displayed_field as violation_type
518: FROM ap_expense_report_headers_all aerh,
519: ap_pol_violations_all apv,
520: ap_lookup_codes alc
521: WHERE aerh.report_header_id = apv.report_header_id
522: AND apv.distribution_line_number = -1

Line 873: employee_id ap_expense_report_headers.EMPLOYEE_ID%TYPE,

869: P_QryType IN VARCHAR2 ) IS
870:
871: -- Declare program variables
872: TYPE ByExpenseCategoryRecType IS RECORD (
873: employee_id ap_expense_report_headers.EMPLOYEE_ID%TYPE,
874: total_expenses NUMBER,
875: violation_line_amount NUMBER,
876: violation_amount NUMBER,
877: allowable_amount NUMBER,

Line 893: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;

889: -- Local Variables
890: L_ByExpCatTab ByExpenseCategoryTabType;
891:
892: L_TabIndex BINARY_INTEGER := 0;
893: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
894: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
895: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
896: L_ExpenseCategory ap_lookup_codes.LOOKUP_CODE%TYPE;
897: L_ExpenseAmount NUMBER := 0;

Line 904: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;

900: L_AllowableAmount NUMBER;
901: L_Convert BOOLEAN := FALSE;
902: L_StartDate DATE;
903: L_EndDate DATE;
904: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
905: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
906: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
907: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
908: L_NumberOfViolations NUMBER;

Line 905: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;

901: L_Convert BOOLEAN := FALSE;
902: L_StartDate DATE;
903: L_EndDate DATE;
904: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
905: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
906: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
907: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
908: L_NumberOfViolations NUMBER;
909:

Line 1102: FROM ap_expense_report_headers_all aerh,

1098: P_ExchangeRateType,
1099: apv.allowable_amount
1100: )) as allowable_amount,
1101: 1 as number_of_violations
1102: FROM ap_expense_report_headers_all aerh,
1103: ap_pol_violations_all apv
1104: WHERE aerh.report_header_id = apv.report_header_id
1105: AND aerh.org_id = apv.org_id
1106: AND apv.distribution_line_number = -1

Line 1136: FROM ap_expense_report_headers_all aerh,

1132: P_ExchangeRateType,
1133: apv.allowable_amount
1134: )) as allowable_amount,
1135: 1 as number_of_violations
1136: FROM ap_expense_report_headers_all aerh,
1137: ap_pol_violations_all apv,
1138: per_all_assignments_f paf
1139: WHERE aerh.report_header_id = apv.report_header_id
1140: AND aerh.org_id = apv.org_id

Line 1445: employee_id ap_expense_report_headers.EMPLOYEE_ID%TYPE,

1441: P_QryType IN VARCHAR2 ) IS
1442:
1443: -- Declare program variables
1444: TYPE ByViolationTypeRecType IS RECORD (
1445: employee_id ap_expense_report_headers.EMPLOYEE_ID%TYPE,
1446: violation_line_amount NUMBER,
1447: violation_amount NUMBER,
1448: allowable_amount NUMBER,
1449: percent_violation NUMBER,

Line 1464: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;

1460: -- Local Variables
1461: L_ByViolTypeTab ByViolationTypeTabType;
1462:
1463: L_TabIndex BINARY_INTEGER := 0;
1464: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
1465: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
1466: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
1467: L_ViolationType ap_lookup_codes.LOOKUP_CODE%TYPE;
1468: L_ViolationLineAmount NUMBER;

Line 1474: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;

1470: L_AllowableAmount NUMBER;
1471: L_Convert BOOLEAN := FALSE;
1472: L_StartDate DATE;
1473: L_EndDate DATE;
1474: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
1475: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
1476: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
1477: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
1478: L_NumberOfViolations NUMBER;

Line 1475: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;

1471: L_Convert BOOLEAN := FALSE;
1472: L_StartDate DATE;
1473: L_EndDate DATE;
1474: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
1475: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
1476: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
1477: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
1478: L_NumberOfViolations NUMBER;
1479:

Line 1629: FROM ap_expense_report_headers_all aerh,

1625: P_ExchangeRateType,
1626: apv.allowable_amount
1627: )) as allowable_amount,
1628: 1 as number_of_violations
1629: FROM ap_expense_report_headers_all aerh,
1630: ap_pol_violations_all apv
1631: WHERE aerh.report_header_id = apv.report_header_id
1632: AND aerh.org_id = apv.org_id
1633: AND apv.distribution_line_number = -1

Line 1663: FROM ap_expense_report_headers_all aerh,

1659: P_ExchangeRateType,
1660: apv.allowable_amount
1661: )) as allowable_amount,
1662: 1 as number_of_violations
1663: FROM ap_expense_report_headers_all aerh,
1664: ap_pol_violations_all apv,
1665: per_all_assignments_f paf
1666: WHERE aerh.report_header_id = apv.report_header_id
1667: AND aerh.org_id = apv.org_id