APPS.FEM_BR_DATA_LDR_PVT dependencies on FEM_OBJECT_DEFINITION_VL

Line 17: -- FEM_OBJECT_DEFINITION_VL. That record must already exist.

13: -- DESCRIPTION
14: -- Deletes all the detail records of a Data Loader Rule Definition(Version)
15: -- (source) into another empty Data Loader Rule Definition (target).
16: -- NOTE: It does not delete the Data Loader Rule Definition record in
17: -- FEM_OBJECT_DEFINITION_VL. That record must already exist.
18: --
19: -- IN
20: -- p_obj_def_id - Object Definition ID
21: --

Line 44: SELECT object_id INTO l_obj_id FROM fem_object_definition_vl

40:
41: -- Get the Object Id for the version to be deleted and
42: -- check if the object has multiple versions.
43:
44: SELECT object_id INTO l_obj_id FROM fem_object_definition_vl
45: WHERE object_definition_id = p_obj_def_id;
46:
47: SELECT COUNT(*) INTO l_ver_count FROM fem_object_definition_vl
48: WHERE object_id = l_obj_id;

Line 47: SELECT COUNT(*) INTO l_ver_count FROM fem_object_definition_vl

43:
44: SELECT object_id INTO l_obj_id FROM fem_object_definition_vl
45: WHERE object_definition_id = p_obj_def_id;
46:
47: SELECT COUNT(*) INTO l_ver_count FROM fem_object_definition_vl
48: WHERE object_id = l_obj_id;
49:
50: DELETE FROM fem_data_loader_params
51: WHERE loader_obj_def_id = p_obj_def_id;

Line 53: DELETE FROM fem_object_definition_vl

49:
50: DELETE FROM fem_data_loader_params
51: WHERE loader_obj_def_id = p_obj_def_id;
52:
53: DELETE FROM fem_object_definition_vl
54: WHERE object_definition_id = p_obj_def_id;
55:
56: -- If the object had only 1 version, then delete the object also
57: IF l_ver_count = 1 THEN

Line 96: -- FEM_OBJECT_CATALOG_VL or its versions into FEM_OBJECT_DEFINITION_VL.

92: -- DESCRIPTION
93: -- Duplicates all the detail records of a Data Loader Rule versions (source)
94: -- into another empty Data Loader Rule (target).
95: -- NOTE: It does not copy the Data Loader Rule record in
96: -- FEM_OBJECT_CATALOG_VL or its versions into FEM_OBJECT_DEFINITION_VL.
97: -- These records must already exist, this proceudre shall only duplicate the
98: -- rule data in rule specific tables.
99: --
100: -- IN

Line 181: -- FEM_OBJECT_DEFINITION_VL.

177: -- DESCRIPTION
178: -- Duplicates all the parameters associated with a Data Loader Version(source)
179: -- into the new Data Loader Version (target)
180: -- NOTE: It does not copy the Data Loader Rule Version record into
181: -- FEM_OBJECT_DEFINITION_VL.
182: -- These records must already exist, this procedure shall only duplicate the
183: -- rule version data in rule specific tables.
184: --
185: -- IN