1 PACKAGE OKE_UTILS AS
2 /* $Header: OKEUTILS.pls 120.1 2005/06/02 16:11:40 appldev $ */
3
4
5 FUNCTION Curr_Emp_ID RETURN NUMBER;
6
7
8 --
9 -- Name : Curr_Emp_Name
10 -- Pre-reqs : FND_GLOBAL.INITIALIZE
11 -- Function : This function returns the employee name derived from
12 -- the current user
13 --
14 --
15 -- Parameters :
16 -- IN : None
17 -- OUT : None
18 --
19 -- Returns : VARCHAR2
20 --
21
22 FUNCTION Curr_Emp_Name RETURN VARCHAR2;
23
24
25 --
26 -- Name : Yes_No / Sys_Yes_No
27 -- Pre-reqs : None
28 -- Function : This function returns the yes/no string based on the
29 -- lookups YES_NO and SYS_YES_NO.
30 --
31 --
32 -- Parameters :
33 -- IN : X_Lookup_Code VARCHAR2
34 -- OUT : None
35 --
36 -- Returns : VARCHAR2
37 --
38
39 FUNCTION Yes_No
40 ( X_Lookup_Code IN VARCHAR2
41 ) return varchar2;
42
43 FUNCTION Sys_Yes_No
44 ( X_Lookup_Code IN NUMBER
45 ) return varchar2;
46
47
48 --
49 -- Name : Chg_Request_Num
50 -- Pre-reqs : None
51 -- Function : This function returns the related Change Request
52 -- Number and Change Status for the given contract
53 -- either for the current version or a specific
54 -- major version.
55 --
56 --
57 -- Parameters :
58 -- IN : X_K_Header_ID NUMBER
59 -- X_Major_Version NUMBER
60 -- X_Current_Only VARCHAR2 DEFAULT Y
61 -- X_Curr_Indicator VARCHAR2 DEFAULT N
62 -- OUT : X_Change_Request VARCHAR2
63 -- X_Change_Status VARCHAR2
64 -- IN : X_History_Use VARCHAR2 DEFAULT N
65 --
66
67 PROCEDURE Chg_Request_Num
68 ( X_K_Header_ID IN NUMBER
69 , X_Major_Version IN NUMBER DEFAULT NULL
70 , X_Current_Only IN VARCHAR2 DEFAULT 'Y'
71 , X_Curr_Indicator IN VARCHAR2 DEFAULT 'N'
72 , X_Change_Request OUT NOCOPY VARCHAR2
73 , X_Change_Status OUT NOCOPY VARCHAR2
74 , X_History_Use IN VARCHAR2 DEFAULT 'N'
75 ) ;
76
77
78 --
79 -- Name : Item_Number
80 -- Pre-reqs : None
81 -- Function : This function returns the item number for a given
82 -- inventory organization and item ID.
83 --
84 --
85 -- Parameters :
86 -- IN : X_Inventory_Org_ID NUMBER
87 -- X_Item_ID NUMBER
88 -- OUT : None
89 --
90 -- Returns : VARCHAR2
91 --
92
93 FUNCTION Item_Number
94 ( X_Inventory_Org_ID IN NUMBER
95 , X_Item_ID IN NUMBER
96 ) RETURN VARCHAR2;
97
98
99 --
100 -- Name : Item_Description
101 -- Pre-reqs : None
102 -- Function : This function returns the item description for a given
103 -- inventory organization and item ID.
104 --
105 --
106 -- Parameters :
107 -- IN : X_Inventory_Org_ID NUMBER
108 -- X_Item_ID NUMBER
109 -- OUT : None
110 --
111 -- Returns : VARCHAR2
112 --
113
114 FUNCTION Item_Description
115 ( X_Inventory_Org_ID IN NUMBER
116 , X_Item_ID IN NUMBER
117 ) RETURN VARCHAR2;
118
119
120 --
121 -- Name : Check_Unique
122 -- Pre-reqs : None
123 -- Function : This function checks uniqueness of a column
124 -- value in the given table.
125 --
126 -- Parameters :
127 -- IN : X_K_Header_ID NUMBER
128 -- X_Major_Version NUMBER
129 -- X_Current_Only VARCHAR2 DEFAULT Y
130 -- X_Curr_Indicator VARCHAR2 DEFAULT N
131 -- OUT : None
132 --
133 -- Returns : BOOLEAN
134 --
135
136 FUNCTION Check_Unique
137 ( X_Table_Name IN VARCHAR2
138 , X_Column_Name IN VARCHAR2
139 , X_Column_Value IN VARCHAR2
140 , X_ROWID_Column IN VARCHAR2
141 , X_Row_ID IN VARCHAR2
142 , X_Translated IN VARCHAR2 DEFAULT 'N'
143 ) RETURN BOOLEAN;
144
145
146
147
148 -- Function get_location_description
149 -- Purpose:
150 -- returns location name by location_id
151 --
152 --
153 --
154 FUNCTION get_location_description(id NUMBER)
155 RETURN VARCHAR2;
156
157
158 -- Function get_term_values
159 -- Purpose:
160 -- to be used by view definition oke_k_terms_v only
161 --
162 --
163 --
164 FUNCTION get_term_values(p_term_code VARCHAR2, p_term_value_pk1 VARCHAR2,
165 p_term_value_pk2 VARCHAR2,p_call_option VARCHAR2 )
166 RETURN VARCHAR2;
167
168
169 -- Function get_term_value
170 -- Purpose:
171 -- to be used by view definition oke_k_headers_full_v only
172 --
173 --
174 --
175
176 FUNCTION get_term_value (p_id NUMBER,p_term_code VARCHAR2)
177 RETURN VARCHAR2;
178
179
180
181
182 -- Function get_userenv_lang
183 -- Purpose: This function returns the value of USERENV('LANG').
184 -- Once it has retrieved the value, it is cached
185 -- and subsequent calls
186 -- to this function from the same session, do not result in
187 -- a database
188 -- hit. This is because a := USERENV('LANG') results in a
189 -- SELECT USERENV('LANG') FROM SYS.DUAL; and can be an
190 -- overhead for mass INSERTs/UPDATEs.
191 --
192 -- Caching is done in the global variable g_userenv_lang
193 -- declared in the package BODY
194 --
195 --
196 -- In Parameters : None
197 -- Out Parameters: None
198 -- Return value : VARCHAR2
199 --
200
201 FUNCTION get_userenv_lang RETURN VARCHAR2;
202
203
204 --
205 -- Name : Get_K_Curr_Fmt_Mask
206 -- Pre-reqs : None
207 -- Function : This function returns the format mask for the
208 -- currency of the given contract. This is used in
209 -- the flowdown view to speed up format time as the
210 -- return value is cached.
211 --
212 -- Parameters :
213 -- IN : X_K_Header_ID NUMBER
214 -- X_Field_Length NUMBER
215 -- OUT : None
216 --
217 -- Returns : VARCHAR2
218 --
219
220 FUNCTION Get_K_Curr_Fmt_Mask
221 ( X_K_Header_ID IN NUMBER
222 , X_Field_Length IN NUMBER
223 ) RETURN VARCHAR2;
224
225
226 -- -------------------------------------------------------------------
227 -- Multi-Org Security
228 -- -------------------------------------------------------------------
229 PROCEDURE Set_Org_Context( X_Org_ID NUMBER , X_Inv_Org_ID NUMBER);
230 FUNCTION Org_ID RETURN NUMBER;
231 FUNCTION Cross_Org_Access RETURN VARCHAR2;
232
233
234 -- -------------------------------------------------------------------
235 -- PL/SQL Server Debugger
236 -- -------------------------------------------------------------------
237 PROCEDURE Enable_Debug;
238 PROCEDURE Disable_Debug;
239 FUNCTION Debug_Mode RETURN VARCHAR2;
240 PROCEDURE Debug ( text IN VARCHAR2 );
241
242 FUNCTION IS_VALID_DATE_RANGE (P_DATE_FROM IN DATE
243 ,P_DATE_TO IN DATE
244 ,P_PROJECT_ID IN NUMBER
245 ) return number;
246
247
248
249 FUNCTION Retrieve_Article_Text (P_id IN NUMBER
250 ,P_position IN NUMBER
251 ,P_next_pos OUT NOCOPY NUMBER)return VARCHAR2;
252
253
254 --
255 -- Name : Retrieve_WF_Role_Name
256 -- Pre-reqs : None
257 -- Function : retrieves the first 'person_id' for the specific contract
258 -- (P_header_ID)that has a particular role (p_role_id).
259 -- Use the P_order_x fields to determine where to look first,
260 -- at the site, program, created by, or contract levels?
261 --
262 --
263 -- Parameters :
264 -- IN : P_Header_ID K_Header_ID of the contract
265 -- P_role_id Role ID
266 --
267 -- OUT : NAME from WF_ROLES table
268 --
269 -- Returns : VARCHAR2
270 --
271
272 FUNCTION Retrieve_WF_Role_Name (P_header_id IN NUMBER,
273 P_role_id IN NUMBER)
274 return VARCHAR2;
275
276 -- Function Name : Set_Multi_org_Access
277 -- This API is created to support multi org access based on OKE profile option
278 -- 'OKE:Allow cross Org Acess'. If any implementation of Oracle Apps
279 -- has chosen not to use new MOAC Security profile feature then only
280 -- this Profile option will only come into play. This API will be called
281 -- from Pre-Form Trigger of Search and organizer screens just after
282 -- calling MO_GLOBAL.init.
283 PROCEDURE Set_Multi_org_Access;
284 END OKE_UTILS;