APPS.MSC_PQ_UTILS dependencies on FND_PROFILE

Line 1869: l_profile := nvl(FND_PROFILE.VALUE('MSC_PQUERY_EXEC_WITH_CRITERIA'), 'Y');

1865: open c_validate;
1866: fetch c_validate into l_temp;
1867: close c_validate;
1868: END IF;
1869: l_profile := nvl(FND_PROFILE.VALUE('MSC_PQUERY_EXEC_WITH_CRITERIA'), 'Y');
1870: l_temp := nvl(l_temp,0);
1871: if (l_temp = 0 and l_profile = 'Y' ) then
1872: if (p_query_type = 1) then
1873: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_YES');

Line 2266: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

2262: l_list VARCHAR2(500);
2263:
2264: l_transaction_id NUMBER;
2265: l_auto_release NUMBER;
2266: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2267: l_errbuf VARCHAR2(2000);
2268: l_retcode NUMBER;
2269: BEGIN
2270: -- ---------------------------------

Line 3502: mime_type := NVL(fnd_profile.value('FND_EXPORT_MIME_TYPE'), 'text/tab-separated-values');

3498: end if;
3499:
3500: END IF;
3501: IF exist_flag ='N' THEN
3502: mime_type := NVL(fnd_profile.value('FND_EXPORT_MIME_TYPE'), 'text/tab-separated-values');
3503: -- mime_type := 'text/comma-separated-values';
3504: db_file := fnd_gfm.file_create(file_name=>filename,content_type => mime_type, program_name => 'export');
3505: file_open := TRUE;
3506: output_string := NULL;