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.

APPS.OKS_UPGRADE_PRECHECK dependencies on FND_PROFILE

Line 932: --l_cov_timezone_id := FND_PROFILE.value('OKS_COV_DEFAULT_TIMEZONE');

928: l_cov_timezone_id Number;
929:
930: BEGIN
931:
932: --l_cov_timezone_id := FND_PROFILE.value('OKS_COV_DEFAULT_TIMEZONE');
933: l_cov_timezone_id := nvl(FND_PROFILE.value('CS_UPG_CONTRACTS_TIMEZONE'),47);
934:
935: -- TVCP Migration 31-OCT-2003 MCHOUDHA
936: --updating the new OKS table OKS_COVERAGE_TIMEZONES with the

Line 933: l_cov_timezone_id := nvl(FND_PROFILE.value('CS_UPG_CONTRACTS_TIMEZONE'),47);

929:
930: BEGIN
931:
932: --l_cov_timezone_id := FND_PROFILE.value('OKS_COV_DEFAULT_TIMEZONE');
933: l_cov_timezone_id := nvl(FND_PROFILE.value('CS_UPG_CONTRACTS_TIMEZONE'),47);
934:
935: -- TVCP Migration 31-OCT-2003 MCHOUDHA
936: --updating the new OKS table OKS_COVERAGE_TIMEZONES with the
937: --value of the profile option

Line 941: WHERE timezone_id = nvl(FND_PROFILE.value('CS_UPG_CONTRACTS_TIMEZONE'),47)

937: --value of the profile option
938:
939: UPDATE OKS_COVERAGE_TIMEZONES
940: SET TIMEZONE_ID = l_cov_timezone_id --tz_rec.timezone_id
941: WHERE timezone_id = nvl(FND_PROFILE.value('CS_UPG_CONTRACTS_TIMEZONE'),47)
942: AND dnz_chr_id IN --= tz_rec.chr_id
943: ( SELECT distinct dnz_chr_id
944: FROM CS_COVERAGE_TXN_GROUPS ctxg,
945: OKC_K_LINES_B cle