eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on FND_PROFILE

Line 1235: l_ret_acty_date := sysdate - to_number(nvl(fnd_profile.value_specific('CSM_MULTI_RET_ACTY_DURATION',null,l_respId,null),90));

1231: l_max_mtl_items NUMBER;
1232: BEGIN
1233:
1234: SELECT RESPONSIBILITY_ID INTO l_respId FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_KEY='OMFS_PALM';
1235: l_ret_acty_date := sysdate - to_number(nvl(fnd_profile.value_specific('CSM_MULTI_RET_ACTY_DURATION',null,l_respId,null),90));
1236: l_max_mtl_items := to_number(nvl(fnd_profile.value_specific('CSM_MULTI_MAX_MTL_ITEMS',null,l_respId,null),500));
1237:
1238:
1239: --DELETE --based on date in profile --COUNT will be retained with old value till user gets recreated or effectively gets corrected in passing days

Line 1236: l_max_mtl_items := to_number(nvl(fnd_profile.value_specific('CSM_MULTI_MAX_MTL_ITEMS',null,l_respId,null),500));

1232: BEGIN
1233:
1234: SELECT RESPONSIBILITY_ID INTO l_respId FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_KEY='OMFS_PALM';
1235: l_ret_acty_date := sysdate - to_number(nvl(fnd_profile.value_specific('CSM_MULTI_RET_ACTY_DURATION',null,l_respId,null),90));
1236: l_max_mtl_items := to_number(nvl(fnd_profile.value_specific('CSM_MULTI_MAX_MTL_ITEMS',null,l_respId,null),500));
1237:
1238:
1239: --DELETE --based on date in profile --COUNT will be retained with old value till user gets recreated or effectively gets corrected in passing days
1240: --This query might take longer and we can make it run twice a day since only date profile is handled