DBA Data[Home] [Help]

APPS.AP_WEB_INACTIVE_EMP_WF_PKG dependencies on AP_WEB_DB_CCARD_PKG

Line 569: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

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;

Line 570: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

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);

Line 571: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

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;

Line 572: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

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;

Line 573: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

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;

Line 575: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

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;

Line 576: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

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;

Line 577: l_merchant_City AP_WEB_DB_CCARD_PKG.ccTrxn_merchantCity;

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);

Line 578: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

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);

Line 580: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

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;