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 2051: l_dormancy_period := fnd_profile.VALUE('ASG_SDQ_PURGE_DAYS');

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

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

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

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

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