APPS.MSC_UTIL dependencies on FND_PROFILE

Line 1305: ||' :v_level:= nvl(fnd_profile.value'||l_dblink||'(:p_profile),3);'

1301: CLOSE db_cur;
1302: ELSE
1303: l_dblink := '@'||P_dblink;
1304: l_sql_stmt := ' BEGIN'
1305: ||' :v_level:= nvl(fnd_profile.value'||l_dblink||'(:p_profile),3);'
1306: ||' END;';
1307:
1308: EXECUTE IMMEDIATE l_sql_stmt USING OUT l_level,
1309: IN l_profile;

Line 1311: l_level_dest := NVL(fnd_profile.value(l_profile),3);

1307:
1308: EXECUTE IMMEDIATE l_sql_stmt USING OUT l_level,
1309: IN l_profile;
1310: END IF;
1311: l_level_dest := NVL(fnd_profile.value(l_profile),3);
1312:
1313: IF l_level < l_level_dest THEN
1314: RETURN l_level;
1315: ELSE

Line 1370: SELECT NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0)

1366: END IF;
1367: END IF;
1368:
1369: BEGIN
1370: SELECT NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0)
1371: INTO v_msc_tp_coll_window
1372: FROM DUAL;
1373: EXCEPTION
1374: WHEN OTHERS THEN

Line 1408: l_cat_set := FND_PROFILE.VALUE('MSC_SERVICE_ITEMS_CATSET') ;

1404: l_cat_set VARCHAR2(30) := NULL ;
1405: BEGIN
1406: IF G_CAT_SET_ID IS NULL THEN
1407:
1408: l_cat_set := FND_PROFILE.VALUE('MSC_SERVICE_ITEMS_CATSET') ;
1409: SELECT CATEGORY_SET_ID INTO G_CAT_SET_ID
1410: FROM MSC_CATEGORY_SETS
1411: WHERE CATEGORY_SET_NAME = l_cat_set;
1412: END IF ;