DBA Data[Home] [Help]

APPS.MSC_PQ_UTILS dependencies on FND_PROFILE

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

1837: open c_validate;
1838: fetch c_validate into l_temp;
1839: close c_validate;
1840: END IF;
1841: l_profile := nvl(FND_PROFILE.VALUE('MSC_PQUERY_EXEC_WITH_CRITERIA'), 'Y');
1842: l_temp := nvl(l_temp,0);
1843: if (l_temp = 0 and l_profile = 'Y' ) then
1844: if (p_query_type = 1) then
1845: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_YES');

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

2212: l_list VARCHAR2(500);
2213:
2214: l_transaction_id NUMBER;
2215: l_auto_release NUMBER;
2216: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2217: l_errbuf VARCHAR2(2000);
2218: l_retcode NUMBER;
2219: BEGIN
2220: -- ---------------------------------