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_LINES

Line 358: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;

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:
362: --

Line 359: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;

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:
362: --
363: -- Cursor to fetch the line amounts for an employee for an expense category

Line 380: FROM ap_expense_report_lines_v aerl

376: sysdate,
377: P_ExchangeRateType,
378: aerl.amount
379: ))) as expense_amount
380: FROM ap_expense_report_lines_v aerl
381: WHERE aerl.employee_id = P_EmployeeId
382: AND aerl.week_end_date between P_StartDate and P_EndDate
383: AND nvl(aerl.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerl.category_code, 'ALL'), P_ExpenseCategory);
384:

Line 406: FROM ap_expense_report_lines_v aerl

402: sysdate,
403: P_ExchangeRateType,
404: aerl.amount
405: )) as line_amount
406: FROM ap_expense_report_lines_v aerl
407: WHERE EXISTS ( SELECT 'X'
408: FROM ap_pol_violations_all apv
409: WHERE apv.report_header_id = aerl.report_header_id
410: AND apv.distribution_line_number = aerl.distribution_line_number

Line 906: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;

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:
910:

Line 907: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;

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:
910:
911: --

Line 941: FROM ap_expense_report_lines_v aerl

937: sysdate,
938: P_ExchangeRateType,
939: aerl.amount
940: )) as expense_amount
941: FROM ap_expense_report_lines_v aerl
942: WHERE ((aerl.employee_id= P_EmployeeId) or (aerl.paid_on_behalf_employee_id = P_EmployeeId))
943: AND aerl.week_end_date BETWEEN P_StartDate AND P_EndDate
944: AND nvl(aerl.category_code, 'ALL') = decode (P_ExpenseCategory, 'ALL', nvl(aerl.category_code, 'ALL'), P_ExpenseCategory)
945: UNION ALL

Line 954: ap_expense_report_lines_v aerl

950: P_ExchangeRateType,
951: aerl.amount
952: )) as expense_amount
953: FROM per_all_assignments_f paf,
954: ap_expense_report_lines_v aerl
955: WHERE paf.supervisor_id = P_EmployeeId
956: AND paf.effective_start_date < P_EndDate
957: AND paf.effective_end_date > P_StartDate
958: AND (paf.assignment_type = 'E' OR paf.assignment_type = 'C')

Line 986: FROM ap_expense_report_lines_v aerl

982: sysdate,
983: P_ExchangeRateType,
984: aerl.amount
985: )) as line_amount
986: FROM ap_expense_report_lines_v aerl
987: WHERE EXISTS ( SELECT 'X'
988: FROM ap_pol_violations_all apv
989: WHERE apv.report_header_id = aerl.report_header_id
990: AND apv.distribution_line_number = aerl.distribution_line_number

Line 1003: FROM ap_expense_report_lines_v aerl,

999: sysdate,
1000: P_ExchangeRateType,
1001: aerl.amount
1002: )) as line_amount
1003: FROM ap_expense_report_lines_v aerl,
1004: per_all_assignments_f paf
1005: WHERE EXISTS ( SELECT 'X'
1006: FROM ap_pol_violations_all apv
1007: WHERE apv.report_header_id = aerl.report_header_id

Line 1476: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;

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:
1480:

Line 1477: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;

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:
1480:
1481: --

Line 1512: FROM ap_expense_report_lines_v aerl

1508: sysdate,
1509: P_ExchangeRateType,
1510: aerl.amount
1511: )) as line_amount
1512: FROM ap_expense_report_lines_v aerl
1513: WHERE EXISTS ( SELECT 'X'
1514: FROM ap_pol_violations_all apv
1515: WHERE apv.report_header_id = aerl.report_header_id
1516: AND apv.distribution_line_number = aerl.distribution_line_number

Line 1529: FROM ap_expense_report_lines_v aerl,

1525: sysdate,
1526: P_ExchangeRateType,
1527: aerl.amount
1528: )) as line_amount
1529: FROM ap_expense_report_lines_v aerl,
1530: per_all_assignments_f paf
1531: WHERE EXISTS ( SELECT 'X'
1532: FROM ap_pol_violations_all apv
1533: WHERE apv.report_header_id = aerl.report_header_id