[Home] [Help]
27: New DateTrack History feature.
28: The Forms coder can optionally specify an
29: alternative DateTrack History view. If this
30: view name is not specified or cannot be
31: found in the database then the standard _D
32: view or _F table will be used as before.
33: To provide the required behaviour re-wrote
34: get_view_and_prompts procedure and simplified
35: the logic due to security changes in R11.0.
234: -- ----------------------------------------------------------------------------
235: -- {Start Of Comments}
236: --
237: -- Description:
238: -- Takes the provided table name and returns the name of the standard _D
239: -- DateTrack history view. Just in case the Form FND_SESSION view name
240: -- has been provided by mistake, the table name is also formatted. Appending
241: -- an _F suffix if it does not exist. All values are returned in uppercase.
242: -- For example, if p_table_name is set to 'per_all_people' then
250: -- Name Reqd Type Description
251: -- p_table_name Yes varchar2 Name of the table.
252: --
253: -- Post Success:
254: -- Returns name of the standard _D DateTrack history view and the name of
255: -- the _F table and the name of table without the '_F' suffix. All in upper
256: -- case.
257: --
258: -- Post Failure:
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
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
495: -- DT history _D view exists.
496: l_st_table_name varchar2(30); -- Formatted table name, with
497: -- _F suffix, in upper case.
498: l_st_table_name_trim varchar2(30); -- Name of the table, without
521: -- END IF
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
527: -- Get the view owner account name from "user" and the title name
528: -- from DT_TITLE_PROMPTS_TL.
529: --
578: end if;
579: --
580: -- If the alternative history view has not been specified OR
581: -- it was specified but was not found then check to see if the
582: -- standard DateTrack History _D view can be found.
583: --
584: if not l_al_view_found then
585: -- First, work out the full table name, name
586: -- of the standard _D view and format table.
582: -- standard DateTrack History _D view can be found.
583: --
584: if not l_al_view_found then
585: -- First, work out the full table name, name
586: -- of the standard _D view and format table.
587: derive_view_table_names
588: (p_table_name => p_table_name
589: ,p_st_view_name => l_st_view_name
590: ,p_st_table_name => l_st_table_name
621: l_view_name := l_al_view_name;
622: --
623: elsif l_st_view_found then
624: --
625: -- The standard view was found.
626: --
627: l_view_name := l_st_view_name;
628: --
629: else