1 package hr_history AUTHID CURRENT_USER as
2 /* $Header: dthistry.pkh 115.5 2002/12/05 15:08:07 apholt ship $ */
3 /*
4 --
5 -- Copyright (c) Oracle Corporation 1991, 1992, 1993. All rights reserved.
6 --
7 /*
8 NAME
9 dthistry.pkh
10 --
11 DESCRIPTION
12 Package header for the DateTrack History PL/SQL procedures.
13 This package is used by Forms 4 DateTrack History.
14 --
15 MODIFIED (DD-MON-YYYY)
16 P.K.Attwood 03-JUN-1994 - created.
17 P.K.Attwood 23-JAN-1996 - Fix for wwbug 295511. Added extra parameter
18 p_view_owner to the get_view_and_prompts
19 procedure. It returns the name of the Oracle
20 account which actually owns the _D view or
21 _F table. This is required for extra secure
22 user logic.
23 P.K.Attwood 08-MAY-1998 - 115.1 Changes for wwbug 658889.
24 New DateTrack History feature.
25 The Forms coder can optionally specify an
26 alternative DateTrack History view. If this
27 view name is not specified or cannot be
28 found in the database then the standard _D
29 view or _F table will be used as before.
30 P.K.Attwood 16-MAR-1999 - 115.2 Changes made to provide MLS for
31 DateTrack History prompts. Altered the
32 p_language_code parameter from IN to OUT
33 on the get_view_and_prompts procedure.
34 S.McMillan 09-APR-2001 - Added function fetch_dt_column_prompt.
35 M.Enderby 28-NOV-2002 - GSCC changes (bug 2620598)
36 A.Holt 05-Dec-2002 - NOCOPY Performance Changes for 11.5.9*/
37 --
38 -- ----------------------------------------------------------------------------
39 -- |-------------------------< get_view_and_prompts >-------------------------|
40 -- ----------------------------------------------------------------------------
41 -- {Start Of Comments}
42 --
43 -- Description:
44 -- Workout which view or table the DateTrack History Form should
45 -- use to obtain data. Also returns some display prompts for the
46 -- session's current language.
47 --
48 -- Prerequisites:
49 -- This procedure should only be executed from the DateTrack History Form.
50 --
51 -- In Parameters:
52 -- Name Reqd Type Description
53 -- p_table_name Yes varchar2 Name of the DateTrack table.
54 -- p_alternative_history_view Yes varchar2 Name of an override
55 -- DateTrack History view.
56 -- This parameter can be set
57 -- to null.
58 --
59 -- Post Success:
60 -- If the alternative view, standard DateTrack History view or table
61 -- can be found in the database then the following OUT parameters will
62 -- be populated.
63 --
64 -- Name Type Description
65 -- p_language_code varchar2 Value from userenv('LANG').
66 -- p_view_name varchar2 Name of the view or table the
67 -- DateTrack History Form should use
68 -- to obtain the history of data
69 -- values.
70 -- p_view_owner varchar2 Name of the database account
71 -- which owns the p_view_name view
72 -- or table.
73 -- p_title_prompt varchar2 The entity name to include in
74 -- the window title prompt. Depends
75 -- on p_language_code.
76 -- p_effective_start_prompt varchar2 The display column prompt for
77 -- effective_start_date. Depends on
78 -- p_language_code.
79 -- p_effective_end_prompt varchar2 The display column prompt for
80 -- effective_end_date. Depends on
81 -- p_language_code.
82 --
83 -- Post Failure:
84 -- If neither the alternative view, standard DateTrack History view or
85 -- table can be found in the database then an error is raised.
86 --
87 -- Access Status:
88 -- Internal Development Use Only.
89 --
90 -- {End Of Comments}
91 --
92 procedure get_view_and_prompts
93 (p_table_name in varchar2
94 ,p_alternative_history_view in varchar2
95 ,p_language_code out nocopy varchar2
96 ,p_view_name out nocopy varchar2
97 ,p_view_owner out nocopy varchar2
98 ,p_title_prompt out nocopy varchar2
99 ,p_effective_start_prompt out nocopy varchar2
100 ,p_effective_end_prompt out nocopy varchar2
101 );
102 --
103 -- Old overload version.
104 --
105 -- Left an old overload version of the get_view_and_prompts
106 -- procedure, without the new p_alternative_history_view parameter
107 -- or the changed p_language_code parameter.
108 -- This old version can be removed after R11.5, as the DTXHISTY
109 -- Form will have been changed to always call the new version.
110 --
111 procedure get_view_and_prompts
112 ( p_table_name in varchar2,
113 p_language_code in varchar2,
114 p_view_name out nocopy varchar2,
115 p_view_owner out nocopy varchar2,
116 p_title_prompt out nocopy varchar2,
117 p_effective_start_prompt out nocopy varchar2,
118 p_effective_end_prompt out nocopy varchar2
119 );
120 --
121 -- Function to return column prompt for a given table.
122 -- Fix for bug 1616627.
123 --
124 FUNCTION fetch_dt_column_prompt(p_table_name IN VARCHAR2
125 ,p_column_name IN VARCHAR2
126 ,p_language_code IN VARCHAR2) RETURN VARCHAR2;
127 --
128 end hr_history;