eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_CREDIT_CARD_WF dependencies on AP_WEB_DB_CCARD_PKG

Line 329: l_cardProgramID AP_WEB_DB_CCARD_PKG.cardProgs_cardProgID;

325: l_managerName wf_users.name%type;
326: l_managerDisplayName wf_users.display_name%type;
327: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
328: l_debugInfo VARCHAR2(200);
329: l_cardProgramID AP_WEB_DB_CCARD_PKG.cardProgs_cardProgID;
330: l_orgId number;
331: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
332: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
333:

Line 410: IF (NOT AP_WEB_DB_CCARD_PKG.GetCardProgramID(p_cardIssuer,

406:
407: --------------------------------------------------------------
408: l_debugInfo := 'Set WF CREDIT_CARD_COMPANY Item Attribute';
409: --------------------------------------------------------------
410: IF (NOT AP_WEB_DB_CCARD_PKG.GetCardProgramID(p_cardIssuer,
411: l_cardProgramID ) ) THEN
412: NULL;
413: END IF;
414:

Line 547: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;

543: l_managerName wf_users.name%type;
544: l_managerDisplayName wf_users.display_name%type;
545: l_employeeDisplayName wf_users.display_name%type;
546: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
547: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
548: l_orgId number;
549: l_debugInfo VARCHAR2(200);
550: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
551: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

Line 843: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(p_cardProgramID,p_employeeId,

839: END IF;
840:
841: END IF;
842:
843: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(p_cardProgramID,p_employeeId,
844: l_total_amount ) ) THEN
845: NULL;
846: END IF;
847:

Line 909: IF (NOT AP_WEB_DB_CCARD_PKG.GetCardProgramName(p_cardProgramID,

905:
906: --------------------------------------------------------------
907: l_debugInfo := 'Set WF CREDIT_CARD_COMPANY Item Attribute';
908: --------------------------------------------------------------
909: IF (NOT AP_WEB_DB_CCARD_PKG.GetCardProgramName(p_cardProgramID,
910: l_cardProgramName ) ) THEN
911: NULL;
912: END IF;
913:

Line 1224: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;

1220: l_employeeId number;
1221: l_employeeName wf_users.name%type;
1222: l_employeeDisplayName wf_users.display_name%type;
1223: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1224: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
1225: l_sysdate VARCHAR2(30);
1226: l_today DATE;
1227: l_orgId number;
1228: l_days number;

Line 1282: IF (NOT AP_WEB_DB_CCARD_PKG.GetCardProgramName(p_cardProgramID,

1278:
1279: --------------------------------------------------------------
1280: l_debugInfo := 'Set WF CREDIT_CARD_COMPANY Item Attribute';
1281: --------------------------------------------------------------
1282: IF (NOT AP_WEB_DB_CCARD_PKG.GetCardProgramName(p_cardProgramID,
1283: l_cardProgramName ) ) THEN
1284: NULL;
1285: END IF;
1286:

Line 1393: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

1389:
1390: l_colon NUMBER;
1391: l_itemtype VARCHAR2(7);
1392: l_itemkey VARCHAR2(15);
1393: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1394: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1395: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1396: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1397: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

Line 1394: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

1390: l_colon NUMBER;
1391: l_itemtype VARCHAR2(7);
1392: l_itemkey VARCHAR2(15);
1393: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1394: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1395: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1396: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1397: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1398: l_dateFormat varchar2(30);

Line 1395: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

1391: l_itemtype VARCHAR2(7);
1392: l_itemkey VARCHAR2(15);
1393: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1394: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1395: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1396: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1397: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1398: l_dateFormat varchar2(30);
1399: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

Line 1396: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

1392: l_itemkey VARCHAR2(15);
1393: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1394: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1395: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1396: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1397: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1398: l_dateFormat varchar2(30);
1399: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1400: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

Line 1397: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

1393: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1394: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1395: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1396: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1397: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1398: l_dateFormat varchar2(30);
1399: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1400: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1401: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

Line 1399: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

1395: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1396: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1397: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1398: l_dateFormat varchar2(30);
1399: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1400: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1401: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1402: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1403: l_lineInfo VARCHAR2(2000);

Line 1400: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

1396: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1397: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1398: l_dateFormat varchar2(30);
1399: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1400: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1401: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1402: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1403: l_lineInfo VARCHAR2(2000);
1404: l_debugInfo VARCHAR2(1000);

Line 1401: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

1397: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1398: l_dateFormat varchar2(30);
1399: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1400: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1401: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1402: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1403: l_lineInfo VARCHAR2(2000);
1404: l_debugInfo VARCHAR2(1000);
1405: l_orgId number;

Line 1402: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

1398: l_dateFormat varchar2(30);
1399: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1400: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1401: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1402: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1403: l_lineInfo VARCHAR2(2000);
1404: l_debugInfo VARCHAR2(1000);
1405: l_orgId number;
1406: l_disputedCharges_cursor AP_WEB_DB_CCARD_PKG.DisputedCCTrxnCursor;

Line 1406: l_disputedCharges_cursor AP_WEB_DB_CCARD_PKG.DisputedCCTrxnCursor;

1402: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1403: l_lineInfo VARCHAR2(2000);
1404: l_debugInfo VARCHAR2(1000);
1405: l_orgId number;
1406: l_disputedCharges_cursor AP_WEB_DB_CCARD_PKG.DisputedCCTrxnCursor;
1407: l_dispute_header_prompt VARCHAR2(200);
1408:
1409: BEGIN
1410:

Line 1471: IF (NOT AP_WEB_DB_CCARD_PKG.GetDisputedCcardTrxnCursor(l_cardProgramId,

1467: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1468:
1469: l_debugInfo := 'Loop over all the Disputed charges';
1470:
1471: IF (NOT AP_WEB_DB_CCARD_PKG.GetDisputedCcardTrxnCursor(l_cardProgramId,
1472: l_minimumAmount, l_employeeId, l_billedStartDate,
1473: l_billedEndDate, l_DisputedCharges_cursor)) THEN
1474: NULL;
1475: END IF;

Line 1572: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

1568:
1569: l_colon NUMBER;
1570: l_itemtype VARCHAR2(7);
1571: l_itemkey VARCHAR2(15);
1572: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1573: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1574: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1575: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1576: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

Line 1573: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

1569: l_colon NUMBER;
1570: l_itemtype VARCHAR2(7);
1571: l_itemkey VARCHAR2(15);
1572: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1573: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1574: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1575: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1576: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1577: l_dateFormat varchar2(30);

Line 1574: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

1570: l_itemtype VARCHAR2(7);
1571: l_itemkey VARCHAR2(15);
1572: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1573: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1574: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1575: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1576: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1577: l_dateFormat varchar2(30);
1578: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

Line 1575: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

1571: l_itemkey VARCHAR2(15);
1572: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1573: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1574: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1575: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1576: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1577: l_dateFormat varchar2(30);
1578: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1579: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

Line 1576: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

1572: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1573: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1574: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1575: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1576: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1577: l_dateFormat varchar2(30);
1578: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1579: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1580: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

Line 1578: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

1574: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1575: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1576: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1577: l_dateFormat varchar2(30);
1578: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1579: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1580: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1581: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1582: l_lineInfo VARCHAR2(2000);

Line 1579: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

1575: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1576: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1577: l_dateFormat varchar2(30);
1578: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1579: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1580: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1581: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1582: l_lineInfo VARCHAR2(2000);
1583: l_debugInfo VARCHAR2(1000);

Line 1580: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

1576: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1577: l_dateFormat varchar2(30);
1578: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1579: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1580: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1581: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1582: l_lineInfo VARCHAR2(2000);
1583: l_debugInfo VARCHAR2(1000);
1584: l_orgId number;

Line 1581: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

1577: l_dateFormat varchar2(30);
1578: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1579: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1580: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1581: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1582: l_lineInfo VARCHAR2(2000);
1583: l_debugInfo VARCHAR2(1000);
1584: l_orgId number;
1585: l_UnsubmittedCharges_cursor AP_WEB_DB_CCARD_PKG.UnsubmittedCCTrxnCursor;

Line 1585: l_UnsubmittedCharges_cursor AP_WEB_DB_CCARD_PKG.UnsubmittedCCTrxnCursor;

1581: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1582: l_lineInfo VARCHAR2(2000);
1583: l_debugInfo VARCHAR2(1000);
1584: l_orgId number;
1585: l_UnsubmittedCharges_cursor AP_WEB_DB_CCARD_PKG.UnsubmittedCCTrxnCursor;
1586: l_expense_report_number VARCHAR2(60);
1587: l_expense_report_status VARCHAR2(30);
1588: l_displayed_status VARCHAR2(60);
1589: l_chargeType VARCHAR2(60);

Line 1592: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;

1588: l_displayed_status VARCHAR2(60);
1589: l_chargeType VARCHAR2(60);
1590: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;
1591: l_title AK_REGIONS_VL.name%TYPE;
1592: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
1593: l_detail_header_prompt VARCHAR2(200);
1594: l_document long;
1595: l_document_max NUMBER := 25000;
1596:

Line 1683: IF (NOT AP_WEB_DB_CCARD_PKG.GetUnsubmittedCcardTrxnCursor(l_cardProgramId,

1679: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1680:
1681: l_debugInfo := 'Loop over all the Unsubmitted charges ';
1682:
1683: IF (NOT AP_WEB_DB_CCARD_PKG.GetUnsubmittedCcardTrxnCursor(l_cardProgramId,
1684: l_employeeId, l_billedStartDate,
1685: l_billedEndDate, l_minimumAmount, l_chargeType, l_UnsubmittedCharges_cursor)) THEN
1686: NULL;
1687: END IF;

Line 1826: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

1822:
1823: l_colon NUMBER;
1824: l_itemtype VARCHAR2(7);
1825: l_itemkey VARCHAR2(15);
1826: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1827: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1828: l_dateFormat VARCHAR2(30);
1829: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1830: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

Line 1827: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

1823: l_colon NUMBER;
1824: l_itemtype VARCHAR2(7);
1825: l_itemkey VARCHAR2(15);
1826: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1827: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1828: l_dateFormat VARCHAR2(30);
1829: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1830: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1831: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

Line 1829: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

1825: l_itemkey VARCHAR2(15);
1826: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1827: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1828: l_dateFormat VARCHAR2(30);
1829: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1830: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1831: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1832: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1833: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

Line 1830: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

1826: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1827: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1828: l_dateFormat VARCHAR2(30);
1829: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1830: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1831: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1832: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1833: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1834: l_lineInfo VARCHAR2(2000);

Line 1831: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

1827: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1828: l_dateFormat VARCHAR2(30);
1829: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1830: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1831: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1832: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1833: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1834: l_lineInfo VARCHAR2(2000);
1835: l_debugInfo VARCHAR2(1000);

Line 1832: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

1828: l_dateFormat VARCHAR2(30);
1829: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1830: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1831: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1832: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1833: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1834: l_lineInfo VARCHAR2(2000);
1835: l_debugInfo VARCHAR2(1000);
1836: l_orgId NUMBER;

Line 1833: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

1829: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1830: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1831: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1832: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1833: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1834: l_lineInfo VARCHAR2(2000);
1835: l_debugInfo VARCHAR2(1000);
1836: l_orgId NUMBER;
1837: l_Dunning_cursor AP_WEB_DB_CCARD_PKG.DunningCCTrxnCursor;

Line 1837: l_Dunning_cursor AP_WEB_DB_CCARD_PKG.DunningCCTrxnCursor;

1833: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1834: l_lineInfo VARCHAR2(2000);
1835: l_debugInfo VARCHAR2(1000);
1836: l_orgId NUMBER;
1837: l_Dunning_cursor AP_WEB_DB_CCARD_PKG.DunningCCTrxnCursor;
1838: l_expense_report_number VARCHAR2(60);
1839: l_expense_report_status VARCHAR2(30);
1840: l_displayed_status VARCHAR2(60);
1841: l_min_bucket NUMBER;

Line 1857: l_Dispute_cursor AP_WEB_DB_CCARD_PKG.DisputeCCTrxnCursor; --Notification Esc

1853: l_posted_date AP_CREDIT_CARD_TRXNS_ALL.POSTED_DATE%TYPE; --Notification Esc
1854: l_posted_currency_code AP_CREDIT_CARD_TRXNS_ALL.POSTED_CURRENCY_CODE%TYPE;--3339380
1855: l_transaction_amount AP_CREDIT_CARD_TRXNS_ALL.TRANSACTION_AMOUNT%TYPE;--Notification Esc
1856: l_location AP_EXPENSE_REPORT_LINES_ALL.LOCATION%TYPE; --Notification Esc
1857: l_Dispute_cursor AP_WEB_DB_CCARD_PKG.DisputeCCTrxnCursor; --Notification Esc
1858:
1859: l_detail_header_prompt VARCHAR2(2000);
1860: l_dispute_header_prompt VARCHAR2(2000);
1861: l_grace_days NUMBER;

Line 1869: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;

1865:
1866:
1867:
1868: --Notification Project
1869: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
1870:
1871: BEGIN
1872:
1873:

Line 1957: IF (NOT AP_WEB_DB_CCARD_PKG.GetDunningCcardTrxnCursor(l_cardProgramId,

1953: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1954:
1955: l_debugInfo := 'Loop over all the Dunning Charges ';
1956:
1957: IF (NOT AP_WEB_DB_CCARD_PKG.GetDunningCcardTrxnCursor(l_cardProgramId,
1958: l_employeeId, l_min_bucket, l_max_bucket,
1959: l_Dunning_cursor)) THEN
1960: NULL;
1961: END IF;

Line 2053: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,

2049:
2050:
2051: --Amulya Mishra : Notification Esc Project: Disputed Trxns
2052:
2053: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,
2054: l_min_bucket, l_max_bucket ,
2055: l_grace_days,l_total_dispute,
2056: l_total_amt_dispute)) THEN
2057: NULL;

Line 2088: IF (NOT AP_WEB_DB_CCARD_PKG.GetDisputeCcardTrxnCursor(l_cardProgramId,

2084: end if;
2085:
2086: l_debugInfo := 'Loop over all the Disputed Charges ';
2087:
2088: IF (NOT AP_WEB_DB_CCARD_PKG.GetDisputeCcardTrxnCursor(l_cardProgramId,
2089: l_employeeId, l_min_bucket, l_max_bucket,l_grace_days,
2090: l_Dispute_cursor)) THEN
2091: NULL;
2092: END IF;

Line 2183: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

2179:
2180: l_colon NUMBER;
2181: l_itemtype VARCHAR2(7);
2182: l_itemkey VARCHAR2(15);
2183: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2184: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2185: l_dateFormat VARCHAR2(30);
2186: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2187: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

Line 2184: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

2180: l_colon NUMBER;
2181: l_itemtype VARCHAR2(7);
2182: l_itemkey VARCHAR2(15);
2183: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2184: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2185: l_dateFormat VARCHAR2(30);
2186: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2187: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2188: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

Line 2186: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

2182: l_itemkey VARCHAR2(15);
2183: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2184: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2185: l_dateFormat VARCHAR2(30);
2186: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2187: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2188: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2189: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2190: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

Line 2187: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

2183: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2184: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2185: l_dateFormat VARCHAR2(30);
2186: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2187: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2188: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2189: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2190: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2191: l_lineInfo VARCHAR2(2000);

Line 2188: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

2184: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2185: l_dateFormat VARCHAR2(30);
2186: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2187: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2188: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2189: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2190: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2191: l_lineInfo VARCHAR2(2000);
2192: l_debugInfo VARCHAR2(1000);

Line 2189: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

2185: l_dateFormat VARCHAR2(30);
2186: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2187: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2188: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2189: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2190: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2191: l_lineInfo VARCHAR2(2000);
2192: l_debugInfo VARCHAR2(1000);
2193: l_orgId NUMBER;

Line 2190: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

2186: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2187: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2188: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2189: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2190: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2191: l_lineInfo VARCHAR2(2000);
2192: l_debugInfo VARCHAR2(1000);
2193: l_orgId NUMBER;
2194: l_Total_cursor AP_WEB_DB_CCARD_PKG.UnsubmittedCCTrxnCursor;

Line 2194: l_Total_cursor AP_WEB_DB_CCARD_PKG.UnsubmittedCCTrxnCursor;

2190: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2191: l_lineInfo VARCHAR2(2000);
2192: l_debugInfo VARCHAR2(1000);
2193: l_orgId NUMBER;
2194: l_Total_cursor AP_WEB_DB_CCARD_PKG.UnsubmittedCCTrxnCursor;
2195: l_expense_report_number VARCHAR2(60);
2196: l_expense_report_status VARCHAR2(30);
2197: l_displayed_status VARCHAR2(60);
2198: l_instructions VARCHAR2(2000);

Line 2200: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

2196: l_expense_report_status VARCHAR2(30);
2197: l_displayed_status VARCHAR2(60);
2198: l_instructions VARCHAR2(2000);
2199:
2200: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2201: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2202: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2203: l_chargeType VARCHAR2(60);
2204: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;

Line 2201: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

2197: l_displayed_status VARCHAR2(60);
2198: l_instructions VARCHAR2(2000);
2199:
2200: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2201: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2202: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2203: l_chargeType VARCHAR2(60);
2204: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
2205:

Line 2202: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

2198: l_instructions VARCHAR2(2000);
2199:
2200: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2201: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2202: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2203: l_chargeType VARCHAR2(60);
2204: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
2205:
2206: BEGIN

Line 2204: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;

2200: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2201: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2202: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2203: l_chargeType VARCHAR2(60);
2204: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
2205:
2206: BEGIN
2207:
2208:

Line 2256: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalUnsubmittedCCCursor(l_cardProgramId,

2252: l_chargeType := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CHARGE_TYPE');
2253:
2254: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2255:
2256: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalUnsubmittedCCCursor(l_cardProgramId,
2257: l_employeeId, l_billedStartDate,
2258: l_billedEndDate, l_minimumAmount, l_chargeType, l_Total_cursor)) THEN
2259: NULL;
2260: END IF;

Line 2310: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

2306:
2307: l_colon NUMBER;
2308: l_itemtype VARCHAR2(7);
2309: l_itemkey VARCHAR2(15);
2310: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2311: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2312: l_dateFormat VARCHAR2(30);
2313: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2314: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

Line 2311: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

2307: l_colon NUMBER;
2308: l_itemtype VARCHAR2(7);
2309: l_itemkey VARCHAR2(15);
2310: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2311: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2312: l_dateFormat VARCHAR2(30);
2313: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2314: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2315: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

Line 2313: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

2309: l_itemkey VARCHAR2(15);
2310: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2311: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2312: l_dateFormat VARCHAR2(30);
2313: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2314: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2315: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2316: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2317: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

Line 2314: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

2310: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2311: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2312: l_dateFormat VARCHAR2(30);
2313: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2314: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2315: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2316: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2317: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2318: l_lineInfo VARCHAR2(2000);

Line 2315: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

2311: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2312: l_dateFormat VARCHAR2(30);
2313: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2314: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2315: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2316: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2317: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2318: l_lineInfo VARCHAR2(2000);
2319: l_debugInfo VARCHAR2(1000);

Line 2316: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

2312: l_dateFormat VARCHAR2(30);
2313: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2314: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2315: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2316: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2317: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2318: l_lineInfo VARCHAR2(2000);
2319: l_debugInfo VARCHAR2(1000);
2320: l_orgId NUMBER;

Line 2317: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

2313: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2314: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2315: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2316: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2317: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2318: l_lineInfo VARCHAR2(2000);
2319: l_debugInfo VARCHAR2(1000);
2320: l_orgId NUMBER;
2321: l_Total_cursor AP_WEB_DB_CCARD_PKG.TotalCCTrxnCursor;

Line 2321: l_Total_cursor AP_WEB_DB_CCARD_PKG.TotalCCTrxnCursor;

2317: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2318: l_lineInfo VARCHAR2(2000);
2319: l_debugInfo VARCHAR2(1000);
2320: l_orgId NUMBER;
2321: l_Total_cursor AP_WEB_DB_CCARD_PKG.TotalCCTrxnCursor;
2322: l_expense_report_number VARCHAR2(60);
2323: l_expense_report_status VARCHAR2(30);
2324: l_displayed_status VARCHAR2(60);
2325: l_min_bucket NUMBER;

Line 2330: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;

2326: l_max_bucket NUMBER;
2327: l_min_bucket1 VARCHAR2(30);
2328: l_max_bucket1 VARCHAR2(30);
2329: l_instructions VARCHAR2(2000);
2330: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
2331:
2332: BEGIN
2333:
2334:

Line 2376: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCcardTrxnCursor(l_cardProgramId,

2372: end if;
2373:
2374: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2375:
2376: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCcardTrxnCursor(l_cardProgramId,
2377: l_employeeId, l_min_bucket, l_max_bucket,
2378: l_Total_cursor)) THEN
2379: NULL;
2380: END IF;

Line 2437: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

2433:
2434: l_colon NUMBER;
2435: l_itemtype VARCHAR2(7);
2436: l_itemkey VARCHAR2(15);
2437: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2438: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2439: l_dateFormat VARCHAR2(30);
2440: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2441: l_lineInfo VARCHAR2(2000);

Line 2438: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

2434: l_colon NUMBER;
2435: l_itemtype VARCHAR2(7);
2436: l_itemkey VARCHAR2(15);
2437: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2438: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2439: l_dateFormat VARCHAR2(30);
2440: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2441: l_lineInfo VARCHAR2(2000);
2442: l_debugInfo VARCHAR2(1000);

Line 2440: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

2436: l_itemkey VARCHAR2(15);
2437: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2438: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2439: l_dateFormat VARCHAR2(30);
2440: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2441: l_lineInfo VARCHAR2(2000);
2442: l_debugInfo VARCHAR2(1000);
2443: l_orgId NUMBER;
2444: l_min_bucket NUMBER;

Line 2568: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(l_cardProgramId,l_employeeId,

2564:
2565:
2566: EXIT WHEN l_employee_cursor%NOTFOUND;
2567:
2568: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(l_cardProgramId,l_employeeId,
2569: l_min_bucket, l_max_bucket , l_total_outstanding,
2570: l_total_amt_outstanding)) THEN
2571: NULL;
2572: END IF;

Line 2576: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,

2572: END IF;
2573:
2574:
2575:
2576: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,
2577: l_min_bucket, l_max_bucket ,
2578: l_grace_days,l_total_dispute,
2579: l_total_amt_dispute)) THEN
2580: NULL;

Line 2585: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(l_cardProgramId,l_employeeId,

2581: END IF;
2582:
2583:
2584:
2585: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(l_cardProgramId,l_employeeId,
2586: l_total_amount ) ) THEN
2587: NULL;
2588: END IF;
2589:

Line 2688: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

2684:
2685: l_colon NUMBER;
2686: l_itemtype VARCHAR2(7);
2687: l_itemkey VARCHAR2(15);
2688: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2689: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2690: l_dateFormat VARCHAR2(30);
2691: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2692: l_lineInfo VARCHAR2(2000);

Line 2689: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

2685: l_colon NUMBER;
2686: l_itemtype VARCHAR2(7);
2687: l_itemkey VARCHAR2(15);
2688: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2689: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2690: l_dateFormat VARCHAR2(30);
2691: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2692: l_lineInfo VARCHAR2(2000);
2693: l_debugInfo VARCHAR2(1000);

Line 2691: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

2687: l_itemkey VARCHAR2(15);
2688: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2689: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2690: l_dateFormat VARCHAR2(30);
2691: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2692: l_lineInfo VARCHAR2(2000);
2693: l_debugInfo VARCHAR2(1000);
2694: l_orgId NUMBER;
2695: l_min_bucket NUMBER;

Line 2843: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(l_cardProgramId,l_employeeId,

2839:
2840: EXIT WHEN l_employee_cursor%NOTFOUND;
2841:
2842:
2843: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(l_cardProgramId,l_employeeId,
2844: l_min_bucket, l_max_bucket , l_total_outstanding,
2845: l_total_amt_outstanding)) THEN
2846: NULL;
2847: END IF;

Line 2849: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,

2845: l_total_amt_outstanding)) THEN
2846: NULL;
2847: END IF;
2848:
2849: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,
2850: l_min_bucket, l_max_bucket ,
2851: l_grace_days,l_total_dispute,
2852: l_total_amt_dispute)) THEN
2853: NULL;

Line 2856: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(l_cardProgramId,l_employeeId,

2852: l_total_amt_dispute)) THEN
2853: NULL;
2854: END IF;
2855:
2856: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(l_cardProgramId,l_employeeId,
2857: l_total_amount ) ) THEN
2858: NULL;
2859: END IF;
2860:

Line 3035: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(p_cardProgramId,l_employee_id,

3031: INTO l_employee_id,l_employee_name;
3032:
3033: EXIT WHEN l_employee_cursor%NOTFOUND;
3034:
3035: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(p_cardProgramId,l_employee_id,
3036: p_min_bucket, p_max_bucket , l_total_outstanding,
3037: l_total_amt_outstanding)) THEN
3038: NULL;
3039: END IF;

Line 3041: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(p_cardProgramId,l_employee_id,

3037: l_total_amt_outstanding)) THEN
3038: NULL;
3039: END IF;
3040:
3041: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(p_cardProgramId,l_employee_id,
3042: p_min_bucket, p_max_bucket ,
3043: p_grace_days,l_total_dispute,
3044: l_total_amt_dispute)) THEN
3045: NULL;

Line 3241: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(p_cardProgramId,l_employee_id,

3237: INTO l_employee_id,l_supervisor_id,l_level; --Direct Manager --Bug 3337388
3238:
3239: EXIT WHEN l_employee_cursor%NOTFOUND;
3240:
3241: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(p_cardProgramId,l_employee_id,
3242: p_min_bucket, p_max_bucket , l_total_outstanding,
3243: l_total_amt_outstanding)) THEN
3244: NULL;
3245: END IF;

Line 3247: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(p_cardProgramId,l_employee_id,

3243: l_total_amt_outstanding)) THEN
3244: NULL;
3245: END IF;
3246:
3247: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(p_cardProgramId,l_employee_id,
3248: p_min_bucket, p_max_bucket ,
3249: p_grace_days,l_total_dispute,
3250: l_total_amt_dispute)) THEN
3251: NULL;

