eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.SOA_REMOVE dependencies on FND_IREP_CLASSES

Line 17: c_irep_base_name fnd_irep_classes .irep_name%type;

13: p_err_code OUT NOCOPY pls_integer,
14: p_err_message OUT NOCOPY varchar2
15: ) IS
16:
17: c_irep_base_name fnd_irep_classes .irep_name%type;
18: c_class_type fnd_irep_classes .class_type%type;
19: --dbms_output.put_line('STARTING Removal Process');
20: cursor c_derived_class_entry(c_irep_name in fnd_irep_classes .irep_name%type , c_base_class_id in number , c_service_type in fnd_irep_classes .class_type%type) is
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 18: c_class_type fnd_irep_classes .class_type%type;

14: p_err_message OUT NOCOPY varchar2
15: ) IS
16:
17: c_irep_base_name fnd_irep_classes .irep_name%type;
18: c_class_type fnd_irep_classes .class_type%type;
19: --dbms_output.put_line('STARTING Removal Process');
20: cursor c_derived_class_entry(c_irep_name in fnd_irep_classes .irep_name%type , c_base_class_id in number , c_service_type in fnd_irep_classes .class_type%type) is
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;
22:

Line 20: cursor c_derived_class_entry(c_irep_name in fnd_irep_classes .irep_name%type , c_base_class_id in number , c_service_type in fnd_irep_classes .class_type%type) is

16:
17: c_irep_base_name fnd_irep_classes .irep_name%type;
18: c_class_type fnd_irep_classes .class_type%type;
19: --dbms_output.put_line('STARTING Removal Process');
20: cursor c_derived_class_entry(c_irep_name in fnd_irep_classes .irep_name%type , c_base_class_id in number , c_service_type in fnd_irep_classes .class_type%type) is
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;
22:
23: cursor c_derived_class_entry1(c_irep_name in fnd_irep_classes .irep_name%type , c_base_class_id in number, c_service_type in fnd_irep_classes. class_type%type) is
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 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;

17: c_irep_base_name fnd_irep_classes .irep_name%type;
18: c_class_type fnd_irep_classes .class_type%type;
19: --dbms_output.put_line('STARTING Removal Process');
20: cursor c_derived_class_entry(c_irep_name in fnd_irep_classes .irep_name%type , c_base_class_id in number , c_service_type in fnd_irep_classes .class_type%type) is
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;
22:
23: cursor c_derived_class_entry1(c_irep_name in fnd_irep_classes .irep_name%type , c_base_class_id in number, c_service_type in fnd_irep_classes. class_type%type) is
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;
25: c_class_rec c_derived_class_entry1%ROWTYPE;

Line 23: cursor c_derived_class_entry1(c_irep_name in fnd_irep_classes .irep_name%type , c_base_class_id in number, c_service_type in fnd_irep_classes. class_type%type) is

19: --dbms_output.put_line('STARTING Removal Process');
20: cursor c_derived_class_entry(c_irep_name in fnd_irep_classes .irep_name%type , c_base_class_id in number , c_service_type in fnd_irep_classes .class_type%type) is
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;
22:
23: cursor c_derived_class_entry1(c_irep_name in fnd_irep_classes .irep_name%type , c_base_class_id in number, c_service_type in fnd_irep_classes. class_type%type) is
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;
25: c_class_rec c_derived_class_entry1%ROWTYPE;
26: d_count pls_integer:= -1;
27:

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;

20: cursor c_derived_class_entry(c_irep_name in fnd_irep_classes .irep_name%type , c_base_class_id in number , c_service_type in fnd_irep_classes .class_type%type) is
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;
22:
23: cursor c_derived_class_entry1(c_irep_name in fnd_irep_classes .irep_name%type , c_base_class_id in number, c_service_type in fnd_irep_classes. class_type%type) is
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;
25: c_class_rec c_derived_class_entry1%ROWTYPE;
26: d_count pls_integer:= -1;
27:
28:

Line 37: select irep_name into c_irep_base_name from fnd_irep_classes where class_id = p_base_class_id;

33: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
34: raise program_exit;
35: end if;
36:
37: select irep_name into c_irep_base_name from fnd_irep_classes where class_id = p_base_class_id;
38: select class_type into c_class_type from fnd_irep_classes where class_id = p_base_class_id;
39:
40: if c_class_type = 'XMLGATEWAY' then
41: update fnd_irep_classes set irep_name=c_irep_base_name where assoc_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;

34: raise program_exit;
35: end if;
36:
37: select irep_name into c_irep_base_name from fnd_irep_classes where class_id = p_base_class_id;
38: select class_type into c_class_type from fnd_irep_classes where class_id = p_base_class_id;
39:
40: if c_class_type = 'XMLGATEWAY' then
41: update fnd_irep_classes set irep_name=c_irep_base_name where assoc_class_id=p_base_class_id;
42: end if;

Line 41: update fnd_irep_classes set irep_name=c_irep_base_name where assoc_class_id=p_base_class_id;

37: select irep_name into c_irep_base_name from fnd_irep_classes where class_id = p_base_class_id;
38: select class_type into c_class_type from fnd_irep_classes where class_id = p_base_class_id;
39:
40: if c_class_type = 'XMLGATEWAY' then
41: update fnd_irep_classes set irep_name=c_irep_base_name where assoc_class_id=p_base_class_id;
42: end if;
43:
44: open c_derived_class_entry1(c_irep_base_name,p_base_class_id,p_service_type);
45: fetch c_derived_class_entry1 into c_class_rec;

Line 66: delete from fnd_irep_classes where class_id = c_derived_class_entry_rec1.class_id;

62: --end if;
63: remove_derived_function_entry(c_derived_class_entry_rec1.class_id,p_err_code ,p_err_message );
64:
65: begin
66: delete from fnd_irep_classes where class_id = c_derived_class_entry_rec1.class_id;
67: --dbms_output.put_line('classId to delete' || c_derived_class_entry_rec1.class_id);
68: exception
69: when program_exit then
70: raise program_exit;

Line 112: c_class_type fnd_irep_classes .class_type%type;

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;
115: begin
116:

Line 113: base_class_id fnd_irep_classes .assoc_class_id%type;

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;
115: begin
116:
117: if (p_derived_class_id is null ) then

Line 129: select assoc_class_id into base_class_id from fnd_irep_classes where class_id=p_derived_class_id;

125: fetch c_derived_function_entry1 into c_function_rec;
126: close c_derived_function_entry1;
127:
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

Line 130: select class_type into c_class_type from fnd_irep_classes where class_id=base_class_id;

126: close c_derived_function_entry1;
127:
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;

Line 222: from fnd_irep_classes_tl

218: ) IS
219:
220: cursor c_derived_class_tl(c_derived_class_id in pls_integer) is
221: select *
222: from fnd_irep_classes_tl
223: where class_id = c_derived_class_id ;
224:
225: begin
226: if (p_derived_class_id is null) then

Line 236: delete from fnd_irep_classes_tl where class_id = p_derived_class_id ;

232: /* FOR c_derived_class_tl_rec IN c_derived_class_tl(p_derived_class_id)
233: LOOP
234: dbms_output.put_line(c_derived_class_tl_rec.language);
235: END LOOP;*/
236: delete from fnd_irep_classes_tl where class_id = p_derived_class_id ;
237: p_err_code := 0;
238: p_err_message := wf_core.translate('WF_WS_DELETE_SUCCESS');
239: exception
240: when program_exit then