DBA Data[Home] [Help]

APPS.ASL_EXCEL_UTIL_PVT dependencies on FND_GLOBAL

Line 206: AND INSTR(l_inv_categories, fnd_global.local_chr(39)||to_char(CATEGORY_ID)|| fnd_global.local_chr(39))>0;

202: CURSOR C_DOWNLOADED_INV_CATEGORY(p_org_id NUMBER, p_user_id NUMBER, p_app_id NUMBER, p_resp_id NUMBER) IS
203: SELECT DISTINCT CATEGORY_ID
204: FROM MTL_ITEM_CATEGORIES
205: WHERE ORGANIZATION_ID = p_org_id
206: AND INSTR(l_inv_categories, fnd_global.local_chr(39)||to_char(CATEGORY_ID)|| fnd_global.local_chr(39))>0;
207:
208: l_old_inv_catgry_rec ASL_OLD_INV_CATEGORY_REC_TYPE;
209: BEGIN
210: SELECT FND_PROFILE.VALUE_SPECIFIC('ASL_EXCEL_INV_CATEGORY',p_user_id, p_resp_id, p_app_id)

Line 254: l_prof_price_list_headers := replace( l_prof_price_list_headers ,fnd_global.local_chr(39),'');

250:
251: SELECT FND_PROFILE.VALUE_SPECIFIC('ASL_EXCEL_PRICE_LIST',p_user_id,p_resp_id,p_app_id) into l_prof_price_list_headers FROM DUAL;
252: l_prof_price_list_headers := replace( l_prof_price_list_headers ,'(','');
253: l_prof_price_list_headers := replace( l_prof_price_list_headers ,')','');
254: l_prof_price_list_headers := replace( l_prof_price_list_headers ,fnd_global.local_chr(39),'');
255:
256:
257: while (INSTR(l_prof_price_list_headers, ',') > 0)
258: LOOP