APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_WEB_DB_AP_INT_PKG

Line 1816: SELECT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(credit_card_trx_id)

1812: BEGIN
1813:
1814: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'Start InsertCCLine');
1815:
1816: SELECT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(credit_card_trx_id)
1817: INTO l_clearning_ccid
1818: FROM ap_expense_report_lines erl
1819: WHERE report_line_id = p_report_line_id;
1820:

Line 2530: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := 0;

2526: --------------------------------------------------------------------------------
2527: l_prepaid_amt expLines_amount;
2528: l_parameterId number;
2529: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;
2530: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := 0;
2531: l_baseAmt AP_WEB_DB_AP_INT_PKG.invAll_baseAmount;
2532: l_totalCCardAmt NUMBER := 0;
2533: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;
2534: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;

Line 2531: l_baseAmt AP_WEB_DB_AP_INT_PKG.invAll_baseAmount;

2527: l_prepaid_amt expLines_amount;
2528: l_parameterId number;
2529: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;
2530: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := 0;
2531: l_baseAmt AP_WEB_DB_AP_INT_PKG.invAll_baseAmount;
2532: l_totalCCardAmt NUMBER := 0;
2533: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;
2534: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;
2535: l_cardProgramID NUMBER;

Line 3427: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange( l_exchange_rate_type);

3423: INTO l_NewReportLineID
3424: FROM DUAL;
3425:
3426: -- Bug 6689280 (sodash)
3427: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange( l_exchange_rate_type);
3428:
3429: IF (l_from_currency_code <> l_to_currency_code) THEN
3430: l_exchange_rate := AP_UTILITIES_PKG.get_exchange_rate
3431: (l_from_currency_code,

Line 3823: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange( l_exchange_rate_type);

3819: INTO l_NewReportLineID
3820: FROM DUAL;
3821:
3822: -- Bug 6689280 (sodash)
3823: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange( l_exchange_rate_type);
3824:
3825: IF (l_from_currency_code <> l_to_currency_code) THEN
3826: l_exchange_rate := AP_UTILITIES_PKG.get_exchange_rate
3827: (l_from_currency_code,