APPS.HR_HISTORY dependencies on DT_TITLE_PROMPTS_TL

Line 42: DT_TITLE_PROMPTS_TL and DT_DATE_PROMPTS_TL.

38: P.K.Attwood 16-MAR-1999 - 115.2 Changes made to provide MLS for
39: DateTrack History prompts.
40: Changed table name references from
41: DT_TITLE_PROMPTS and DT_DATE_PROMPTS to
42: DT_TITLE_PROMPTS_TL and DT_DATE_PROMPTS_TL.
43: Changed the get_view_and_prompts
44: p_language_code parameter from IN to OUT.
45: Value is now derived from userenv('LANG').
46: Added find_language_code procedure.

Line 128: -- title prompt from DT_TITLE_PROMPTS_TL.

124: --
125: -- Description:
126: -- Checks if the specified view exists in the current database account.
127: -- If it exists also derived the name of the database account and the
128: -- title prompt from DT_TITLE_PROMPTS_TL.
129: --
130: -- Prerequisites:
131: -- p_view_name must be in upper case.
132: --

Line 151: -- from the DT_TITLE_PROMPTS_TL.

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
151: -- from the DT_TITLE_PROMPTS_TL.
152: --
153: -- Post Failure:
154: -- Processing stops and an error is raised if an unexpected error occurs.
155: --

Line 180: from dt_title_prompts_tl

176: -- Cursor to obtain the entity title name.
177: --
178: cursor csr_title is
179: select title_prompt
180: from dt_title_prompts_tl
181: where view_name = p_view_name
182: and language = p_language_code;
183: --
184: -- Declare local variables

Line 520: -- from DT_TITLE_PROMPTS_TL.

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: --
523: -- IF (alternative_history_view has NOT been specified) OR
524: -- (alternative_history_view was specified but was not found) THEN

Line 528: -- from DT_TITLE_PROMPTS_TL.

524: -- (alternative_history_view was specified but was not found) THEN
525: -- Check to see if standard _D view exists
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
531: -- for a synonym. Secure users now connect to the APPS account
532: -- where the view definitions are held.