[Home] [Help]
PACKAGE: APPS.AHL_UTIL_PKG
Source
1 Package AHL_UTIL_PKG AS
2 /* $Header: AHLUTILS.pls 120.0.12010000.2 2008/09/19 09:46:56 pdoki ship $ */
3
4 ------------------------------
5 -- Define Error Record Type --
6 ------------------------------
7 TYPE Err_Rec_Type IS RECORD (
8 msg_index NUMBER,
9 msg_data VARCHAR2(2000)
10 );
11
12 ------------------------------
13 -- Define Error Table Type --
14 ------------------------------
15 TYPE Err_Tbl_Type IS TABLE OF Err_Rec_Type INDEX BY BINARY_INTEGER;
16
17 ----------------------------------------------------------
18 -- Procedure to convert Error messages into a pl/sql table
19 ----------------------------------------------------------
20 Procedure ERR_MESG_TO_TABLE (
21 x_err_table OUT NOCOPY Err_Tbl_Type );
22
23
24 FUNCTION is_pm_installed RETURN VARCHAR2;
25
26
27 PROCEDURE Get_Appln_Usage
28 (
29 x_appln_code OUT NOCOPY VARCHAR2,
30 x_return_status OUT NOCOPY VARCHAR2
31 );
32
33 FUNCTION Get_User_Role (
34 p_function_key IN VARCHAR2 := NULL
35 ) RETURN VARCHAR2;
36
37 END AHL_UTIL_PKG;