Line 3397: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

3393: p_itemKey IN VARCHAR2) IS
3394:
3395: l_itemtype VARCHAR2(7);
3396: l_itemkey VARCHAR2(15);
3397: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
3398: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
3399: l_dateFormat VARCHAR2(30);
3400: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
3401: l_lineInfo VARCHAR2(2000);

Line 3398: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

3394:
3395: l_itemtype VARCHAR2(7);
3396: l_itemkey VARCHAR2(15);
3397: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
3398: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
3399: l_dateFormat VARCHAR2(30);
3400: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
3401: l_lineInfo VARCHAR2(2000);
3402: l_debugInfo VARCHAR2(1000);

Line 3400: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

3396: l_itemkey VARCHAR2(15);
3397: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
3398: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
3399: l_dateFormat VARCHAR2(30);
3400: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
3401: l_lineInfo VARCHAR2(2000);
3402: l_debugInfo VARCHAR2(1000);
3403: l_orgId NUMBER;
3404: l_min_bucket NUMBER;

Line 3507: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(l_cardProgramId,l_employeeId,

3503:
3504: EXIT WHEN l_employee_cursor%NOTFOUND;
3505:
3506:
3507: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(l_cardProgramId,l_employeeId,
3508: l_min_bucket, l_max_bucket , l_total_outstanding,
3509: l_total_amt_outstanding)) THEN
3510: NULL;
3511: END IF;

