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.
398: -- {Start Of Comments}
399: --
400: -- Description:
401: -- Obtains the effective_start_date and effective_end_date column display
402: -- prompts, from DT_DATE_PROMPTS_TL, for a particular language.
403: --
404: -- Prerequisites:
405: -- None.
406: --
440: --
441: cursor csr_prompts is
442: select effective_start_prompt
443: , effective_end_prompt
444: from dt_date_prompts_tl
445: where language = p_language_code;
446: --
447: l_proc varchar2(72) := g_package||'get_date_prompts';
448: begin
550: -- characters are replaced with spaces and initcap the remaining text.
551: --
552: -- END IF
553: --
554: -- Get p_effective_start_prompt value from DT_DATE_PROMPTS_TL
555: -- Get p_effective_end_prompt value from DT_DATE_PROMPTS_TL
556: --
557: begin
558: hr_utility.set_location('Entering:'||l_proc, 10);
551: --
552: -- END IF
553: --
554: -- Get p_effective_start_prompt value from DT_DATE_PROMPTS_TL
555: -- Get p_effective_end_prompt value from DT_DATE_PROMPTS_TL
556: --
557: begin
558: hr_utility.set_location('Entering:'||l_proc, 10);
559: --