[Home] [Help]
PACKAGE: APPS.HR_SESSION_UTILITIES
Source
1 PACKAGE HR_SESSION_UTILITIES AS
2 /* $Header: hrsessuw.pkh 120.1 2005/09/23 15:54:43 svittal noship $*/
3 -- ----------------------------------------------------------------------------
4 -- |--< comments >------------------------------------------------------------|
5 -- ----------------------------------------------------------------------------
6 -- NOTE:
7 -- This package must not have any print calls (to htp.p or procedures that
8 -- contain it, or anything else, such as javascript alert);
9 -- errors (as exceptions) must be handled in the packages which called the
10 -- function (or the parent of that package if it is a child).
11 -- package prepared in part from: (comments and dates remain in the code for
12 -- cross-referencing)
13 -- hr_util_web Header: hrutlweb.pkb 110.16 97/12/05
14 -- per_cm_util_web Header: pecmuweb.pkb 110.19 97/11/19
15 -- ----------------------------------------------------------------------------
16 -- |--< EXCEPTIONS >----------------------------------------------------------|
17 -- ----------------------------------------------------------------------------
18
19 g_fatal_error EXCEPTION;
20 PRAGMA EXCEPTION_INIT(g_fatal_error, -20001);
21 g_validation_error EXCEPTION;
22 PRAGMA EXCEPTION_INIT(g_validation_error, -20002);
23 g_coding_error EXCEPTION;
24 -- ----------------------------------------------------------------------------
25 -- |--< GLOBALS >-------------------------------------------------------------|
26 -- ----------------------------------------------------------------------------
27 g_error EXCEPTION;
28 g_package VARCHAR2 (200) := 'HR_SESSION_UTILITIES';
29 g_region_application_id VARCHAR2 (3) := '601';
30 g_PER_application_id VARCHAR2 (3) := '800';
31 g_image_dir CONSTANT VARCHAR2 (8) := 'OA_MEDIA';
32 g_html_dir CONSTANT VARCHAR2 (6) := 'OA_DOC';
33 g_static_html_dir CONSTANT VARCHAR2 (7) := 'OA_HTML';
34 g_java_dir CONSTANT VARCHAR2 (7) := 'OA_JAVA';
35 g_error_handled BOOLEAN;
36 -- ----------------------------------------------------------------------------
37 -- |--< TYPES >---------------------------------------------------------------|
38 -- ----------------------------------------------------------------------------
39 TYPE r_workflow_process_rec
40 IS RECORD
41 ( item_type wf_items.item_type%TYPE
42 , item_key wf_items.item_key%TYPE
43 , actid NUMBER
44 , prt_switch VARCHAR2 (2000)
45 , obj_switch VARCHAR2 (2000)
46 , asn_switch VARCHAR2 (2000)
47 , qun_switch VARCHAR2 (2000)
48 , rev_switch VARCHAR2 (2000)
49 , gpr_switch VARCHAR2 (2000)
50 , aprv_appraiser_switch VARCHAR2 (2000)
51 );
52 -- ----------------------------------------------------------------------------
53 -- |--< Get_LoggedIn_User >---------------------------------------------------|
54 -- ----------------------------------------------------------------------------
55 -- {Start Of Comments}
56 --
57 -- Description:
58 -- gets the person record of the logged in user
59 --
60 -- Prerequisites:
61 -- none
62 --
63 -- Post Success:
64 --
65 -- Post Failure:
66 -- n/a
67 --
68 -- Access Status:
69 -- Public
70 --
71 -- {End Of Comments}
72 -- ----------------------------------------------------------------------------
73 FUNCTION Get_LoggedIn_User
74 RETURN per_people_f%ROWTYPE;
75 -- ----------------------------------------------------------------------------
76 -- |--< insert_session_row >--------------------------------------------------|
77 -- ----------------------------------------------------------------------------
78 -- name:
79 -- insert_session_row
80 -- description:
81 -- insert an fnd session row so that selects from date tracked
82 -- tables is successful.
83 -- requirement:
84 -- remember to use remove_session_row
85 -- when your select is complete.
86 -- ----------------------------------------------------------------------------
87 PROCEDURE insert_session_row
88 (p_effective_date in varchar2);
89 -- ----------------------------------------------------------------------------
90 -- |--< insert_session_row >--------------------------------------------------|
91 -- ----------------------------------------------------------------------------
92 -- overloaded to accept an encrypted effective date
93 -- ----------------------------------------------------------------------------
94 PROCEDURE insert_session_row
95 (p_effective_date in date);
96 -- ----------------------------------------------------------------------------
97 -- |--< remove_session_row >--------------------------------------------------|
98 -- ----------------------------------------------------------------------------
99 -- name:
100 -- remove_session_row
101 -- description:
102 -- removes the fnd session row created by insert_session_row
103 -- ------------------------------------------------------------------------
104 PROCEDURE remove_session_row;
105 -- ----------------------------------------------------------------------------
106 -- |--< get_ <procedures >>---------------------------------------------------|
107 -- ----------------------------------------------------------------------------
108 -- {Start Of Comments}
109 --
110 -- Description:
111 -- retrieve NLS language code, directory locations, user profile date format
112 -- and current data
113 --
114 -- Prerequisites:
115 -- none
116 --
117 -- Post Success:
118 --
119 -- Post Failure:
120 -- n/a
121 --
122 -- Access Status:
123 -- Public
124 --
125 -- {End Of Comments}
126 -- ----------------------------------------------------------------------------
127 -- |--< get_language_code >---------------------------------------------------|
128 -- ----------------------------------------------------------------------------
129 FUNCTION get_language_code
130 RETURN VARCHAR2;
131 -- ----------------------------------------------------------------------------
132 -- |--< get_image_directory >-------------------------------------------------|
133 -- ----------------------------------------------------------------------------
134 FUNCTION get_image_directory
135 RETURN VARCHAR2;
136 -- ----------------------------------------------------------------------------
137 -- |--< get_html_directory >--------------------------------------------------|
138 -- ----------------------------------------------------------------------------
139 FUNCTION get_html_directory
140 RETURN VARCHAR2;
141 -- ----------------------------------------------------------------------------
142 -- |--< get_static_html_directory >-------------------------------------------|
143 -- ----------------------------------------------------------------------------
144 FUNCTION get_static_html_directory
145 RETURN VARCHAR2;
146 -- ----------------------------------------------------------------------------
147 -- |--< get_java_directory >--------------------------------------------------|
148 -- ----------------------------------------------------------------------------
149 FUNCTION get_java_directory
150 RETURN VARCHAR2;
151 -- ----------------------------------------------------------------------------
152 -- |--< get_user_date_format >------------------------------------------------|
153 -- ----------------------------------------------------------------------------
154 FUNCTION get_user_date_format
155 RETURN VARCHAR2;
156 -- ----------------------------------------------------------------------------
157 -- |--< Get_Base_HREF >-------------------------------------------------------|
158 -- ----------------------------------------------------------------------------
159 FUNCTION Get_Base_HREF
160 RETURN VARCHAR2;
161 -- ----------------------------------------------------------------------------
162 -- |--< Get_Today >-----------------------------------------------------------|
163 -- ----------------------------------------------------------------------------
164 FUNCTION Get_Today
165 RETURN DATE;
166 -- ----------------------------------------------------------------------------
167 -- |--< Get_Today_As_Text >---------------------------------------------------|
168 -- ----------------------------------------------------------------------------
169 FUNCTION Get_Today_As_Text
170 RETURN VARCHAR2;
171 -- ----------------------------------------------------------------------------
172 -- |--< Get_Print_Action >----------------------------------------------------|
173 -- ----------------------------------------------------------------------------
174 FUNCTION Get_Print_Action
175 ( p_frame_index IN NUMBER
176 )
177 RETURN VARCHAR2;
178 RETURN hr_session_utilities.r_workflow_process_rec;
179
180 END HR_SESSION_UTILITIES;
181 --