Line 3513: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,

3509: l_total_amt_outstanding)) THEN
3510: NULL;
3511: END IF;
3512:
3513: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,
3514: l_min_bucket, l_max_bucket ,
3515: l_grace_days,l_total_dispute,
3516: l_total_amt_dispute)) THEN
3517: NULL;

Line 3520: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(l_cardProgramId,l_employeeId,

3516: l_total_amt_dispute)) THEN
3517: NULL;
3518: END IF;
3519:
3520: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(l_cardProgramId,l_employeeId,
3521: l_total_amount ) ) THEN
3522: NULL;
3523: END IF;
3524:

Line 3587: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

3583:
3584: l_colon NUMBER;
3585: l_itemtype VARCHAR2(7);
3586: l_itemkey VARCHAR2(15);
3587: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
3588: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
3589: l_dateFormat VARCHAR2(30);
3590: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
3591: l_lineInfo VARCHAR2(2000);

Line 3588: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

3584: l_colon NUMBER;
3585: l_itemtype VARCHAR2(7);
3586: l_itemkey VARCHAR2(15);
3587: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
3588: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
3589: l_dateFormat VARCHAR2(30);
3590: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
3591: l_lineInfo VARCHAR2(2000);
3592: l_debugInfo VARCHAR2(1000);

Line 3590: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

