APPS.CSY_KPI_PKG dependencies on FND_PROFILE

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

2174: g_conc_program_id := fnd_global.conc_program_id;
2175: g_conc_login_id := fnd_global.conc_login_id;
2176: g_conc_appl_id := fnd_global.prog_appl_id;
2177: g_conc_request_id := fnd_global.conc_request_id;
2178: select to_date(fnd_profile.value('CS_CSY_LAST_PROGRAM_RUN_DATE'),
2179: 'YYYYMMDD HH24:MI:SS')
2180: into l_from_date
2181: from dual;
2182: if (l_from_date is null) then

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

2212: -- for group it will not get corrected due to from_date value. So changing from date to
2213: -- last 365 days since kpi displays data only for up to last 365 days
2214: update_group_data (l_to_date-367, l_to_date);
2215: debug('After Group Data :'||to_char(sysdate,'hh24:mi:ss'));
2216: l_ret_val := fnd_profile.save('CS_CSY_LAST_PROGRAM_RUN_DATE',
2217: to_char(l_to_date,'YYYYMMDD hh24:mi:ss'),
2218: 'SITE');
2219: if (l_ret_val) then
2220: --refresh_mvs(p_errbuf,p_retcode);

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

2239: delete from csy_response_resolutions;
2240: delete from csy_resolution_qlty;
2241: commit;
2242: l_min_date := trunc(sysdate) - 370;
2243: l_ret_val := fnd_profile.save('CS_CSY_LAST_PROGRAM_RUN_DATE',
2244: to_char(l_min_date,'YYYYMMDD hh24:mi:ss'),
2245: 'SITE');
2246: if (l_ret_val) then
2247: commit;