DBA Data[Home] [Help]

APPS.CSD_GEN_UTILITY_PVT dependencies on DUAL

Line 11: SELECT USERENV('SESSIONID') INTO l_audsid FROM sys.dual;

7: l_os_user VARCHAR2(30);
8: BEGIN
9: IF csd_gen_utility_pvt.g_debug = fnd_api.g_false THEN
10: IF csd_gen_utility_pvt.g_file IS NULL THEN
11: SELECT USERENV('SESSIONID') INTO l_audsid FROM sys.dual;
12:
13: SELECT sid, SUBSTR(osuser,1,8) INTO l_sid ,l_os_user
14: FROM v$session
15: WHERE audsid = l_audsid;

Line 19: FROM dual;

15: WHERE audsid = l_audsid;
16:
17: SELECT l_os_user||'.csd'||TO_CHAR(l_sid)||'.dbg'
18: INTO csd_gen_utility_pvt.g_file
19: FROM dual;
20: csd_gen_utility_pvt.g_file_ptr := utl_file.fopen(G_DIR, G_FILE, 'w');
21: ELSE
22: csd_gen_utility_pvt.g_file_ptr := utl_file.fopen(G_DIR, G_FILE, 'a');
23: END IF;