[Home] [Help]
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;
1498:
1499: -------------------------------------------
1500: l_debug_info := 'Check if user is credit card enabled';
1501: -------------------------------------------
1502: l_cCardEnabled := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(
1503: p_name => 'SSE_ENABLE_CREDIT_CARD',
1504: p_user_id => nvl(p_user_id,l_userId),
1505: p_resp_id => null,
1506: p_apps_id => null);
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;