APPS.DELETE_FROM_IREP dependencies on FND_IREP_CLASSES

Line 20: if (stable = 'FND_IREP_CLASSES') then

16: from FND_IREP_ALL_INTERFACES
17: where class_id = key_id;
18:
19:
20: if (stable = 'FND_IREP_CLASSES') then
21: -- find file name and update history table
22:
23: select source_file_name, source_file_product, source_file_version
24: into filename, fileproduct, fileversion

Line 25: from fnd_irep_classes

21: -- find file name and update history table
22:
23: select source_file_name, source_file_product, source_file_version
24: into filename, fileproduct, fileversion
25: from fnd_irep_classes
26: where class_id = key_id;
27:
28: ildtfilename := replace(filename,'.','_');
29: ildtfilename := ildtfilename || '.ildt';

Line 54: from fnd_irep_classes

50:
51: Delete from FND_IREP_CLASS_PARENT_ASSIGNS
52: where class_name in
53: (select class_name
54: from fnd_irep_classes
55: where class_id = key_id);
56:
57: Delete from FND_LOOKUP_ASSIGNMENTS
58: where obj_name = 'FND_IREP_CLASSES'

Line 58: where obj_name = 'FND_IREP_CLASSES'

54: from fnd_irep_classes
55: where class_id = key_id);
56:
57: Delete from FND_LOOKUP_ASSIGNMENTS
58: where obj_name = 'FND_IREP_CLASSES'
59: and INSTANCE_PK1_VALUE = to_char(key_id);
60:
61: Delete from FND_CHILD_ANNOTATIONS
62: where parent_id = key_id

Line 139: Delete from FND_IREP_CLASSES_TL

135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Derived Functions Removed');
136: end if;
137:
138: -- remove classes
139: Delete from FND_IREP_CLASSES_TL
140: where class_id = assoc_key_id;
141:
142: Delete from FND_IREP_CLASSES
143: where class_id = assoc_key_id;

Line 142: Delete from FND_IREP_CLASSES

138: -- remove classes
139: Delete from FND_IREP_CLASSES_TL
140: where class_id = assoc_key_id;
141:
142: Delete from FND_IREP_CLASSES
143: where class_id = assoc_key_id;
144:
145: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
146: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Derived Classes Removed');

Line 185: Delete from FND_IREP_CLASSES_TL

181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Functions Removed');
182: end if;
183:
184: -- remove classes
185: Delete from FND_IREP_CLASSES_TL
186: where class_id = key_id;
187:
188: Delete from FND_IREP_CLASSES
189: where class_id = key_id;

Line 188: Delete from FND_IREP_CLASSES

184: -- remove classes
185: Delete from FND_IREP_CLASSES_TL
186: where class_id = key_id;
187:
188: Delete from FND_IREP_CLASSES
189: where class_id = key_id;
190:
191: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
192: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep','Classes Removed. ' || 'Deletion completed for all entries corresponding to Class Id : '|| key_id );