APPS.SOA_REMOVE dependencies on FND_FORM_FUNCTIONS

Line 107: select function_id from fnd_form_functions where irep_class_id = c_derived_class_id;

103: p_err_message OUT NOCOPY varchar2
104: ) IS
105:
106: cursor c_derived_function_entry(c_derived_class_id in number) is
107: select function_id from fnd_form_functions where irep_class_id = c_derived_class_id;
108:
109: cursor c_derived_function_entry1(c_derived_class_id in number) is
110: select COUNT(*) l_count from fnd_form_functions where irep_class_id = c_derived_class_id;
111: c_function_rec c_derived_function_entry1%ROWTYPE;

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

106: cursor c_derived_function_entry(c_derived_class_id in number) is
107: select function_id from fnd_form_functions where irep_class_id = c_derived_class_id;
108:
109: cursor c_derived_function_entry1(c_derived_class_id in number) is
110: select COUNT(*) l_count from fnd_form_functions where irep_class_id = c_derived_class_id;
111: c_function_rec c_derived_function_entry1%ROWTYPE;
112: c_class_type fnd_irep_classes .class_type%type;
113: base_class_id fnd_irep_classes .assoc_class_id%type;
114: f_count pls_integer := -1;

Line 132: DBMS_OUTPUT.PUT_LINE('XMLGateway service exempted from fnd_form_functions check ');

128: if c_function_rec.l_count = 0 then
129: select assoc_class_id into base_class_id from fnd_irep_classes where class_id=p_derived_class_id;
130: select class_type into c_class_type from fnd_irep_classes where class_id=base_class_id;
131: if c_class_type = 'XMLGATEWAY' then
132: DBMS_OUTPUT.PUT_LINE('XMLGateway service exempted from fnd_form_functions check ');
133: else
134: p_err_code := -1;
135: p_err_message := wf_core.translate('WF_WS_DERIVED_FUNC_NOT_EXIST');
136: raise program_exit;

Line 152: delete from fnd_form_functions where function_id = c_derived_function_entry_rec.function_id;

148: raise program_exit;
149: end if;
150: remove_function_lang_entries(c_derived_function_entry_rec.function_id ,p_derived_class_id ,p_err_code ,p_err_message );
151: --dbms_output.put_line('functionId to delete' || c_derived_function_entry_rec.function_id );
152: delete from fnd_form_functions where function_id = c_derived_function_entry_rec.function_id;
153: f_count := f_count -1;
154: END LOOP;
155: if(f_count = 0) then
156: p_err_code := 0;

Line 180: from fnd_form_functions_tl

176: ) IS
177:
178: cursor c_derived_function_tl(c_derived_function_id in pls_integer) is
179: select *
180: from fnd_form_functions_tl
181: where function_id = c_derived_function_id;
182:
183: begin
184:

Line 195: delete from fnd_form_functions_tl where function_id = p_derived_function_id;

191: LOOP
192: dbms_output.put_line(c_derived_function_tl_rec.language);
193: END LOOP;*/
194: remove_class_lang_entry(p_derived_class_id,p_err_code,p_err_message);
195: delete from fnd_form_functions_tl where function_id = p_derived_function_id;
196: p_err_code := 0;
197: p_err_message := wf_core.translate('WF_WS_DELETE_SUCCESS');
198:
199: exception