DBA Data[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;