1 PACKAGE EGO_USER_ATTRS_COMMON_PVT AUTHID DEFINER AS
2 /* $Header: EGOPEFCS.pls 120.6 2011/04/18 04:31:14 jewen 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 * Bug:11854366
91 * Description:This function return database column alias with the table or view alias
92 */
93 FUNCTION Create_DB_Col_Alias_If_Needed (
94 p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
95 ,table_view_alias IN VARCHAR2
96 ) RETURN VARCHAR2;
97
98 /*FUNCTION Is_EGO_Installed (
99 p_api_version IN NUMBER
100 ,p_release_version IN VARCHAR2
101 ) RETURN VARCHAR2;*/
102
103
104 /*
105 * Method to get sql query (partial) to be used in another sql to get values from a value set
106 */
107 PROCEDURE Build_Sql_Queries_For_Value (
108 p_value_set_id IN NUMBER
109 ,p_validation_code IN VARCHAR2
110 ,px_attr_group_metadata_obj IN OUT NOCOPY EGO_ATTR_GROUP_METADATA_OBJ
111 ,px_attr_metadata_obj IN OUT NOCOPY EGO_ATTR_METADATA_OBJ
112 );
113 --bug 5094087
114 -------------------------------------------------------------------------------------
115 -- API Name: Get_User_Pref_Date_Time_Val --
116 -- --
117 -- Description:This Function retruns the Formatted Date or Date Time Value --
118 -- depending on the type of the Attribute Passed in and the Value passed in --
119 -- Parameters: The Value of date or DateTime and the Attribute Type with X for --
120 -- Date Type or Y for Date_time Type --
121 -------------------------------------------------------------------------------------
122 FUNCTION Get_User_Pref_Date_Time_Val (
123 p_date IN DATE
124 ,p_attr_type IN VARCHAR2
125 ,x_return_status OUT NOCOPY VARCHAR2
126 ,x_msg_count OUT NOCOPY NUMBER
127 ,x_msg_data OUT NOCOPY VARCHAR2
128 ) RETURN VARCHAR2;
129
130 FUNCTION Get_Data_Levels_For_AGType ( p_application_id IN NUMBER
131 ,p_attr_group_type IN VARCHAR2
132 )
133 RETURN EGO_DATA_LEVEL_METADATA_TABLE;
134
135 FUNCTION Get_Data_Level_Metadata (p_data_level_id IN NUMBER)
136 RETURN EGO_DATA_LEVEL_METADATA_OBJ;
137
138 FUNCTION Get_Enabled_Data_Levels_For_AG (p_attr_group_id IN NUMBER)
139 RETURN EGO_DATA_LEVEL_TABLE;
140
141 FUNCTION Get_Data_Level_Col_Array( p_application_id IN NUMBER
142 ,p_attr_group_type IN VARCHAR2)
143 RETURN EGO_COL_METADATA_ARRAY;
144
145 FUNCTION Get_All_Data_Level_PK_Names ( p_application_id IN NUMBER
146 ,p_attr_group_type IN VARCHAR2)
147 RETURN VARCHAR2;
148
149 FUNCTION HAS_COLUMN_IN_TABLE (p_table_name IN VARCHAR2
150 ,p_column_name IN VARCHAR2
151 )
152 RETURN VARCHAR2;
153
154 END EGO_USER_ATTRS_COMMON_PVT;
155