DBA Data[Home] [Help]

APPS.FEM_UTILS dependencies on FEM_OBJECT_CATALOG_VL

Line 134: fem_object_catalog_vl a

130: select
131: a.object_name
132: ,b.folder_name
133: from
134: fem_object_catalog_vl a
135: ,fem_folders_vl b
136: where
137: a.object_id = p_Object_ID
138: and a.folder_id = b.folder_id;

Line 139: l_Object_Name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;

135: ,fem_folders_vl b
136: where
137: a.object_id = p_Object_ID
138: and a.folder_id = b.folder_id;
139: l_Object_Name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
140: l_Folder_Name FEM_FOLDERS_VL.FOLDER_NAME%TYPE;
141: Begin
142: OPEN getObjandFolderName;
143: FETCH getObjandFolderName into

Line 161: ,fem_object_catalog_vl a

157: a.object_name
158: ,b.folder_name
159: from
160: fem_object_definition_b c
161: ,fem_object_catalog_vl a
162: ,fem_folders_vl b
163: where
164: c.object_definition_id = p_Obj_Def_ID
165: and c.object_id = a.object_id

Line 167: l_Object_Name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;

163: where
164: c.object_definition_id = p_Obj_Def_ID
165: and c.object_id = a.object_id
166: and a.folder_id = b.folder_id;
167: l_Object_Name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
168: l_Folder_Name FEM_FOLDERS_VL.FOLDER_NAME%TYPE;
169: Begin
170: OPEN getObjandFolderName;
171: FETCH getObjandFolderName into