APPS.CSY_KPI_PKG dependencies on FND_PROFILE

Line 2136: select to_date(fnd_profile.value('CS_CSY_LAST_PROGRAM_RUN_DATE'),

2132: g_conc_program_id := fnd_global.conc_program_id;
2133: g_conc_login_id := fnd_global.conc_login_id;
2134: g_conc_appl_id := fnd_global.prog_appl_id;
2135: g_conc_request_id := fnd_global.conc_request_id;
2136: select to_date(fnd_profile.value('CS_CSY_LAST_PROGRAM_RUN_DATE'),
2137: 'YYYYMMDD HH24:MI:SS')
2138: into l_from_date
2139: from dual;
2140: if (l_from_date is null) then

Line 2174: l_ret_val := fnd_profile.save('CS_CSY_LAST_PROGRAM_RUN_DATE',

2170: -- for group it will not get corrected due to from_date value. So changing from date to
2171: -- last 365 days since kpi displays data only for up to last 365 days
2172: update_group_data (l_to_date-367, l_to_date);
2173: debug('After Group Data :'||to_char(sysdate,'hh24:mi:ss'));
2174: l_ret_val := fnd_profile.save('CS_CSY_LAST_PROGRAM_RUN_DATE',
2175: to_char(l_to_date,'YYYYMMDD hh24:mi:ss'),
2176: 'SITE');
2177: if (l_ret_val) then
2178: --refresh_mvs(p_errbuf,p_retcode);

Line 2201: l_ret_val := fnd_profile.save('CS_CSY_LAST_PROGRAM_RUN_DATE',

2197: delete from csy_response_resolutions;
2198: delete from csy_resolution_qlty;
2199: commit;
2200: l_min_date := trunc(sysdate) - 370;
2201: l_ret_val := fnd_profile.save('CS_CSY_LAST_PROGRAM_RUN_DATE',
2202: to_char(l_min_date,'YYYYMMDD hh24:mi:ss'),
2203: 'SITE');
2204: if (l_ret_val) then
2205: commit;