[Home] [Help]
13: --
14: MODIFIED (DD-MON-YYYY)
15: P.K.Attwood 03-JUN-1994 - created.
16: P.K.Attwood 19-JUL-1994 - Added extra check for _D view. If the _D view
17: cannot be found in user_views go onto check
18: for a synonym, as the user could be logged on
19: as a secure user.
20: P.K.Attwood 23-JAN-1996 - Fix for wwbug 295511. Added extra parameter
21: p_view_owner to the get_view_and_prompts
138: -- specified language.
139: --
140: -- Post Success:
141: -- p_view_found will be set to false if the view definition does not exist
142: -- in user_views. All other OUT parameters will be null.
143: --
144: -- Name Type Description
145: -- p_view_found boolean Indicates if the view definition
146: -- was found in user_views.
142: -- in user_views. All other OUT parameters will be null.
143: --
144: -- Name Type Description
145: -- p_view_found boolean Indicates if the view definition
146: -- was found in user_views.
147: -- p_view_owner varchar2 Name of the database account
148: -- which owns the view.
149: -- p_title_prompt varchar2 User entity name to include in
150: -- the window title prompt. Derived
169: -- Cursor to find view definition
170: --
171: cursor csr_view_exists is
172: select user
173: from user_views
174: where view_name = p_view_name;
175: --
176: -- Cursor to obtain the entity title name.
177: --
271: ) is
272: --
273: -- Declare local variables
274: --
275: l_table_trim user_views.view_name%type; -- Table name, without white
276: -- space, without _F and in
277: -- uppercase.
278: l_name_length number; -- Length of the table
279: -- name provided without white
481: ) is
482: --
483: -- Declare local variables
484: --
485: l_view_name user_views.view_name%type; -- Name of the view, or table,
486: -- to return OUT of this
487: -- procedure.
488: l_al_view_name user_views.view_name%type; -- Alternative DT history view
489: -- in upper case.
484: --
485: l_view_name user_views.view_name%type; -- Name of the view, or table,
486: -- to return OUT of this
487: -- procedure.
488: l_al_view_name user_views.view_name%type; -- Alternative DT history view
489: -- in upper case.
490: l_st_view_name user_views.view_name%type; -- Standard DT history _D view
491: -- in upper case.
492: l_al_view_found boolean default false; -- Indicates if the alternative
486: -- to return OUT of this
487: -- procedure.
488: l_al_view_name user_views.view_name%type; -- Alternative DT history view
489: -- in upper case.
490: l_st_view_name user_views.view_name%type; -- Standard DT history _D view
491: -- in upper case.
492: l_al_view_found boolean default false; -- Indicates if the alternative
493: -- DT history view exists.
494: l_st_view_found boolean default false; -- Indicates if the standard
514: --
515: -- Get language from userenv('LANG')
516: --
517: -- IF alternative_history_view has been specified THEN
518: -- Check to see if alternative_history_view exists in user_views
519: -- Get the view owner account name from "user" and the title name
520: -- from DT_TITLE_PROMPTS_TL.
521: -- END IF
522: --
522: --
523: -- IF (alternative_history_view has NOT been specified) OR
524: -- (alternative_history_view was specified but was not found) THEN
525: -- Check to see if standard
526: -- in user_views
527: -- Get the view owner account name from "user" and the title name
528: -- from DT_TITLE_PROMPTS_TL.
529: --
530: -- N.B. From R11.0 onwards it is no longer necessary to double check