565:
566: l_colon NUMBER;
567: l_itemtype VARCHAR2(7);
568: l_itemkey VARCHAR2(15);
569: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
570: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
571: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
572: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
573: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
566: l_colon NUMBER;
567: l_itemtype VARCHAR2(7);
568: l_itemkey VARCHAR2(15);
569: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
570: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
571: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
572: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
573: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
574: l_dateFormat VARCHAR2(30);
567: l_itemtype VARCHAR2(7);
568: l_itemkey VARCHAR2(15);
569: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
570: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
571: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
572: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
573: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
574: l_dateFormat VARCHAR2(30);
575: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
568: l_itemkey VARCHAR2(15);
569: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
570: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
571: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
572: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
573: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
574: l_dateFormat VARCHAR2(30);
575: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
576: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
569: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
570: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
571: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
572: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
573: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
574: l_dateFormat VARCHAR2(30);
575: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
576: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
577: l_merchant_City AP_WEB_DB_CCARD_PKG.ccTrxn_merchantCity;
571: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
572: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
573: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
574: l_dateFormat VARCHAR2(30);
575: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
576: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
577: l_merchant_City AP_WEB_DB_CCARD_PKG.ccTrxn_merchantCity;
578: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
579: l_total_billed_amt NUMBER := 0;
572: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
573: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
574: l_dateFormat VARCHAR2(30);
575: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
576: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
577: l_merchant_City AP_WEB_DB_CCARD_PKG.ccTrxn_merchantCity;
578: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
579: l_total_billed_amt NUMBER := 0;
580: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
573: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
574: l_dateFormat VARCHAR2(30);
575: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
576: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
577: l_merchant_City AP_WEB_DB_CCARD_PKG.ccTrxn_merchantCity;
578: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
579: l_total_billed_amt NUMBER := 0;
580: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
581: l_lineInfo VARCHAR2(2000);
574: l_dateFormat VARCHAR2(30);
575: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
576: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
577: l_merchant_City AP_WEB_DB_CCARD_PKG.ccTrxn_merchantCity;
578: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
579: l_total_billed_amt NUMBER := 0;
580: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
581: l_lineInfo VARCHAR2(2000);
582: l_debugInfo VARCHAR2(1000);
576: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
577: l_merchant_City AP_WEB_DB_CCARD_PKG.ccTrxn_merchantCity;
578: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
579: l_total_billed_amt NUMBER := 0;
580: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
581: l_lineInfo VARCHAR2(2000);
582: l_debugInfo VARCHAR2(1000);
583: l_orgId NUMBER;
584: l_InactEmpCCTrxn_cursor InactEmpCCTrxnCursor;