APPS.ASG_HELPER dependencies on FND_PROFILE

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

1135: PROCEDURE set_sso_profile(p_userId in VARCHAR2)
1136: IS
1137: l_ret boolean;
1138: BEGIN
1139: l_ret:=fnd_profile.save('APPS_SSO_LOCAL_LOGIN','BOTH','USER',p_userId);
1140: commit;
1141: EXCEPTION
1142: WHEN OTHERS then
1143: rollback;

Line 1333: from fnd_profile_options

1329: is
1330: cursor c_get_profile_option_id(l_profile_name varchar2)
1331: is
1332: select profile_option_id, application_id
1333: from fnd_profile_options
1334: where ( END_dATE_ACTIVE IS NULL OR END_dATE_ACTIVE > SYSDATE )
1335: AND profile_option_name = l_profile_name;
1336:
1337: cursor c_profile_reset(l_app_id number, l_profile_id number,l_level_id number)

Line 1340: from fnd_profile_option_values

1336:
1337: cursor c_profile_reset(l_app_id number, l_profile_id number,l_level_id number)
1338: is
1339: select profile_option_value,level_value,level_id
1340: from fnd_profile_option_values
1341: where application_id = l_app_id and
1342: profile_option_id = l_profile_id and
1343: level_id = l_level_id ;
1344:

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

1358: open c_profile_reset(l_app_id, l_prof_id,10001);
1359: loop
1360: fetch c_profile_reset into l_profile_var;
1361: exit when c_profile_reset%NOTFOUND;
1362: l_ret := fnd_profile.save(p_profile_name,null,'SITE');
1363: end loop;
1364: close c_profile_reset;
1365:
1366: --set to null at application level : 10002

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

1367: open c_profile_reset(l_app_id, l_prof_id,10002);
1368: loop
1369: fetch c_profile_reset into l_profile_var;
1370: exit when c_profile_reset%NOTFOUND;
1371: l_ret :=fnd_profile.save(p_profile_name,null,'APPL',
1372: l_profile_var.level_value);
1373: end loop;
1374: close c_profile_reset;
1375:

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

1377: open c_profile_reset(l_app_id,l_prof_id,10003);
1378: loop
1379: fetch c_profile_reset into l_profile_var;
1380: exit when c_profile_reset%NOTFOUND;
1381: l_ret := fnd_profile.save(p_profile_name,null,'RESP',
1382: l_profile_var.level_value,l_app_id);
1383: end loop;
1384: close c_profile_reset;
1385:

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

1387: open c_profile_reset(l_app_id, l_prof_id,10004);
1388: loop
1389: fetch c_profile_reset into l_profile_var;
1390: exit when c_profile_reset%NOTFOUND;
1391: l_ret := fnd_profile.save(p_profile_name,null,'USER',
1392: l_profile_var.level_value);
1393: end loop;
1394: close c_profile_reset;
1395: end if;