DBA Data[Home] [Help]

APPS.AP_CREDIT_CARD_INVOICE_PKG dependencies on AP_WEB_DB_EXPLINE_PKG

Line 422: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;

418: p_expReportHeaderId IN NUMBER,
419: p_glDate IN DATE,
420: p_periodName IN VARCHAR2)
421: IS
422: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;
423: l_debugInfo VARCHAR2(2000);
424: l_clearingCCID NUMBER;
425: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := 0;
426: l_baseAmt AP_WEB_DB_AP_INT_PKG.invAll_baseAmount;

Line 433: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;

429: l_minAcctUnit AP_WEB_DB_COUNTRY_PKG.curr_minAcctUnit ;
430: l_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
431: l_exchangeRate AP_WEB_DB_AP_INT_PKG.invAll_exchangeRate;
432: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;
433: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;
434: l_cardProgramID NUMBER;
435: l_Personal VARCHAR2(10);
436: l_org_id NUMBER;
437: l_transaction_date DATE;

Line 453: if (AP_WEB_DB_EXPLINE_PKG.GetCCardLineCursor(p_expReportHeaderId, l_cCardLineCursor) <> TRUE) THEN

449:
450: ------------------------------------------------------------------
451: l_debugInfo := 'Get the credit card report line cursor.';
452: ----------------------------------------------------------------
453: if (AP_WEB_DB_EXPLINE_PKG.GetCCardLineCursor(p_expReportHeaderId, l_cCardLineCursor) <> TRUE) THEN
454: raise NO_DATA_FOUND;
455: END IF;
456:
457: ------------------------------------------------------------------

Line 565: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;

561: p_expReportHeaderId IN NUMBER,
562: p_gl_date IN DATE,
563: p_invoiceTotal IN NUMBER)
564: RETURN NUMBER IS
565: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;
566: l_debugInfo VARCHAR2(2000);
567: l_clearingCCID NUMBER;
568: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := p_invoiceTotal;
569: l_totalCCardAmt NUMBER := 0;

Line 571: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;

567: l_clearingCCID NUMBER;
568: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := p_invoiceTotal;
569: l_totalCCardAmt NUMBER := 0;
570: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;
571: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;
572: l_cardProgramID NUMBER;
573: l_Personal VARCHAR2(10);
574: l_callingSequence varchar2(100);
575: l_org_id NUMBER;

Line 591: /*if (AP_WEB_DB_EXPLINE_PKG.GetCCardLineCursor(p_expReportHeaderId,

587: end if;
588: ------------------------------------------------------------------
589: l_debugInfo := 'Get the credit card report line cursor.';
590: ------------------------------------------------------------------
591: /*if (AP_WEB_DB_EXPLINE_PKG.GetCCardLineCursor(p_expReportHeaderId,
592: l_cCardLineCursor) <> TRUE) THEN
593: raise NO_DATA_FOUND;
594: END IF;*/
595: