APPS.AP_CREDIT_CARD_INVOICE_PKG dependencies on AP_WEB_DB_EXPLINE_PKG

Line 412: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;

408: p_expReportHeaderId IN NUMBER,
409: p_glDate IN DATE,
410: p_periodName IN VARCHAR2)
411: IS
412: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;
413: l_debugInfo VARCHAR2(2000);
414: l_clearingCCID NUMBER;
415: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := 0;
416: l_baseAmt AP_WEB_DB_AP_INT_PKG.invAll_baseAmount;

Line 423: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;

419: l_minAcctUnit AP_WEB_DB_COUNTRY_PKG.curr_minAcctUnit ;
420: l_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
421: l_exchangeRate AP_WEB_DB_AP_INT_PKG.invAll_exchangeRate;
422: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;
423: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;
424: l_cardProgramID NUMBER;
425: l_Personal VARCHAR2(10);
426: l_org_id NUMBER;
427: l_transaction_date DATE;

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

439:
440: ------------------------------------------------------------------
441: l_debugInfo := 'Get the credit card report line cursor.';
442: ----------------------------------------------------------------
443: if (AP_WEB_DB_EXPLINE_PKG.GetCCardLineCursor(p_expReportHeaderId, l_cCardLineCursor) <> TRUE) THEN
444: raise NO_DATA_FOUND;
445: END IF;
446:
447: ------------------------------------------------------------------

Line 555: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;

551: p_expReportHeaderId IN NUMBER,
552: p_gl_date IN DATE,
553: p_invoiceTotal IN NUMBER)
554: RETURN NUMBER IS
555: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;
556: l_debugInfo VARCHAR2(2000);
557: l_clearingCCID NUMBER;
558: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := p_invoiceTotal;
559: l_totalCCardAmt NUMBER := 0;

Line 561: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;

557: l_clearingCCID NUMBER;
558: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := p_invoiceTotal;
559: l_totalCCardAmt NUMBER := 0;
560: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;
561: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;
562: l_cardProgramID NUMBER;
563: l_Personal VARCHAR2(10);
564: l_callingSequence varchar2(100);
565: l_org_id NUMBER;

Line 574: if (AP_WEB_DB_EXPLINE_PKG.GetCCardLineCursor(p_expReportHeaderId,

570: l_callingSequence := 'createCreditCardReversals';
571: ------------------------------------------------------------------
572: l_debugInfo := 'Get the credit card report line cursor.';
573: ------------------------------------------------------------------
574: if (AP_WEB_DB_EXPLINE_PKG.GetCCardLineCursor(p_expReportHeaderId,
575: l_cCardLineCursor) <> TRUE) THEN
576: raise NO_DATA_FOUND;
577: END IF;
578: