APPS.ENG_CHANGE_ATTR_UTIL dependencies on EGO_VARCHAR_TBL_TYPE

Line 180: RETURN EGO_VARCHAR_TBL_TYPE

176: ,p_entity_id IN NUMBER DEFAULT NULL
177: ,p_entity_index IN NUMBER DEFAULT NULL
178: ,p_entity_code IN VARCHAR2 DEFAULT NULL
179: )
180: RETURN EGO_VARCHAR_TBL_TYPE
181: IS
182:
183: l_party_id VARCHAR2(30);
184: l_return_status VARCHAR2(1);

Line 186: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;

182:
183: l_party_id VARCHAR2(30);
184: l_return_status VARCHAR2(1);
185: l_user_privileges_table EGO_DATA_SECURITY.EGO_PRIVILEGE_NAME_TABLE_TYPE;
186: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
187: l_privilege_table_index NUMBER;
188: l_token_table ERROR_HANDLER.Token_Tbl_Type;
189:
190: BEGIN

Line 228: -- the table we have into a table of type EGO_VARCHAR_TBL_TYPE --

224: );
225:
226: ---------------------------------------------------------------------
227: -- If the user has privileges on this instance, we need to convert --
228: -- the table we have into a table of type EGO_VARCHAR_TBL_TYPE --
229: ---------------------------------------------------------------------
230: IF (l_return_status = 'T' AND
231: l_user_privileges_table.COUNT > 0) THEN
232:

Line 233: l_user_privileges_on_object := EGO_VARCHAR_TBL_TYPE();

229: ---------------------------------------------------------------------
230: IF (l_return_status = 'T' AND
231: l_user_privileges_table.COUNT > 0) THEN
232:
233: l_user_privileges_on_object := EGO_VARCHAR_TBL_TYPE();
234:
235: l_privilege_table_index := l_user_privileges_table.FIRST;
236: WHILE (l_privilege_table_index <= l_user_privileges_table.LAST)
237: LOOP

Line 743: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL

739: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
740: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
741: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
742: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
743: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
744: ,p_row_identifier IN NUMBER DEFAULT NULL
745: ,p_validate_only IN VARCHAR2
746: ,p_mode IN VARCHAR2
747: ,p_acd_type IN VARCHAR2

Line 785: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;

781: l_dummy NUMBER;
782: L_CACHED_SQL_FOUND VARCHAR2(1) := 'N';
783: p_prod_vl_name VARCHAR2(40);
784: l_DataLevelColumnExists VARCHAR2(5);
785: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
786: CURSOR C_DATALEVEL_COLUMN_EXISTS(TABLENAME IN VARCHAR2) IS
787: SELECT 'Y' FROM FND_TABLES FT,FND_COLUMNS FC
788: WHERE FT.TABLE_NAME = UPPER(TABLENAME) AND FT.TABLE_ID = FC.TABLE_ID
789: AND COLUMN_NAME = 'DATA_LEVEL_ID';