DBA Data[Home] [Help]

APPS.EGO_ITEM_PEOPLE_IMPORT_PKG dependencies on V$PARAMETER

Line 1594: FROM V$PARAMETER

1590: PROCEDURE open_debug_session IS
1591:
1592: CURSOR c_get_utl_file_dir IS
1593: SELECT VALUE
1594: FROM V$PARAMETER
1595: WHERE NAME = 'utl_file_dir';
1596:
1597: --local variables
1598: --EMTAPIA: modified length of varchar l_log_output_dir from 200 to 200 for bug: 7041983

Line 1601: l_log_output_dir v$parameter.value%type;

1597: --local variables
1598: --EMTAPIA: modified length of varchar l_log_output_dir from 200 to 200 for bug: 7041983
1599: --l_log_output_dir VARCHAR2(200);
1600: -- Bug 13074883 swuppala : Replaced teh varchar2(2000) with the datatype
1601: l_log_output_dir v$parameter.value%type;
1602: l_log_return_status VARCHAR2(99);
1603: l_errbuff VARCHAR2(999);
1604: BEGIN
1605:

Line 1901: FROM V$PARAMETER

1897: -- Select the directory where the error log file needs to be saved
1898: --
1899: CURSOR c_get_utl_file_dir IS
1900: SELECT VALUE
1901: FROM V$PARAMETER
1902: WHERE NAME = 'utl_file_dir';
1903:
1904: l_token_tbl_none Error_Handler.Token_Tbl_Type;
1905: l_token_tbl_one Error_Handler.Token_Tbl_Type;