APPS.GL_AUTO_ALLOC_WF_PKG dependencies on DUAL

Line 2699: FROM DUAL

2695: c_je_batch_id VARCHAR2(240) := to_char(l_je_batch_id);
2696:
2697: CURSOR check_untaxed IS
2698: SELECT 'untaxed journals'
2699: FROM DUAL
2700: WHERE EXISTS
2701: (SELECT 'UNTAXED'
2702: FROM GL_JE_HEADERS JEH,
2703: GL_LEDGERS LGR

Line 3220: select userenv('LANG') into l_userenv_lang from dual;

3216: (p_item_type,
3217: p_item_key,
3218: 'RESP_APPL_ID');
3219:
3220: select userenv('LANG') into l_userenv_lang from dual;
3221: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
3222: diagn_debug_msg('WAITING_TO_COMPLETE: ' || 'LANG='||l_userenv_lang);
3223: END IF;
3224: select userenv('CLIENT_INFO') into l_client_info from dual;

Line 3224: select userenv('CLIENT_INFO') into l_client_info from dual;

3220: select userenv('LANG') into l_userenv_lang from dual;
3221: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
3222: diagn_debug_msg('WAITING_TO_COMPLETE: ' || 'LANG='||l_userenv_lang);
3223: END IF;
3224: select userenv('CLIENT_INFO') into l_client_info from dual;
3225: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
3226: diagn_debug_msg('WAITING_TO_COMPLETE: ' || 'CLINT_INFO='||l_client_info);
3227: END IF;
3228:

Line 3968: select userenv('LANG') into l_userenv_lang from dual;

3964: FND_PROFILE.put('USER_ID', l_user_id );
3965: FND_PROFILE.put('RESP_ID', l_resp_id);
3966: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
3967:
3968: select userenv('LANG') into l_userenv_lang from dual;
3969: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
3970: diagn_debug_msg('Submit_Request: ' || 'LANG='||l_userenv_lang);
3971: END IF;
3972: select userenv('CLIENT_INFO') into l_client_info from dual;

Line 3972: select userenv('CLIENT_INFO') into l_client_info from dual;

3968: select userenv('LANG') into l_userenv_lang from dual;
3969: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
3970: diagn_debug_msg('Submit_Request: ' || 'LANG='||l_userenv_lang);
3971: END IF;
3972: select userenv('CLIENT_INFO') into l_client_info from dual;
3973: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
3974: diagn_debug_msg('Submit_Request: ' || 'CLINT_INFO='||l_client_info);
3975: END IF;
3976:

Line 4010: select nvl(userenv('LANG'),'US') into l_userenv_lang from dual;

4006: itemkey => p_item_key,
4007: aname => 'CONC_PRG_CODE',
4008: avalue => Prog_Code );
4009:
4010: select nvl(userenv('LANG'),'US') into l_userenv_lang from dual;
4011: Open conc_prog_name_C;
4012: Fetch conc_prog_name_C into l_conc_prg_name;
4013: Close conc_prog_name_C;
4014: