APPS.MSC_UTIL dependencies on FND_PROFILE

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

1043: CLOSE db_cur;
1044: ELSE
1045: l_dblink := '@'||P_dblink;
1046: l_sql_stmt := ' BEGIN'
1047: ||' :v_level:= nvl(fnd_profile.value'||l_dblink||'(:p_profile),3);'
1048: ||' END;';
1049:
1050: EXECUTE IMMEDIATE l_sql_stmt USING OUT l_level,
1051: IN l_profile;

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

1049:
1050: EXECUTE IMMEDIATE l_sql_stmt USING OUT l_level,
1051: IN l_profile;
1052: END IF;
1053: l_level_dest := NVL(fnd_profile.value(l_profile),3);
1054:
1055: IF l_level < l_level_dest THEN
1056: RETURN l_level;
1057: ELSE

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

1110:
1111:
1112:
1113: BEGIN
1114: SELECT NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0)
1115: INTO v_msc_tp_coll_window
1116: FROM DUAL;
1117: EXCEPTION
1118: WHEN OTHERS THEN