[Home] [Help]
1: PACKAGE BODY AP_WEB_DB_CCARD_PKG AS
2: /* $Header: apwdbccb.pls 120.60.12020000.2 2012/07/05 14:13:01 rveliche ship $ */
3: /* Credit Cards */
4:
5: --------------------------------------------------------------------------------
496: erh.report_header_id),'UNUSED'), --2615505
497: nvl(cct.billed_date, cct.posted_date) billed_date,
498: cct.posted_date, --Notification Esc
499: cct.transaction_amount,--Notification Esc
500: AP_WEB_DB_CCARD_PKG.GETLOCATION(cct.merchant_city , cct.merchant_province_state), --Notification Esc
501: cct.trx_id -- Bug 3241358
502: FROM
503: ap_credit_card_trxns cct,
504: ap_cards ac,
531: erh.report_header_id),
532: nvl(cct.billed_date, cct.posted_date) billed_date,
533: cct.posted_date, --Notification Esc
534: cct.transaction_amount,--Notification Esc
535: AP_WEB_DB_CCARD_PKG.GETLOCATION(cct.merchant_city , cct.merchant_province_state), --Notification Esc
536: cct.trx_id -- Bug 3241358
537: FROM
538: ap_credit_card_trxns cct,
539: ap_cards ac,
563: 'UNUSED',
564: nvl(cct.billed_date, cct.posted_date) billed_date,
565: cct.posted_date, --Notification Esc
566: cct.transaction_amount,--Notification Esc
567: AP_WEB_DB_CCARD_PKG.GETLOCATION(cct.merchant_city , cct.merchant_province_state), --Notification Esc
568: cct.trx_id -- Bug 3241358
569: FROM
570: ap_credit_card_trxns cct,
571: ap_cards ac
1377:
1378: paymentMethodCount NUMBER;
1379: ------------------------------------------------------------------------------
1380: BEGIN
1381: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_CCARD_PKG', 'start isMultPayments');
1382: select count(distinct payment_due_from_code)
1383: into paymentMethodCount
1384: from ap_credit_card_trxns
1385: where card_program_id = p_cardProgramID
1412: p_paymentDueCode VARCHAR2(30);
1413: -----------------------------------------------------------------------------
1414: BEGIN
1415:
1416: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_CCARD_PKG', 'start getPaymentDueCodeFromTrxn');
1417:
1418: SELECT DISTINCT payment_due_from_code
1419: INTO p_paymentDueCode
1420: FROM ap_credit_card_trxns trx
1446:
1447: -----------------------------------------------------------------------------
1448: BEGIN
1449:
1450: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_CCARD_PKG', 'start getFirstLineWithCCTrxId');
1451:
1452: FOR i IN 1..p_expLines.Count LOOP
1453: IF p_expLines(i).cCardTrxnId IS NOT NULL THEN
1454: RETURN p_expLines(i).cCardTrxnId;
1504: p_user_id => nvl(p_user_id,l_userId),
1505: p_resp_id => null,
1506: p_apps_id => null);
1507:
1508: IF (AP_WEB_DB_CCARD_PKG.UserHasCreditCard(p_employee_id, l_has)) THEN
1509: if (AP_WEB_DB_HR_INT_PKG.IsPersonCwk(p_employee_id) = 'N' AND
1510: l_has = 'Y' AND l_cCardEnabled = 'Y') THEN
1511: return 'Y';
1512: end if;
1804: l_debug_info VARCHAR2(1000);
1805: l_user_id NUMBER;
1806:
1807: BEGIN
1808: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_CCARD_PKG', 'start getAlertsForHomepage');
1809:
1810: p_cc_flag := 'N';
1811: p_num_days := 0;
1812: p_num_old := 0;
1835:
1836: -- check if delegates have CC Alerts
1837: checkDelegatesForAlerts(p_employee_id, l_user_id, p_delegate_flag);
1838:
1839: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_CCARD_PKG', 'end getAlertsForHomepage');
1840:
1841: EXCEPTION
1842: WHEN NO_DATA_FOUND THEN
1843: NULL;
1873: cct.posted_currency_code, --3339380
1874: nvl(cct.billed_date, cct.posted_date) billed_date,
1875: cct.posted_date, --Notification Esc
1876: cct.transaction_amount,--Notification Esc
1877: AP_WEB_DB_CCARD_PKG.GETLOCATION(cct.merchant_city , cct.merchant_province_state) --Notification Esc
1878: from
1879: ap_credit_card_trxns cct,
1880: ap_cards_all ac
1881: where
2180: END IF;
2181: END GetLocation;
2182: -----------------------------------------------------------------------
2183:
2184: END AP_WEB_DB_CCARD_PKG;