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 339: l_cardProgramID AP_WEB_DB_CCARD_PKG.cardProgs_cardProgID;

335: l_managerName wf_users.name%type;
336: l_managerDisplayName wf_users.display_name%type;
337: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
338: l_debugInfo VARCHAR2(200);
339: l_cardProgramID AP_WEB_DB_CCARD_PKG.cardProgs_cardProgID;
340: l_orgId number;
341: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
342: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
343:

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

416:
417: --------------------------------------------------------------
418: l_debugInfo := 'Set WF CREDIT_CARD_COMPANY Item Attribute';
419: --------------------------------------------------------------
420: IF (NOT AP_WEB_DB_CCARD_PKG.GetCardProgramID(p_cardIssuer,
421: l_cardProgramID ) ) THEN
422: NULL;
423: END IF;
424:

Line 591: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;

587: l_managerName wf_users.name%type;
588: l_managerDisplayName wf_users.display_name%type;
589: l_employeeDisplayName wf_users.display_name%type;
590: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
591: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
592: l_orgId number;
593: l_debugInfo VARCHAR2(200);
594: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
595: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

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

890: END IF;
891:
892: END IF;
893:
894: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(p_cardProgramID,p_employeeId,
895: l_total_amount ) ) THEN
896: NULL;
897: END IF;
898:

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

967:
968: --------------------------------------------------------------
969: l_debugInfo := 'Set WF CREDIT_CARD_COMPANY Item Attribute';
970: --------------------------------------------------------------
971: IF (NOT AP_WEB_DB_CCARD_PKG.GetCardProgramName(p_cardProgramID,
972: l_cardProgramName ) ) THEN
973: NULL;
974: END IF;
975:

Line 1292: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;

1288: l_employeeId number;
1289: l_employeeName wf_users.name%type;
1290: l_employeeDisplayName wf_users.display_name%type;
1291: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1292: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
1293: l_sysdate VARCHAR2(30);
1294: l_today DATE;
1295: l_orgId number;
1296: l_days number;

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

1346:
1347: --------------------------------------------------------------
1348: l_debugInfo := 'Set WF CREDIT_CARD_COMPANY Item Attribute';
1349: --------------------------------------------------------------
1350: IF (NOT AP_WEB_DB_CCARD_PKG.GetCardProgramName(p_cardProgramID,
1351: l_cardProgramName ) ) THEN
1352: NULL;
1353: END IF;
1354:

Line 1467: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

1463:
1464: l_colon NUMBER;
1465: l_itemtype VARCHAR2(7);
1466: l_itemkey VARCHAR2(15);
1467: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1468: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1469: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1470: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1471: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

Line 1468: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

1464: l_colon NUMBER;
1465: l_itemtype VARCHAR2(7);
1466: l_itemkey VARCHAR2(15);
1467: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1468: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1469: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1470: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1471: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1472: l_dateFormat varchar2(30);

Line 1469: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

1465: l_itemtype VARCHAR2(7);
1466: l_itemkey VARCHAR2(15);
1467: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1468: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1469: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1470: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1471: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1472: l_dateFormat varchar2(30);
1473: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

Line 1470: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

1466: l_itemkey VARCHAR2(15);
1467: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1468: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1469: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1470: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1471: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1472: l_dateFormat varchar2(30);
1473: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1474: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

Line 1471: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

1467: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1468: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1469: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1470: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1471: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1472: l_dateFormat varchar2(30);
1473: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1474: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1475: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

Line 1473: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

1469: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1470: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1471: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1472: l_dateFormat varchar2(30);
1473: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1474: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1475: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1476: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1477: l_lineInfo VARCHAR2(2000);

Line 1474: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

1470: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1471: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1472: l_dateFormat varchar2(30);
1473: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1474: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1475: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1476: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1477: l_lineInfo VARCHAR2(2000);
1478: l_debugInfo VARCHAR2(1000);

Line 1475: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

1471: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1472: l_dateFormat varchar2(30);
1473: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1474: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1475: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1476: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1477: l_lineInfo VARCHAR2(2000);
1478: l_debugInfo VARCHAR2(1000);
1479: l_orgId number;

Line 1476: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

1472: l_dateFormat varchar2(30);
1473: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1474: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1475: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1476: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1477: l_lineInfo VARCHAR2(2000);
1478: l_debugInfo VARCHAR2(1000);
1479: l_orgId number;
1480: l_disputedCharges_cursor AP_WEB_DB_CCARD_PKG.DisputedCCTrxnCursor;

Line 1480: l_disputedCharges_cursor AP_WEB_DB_CCARD_PKG.DisputedCCTrxnCursor;

1476: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1477: l_lineInfo VARCHAR2(2000);
1478: l_debugInfo VARCHAR2(1000);
1479: l_orgId number;
1480: l_disputedCharges_cursor AP_WEB_DB_CCARD_PKG.DisputedCCTrxnCursor;
1481: l_dispute_header_prompt VARCHAR2(200);
1482:
1483: BEGIN
1484:

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

1541: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1542:
1543: l_debugInfo := 'Loop over all the Disputed charges';
1544:
1545: IF (NOT AP_WEB_DB_CCARD_PKG.GetDisputedCcardTrxnCursor(l_cardProgramId,
1546: l_minimumAmount, l_employeeId, l_billedStartDate,
1547: l_billedEndDate, l_DisputedCharges_cursor)) THEN
1548: NULL;
1549: END IF;

Line 1646: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

1642:
1643: l_colon NUMBER;
1644: l_itemtype VARCHAR2(7);
1645: l_itemkey VARCHAR2(15);
1646: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1647: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1648: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1649: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1650: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

Line 1647: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

1643: l_colon NUMBER;
1644: l_itemtype VARCHAR2(7);
1645: l_itemkey VARCHAR2(15);
1646: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1647: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1648: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1649: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1650: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1651: l_dateFormat varchar2(30);

Line 1648: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

1644: l_itemtype VARCHAR2(7);
1645: l_itemkey VARCHAR2(15);
1646: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1647: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1648: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1649: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1650: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1651: l_dateFormat varchar2(30);
1652: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

Line 1649: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

1645: l_itemkey VARCHAR2(15);
1646: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1647: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1648: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1649: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1650: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1651: l_dateFormat varchar2(30);
1652: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1653: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

Line 1650: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

1646: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1647: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1648: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1649: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1650: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1651: l_dateFormat varchar2(30);
1652: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1653: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1654: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

Line 1652: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

1648: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1649: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1650: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1651: l_dateFormat varchar2(30);
1652: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1653: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1654: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1655: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1656: l_lineInfo VARCHAR2(2000);

Line 1653: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

1649: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1650: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1651: l_dateFormat varchar2(30);
1652: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1653: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1654: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1655: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1656: l_lineInfo VARCHAR2(2000);
1657: l_debugInfo VARCHAR2(1000);

Line 1654: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

1650: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1651: l_dateFormat varchar2(30);
1652: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1653: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1654: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1655: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1656: l_lineInfo VARCHAR2(2000);
1657: l_debugInfo VARCHAR2(1000);
1658: l_orgId number;

Line 1655: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

1651: l_dateFormat varchar2(30);
1652: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1653: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1654: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1655: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1656: l_lineInfo VARCHAR2(2000);
1657: l_debugInfo VARCHAR2(1000);
1658: l_orgId number;
1659: l_UnsubmittedCharges_cursor AP_WEB_DB_CCARD_PKG.UnsubmittedCCTrxnCursor;

Line 1659: l_UnsubmittedCharges_cursor AP_WEB_DB_CCARD_PKG.UnsubmittedCCTrxnCursor;

1655: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1656: l_lineInfo VARCHAR2(2000);
1657: l_debugInfo VARCHAR2(1000);
1658: l_orgId number;
1659: l_UnsubmittedCharges_cursor AP_WEB_DB_CCARD_PKG.UnsubmittedCCTrxnCursor;
1660: l_expense_report_number VARCHAR2(60);
1661: l_expense_report_status VARCHAR2(30);
1662: l_displayed_status VARCHAR2(60);
1663: l_chargeType VARCHAR2(60);

Line 1666: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;

1662: l_displayed_status VARCHAR2(60);
1663: l_chargeType VARCHAR2(60);
1664: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;
1665: l_title AK_REGIONS_VL.name%TYPE;
1666: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
1667: l_detail_header_prompt VARCHAR2(200);
1668: l_document long;
1669: l_document_max NUMBER := 25000;
1670:

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

1753: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1754:
1755: l_debugInfo := 'Loop over all the Unsubmitted charges ';
1756:
1757: IF (NOT AP_WEB_DB_CCARD_PKG.GetUnsubmittedCcardTrxnCursor(l_cardProgramId,
1758: l_employeeId, l_billedStartDate,
1759: l_billedEndDate, l_minimumAmount, l_chargeType, l_UnsubmittedCharges_cursor)) THEN
1760: NULL;
1761: END IF;

Line 1900: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

1896:
1897: l_colon NUMBER;
1898: l_itemtype VARCHAR2(7);
1899: l_itemkey VARCHAR2(15);
1900: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1901: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1902: l_dateFormat VARCHAR2(30);
1903: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1904: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

Line 1901: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

1897: l_colon NUMBER;
1898: l_itemtype VARCHAR2(7);
1899: l_itemkey VARCHAR2(15);
1900: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1901: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1902: l_dateFormat VARCHAR2(30);
1903: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1904: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1905: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

Line 1903: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

1899: l_itemkey VARCHAR2(15);
1900: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1901: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1902: l_dateFormat VARCHAR2(30);
1903: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1904: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1905: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1906: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1907: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

Line 1904: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

1900: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
1901: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1902: l_dateFormat VARCHAR2(30);
1903: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1904: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1905: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1906: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1907: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1908: l_lineInfo VARCHAR2(2000);

Line 1905: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

1901: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
1902: l_dateFormat VARCHAR2(30);
1903: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1904: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1905: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1906: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1907: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1908: l_lineInfo VARCHAR2(2000);
1909: l_debugInfo VARCHAR2(1000);

Line 1906: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

1902: l_dateFormat VARCHAR2(30);
1903: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1904: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1905: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1906: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1907: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1908: l_lineInfo VARCHAR2(2000);
1909: l_debugInfo VARCHAR2(1000);
1910: l_orgId NUMBER;

Line 1907: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

1903: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
1904: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
1905: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
1906: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
1907: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1908: l_lineInfo VARCHAR2(2000);
1909: l_debugInfo VARCHAR2(1000);
1910: l_orgId NUMBER;
1911: l_Dunning_cursor AP_WEB_DB_CCARD_PKG.DunningCCTrxnCursor;

Line 1911: l_Dunning_cursor AP_WEB_DB_CCARD_PKG.DunningCCTrxnCursor;

1907: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
1908: l_lineInfo VARCHAR2(2000);
1909: l_debugInfo VARCHAR2(1000);
1910: l_orgId NUMBER;
1911: l_Dunning_cursor AP_WEB_DB_CCARD_PKG.DunningCCTrxnCursor;
1912: l_expense_report_number VARCHAR2(60);
1913: l_expense_report_status VARCHAR2(30);
1914: l_displayed_status VARCHAR2(60);
1915: l_min_bucket NUMBER;

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

1927: l_posted_date AP_CREDIT_CARD_TRXNS_ALL.POSTED_DATE%TYPE; --Notification Esc
1928: l_posted_currency_code AP_CREDIT_CARD_TRXNS_ALL.POSTED_CURRENCY_CODE%TYPE;--3339380
1929: l_transaction_amount AP_CREDIT_CARD_TRXNS_ALL.TRANSACTION_AMOUNT%TYPE;--Notification Esc
1930: l_location AP_EXPENSE_REPORT_LINES_ALL.LOCATION%TYPE; --Notification Esc
1931: l_Dispute_cursor AP_WEB_DB_CCARD_PKG.DisputeCCTrxnCursor; --Notification Esc
1932:
1933: l_detail_header_prompt VARCHAR2(2000);
1934: l_dispute_header_prompt VARCHAR2(2000);
1935: l_grace_days NUMBER;

Line 1943: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;

1939:
1940:
1941:
1942: --Notification Project
1943: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
1944:
1945: BEGIN
1946:
1947:

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

2027: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2028:
2029: l_debugInfo := 'Loop over all the Dunning Charges ';
2030:
2031: IF (NOT AP_WEB_DB_CCARD_PKG.GetDunningCcardTrxnCursor(l_cardProgramId,
2032: l_employeeId, l_min_bucket, l_max_bucket,
2033: l_Dunning_cursor)) THEN
2034: NULL;
2035: END IF;

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

2123:
2124:
2125: --Amulya Mishra : Notification Esc Project: Disputed Trxns
2126:
2127: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,
2128: l_min_bucket, l_max_bucket ,
2129: l_grace_days,l_total_dispute,
2130: l_total_amt_dispute)) THEN
2131: NULL;

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

2158: end if;
2159:
2160: l_debugInfo := 'Loop over all the Disputed Charges ';
2161:
2162: IF (NOT AP_WEB_DB_CCARD_PKG.GetDisputeCcardTrxnCursor(l_cardProgramId,
2163: l_employeeId, l_min_bucket, l_max_bucket,l_grace_days,
2164: l_Dispute_cursor)) THEN
2165: NULL;
2166: END IF;

Line 2257: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

2253:
2254: l_colon NUMBER;
2255: l_itemtype VARCHAR2(7);
2256: l_itemkey VARCHAR2(15);
2257: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2258: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2259: l_dateFormat VARCHAR2(30);
2260: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2261: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

Line 2258: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

2254: l_colon NUMBER;
2255: l_itemtype VARCHAR2(7);
2256: l_itemkey VARCHAR2(15);
2257: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2258: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2259: l_dateFormat VARCHAR2(30);
2260: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2261: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2262: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

Line 2260: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

2256: l_itemkey VARCHAR2(15);
2257: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2258: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2259: l_dateFormat VARCHAR2(30);
2260: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2261: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2262: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2263: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2264: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

Line 2261: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

2257: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2258: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2259: l_dateFormat VARCHAR2(30);
2260: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2261: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2262: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2263: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2264: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2265: l_lineInfo VARCHAR2(2000);

Line 2262: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

2258: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2259: l_dateFormat VARCHAR2(30);
2260: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2261: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2262: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2263: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2264: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2265: l_lineInfo VARCHAR2(2000);
2266: l_debugInfo VARCHAR2(1000);

Line 2263: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

2259: l_dateFormat VARCHAR2(30);
2260: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2261: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2262: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2263: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2264: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2265: l_lineInfo VARCHAR2(2000);
2266: l_debugInfo VARCHAR2(1000);
2267: l_orgId NUMBER;

Line 2264: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

2260: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2261: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2262: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2263: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2264: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2265: l_lineInfo VARCHAR2(2000);
2266: l_debugInfo VARCHAR2(1000);
2267: l_orgId NUMBER;
2268: l_Total_cursor AP_WEB_DB_CCARD_PKG.UnsubmittedCCTrxnCursor;

Line 2268: l_Total_cursor AP_WEB_DB_CCARD_PKG.UnsubmittedCCTrxnCursor;

2264: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2265: l_lineInfo VARCHAR2(2000);
2266: l_debugInfo VARCHAR2(1000);
2267: l_orgId NUMBER;
2268: l_Total_cursor AP_WEB_DB_CCARD_PKG.UnsubmittedCCTrxnCursor;
2269: l_expense_report_number VARCHAR2(60);
2270: l_expense_report_status VARCHAR2(30);
2271: l_displayed_status VARCHAR2(60);
2272: l_instructions VARCHAR2(2000);

Line 2274: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

2270: l_expense_report_status VARCHAR2(30);
2271: l_displayed_status VARCHAR2(60);
2272: l_instructions VARCHAR2(2000);
2273:
2274: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2275: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2276: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2277: l_chargeType VARCHAR2(60);
2278: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;

Line 2275: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

2271: l_displayed_status VARCHAR2(60);
2272: l_instructions VARCHAR2(2000);
2273:
2274: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2275: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2276: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2277: l_chargeType VARCHAR2(60);
2278: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
2279:

Line 2276: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

2272: l_instructions VARCHAR2(2000);
2273:
2274: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2275: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2276: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2277: l_chargeType VARCHAR2(60);
2278: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
2279:
2280: BEGIN

Line 2278: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;

2274: l_billedStartDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2275: l_billedEndDate AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2276: l_minimumAmount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2277: l_chargeType VARCHAR2(60);
2278: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
2279:
2280: BEGIN
2281:
2282:

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

2326: l_chargeType := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CHARGE_TYPE');
2327:
2328: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2329:
2330: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalUnsubmittedCCCursor(l_cardProgramId,
2331: l_employeeId, l_billedStartDate,
2332: l_billedEndDate, l_minimumAmount, l_chargeType, l_Total_cursor)) THEN
2333: NULL;
2334: END IF;

Line 2384: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

2380:
2381: l_colon NUMBER;
2382: l_itemtype VARCHAR2(7);
2383: l_itemkey VARCHAR2(15);
2384: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2385: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2386: l_dateFormat VARCHAR2(30);
2387: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2388: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

Line 2385: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

2381: l_colon NUMBER;
2382: l_itemtype VARCHAR2(7);
2383: l_itemkey VARCHAR2(15);
2384: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2385: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2386: l_dateFormat VARCHAR2(30);
2387: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2388: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2389: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

Line 2387: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;

2383: l_itemkey VARCHAR2(15);
2384: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2385: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2386: l_dateFormat VARCHAR2(30);
2387: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2388: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2389: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2390: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2391: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

Line 2388: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;

2384: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2385: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2386: l_dateFormat VARCHAR2(30);
2387: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2388: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2389: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2390: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2391: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2392: l_lineInfo VARCHAR2(2000);

Line 2389: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

2385: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2386: l_dateFormat VARCHAR2(30);
2387: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2388: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2389: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2390: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2391: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2392: l_lineInfo VARCHAR2(2000);
2393: l_debugInfo VARCHAR2(1000);

Line 2390: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;

2386: l_dateFormat VARCHAR2(30);
2387: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2388: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2389: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2390: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2391: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2392: l_lineInfo VARCHAR2(2000);
2393: l_debugInfo VARCHAR2(1000);
2394: l_orgId NUMBER;

Line 2391: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

2387: l_transaction_date AP_WEB_DB_CCARD_PKG.ccTrxn_transDate;
2388: l_merchant_name1 AP_WEB_DB_CCARD_PKG.ccTrxn_merchantName1;
2389: l_billed_amount AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
2390: l_billed_date AP_WEB_DB_CCARD_PKG.ccTrxn_billedDate;
2391: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2392: l_lineInfo VARCHAR2(2000);
2393: l_debugInfo VARCHAR2(1000);
2394: l_orgId NUMBER;
2395: l_Total_cursor AP_WEB_DB_CCARD_PKG.TotalCCTrxnCursor;

Line 2395: l_Total_cursor AP_WEB_DB_CCARD_PKG.TotalCCTrxnCursor;

2391: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2392: l_lineInfo VARCHAR2(2000);
2393: l_debugInfo VARCHAR2(1000);
2394: l_orgId NUMBER;
2395: l_Total_cursor AP_WEB_DB_CCARD_PKG.TotalCCTrxnCursor;
2396: l_expense_report_number VARCHAR2(60);
2397: l_expense_report_status VARCHAR2(30);
2398: l_displayed_status VARCHAR2(60);
2399: l_min_bucket NUMBER;

Line 2404: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;

2400: l_max_bucket NUMBER;
2401: l_min_bucket1 VARCHAR2(30);
2402: l_max_bucket1 VARCHAR2(30);
2403: l_instructions VARCHAR2(2000);
2404: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
2405:
2406: BEGIN
2407:
2408:

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

2446: end if;
2447:
2448: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2449:
2450: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCcardTrxnCursor(l_cardProgramId,
2451: l_employeeId, l_min_bucket, l_max_bucket,
2452: l_Total_cursor)) THEN
2453: NULL;
2454: END IF;

Line 2511: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

2507:
2508: l_colon NUMBER;
2509: l_itemtype VARCHAR2(7);
2510: l_itemkey VARCHAR2(15);
2511: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2512: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2513: l_dateFormat VARCHAR2(30);
2514: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2515: l_lineInfo VARCHAR2(2000);

Line 2512: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

2508: l_colon NUMBER;
2509: l_itemtype VARCHAR2(7);
2510: l_itemkey VARCHAR2(15);
2511: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2512: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2513: l_dateFormat VARCHAR2(30);
2514: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2515: l_lineInfo VARCHAR2(2000);
2516: l_debugInfo VARCHAR2(1000);

Line 2514: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

2510: l_itemkey VARCHAR2(15);
2511: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2512: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2513: l_dateFormat VARCHAR2(30);
2514: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2515: l_lineInfo VARCHAR2(2000);
2516: l_debugInfo VARCHAR2(1000);
2517: l_orgId NUMBER;
2518: l_min_bucket NUMBER;

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

2638:
2639:
2640: EXIT WHEN l_employee_cursor%NOTFOUND;
2641:
2642: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(l_cardProgramId,l_employeeId,
2643: l_min_bucket, l_max_bucket , l_total_outstanding,
2644: l_total_amt_outstanding)) THEN
2645: NULL;
2646: END IF;

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

2646: END IF;
2647:
2648:
2649:
2650: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,
2651: l_min_bucket, l_max_bucket ,
2652: l_grace_days,l_total_dispute,
2653: l_total_amt_dispute)) THEN
2654: NULL;

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

2655: END IF;
2656:
2657:
2658:
2659: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(l_cardProgramId,l_employeeId,
2660: l_total_amount ) ) THEN
2661: NULL;
2662: END IF;
2663:

Line 2762: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

2758:
2759: l_colon NUMBER;
2760: l_itemtype VARCHAR2(7);
2761: l_itemkey VARCHAR2(15);
2762: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2763: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2764: l_dateFormat VARCHAR2(30);
2765: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2766: l_lineInfo VARCHAR2(2000);

Line 2763: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

2759: l_colon NUMBER;
2760: l_itemtype VARCHAR2(7);
2761: l_itemkey VARCHAR2(15);
2762: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2763: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2764: l_dateFormat VARCHAR2(30);
2765: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2766: l_lineInfo VARCHAR2(2000);
2767: l_debugInfo VARCHAR2(1000);

Line 2765: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

2761: l_itemkey VARCHAR2(15);
2762: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
2763: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
2764: l_dateFormat VARCHAR2(30);
2765: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
2766: l_lineInfo VARCHAR2(2000);
2767: l_debugInfo VARCHAR2(1000);
2768: l_orgId NUMBER;
2769: l_min_bucket NUMBER;

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

2913:
2914: EXIT WHEN l_employee_cursor%NOTFOUND;
2915:
2916:
2917: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(l_cardProgramId,l_employeeId,
2918: l_min_bucket, l_max_bucket , l_total_outstanding,
2919: l_total_amt_outstanding)) THEN
2920: NULL;
2921: END IF;

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

2919: l_total_amt_outstanding)) THEN
2920: NULL;
2921: END IF;
2922:
2923: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,
2924: l_min_bucket, l_max_bucket ,
2925: l_grace_days,l_total_dispute,
2926: l_total_amt_dispute)) THEN
2927: NULL;

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

2926: l_total_amt_dispute)) THEN
2927: NULL;
2928: END IF;
2929:
2930: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(l_cardProgramId,l_employeeId,
2931: l_total_amount ) ) THEN
2932: NULL;
2933: END IF;
2934:

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

3105: INTO l_employee_id,l_employee_name;
3106:
3107: EXIT WHEN l_employee_cursor%NOTFOUND;
3108:
3109: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(p_cardProgramId,l_employee_id,
3110: p_min_bucket, p_max_bucket , l_total_outstanding,
3111: l_total_amt_outstanding)) THEN
3112: NULL;
3113: END IF;

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

3111: l_total_amt_outstanding)) THEN
3112: NULL;
3113: END IF;
3114:
3115: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(p_cardProgramId,l_employee_id,
3116: p_min_bucket, p_max_bucket ,
3117: p_grace_days,l_total_dispute,
3118: l_total_amt_dispute)) THEN
3119: NULL;

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

3310: INTO l_employee_id,l_supervisor_id,l_level; --Direct Manager --Bug 3337388
3311:
3312: EXIT WHEN l_employee_cursor%NOTFOUND;
3313:
3314: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(p_cardProgramId,l_employee_id,
3315: p_min_bucket, p_max_bucket , l_total_outstanding,
3316: l_total_amt_outstanding)) THEN
3317: NULL;
3318: END IF;

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

3316: l_total_amt_outstanding)) THEN
3317: NULL;
3318: END IF;
3319:
3320: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(p_cardProgramId,l_employee_id,
3321: p_min_bucket, p_max_bucket ,
3322: p_grace_days,l_total_dispute,
3323: l_total_amt_dispute)) THEN
3324: NULL;

Line 3470: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

3466: p_itemKey IN VARCHAR2) IS
3467:
3468: l_itemtype VARCHAR2(7);
3469: l_itemkey VARCHAR2(15);
3470: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
3471: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
3472: l_dateFormat VARCHAR2(30);
3473: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
3474: l_lineInfo VARCHAR2(2000);

Line 3471: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

3467:
3468: l_itemtype VARCHAR2(7);
3469: l_itemkey VARCHAR2(15);
3470: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
3471: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
3472: l_dateFormat VARCHAR2(30);
3473: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
3474: l_lineInfo VARCHAR2(2000);
3475: l_debugInfo VARCHAR2(1000);

