APPS.DELETE_FROM_IREP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

	select src_table
	into stable
	from FND_IREP_ALL_INTERFACES
	where class_id = key_id;

Line: 21

		-- find file name and update history table

		select source_file_name, source_file_product, source_file_version
		into filename, fileproduct, fileversion
		from fnd_irep_classes
		where class_id = key_id;

Line: 32

			update fnd_irep_deferred_load_files
			set load_status = 'N'
			where file_name = ildtfilename
			and fileproduct = file_product
			and fileversion = file_version;

Line: 40

				FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Error: History table does not have this entry.');

Line: 47

		Delete from FND_IREP_CLASS_DATASOURCES
		where CLASS_ID = key_id;

Line: 51

		Delete from FND_IREP_CLASS_PARENT_ASSIGNS
		where class_name in
			(select class_name
			from fnd_irep_classes
			where class_id = key_id);

Line: 57

		Delete from FND_LOOKUP_ASSIGNMENTS
		where obj_name = 'FND_IREP_CLASSES'
		  and INSTANCE_PK1_VALUE = to_char(key_id);

Line: 61

		Delete from FND_CHILD_ANNOTATIONS
		where parent_id = key_id
		  and parent_flag = 'C';

Line: 65

		Delete from FND_IREP_USES_TABLES
		where CLASS_ID = key_id;

Line: 68

		Delete from FND_IREP_USES_MAPS
		where CLASS_ID = key_id;

Line: 72

				FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Class Sub-Entities Removed');

Line: 76

		Delete from FND_LOOKUP_ASSIGNMENTS
		where obj_name = 'FND_IREP_FUNCTION_FLAVORS'
		  and INSTANCE_PK1_VALUE in
			(select function_id
			   from FND_FORM_FUNCTIONS
			  where irep_class_id = key_id);

Line: 83

		Delete from FND_CHILD_ANNOTATIONS
		where parent_flag = 'F'
		  and parent_id in
			(select function_id
			   from FND_FORM_FUNCTIONS
			  where irep_class_id = key_id);

Line: 90

		Delete from FND_PARAMETERS
		where function_id in
			(select function_id
			   from FND_FORM_FUNCTIONS
			  where irep_class_id = key_id);

Line: 97

				FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Function Sub-Entities Removed');

Line: 104

			select class_id
			into assoc_key_id
			from FND_IREP_ALL_INTERFACES
			where assoc_class_id  = key_id;

Line: 110

				FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Derived Entry : '|| assoc_key_id);

Line: 114

			Delete from FND_IREP_FUNCTION_FLAVORS
			where FUNCTION_ID in
				(select function_id
				from FND_FORM_FUNCTIONS
				where irep_class_id = assoc_key_id);

Line: 121

				FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Derived Function Flavors Removed');

Line: 125

			Delete from FND_FORM_FUNCTIONS_TL
			where function_id in
				(select function_id
				from fnd_form_functions
				where irep_class_id = assoc_key_id);

Line: 131

			Delete from FND_FORM_FUNCTIONS
			where irep_class_id  = assoc_key_id;

Line: 135

				FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Derived Functions Removed');

Line: 139

			Delete from FND_IREP_CLASSES_TL
			where class_id = assoc_key_id;

Line: 142

			Delete from FND_IREP_CLASSES
			where class_id = assoc_key_id;

Line: 146

				FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Derived Classes Removed');

Line: 152

				FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Derived Entries Not Present.');

Line: 160

		Delete from FND_IREP_FUNCTION_FLAVORS
		where FUNCTION_ID in
			(select function_id
			from FND_FORM_FUNCTIONS
			where irep_class_id = key_id);

Line: 167

				FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Function Flavors Removed');

Line: 171

		Delete from FND_FORM_FUNCTIONS_TL
		where function_id in
			(select function_id
			from fnd_form_functions
			where irep_class_id = key_id);

Line: 177

		Delete from FND_FORM_FUNCTIONS
		where irep_class_id  = key_id;

Line: 181

				FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Functions Removed');

Line: 185

		Delete from FND_IREP_CLASSES_TL
		where class_id = key_id;

Line: 188

		Delete from FND_IREP_CLASSES
		where class_id = key_id;

Line: 192

				FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep','Classes Removed. ' || 'Deletion completed for all entries corresponding to Class Id : '|| key_id );

Line: 198

		Delete from FND_OBJECT_KEY_SETS
		where object_id = key_id;

Line: 201

		Delete from FND_LOOKUP_ASSIGNMENTS
		where obj_name = 'FND_OBJECTS'
		and INSTANCE_PK1_VALUE = to_char(key_id);

Line: 205

		Delete from FND_CHILD_ANNOTATIONS
		where parent_id = key_id
		and parent_flag = 'O';

Line: 209

		Delete from FND_OBJECT_TYPE_MEMBERS
		where object_id = key_id;

Line: 213

				FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Object Sub-Entities Removed');

Line: 218

		Delete from FND_OBJECTS_TL
		where object_id = key_id;

Line: 221

		Delete from FND_OBJECTS
		where object_id  = key_id;

Line: 225

				FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Objects Removed . '|| 'Deletion completed for all entries corresponding to object Id : '|| key_id);

Line: 236

	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', SQLERRM);

Line: 240

   end delete_irep_entry ;

Line: 242

end DELETE_FROM_IREP;