3586: l_itemkey VARCHAR2(15);
3587: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
3588: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
3589: l_dateFormat VARCHAR2(30);
3590: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
3591: l_lineInfo VARCHAR2(2000);
3592: l_debugInfo VARCHAR2(1000);
3593: l_orgId NUMBER;
3594: l_min_bucket NUMBER;

Line 3686: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(l_cardProgramId,l_employeeId,

3682:
3683:
3684: EXIT WHEN l_employee_cursor%NOTFOUND;
3685:
3686: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(l_cardProgramId,l_employeeId,
3687: l_min_bucket, l_max_bucket , l_total_outstanding,
3688: l_total_amt_outstanding)) THEN
3689: NULL;
3690: END IF;

Line 3694: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,

3690: END IF;
3691:
3692:
3693:
3694: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,
3695: l_min_bucket, l_max_bucket ,
3696: l_grace_days,l_total_dispute,
3697: l_total_amt_dispute)) THEN
3698: NULL;

Line 3703: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(l_cardProgramId,l_employeeId,

3699: END IF;
3700:
3701:
3702:
3703: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(l_cardProgramId,l_employeeId,
3704: l_total_amount ) ) THEN
3705: NULL;
3706: END IF;
3707:

Line 3758: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;

3754: l_employeeName wf_users.name%type;
3755: l_employeeID NUMBER;
3756: l_employeeDisplayName wf_users.display_name%type;
3757: l_debugInfo VARCHAR2(200);
3758: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
3759: l_orgId number;
3760: BEGIN
3761:
3762: WF_DIRECTORY.GetUserName('PER',

Line 3818: IF (NOT AP_WEB_DB_CCARD_PKG.GetCardProgramName(p_cardProgramID,

3814:
3815: ------------------------------------------------------
3816: l_debugInfo := 'Set WF CREDIT_CARD_COMPANY Item Attribute';
3817: ------------------------------------------------------
3818: IF (NOT AP_WEB_DB_CCARD_PKG.GetCardProgramName(p_cardProgramID,
3819: l_cardProgramName ) ) THEN
3820: NULL;
3821: END IF;
3822: