APPS.ASG_HELPER dependencies on FND_PROFILE

Line 1202: l_ret:=fnd_profile.save('APPS_SSO_LOCAL_LOGIN','BOTH','USER',p_userId);

1198: PROCEDURE set_sso_profile(p_userId in VARCHAR2)
1199: IS
1200: l_ret boolean;
1201: BEGIN
1202: l_ret:=fnd_profile.save('APPS_SSO_LOCAL_LOGIN','BOTH','USER',p_userId);
1203: commit;
1204: EXCEPTION
1205: WHEN OTHERS then
1206: rollback;

Line 1396: from fnd_profile_options

1392: is
1393: cursor c_get_profile_option_id(l_profile_name varchar2)
1394: is
1395: select profile_option_id, application_id
1396: from fnd_profile_options
1397: where ( END_dATE_ACTIVE IS NULL OR END_dATE_ACTIVE > SYSDATE )
1398: AND profile_option_name = l_profile_name;
1399:
1400: cursor c_profile_reset(l_app_id number, l_profile_id number,l_level_id number)

Line 1403: from fnd_profile_option_values

1399:
1400: cursor c_profile_reset(l_app_id number, l_profile_id number,l_level_id number)
1401: is
1402: select profile_option_value,level_value,level_id
1403: from fnd_profile_option_values
1404: where application_id = l_app_id and
1405: profile_option_id = l_profile_id and
1406: level_id = l_level_id ;
1407:

Line 1425: l_ret := fnd_profile.save(p_profile_name,null,'SITE');

1421: open c_profile_reset(l_app_id, l_prof_id,10001);
1422: loop
1423: fetch c_profile_reset into l_profile_var;
1424: exit when c_profile_reset%NOTFOUND;
1425: l_ret := fnd_profile.save(p_profile_name,null,'SITE');
1426: end loop;
1427: close c_profile_reset;
1428:
1429: --set to null at application level : 10002

Line 1434: l_ret :=fnd_profile.save(p_profile_name,null,'APPL',

1430: open c_profile_reset(l_app_id, l_prof_id,10002);
1431: loop
1432: fetch c_profile_reset into l_profile_var;
1433: exit when c_profile_reset%NOTFOUND;
1434: l_ret :=fnd_profile.save(p_profile_name,null,'APPL',
1435: l_profile_var.level_value);
1436: end loop;
1437: close c_profile_reset;
1438:

Line 1444: l_ret := fnd_profile.save(p_profile_name,null,'RESP',

1440: open c_profile_reset(l_app_id,l_prof_id,10003);
1441: loop
1442: fetch c_profile_reset into l_profile_var;
1443: exit when c_profile_reset%NOTFOUND;
1444: l_ret := fnd_profile.save(p_profile_name,null,'RESP',
1445: l_profile_var.level_value,l_app_id);
1446: end loop;
1447: close c_profile_reset;
1448:

Line 1454: l_ret := fnd_profile.save(p_profile_name,null,'USER',

1450: open c_profile_reset(l_app_id, l_prof_id,10004);
1451: loop
1452: fetch c_profile_reset into l_profile_var;
1453: exit when c_profile_reset%NOTFOUND;
1454: l_ret := fnd_profile.save(p_profile_name,null,'USER',
1455: l_profile_var.level_value);
1456: end loop;
1457: close c_profile_reset;
1458: end if;