Line 3473: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

3469: l_itemkey VARCHAR2(15);
3470: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
3471: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
3472: l_dateFormat VARCHAR2(30);
3473: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
3474: l_lineInfo VARCHAR2(2000);
3475: l_debugInfo VARCHAR2(1000);
3476: l_orgId NUMBER;
3477: l_min_bucket NUMBER;

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

3575: INTO l_employeeId,l_supervisor_id,l_level;
3576:
3577: EXIT WHEN l_employee_cursor%NOTFOUND;
3578:
3579: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(l_cardProgramId,l_employeeId,
3580: l_min_bucket, l_max_bucket , l_total_outstanding,
3581: l_total_amt_outstanding)) THEN
3582: NULL;
3583: END IF;

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

3580: l_min_bucket, l_max_bucket , l_total_outstanding,
3581: l_total_amt_outstanding)) THEN
3582: NULL;
3583: END IF;
3584: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,
3585: l_min_bucket, l_max_bucket ,
3586: l_grace_days,l_total_dispute,
3587: l_total_amt_dispute)) THEN
3588: NULL;

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

3587: l_total_amt_dispute)) THEN
3588: NULL;
3589: END IF;
3590:
3591: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(l_cardProgramId,l_employeeId,
3592: l_total_amount ) ) THEN
3593: NULL;
3594: END IF;
3595:

Line 3656: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;

3652:
3653: l_colon NUMBER;
3654: l_itemtype VARCHAR2(7);
3655: l_itemkey VARCHAR2(15);
3656: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
3657: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
3658: l_dateFormat VARCHAR2(30);
3659: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
3660: l_lineInfo VARCHAR2(2000);

Line 3657: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;

3653: l_colon NUMBER;
3654: l_itemtype VARCHAR2(7);
3655: l_itemkey VARCHAR2(15);
3656: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
3657: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
3658: l_dateFormat VARCHAR2(30);
3659: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
3660: l_lineInfo VARCHAR2(2000);
3661: l_debugInfo VARCHAR2(1000);

Line 3659: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

3655: l_itemkey VARCHAR2(15);
3656: l_cardProgramId AP_WEB_DB_CCARD_PKG.ccTrxn_cardProgID;
3657: l_employeeId AP_WEB_DB_CCARD_PKG.cards_employeeID;
3658: l_dateFormat VARCHAR2(30);
3659: l_billed_currency_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
3660: l_lineInfo VARCHAR2(2000);
3661: l_debugInfo VARCHAR2(1000);
3662: l_orgId NUMBER;
3663: l_min_bucket NUMBER;

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

3751:
3752:
3753: EXIT WHEN l_employee_cursor%NOTFOUND;
3754:
3755: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberOutstanding(l_cardProgramId,l_employeeId,
3756: l_min_bucket, l_max_bucket , l_total_outstanding,
3757: l_total_amt_outstanding)) THEN
3758: NULL;
3759: END IF;

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

3759: END IF;
3760:
3761:
3762:
3763: IF (AP_WEB_DB_CCARD_PKG.GetTotalNumberDispute(l_cardProgramId,l_employeeId,
3764: l_min_bucket, l_max_bucket ,
3765: l_grace_days,l_total_dispute,
3766: l_total_amt_dispute)) THEN
3767: NULL;

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

3768: END IF;
3769:
3770:
3771:
3772: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCreditCardAmount(l_cardProgramId,l_employeeId,
3773: l_total_amount ) ) THEN
3774: NULL;
3775: END IF;
3776:

Line 3827: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;

3823: l_employeeName wf_users.name%type;
3824: l_employeeID NUMBER;
3825: l_employeeDisplayName wf_users.display_name%type;
3826: l_debugInfo VARCHAR2(200);
3827: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
3828: l_orgId number;
3829: BEGIN
3830:
3831: WF_DIRECTORY.GetUserName('PER',

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

3883:
3884: ------------------------------------------------------
3885: l_debugInfo := 'Set WF CREDIT_CARD_COMPANY Item Attribute';
3886: ------------------------------------------------------
3887: IF (NOT AP_WEB_DB_CCARD_PKG.GetCardProgramName(p_cardProgramID,
3888: l_cardProgramName ) ) THEN
3889: NULL;
3890: END IF;
3891: