APPS.CSM_HTML5_PKG dependencies on FND_PROFILE

Line 1967: select profile_option_value from fnd_profile_option_values where profile_option_id in

1963: AND procedure_name = 'PURGE_HTML5_DATA'
1964: FOR UPDATE OF last_run_date NOWAIT;
1965:
1966: CURSOR c_purge_days IS
1967: select profile_option_value from fnd_profile_option_values where profile_option_id in
1968: (select profile_option_id from fnd_profile_options where profile_option_name='CSM_PURGE_INTERVAL')
1969: and level_id=10001;
1970:
1971: l_days NUMBER;

Line 1968: (select profile_option_id from fnd_profile_options where profile_option_name='CSM_PURGE_INTERVAL')

1964: FOR UPDATE OF last_run_date NOWAIT;
1965:
1966: CURSOR c_purge_days IS
1967: select profile_option_value from fnd_profile_option_values where profile_option_id in
1968: (select profile_option_id from fnd_profile_options where profile_option_name='CSM_PURGE_INTERVAL')
1969: and level_id=10001;
1970:
1971: l_days NUMBER;
1972:

Line 2308: IF fnd_profile.value_specific('ASG_SYNCHRONOUS_UPLOAD',l_user_id,l_resp_id,l_app_id)='Y' THEN

2304:
2305:
2306: SELECT USER_ID,RESPONSIBILITY_ID,APP_ID INTO l_user_id,l_resp_id,l_app_id FROM ASG_USER WHERE USER_NAME=p_user_name;
2307:
2308: IF fnd_profile.value_specific('ASG_SYNCHRONOUS_UPLOAD',l_user_id,l_resp_id,l_app_id)='Y' THEN
2309: is_synchronous:=true;
2310: END IF;
2311:
2312: l_session_id:=CREATE_SESSION(p_user_name,'UPLOAD');

Line 3582: and nvl(fnd_profile.value_specific('ASG_SYNCHRONOUS_UPLOAD',b.user_id,b.responsibility_id,b.app_id),'N')='N'

3578: l_list VARCHAR2(4000):=NULL;
3579: BEGIN
3580: FOR rec IN (select a.session_id,c.user_name from csm_html5_upload_data a,asg_user b, csm_html5_sync_info c
3581: where a.status<>'PARSED' and a.session_id=c.session_id
3582: and nvl(fnd_profile.value_specific('ASG_SYNCHRONOUS_UPLOAD',b.user_id,b.responsibility_id,b.app_id),'N')='N'
3583: and b.user_name=c.user_name and b.multi_platform='Y' and b.enabled='Y' ORDER BY c.USER_NAME,a.SESSION_ID ASC)
3584: LOOP
3585: IF(l_uname IS NULL OR l_uname<>rec.USER_NAME) THEN
3586: CSM_HTML5_PKG.HTML5_PARSE_XML(rec.SESSION_ID,RETCODE,errbuf);

Line 3622: IF instr(NVL(fnd_profile.value('APPS_SSO'),'NULL'),'SSO')>0 THEN RETURN 'Y'; END IF;

3618:
3619: FUNCTION isSSOEnabled RETURN VARCHAR2
3620: IS
3621: BEGIN
3622: IF instr(NVL(fnd_profile.value('APPS_SSO'),'NULL'),'SSO')>0 THEN RETURN 'Y'; END IF;
3623: RETURN 'N';
3624: END isSSOEnabled;
3625:
3626: PROCEDURE setForceLocalLogin(p_user_name IN VARCHAR2,p_v IN VARCHAR2)

Line 3667: IF (instr(NVL(fnd_profile.value('APPS_SSO'),'NULL'),'SSO')>0)

3663: SELECT user_id,responsibility_id, app_id
3664: INTO l_user_id,l_resp_id,l_app_id
3665: FROM asg_user WHERE user_name=p_user_name;
3666:
3667: IF (instr(NVL(fnd_profile.value('APPS_SSO'),'NULL'),'SSO')>0)
3668: AND (NVL(fnd_profile.value_specific('APPS_SSO_LOCAL_LOGIN',l_user_id,l_resp_id,l_app_id),'BOTH')<>'LOCAL') THEN
3669: RETURN TRUE;
3670: END IF;
3671:

Line 3668: AND (NVL(fnd_profile.value_specific('APPS_SSO_LOCAL_LOGIN',l_user_id,l_resp_id,l_app_id),'BOTH')<>'LOCAL') THEN

3664: INTO l_user_id,l_resp_id,l_app_id
3665: FROM asg_user WHERE user_name=p_user_name;
3666:
3667: IF (instr(NVL(fnd_profile.value('APPS_SSO'),'NULL'),'SSO')>0)
3668: AND (NVL(fnd_profile.value_specific('APPS_SSO_LOCAL_LOGIN',l_user_id,l_resp_id,l_app_id),'BOTH')<>'LOCAL') THEN
3669: RETURN TRUE;
3670: END IF;
3671:
3672: RETURN FALSE;

Line 3720: ||';'|| fnd_profile.value_specific('CSM_MULTI_APP_STORE_URL',USER_ID,RESPONSIBILITY_ID)

3716: IS
3717: l_store VARCHAR2(4000);
3718: BEGIN
3719: SELECT (SELECT NVL(MAX(PRF_VALUE),'N') FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME='APPLICATION' AND PRF_NAME='FORCE_UPDATE')
3720: ||';'|| fnd_profile.value_specific('CSM_MULTI_APP_STORE_URL',USER_ID,RESPONSIBILITY_ID)
3721: INTO l_store
3722: FROM ASG_USER WHERE USER_NAME=p_user_name;
3723:
3724: RETURN l_store;