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 347: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;

343: L_EffectiveStartDate DATE;
344: L_EffectiveEndDate DATE;
345: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
346: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
347: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
348: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
349: L_NumberOfViolations NUMBER;
350:
351: --

Line 348: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;

344: L_EffectiveEndDate DATE;
345: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
346: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
347: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
348: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
349: L_NumberOfViolations NUMBER;
350:
351: --
352: -- Cursor to fetch the line amounts for an employee for an expense category

Line 369: FROM ap_expense_report_lines_v aerl

365: sysdate,
366: P_ExchangeRateType,
367: aerl.amount
368: ))) as expense_amount
369: FROM ap_expense_report_lines_v aerl
370: WHERE aerl.employee_id = P_EmployeeId
371: AND aerl.week_end_date between P_StartDate and P_EndDate
372: AND nvl(aerl.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerl.category_code, 'ALL'), P_ExpenseCategory);
373:

Line 395: FROM ap_expense_report_lines_v aerl

391: sysdate,
392: P_ExchangeRateType,
393: aerl.amount
394: )) as line_amount
395: FROM ap_expense_report_lines_v aerl
396: WHERE EXISTS ( SELECT 'X'
397: FROM ap_pol_violations_all apv
398: WHERE apv.report_header_id = aerl.report_header_id
399: AND apv.distribution_line_number = aerl.distribution_line_number

Line 889: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;

885: L_StartDate DATE;
886: L_EndDate DATE;
887: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
888: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
889: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
890: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
891: L_NumberOfViolations NUMBER;
892:
893:

Line 890: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;

886: L_EndDate DATE;
887: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
888: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
889: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
890: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
891: L_NumberOfViolations NUMBER;
892:
893:
894: --

Line 924: FROM ap_expense_report_lines_v aerl

920: sysdate,
921: P_ExchangeRateType,
922: aerl.amount
923: )) as expense_amount
924: FROM ap_expense_report_lines_v aerl
925: WHERE ((aerl.employee_id= P_EmployeeId) or (aerl.paid_on_behalf_employee_id = P_EmployeeId))
926: AND aerl.week_end_date BETWEEN P_StartDate AND P_EndDate
927: AND nvl(aerl.category_code, 'ALL') = decode (P_ExpenseCategory, 'ALL', nvl(aerl.category_code, 'ALL'), P_ExpenseCategory)
928: UNION ALL

Line 937: ap_expense_report_lines_v aerl

933: P_ExchangeRateType,
934: aerl.amount
935: )) as expense_amount
936: FROM per_all_assignments_f paf,
937: ap_expense_report_lines_v aerl
938: WHERE paf.supervisor_id = P_EmployeeId
939: AND paf.effective_start_date < P_EndDate
940: AND paf.effective_end_date > P_StartDate
941: AND (paf.assignment_type = 'E' OR paf.assignment_type = 'C')

Line 969: FROM ap_expense_report_lines_v aerl

965: sysdate,
966: P_ExchangeRateType,
967: aerl.amount
968: )) as line_amount
969: FROM ap_expense_report_lines_v aerl
970: WHERE EXISTS ( SELECT 'X'
971: FROM ap_pol_violations_all apv
972: WHERE apv.report_header_id = aerl.report_header_id
973: AND apv.distribution_line_number = aerl.distribution_line_number

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: per_all_assignments_f paf
988: WHERE EXISTS ( SELECT 'X'
989: FROM ap_pol_violations_all apv
990: WHERE apv.report_header_id = aerl.report_header_id

Line 1455: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;

1451: L_StartDate DATE;
1452: L_EndDate DATE;
1453: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
1454: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
1455: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
1456: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
1457: L_NumberOfViolations NUMBER;
1458:
1459:

Line 1456: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;

1452: L_EndDate DATE;
1453: L_PrevReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
1454: L_ReportHeaderId ap_expense_report_headers.REPORT_HEADER_ID%TYPE := 0;
1455: L_PrevDistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
1456: L_DistributionLineNumber ap_expense_report_lines.DISTRIBUTION_LINE_NUMBER%TYPE;
1457: L_NumberOfViolations NUMBER;
1458:
1459:
1460: --

Line 1491: FROM ap_expense_report_lines_v aerl

1487: sysdate,
1488: P_ExchangeRateType,
1489: aerl.amount
1490: )) as line_amount
1491: FROM ap_expense_report_lines_v aerl
1492: WHERE EXISTS ( SELECT 'X'
1493: FROM ap_pol_violations_all apv
1494: WHERE apv.report_header_id = aerl.report_header_id
1495: AND apv.distribution_line_number = aerl.distribution_line_number

Line 1508: FROM ap_expense_report_lines_v aerl,

1504: sysdate,
1505: P_ExchangeRateType,
1506: aerl.amount
1507: )) as line_amount
1508: FROM ap_expense_report_lines_v aerl,
1509: per_all_assignments_f paf
1510: WHERE EXISTS ( SELECT 'X'
1511: FROM ap_pol_violations_all apv
1512: WHERE apv.report_header_id = aerl.report_header_id