DBA Data[Home] [Help]

APPS.AMS_LIST_PURGE_PVT dependencies on FND_PROFILE

Line 152: l_grace_date := l_creation_date + NVL(fnd_profile.VALUE('AMS_BUDGET_ADJ_GRACE_PERIOD'), 60);

148: END IF;
149:
150: IF l_expiry_date IS NULL AND l_usage IS NULL THEN
151: -- get grace period from profile, default 60
152: l_grace_date := l_creation_date + NVL(fnd_profile.VALUE('AMS_BUDGET_ADJ_GRACE_PERIOD'), 60);
153:
154: IF l_grace_date <= SYSDATE THEN
155:
156: IF (AMS_DEBUG_HIGH_ON) THEN

Line 690: NVL(fnd_profile.VALUE('AMS_BUDGET_ADJ_GRACE_PERIOD'), 180); --should be defaulted to 180.

686: IF l_sent_out_date is NOT NULL THEN
687:
688: -- get grace period from profile, default 30
689: l_grace_date := l_sent_out_date +
690: NVL(fnd_profile.VALUE('AMS_BUDGET_ADJ_GRACE_PERIOD'), 180); --should be defaulted to 180.
691: IF SYSDATE >= l_grace_date THEN
692: IF (AMS_DEBUG_HIGH_ON) THEN
693:
694: AMS_Utility_PVT.Debug_Message(l_api_name||' Purge list header ID ' || l_list_header_id);