APPS.PO_WF_FUN dependencies on ALL_SOURCE

Line 74: from all_source

70: and language = 'US' ;
71:
72: select min(line)
73: into x_line_s
74: from all_source
75: where name= x_wf_function.package_name
76: and owner= l_apps_schema_name --bug4025028
77: and type='PACKAGE BODY'
78: and upper(text) like '%PROCEDURE'||'% '||x_wf_function.procedure_name||'%' ;

Line 82: from all_source

78: and upper(text) like '%PROCEDURE'||'% '||x_wf_function.procedure_name||'%' ;
79:
80: select max(line)
81: into x_line_e
82: from all_source
83: where name= x_wf_function.package_name
84: and owner= l_apps_schema_name --bug4025028
85: and type='PACKAGE BODY'
86: and (upper(text) like '%END'||'% '||x_wf_function.procedure_name||'%');

Line 108: from all_source

104:
105: if (upper(x_wf_function_code.text) like '%SETITEMATTR%' ) then
106: select text
107: into x_text
108: from all_source
109: where name = x_wf_function.package_name
110: and owner= l_apps_schema_name --bug4025028
111: and type='PACKAGE BODY'
112: and line >=x_wf_function_code.line and line <= (x_wf_function_code.line+5)

Line 121: from all_source

117:
118: elsif (upper(x_wf_function_code.text) like '%GETITEMATTR%') then
119: select text
120: into x_text
121: from all_source
122: where name = x_wf_function.package_name
123: and owner= l_apps_schema_name --bug4025028
124: and type='PACKAGE BODY'
125: and line >=x_wf_function_code.line and line <= (x_wf_function_code.line+3)