91: fetch wf_function_codes_cursor into x_wf_function_code;
92: exit when wf_function_codes_cursor%NOTFOUND;
93:
94: if(x_count =0) then
95: dbms_output.put_line(' /***************************************************/');
96: dbms_output.put_line(' Item type '||x_item_type_name);
97: dbms_output.put_line(' Item type(Internal name) '||x_wf_function.item_type);
98: dbms_output.put_line(' Function Activity '||x_function_name);
99: dbms_output.put_line(' Package '||x_wf_function.package_name);
92: exit when wf_function_codes_cursor%NOTFOUND;
93:
94: if(x_count =0) then
95: dbms_output.put_line(' /***************************************************/');
96: dbms_output.put_line(' Item type '||x_item_type_name);
97: dbms_output.put_line(' Item type(Internal name) '||x_wf_function.item_type);
98: dbms_output.put_line(' Function Activity '||x_function_name);
99: dbms_output.put_line(' Package '||x_wf_function.package_name);
100: dbms_output.put_line(' Procedure '||x_wf_function.procedure_name);
93:
94: if(x_count =0) then
95: dbms_output.put_line(' /***************************************************/');
96: dbms_output.put_line(' Item type '||x_item_type_name);
97: dbms_output.put_line(' Item type(Internal name) '||x_wf_function.item_type);
98: dbms_output.put_line(' Function Activity '||x_function_name);
99: dbms_output.put_line(' Package '||x_wf_function.package_name);
100: dbms_output.put_line(' Procedure '||x_wf_function.procedure_name);
101: dbms_output.put_line(' /***************************************************/');
94: if(x_count =0) then
95: dbms_output.put_line(' /***************************************************/');
96: dbms_output.put_line(' Item type '||x_item_type_name);
97: dbms_output.put_line(' Item type(Internal name) '||x_wf_function.item_type);
98: dbms_output.put_line(' Function Activity '||x_function_name);
99: dbms_output.put_line(' Package '||x_wf_function.package_name);
100: dbms_output.put_line(' Procedure '||x_wf_function.procedure_name);
101: dbms_output.put_line(' /***************************************************/');
102: x_count :=1;
95: dbms_output.put_line(' /***************************************************/');
96: dbms_output.put_line(' Item type '||x_item_type_name);
97: dbms_output.put_line(' Item type(Internal name) '||x_wf_function.item_type);
98: dbms_output.put_line(' Function Activity '||x_function_name);
99: dbms_output.put_line(' Package '||x_wf_function.package_name);
100: dbms_output.put_line(' Procedure '||x_wf_function.procedure_name);
101: dbms_output.put_line(' /***************************************************/');
102: x_count :=1;
103: end if;
96: dbms_output.put_line(' Item type '||x_item_type_name);
97: dbms_output.put_line(' Item type(Internal name) '||x_wf_function.item_type);
98: dbms_output.put_line(' Function Activity '||x_function_name);
99: dbms_output.put_line(' Package '||x_wf_function.package_name);
100: dbms_output.put_line(' Procedure '||x_wf_function.procedure_name);
101: dbms_output.put_line(' /***************************************************/');
102: x_count :=1;
103: end if;
104:
97: dbms_output.put_line(' Item type(Internal name) '||x_wf_function.item_type);
98: dbms_output.put_line(' Function Activity '||x_function_name);
99: dbms_output.put_line(' Package '||x_wf_function.package_name);
100: dbms_output.put_line(' Procedure '||x_wf_function.procedure_name);
101: dbms_output.put_line(' /***************************************************/');
102: x_count :=1;
103: end if;
104:
105: if (upper(x_wf_function_code.text) like '%SETITEMATTR%' ) then
112: and line >=x_wf_function_code.line and line <= (x_wf_function_code.line+5)
113: and upper(text) like '%ANAME%';
114:
115: extract_str(x_text,x_temp);
116: dbms_output.put_line('SETITEMATTR '||x_temp);
117:
118: elsif (upper(x_wf_function_code.text) like '%GETITEMATTR%') then
119: select text
120: into x_text
125: and line >=x_wf_function_code.line and line <= (x_wf_function_code.line+3)
126: and upper(text) like '%ANAME%';
127:
128: extract_str(x_text,x_temp);
129: dbms_output.put_line('GETITEMATTR '||x_temp);
130: else
131: dbms_output.put_line(x_wf_function_code.text);
132: end if;
133:
127:
128: extract_str(x_text,x_temp);
129: dbms_output.put_line('GETITEMATTR '||x_temp);
130: else
131: dbms_output.put_line(x_wf_function_code.text);
132: end if;
133:
134: end loop;
135:
134: end loop;
135:
136: close wf_function_codes_cursor;
137:
138: dbms_output.put_line(' ');
139: x_count := 0;
140: end loop;
141:
142: close wf_functions_cursor;
143:
144: EXCEPTION
145:
146: WHEN OTHERS THEN
147: dbms_output.put_line ('In exception');
148: raise_application_error(-20001,sqlerrm||'---');
149: END PRINT_FUNCTION;
150:
151: