1 PACKAGE EGO_USER_ATTRS_COMMON_PVT AUTHID DEFINER AS
2 /* $Header: EGOPEFCS.pls 120.5 2007/03/29 19:10:15 srajapar ship $ */
3
4
5
6 --=======================================================================--
7 --=*********************************************************************=--
8 --=*===================================================================*=--
9 --=*= =*=--
10 --=*= NOTE: This is a PRIVATE package; it is for internal use only, =*=--
11 --=*= and it is not supported for customer use. =*=--
12 --=*= =*=--
13 --=*===================================================================*=--
14 --=*********************************************************************=--
15 --=======================================================================--
16
17 ----------------------
18 -- Global Variables --
19 ----------------------
20
21 -------------------------------------------------------------------------------
22 -- The Date Format is chosen to be as close as possible to Timestamp format, --
23 -- except that we support dates before zero A.D. (the "S" in the year part). --
24 -------------------------------------------------------------------------------
25 G_DATE_FORMAT CONSTANT VARCHAR2(30) := 'SYYYY-MM-DD HH24:MI:SS';
26
27 --4105841 Business Event Enhancement
28 G_SUBSCRIPTION_EXC EXCEPTION; --Subscription Exception defined
29
30 --------------------------------------
31 -- Caching Procedures and Functions --
32 --------------------------------------
33
34 PROCEDURE Reset_Cache_And_Globals;
35
36
37
38
39 FUNCTION Get_Attr_Group_Metadata (
40 p_attr_group_id IN NUMBER DEFAULT NULL
41 ,p_application_id IN NUMBER DEFAULT NULL
42 ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
43 ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
44 ,p_pick_from_cache IN BOOLEAN DEFAULT TRUE
45 )
46 RETURN EGO_ATTR_GROUP_METADATA_OBJ;
47
48
49
50 FUNCTION Get_Ext_Table_Metadata (
51 p_object_id IN NUMBER
52 )
53 RETURN EGO_EXT_TABLE_METADATA_OBJ;
54
55
56
57 FUNCTION Find_Metadata_For_Attr (
58 p_attr_metadata_table IN EGO_ATTR_METADATA_TABLE
59 ,p_attr_name IN VARCHAR2 DEFAULT NULL
60 ,p_attr_id IN NUMBER DEFAULT NULL
61 ,p_db_column_name IN VARCHAR2 DEFAULT NULL
62 )
63 RETURN EGO_ATTR_METADATA_OBJ;
64
65
66 ---------------------------------------------------
67 -- Miscellaneous Common Procedures and Functions --
68 ---------------------------------------------------
69
70 /*
71 * Get_List_For_Table_Cols
72 * -----------------------
73 */
74 FUNCTION Get_List_For_Table_Cols (
75 p_col_metadata_array IN EGO_COL_METADATA_ARRAY
76 ,p_col_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
77 ,p_mode IN VARCHAR2
78 ,p_use_binds IN BOOLEAN DEFAULT FALSE
79 ,p_prefix IN VARCHAR2 DEFAULT NULL
80 )
81 RETURN VARCHAR2;
82
83
84
85 FUNCTION Create_DB_Col_Alias_If_Needed (
86 p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
87 ) RETURN VARCHAR2;
88
89
90 /*FUNCTION Is_EGO_Installed (
91 p_api_version IN NUMBER
92 ,p_release_version IN VARCHAR2
93 ) RETURN VARCHAR2;*/
94
95
96 /*
97 * Method to get sql query (partial) to be used in another sql to get values from a value set
98 */
99 PROCEDURE Build_Sql_Queries_For_Value (
100 p_value_set_id IN NUMBER
101 ,p_validation_code IN VARCHAR2
102 ,px_attr_group_metadata_obj IN OUT NOCOPY EGO_ATTR_GROUP_METADATA_OBJ
103 ,px_attr_metadata_obj IN OUT NOCOPY EGO_ATTR_METADATA_OBJ
104 );
105 --bug 5094087
106 -------------------------------------------------------------------------------------
107 -- API Name: Get_User_Pref_Date_Time_Val --
108 -- --
109 -- Description:This Function retruns the Formatted Date or Date Time Value --
110 -- depending on the type of the Attribute Passed in and the Value passed in --
111 -- Parameters: The Value of date or DateTime and the Attribute Type with X for --
112 -- Date Type or Y for Date_time Type --
113 -------------------------------------------------------------------------------------
114 FUNCTION Get_User_Pref_Date_Time_Val (
115 p_date IN DATE
116 ,p_attr_type IN VARCHAR2
117 ,x_return_status OUT NOCOPY VARCHAR2
118 ,x_msg_count OUT NOCOPY NUMBER
119 ,x_msg_data OUT NOCOPY VARCHAR2
120 ) RETURN VARCHAR2;
121
122 FUNCTION Get_Data_Levels_For_AGType ( p_application_id IN NUMBER
123 ,p_attr_group_type IN VARCHAR2
124 )
125 RETURN EGO_DATA_LEVEL_METADATA_TABLE;
126
127 FUNCTION Get_Data_Level_Metadata (p_data_level_id IN NUMBER)
128 RETURN EGO_DATA_LEVEL_METADATA_OBJ;
129
130 FUNCTION Get_Enabled_Data_Levels_For_AG (p_attr_group_id IN NUMBER)
131 RETURN EGO_DATA_LEVEL_TABLE;
132
133 FUNCTION Get_Data_Level_Col_Array( p_application_id IN NUMBER
134 ,p_attr_group_type IN VARCHAR2)
135 RETURN EGO_COL_METADATA_ARRAY;
136
137 FUNCTION Get_All_Data_Level_PK_Names ( p_application_id IN NUMBER
138 ,p_attr_group_type IN VARCHAR2)
139 RETURN VARCHAR2;
140
141 FUNCTION HAS_COLUMN_IN_TABLE (p_table_name IN VARCHAR2
142 ,p_column_name IN VARCHAR2
143 )
144 RETURN VARCHAR2;
145
146 END EGO_USER_ATTRS_COMMON_PVT;
147