APPS.ASL_EXCEL_UTIL_PVT dependencies on FND_PROFILE

Line 195: (SELECT FND_PROFILE.VALUE_SPECIFIC('ASL_EXCEL_INV_CATEGORY',p_user_id,p_resp_id,p_app_id)

191: SELECT DISTINCT CATEGORY_ID
192: FROM MTL_ITEM_CATEGORIES
193: WHERE ORGANIZATION_ID = p_org_id
194: AND CATEGORY_ID in
195: (SELECT FND_PROFILE.VALUE_SPECIFIC('ASL_EXCEL_INV_CATEGORY',p_user_id,p_resp_id,p_app_id)
196: FROM DUAL
197: );
198:
199: */

Line 210: SELECT FND_PROFILE.VALUE_SPECIFIC('ASL_EXCEL_INV_CATEGORY',p_user_id, p_resp_id, p_app_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)
211: INTO l_inv_categories
212: FROM DUAL;
213:
214: FOR r_old_inv_catgry_rec IN C_DOWNLOADED_INV_CATEGORY (p_org_id,p_user_id,p_app_id,p_resp_id) LOOP

Line 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;

247: FROM QP_LIST_HEADERS_B
248: WHERE LIST_HEADER_ID = p_header_id;
249: BEGIN
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:

Line 307: ** last_sync_time comes from FND_PROFILE 'ASL_EXCEL_LAST_SYNC_TIME'. If the value

303: ** It doesn't do any validation on the passed in values. Assumeably ASF_PAGE
304: ** Already done that.
305: ** If incremental sync is implmented, save the new-added Organization for
306: ** Check_Org_Download Method
307: ** last_sync_time comes from FND_PROFILE 'ASL_EXCEL_LAST_SYNC_TIME'. If the value
308: ** is null, it means this user never synced, set the M_FULL_SYNC to true no matter
309: ** what value client sends over.
310: */
311: PROCEDURE SAVE_SYNC_CONTEXT

Line 332: -- l_last_sync_time_str := FND_PROFILE.VALUE('ASL_EXCEL_LAST_SYNC_TIME');

328: t_salesgroup_id := p_salesgroup_id;
329: t_manager_flag := CHECK_MANAGER_FLAG(t_salesgroup_id);
330: -- t_last_sync_time := p_last_sync_time;
331:
332: -- l_last_sync_time_str := FND_PROFILE.VALUE('ASL_EXCEL_LAST_SYNC_TIME');
333: BEGIN
334: FND_PROFILE.GET_SPECIFIC(name_z => 'ASL_EXCEL_LAST_SYNC_TIME',
335: user_id_z => p_user_id ,
336: val_z => l_last_sync_time_str,

Line 334: FND_PROFILE.GET_SPECIFIC(name_z => 'ASL_EXCEL_LAST_SYNC_TIME',

330: -- t_last_sync_time := p_last_sync_time;
331:
332: -- l_last_sync_time_str := FND_PROFILE.VALUE('ASL_EXCEL_LAST_SYNC_TIME');
333: BEGIN
334: FND_PROFILE.GET_SPECIFIC(name_z => 'ASL_EXCEL_LAST_SYNC_TIME',
335: user_id_z => p_user_id ,
336: val_z => l_last_sync_time_str,
337: defined_z => l_defined );
338: EXCEPTION