APPS.ASG_DOWNLOAD dependencies on FND_PROFILE

Line 1534: select nvl(fnd_profile.value_specific('ASG_ENABLE_DELIVERY_EVENTS'),'N')

1530: DELETE FROM asg_system_dirty_queue
1531: WHERE client_id = g_clientid AND
1532: transaction_id IS NOT NULL;
1533: ELSE
1534: select nvl(fnd_profile.value_specific('ASG_ENABLE_DELIVERY_EVENTS'),'N')
1535: into l_prof_value from dual;
1536: /*Raise delivery events only if the profile is set to 'Y'*/
1537: if(l_prof_value = 'Y')
1538: then

Line 2049: l_dormancy_period := fnd_profile.VALUE('ASG_SDQ_PURGE_DAYS');

2045:
2046: -- Fix to 3536657
2047: -- Later, allow customer to specify the interval via a separate
2048: -- profile option
2049: l_dormancy_period := fnd_profile.VALUE('ASG_SDQ_PURGE_DAYS');
2050: if(l_dormancy_period is not null) then
2051: l_purge_conf_interval := l_dormancy_period;
2052: end if;
2053: delete from asg_conf_info

Line 2058: fnd_profile.VALUE('ASG_SDQ_PURGE_USER_COUNT');

2054: where (sysdate-creation_date) >l_purge_conf_interval;
2055: commit;
2056:
2057: l_max_users :=
2058: fnd_profile.VALUE('ASG_SDQ_PURGE_USER_COUNT');
2059: if(l_max_users is null )
2060: then
2061: log_concprogram('Profile ASG: Purge User Count is set to null. Exiting',
2062: 'asg_download',FND_LOG.LEVEL_STATEMENT);

Line 2375: l_purge_interval := fnd_profile.VALUE('ASG_SYNCH_HIST_PURGE_PERIOD');

2371: BEGIN
2372: log_concprogram('Starting to purge synch history data',
2373: 'asg_download',
2374: FND_LOG.LEVEL_STATEMENT);
2375: l_purge_interval := fnd_profile.VALUE('ASG_SYNCH_HIST_PURGE_PERIOD');
2376: if( l_purge_interval is null )
2377: then
2378: log_concprogram('Synch history purge interval is set to NULL ',
2379: 'asg_download',