135: L_DUMMY number;
136: begin
137: begin
138: select 1 into l_dummy
139: from dba_source
140: where owner = ad_zd.apps_schema
141: and name = ad_zd_seed.eds_function(x_table_name)
142: and type = 'FUNCTION'
143: and instr(text, ad_zd.get_edition('PATCH')) <> 0;
1147: L_SAVE_BODY varchar2(32000);
1148:
1149: cursor C_FUNC_CUR(x_owner varchar2, x_function varchar2, x_edition varchar2) is
1150: select text
1151: from dba_source
1152: where owner = x_owner
1153: and name = x_function
1154: and type = 'FUNCTION'
1155: and instr(text,x_edition) <> 0;