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_DB_EXPLINE_PKG dependencies on AP_WEB_DB_AP_INT_PKG

Line 2060: SELECT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(credit_card_trx_id)

2056: BEGIN
2057:
2058: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'Start InsertCCLine');
2059:
2060: SELECT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(credit_card_trx_id)
2061: INTO l_clearning_ccid
2062: FROM ap_expense_report_lines erl
2063: WHERE report_line_id = p_report_line_id;
2064:

Line 2787: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := 0;

2783: --------------------------------------------------------------------------------
2784: l_prepaid_amt expLines_amount;
2785: l_parameterId number;
2786: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;
2787: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := 0;
2788: l_baseAmt AP_WEB_DB_AP_INT_PKG.invAll_baseAmount;
2789: l_totalCCardAmt NUMBER := 0;
2790: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;
2791: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;

Line 2788: l_baseAmt AP_WEB_DB_AP_INT_PKG.invAll_baseAmount;

2784: l_prepaid_amt expLines_amount;
2785: l_parameterId number;
2786: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;
2787: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := 0;
2788: l_baseAmt AP_WEB_DB_AP_INT_PKG.invAll_baseAmount;
2789: l_totalCCardAmt NUMBER := 0;
2790: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;
2791: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;
2792: l_cardProgramID NUMBER;

Line 3714: AP_WEB_DB_AP_INT_PKG.GetDefaultExchangeRates(l_default_exchange_rates, l_exchange_rate_allowance);

3710: INTO l_NewReportLineID
3711: FROM DUAL;
3712:
3713: -- Bug# 9182883: Get the default exchange rates and the allowance rate
3714: AP_WEB_DB_AP_INT_PKG.GetDefaultExchangeRates(l_default_exchange_rates, l_exchange_rate_allowance);
3715:
3716: IF l_default_exchange_rates = 'Y' THEN
3717: -- Bug 6689280 (sodash)
3718: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange( l_exchange_rate_type);

Line 3718: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange( l_exchange_rate_type);

3714: AP_WEB_DB_AP_INT_PKG.GetDefaultExchangeRates(l_default_exchange_rates, l_exchange_rate_allowance);
3715:
3716: IF l_default_exchange_rates = 'Y' THEN
3717: -- Bug 6689280 (sodash)
3718: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange( l_exchange_rate_type);
3719:
3720: IF (l_from_currency_code <> l_to_currency_code) THEN
3721: l_exchange_rate := AP_UTILITIES_PKG.get_exchange_rate
3722: (l_from_currency_code,

Line 4123: AP_WEB_DB_AP_INT_PKG.GetDefaultExchangeRates(l_default_exchange_rates, l_exchange_rate_allowance);

4119: INTO l_NewReportLineID
4120: FROM DUAL;
4121:
4122: -- Bug# 9182883: Get the default exchange rates and the allowance rate
4123: AP_WEB_DB_AP_INT_PKG.GetDefaultExchangeRates(l_default_exchange_rates, l_exchange_rate_allowance);
4124:
4125: -- Bug: 9920631, Exchange rate should be defaulted on the duplicated report.
4126: IF l_default_exchange_rates = 'N' THEN
4127: l_exchange_rate_allowance := 0;

Line 4130: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange( l_exchange_rate_type);

4126: IF l_default_exchange_rates = 'N' THEN
4127: l_exchange_rate_allowance := 0;
4128: END IF;
4129: -- Bug 6689280 (sodash)
4130: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange( l_exchange_rate_type);
4131:
4132: IF (l_from_currency_code <> l_to_currency_code) THEN
4133: l_exchange_rate := AP_UTILITIES_PKG.get_exchange_rate
4134: (l_from_currency_code,