1 package FEM_UTILS as
2 --$Header: FEMUTILS.pls 120.0 2005/06/06 20:31:10 appldev noship $
3 -- utility function used by both DSWG and RSM
4
5 -- these variables must be kept in numerical order, with the lowest number indicating 'no error',
6 -- and each variable after indicating a higher level of error (with the highest being utterly fatal..
7 G_RSM_NO_ERR CONSTANT NUMBER := 0;
8 G_RSM_NONFATAL_ERR CONSTANT NUMBER := 1;
9 G_RSM_FATAL_ERR CONSTANT NUMBER := 2;
10
11 PROCEDURE set_master_err_state( p_master_err_state IN OUT NOCOPY NUMBER,
12 err_state IN NUMBER,
13 p_app_name IN VARCHAR2,
14 p_msg_name IN VARCHAR2,
15 p_token1 IN VARCHAR2 DEFAULT NULL,
16 p_value1 IN VARCHAR2 DEFAULT NULL,
17 p_trans1 IN VARCHAR2 DEFAULT NULL,
18 p_token2 IN VARCHAR2 DEFAULT NULL,
19 p_value2 IN VARCHAR2 DEFAULT NULL,
20 p_trans2 IN VARCHAR2 DEFAULT NULL,
21 p_token3 IN VARCHAR2 DEFAULT NULL,
22 p_value3 IN VARCHAR2 DEFAULT NULL,
23 p_trans3 IN VARCHAR2 DEFAULT NULL,
24 p_token4 IN VARCHAR2 DEFAULT NULL,
25 p_value4 IN VARCHAR2 DEFAULT NULL,
26 p_trans4 IN VARCHAR2 DEFAULT NULL,
27 p_token5 IN VARCHAR2 DEFAULT NULL,
28 p_value5 IN VARCHAR2 DEFAULT NULL,
29 p_trans5 IN VARCHAR2 DEFAULT NULL,
30 p_token6 IN VARCHAR2 DEFAULT NULL,
31 p_value6 IN VARCHAR2 DEFAULT NULL,
32 p_trans6 IN VARCHAR2 DEFAULT NULL,
33 p_token7 IN VARCHAR2 DEFAULT NULL,
34 p_value7 IN VARCHAR2 DEFAULT NULL,
35 p_trans7 IN VARCHAR2 DEFAULT NULL,
36 p_token8 IN VARCHAR2 DEFAULT NULL,
37 p_value8 IN VARCHAR2 DEFAULT NULL,
38 p_trans8 IN VARCHAR2 DEFAULT NULL,
39 p_token9 IN VARCHAR2 DEFAULT NULL,
40 p_value9 IN VARCHAR2 DEFAULT NULL,
41 p_trans9 IN VARCHAR2 DEFAULT NULL );
42
43 Procedure GetObjNameandFolderUsingObj(p_Object_ID IN NUMBER
44 ,x_Object_Name OUT NOCOPY VARCHAR2
45 ,x_Folder_Name OUT NOCOPY VARCHAR2);
46 Procedure GetObjNameandFolderUsingDef(p_Obj_Def_ID IN NUMBER
47 ,x_Object_Name OUT NOCOPY VARCHAR2
48 ,x_Folder_Name OUT NOCOPY VARCHAR2);
49 Function getVersionCount(X_Object_ID NUMBER) RETURN NUMBER;
50 FUNCTION get_user_name(l_user_id IN NUMBER) RETURN VARCHAR2;
51 Function migrationEnabledForUser RETURN VARCHAR2;
52 Function getRuleSetObjectDefID(X_RULE_SET_OBJECT_ID IN NUMBER) RETURN NUMBER;
53 Function getFolderPrivilege(X_Object_ID IN NUMBER) RETURN VARCHAR2;
54
55 FUNCTION getLookupMeaning(p_Application_ID IN NUMBER
56 ,p_Lookup_Type IN VARCHAR2
57 ,p_Lookup_Code IN VARCHAR2
58 ) RETURN VARCHAR2;
59
60
61 end FEM_UTILS;
[Home] [Help]