APPS.IEX_PROMISES_BATCH_PUB dependencies on FND_PROFILE

Line 47: l_callback_days := to_number(nvl(fnd_profile.value('IEX_PTP_CALLBACK_DAYS'), '0'));

43: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
44: LogMessage(G_PKG_NAME || '.Get_Calback_Date: start');
45: END IF;
46:
47: l_callback_days := to_number(nvl(fnd_profile.value('IEX_PTP_CALLBACK_DAYS'), '0'));
48: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
49: LogMessage(G_PKG_NAME || '.Get_Calback_Date: callback days from profile = ' || l_callback_days);
50: END IF;
51: if l_callback_days < 0 then

Line 664: fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate)))

660: AND EXISTS (SELECT 1 FROM iex_promise_details b
661: where TRUNC(b.last_update_date)=TRUNC(SYSDATE) AND pd.cust_account_id = b.cust_account_id)
662: AND(pd.uwq_status = 'COMPLETE'
663: AND(TRUNC(pd.uwq_complete_date) +
664: fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate)))
665: GROUP BY d.party_cust_id,
666: pd.cust_account_id,
667: d.customer_site_use_id;
668:

Line 755: fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate)))

751: FROM iex_promise_details pd
752: WHERE pd.state = 'BROKEN_PROMISE'
753: AND(pd.uwq_status = 'COMPLETE'
754: AND(TRUNC(pd.uwq_complete_date) +
755: fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate)))
756: GROUP BY CUST_ACCOUNT_ID;
757:
758: CURSOR UPDATE_IEX_PEND_PRO IS
759: SELECT count(cust_account_id)pending_promises,cust_account_id