DBA Data[Home] [Help]

APPS.PO_WF_FUN dependencies on DBMS_OUTPUT

Line 95: dbms_output.put_line(' /***************************************************/');

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);

Line 96: dbms_output.put_line(' Item type '||x_item_type_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);

Line 97: dbms_output.put_line(' Item type(Internal name) '||x_wf_function.item_type);

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(' /***************************************************/');

Line 98: dbms_output.put_line(' Function Activity '||x_function_name);

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;

Line 99: dbms_output.put_line(' Package '||x_wf_function.package_name);

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;

Line 100: dbms_output.put_line(' Procedure '||x_wf_function.procedure_name);

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:

Line 101: dbms_output.put_line(' /***************************************************/');

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

Line 116: dbms_output.put_line('SETITEMATTR '||x_temp);

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

Line 129: dbms_output.put_line('GETITEMATTR '||x_temp);

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:

Line 131: dbms_output.put_line(x_wf_function_code.text);

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:

Line 138: dbms_output.put_line(' ');

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;

Line 147: dbms_output.put_line ('In exception');

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: