307: l_dbc VARCHAR2(2000);
308: l_language_code VARCHAR2(2000);
309: BEGIN
310:
311: IF icx_sec.validateSession THEN
312:
313: l_session_id := ICX_SEC.g_session_id; --pass g_session_id
314: l_transaction_id := icx_sec.createTransaction(l_session_id);
315: l_dbc := FND_WEB_CONFIG.DATABASE_ID;
309: BEGIN
310:
311: IF icx_sec.validateSession THEN
312:
313: l_session_id := ICX_SEC.g_session_id; --pass g_session_id
314: l_transaction_id := icx_sec.createTransaction(l_session_id);
315: l_dbc := FND_WEB_CONFIG.DATABASE_ID;
316: l_language_code := icx_sec.g_language_code;
317:
310:
311: IF icx_sec.validateSession THEN
312:
313: l_session_id := ICX_SEC.g_session_id; --pass g_session_id
314: l_transaction_id := icx_sec.createTransaction(l_session_id);
315: l_dbc := FND_WEB_CONFIG.DATABASE_ID;
316: l_language_code := icx_sec.g_language_code;
317:
318: l_url := RTRIM(LTRIM(fnd_profile.value('APPS_FRAMEWORK_AGENT')));
312:
313: l_session_id := ICX_SEC.g_session_id; --pass g_session_id
314: l_transaction_id := icx_sec.createTransaction(l_session_id);
315: l_dbc := FND_WEB_CONFIG.DATABASE_ID;
316: l_language_code := icx_sec.g_language_code;
317:
318: l_url := RTRIM(LTRIM(fnd_profile.value('APPS_FRAMEWORK_AGENT')));
319: IF SUBSTRB(l_url, -1, 1) <> '/' THEN
320: l_url := l_url||'/';
344: p_mime_type IN VARCHAR2 := 'image/gif'
345: ) IS
346: doc blob;
347: BEGIN
348: IF icx_sec.validateSession THEN
349: SELECT bsi.file_body
350: INTO doc
351: FROM bsc_sys_images bsi, bsc_sys_images_map_vl bsim, bsc_user_tab_access bta
352: WHERE bsim.image_id = bsi.image_id AND bsim.source_type = 1