DBA Data[Home] [Help]

APPS.AP_WEB_CREDIT_CARD_WF dependencies on AP_WEB_DB_UTIL_PKG

Line 81: AP_WEB_DB_UTIL_PKG.RaiseException('GetNextCardNotificationID');

77: FROM sys.dual;
78: return l_itemKey;
79: EXCEPTION
80: WHEN OTHERS THEN
81: AP_WEB_DB_UTIL_PKG.RaiseException('GetNextCardNotificationID');
82: END GetNextCardNotificationID;
83:
84: ---------------------------------------------------------------------------
85: PROCEDURE sendPaymentNotification(p_checkNumber IN NUMBER,

Line 1307: IF (AP_WEB_DB_UTIL_PKG.GetSysDate(l_sysdate)) THEN

1303:
1304: ------------------------------------------------------
1305: l_debugInfo := 'Set WF NUMBER_OF_DAYS Item Attribute';
1306: ------------------------------------------------------
1307: IF (AP_WEB_DB_UTIL_PKG.GetSysDate(l_sysdate)) THEN
1308: l_today := to_date(l_sysdate,AP_WEB_INFRASTRUCTURE_PKG.getDateFormat);
1309: END IF;
1310:
1311: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'NUMBER_OF_DAYS', round(l_today - p_billedStartDate));