[Home] [Help]
PACKAGE: APPS.AHL_UTIL_PKG
Source
1 Package AHL_UTIL_PKG AUTHID CURRENT_USER AS
2 /* $Header: AHLUTILS.pls 120.3.12020000.2 2012/12/10 16:54:40 prakkum 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 FUNCTION Get_Wip_Eam_Class_Type RETURN NUMBER;
38
39 -- JKJain added for ER9367907
40 FUNCTION Get_Message_String(p_message_key VARCHAR2)
41 RETURN VARCHAR2 ;
42
43 -------------------------------------------------------------------------
44 -- sansatpa added for marshalling
45 -- generic method to check if user is allowed for the security function
46 -------------------------------------------------------------------------
47 FUNCTION IS_USER_ALLOWED_FOR_FUNC(
48 P_FUNCTION_NAME IN VARCHAR2 )
49 RETURN VARCHAR2;
50
51
52 END AHL_UTIL_PKG;