APPS.SOA_REMOVE SQL Statements

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

Line: 21

          select class_id,class_type from fnd_irep_classes where irep_name = c_irep_name and assoc_class_id = c_base_class_id and class_type = c_service_type;

Line: 24

          select count(*) l_count from fnd_irep_classes where irep_name = c_irep_name and assoc_class_id = c_base_class_id and class_type = c_service_type;

Line: 37

          select irep_name into c_irep_base_name from fnd_irep_classes where class_id = p_base_class_id;

Line: 38

          select class_type into c_class_type from fnd_irep_classes where class_id = p_base_class_id;

Line: 41

          update fnd_irep_classes set irep_name=c_irep_base_name where assoc_class_id=p_base_class_id;

Line: 66

             delete from fnd_irep_classes where class_id = c_derived_class_entry_rec1.class_id;

Line: 85

        p_err_message := wf_core.translate('WF_WS_DELETE_SUCCESS');

Line: 107

 	select function_id  from fnd_form_functions where irep_class_id = c_derived_class_id;

Line: 110

 	select COUNT(*) l_count from fnd_form_functions where irep_class_id = c_derived_class_id;

Line: 129

          	select assoc_class_id into base_class_id from fnd_irep_classes where class_id=p_derived_class_id;

Line: 130

                select class_type into c_class_type from fnd_irep_classes where class_id=base_class_id;

Line: 152

               delete from fnd_form_functions where function_id = c_derived_function_entry_rec.function_id;

Line: 157

 	p_err_message := wf_core.translate('WF_WS_DELETE_SUCCESS');

Line: 179

	select *
	from fnd_form_functions_tl
	where function_id = c_derived_function_id;

Line: 195

    delete from fnd_form_functions_tl where function_id = p_derived_function_id;

Line: 197

    p_err_message := wf_core.translate('WF_WS_DELETE_SUCCESS');

Line: 221

 	select *
 	from fnd_irep_classes_tl
 	where class_id = c_derived_class_id  ;

Line: 236

    delete  from fnd_irep_classes_tl where class_id = p_derived_class_id  ;

Line: 238

    p_err_message := wf_core.translate('WF_WS_DELETE_SUCCESS');