DBA Data[Home] [Help]

APPS.CTO_WIP_WORKFLOW_API_PK dependencies on V$PARAMETER2

Line 89: /* -- begin bugfix 3511114: use v$parameter2 instead.

85:
86:
87: if CTO_WIP_WORKFLOW_API_PK.file_dir is null then
88:
89: /* -- begin bugfix 3511114: use v$parameter2 instead.
90: *
91: * select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
92: * into file_dir
93: * from v$parameter

Line 99: -- begin bugfix 3511114: use v$parameter2 instead.

95: *
96: * -- end bugfix 3511114
97: * */
98:
99: -- begin bugfix 3511114: use v$parameter2 instead.
100:
101: select ltrim(rtrim(value))
102: into file_dir
103: from (select value from v$parameter2

Line 103: from (select value from v$parameter2

99: -- begin bugfix 3511114: use v$parameter2 instead.
100:
101: select ltrim(rtrim(value))
102: into file_dir
103: from (select value from v$parameter2
104: where name='utl_file_dir'
105: order by rownum desc)
106: where rownum <2;
107: