DBA Data[Home] [Help]

APPS.FEM_UTILS dependencies on FEM_FOLDERS_VL

Line 135: ,fem_folders_vl b

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;
139: l_Object_Name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;

Line 140: l_Folder_Name FEM_FOLDERS_VL.FOLDER_NAME%TYPE;

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
144: l_Object_Name

Line 162: ,fem_folders_vl b

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
166: and a.folder_id = b.folder_id;

Line 168: l_Folder_Name FEM_FOLDERS_VL.FOLDER_NAME%TYPE;

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
172: l_Object_Name