SYSTEM.AD_DDL dependencies on DBMS_SQL

Line 205: c := dbms_sql.open_cursor;

201: c integer;
202: rows_processed number;
203: c_statement varchar2(2000);
204: begin
205: c := dbms_sql.open_cursor;
206: c_statement:='select install_group_num from '||
207: p_apps_schema||'.fnd_oracle_userid '||
208: 'where oracle_username = upper(:oracle_schema) '||
209: 'and install_group_num is not null';

Line 210: dbms_sql.parse(c, c_statement, dbms_sql.native);

206: c_statement:='select install_group_num from '||
207: p_apps_schema||'.fnd_oracle_userid '||
208: 'where oracle_username = upper(:oracle_schema) '||
209: 'and install_group_num is not null';
210: dbms_sql.parse(c, c_statement, dbms_sql.native);
211: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
212: dbms_sql.define_column(c,1,install_group_num);
213: rows_processed := dbms_sql.execute(c);
214: if dbms_sql.fetch_rows(c) > 0 then

Line 211: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);

207: p_apps_schema||'.fnd_oracle_userid '||
208: 'where oracle_username = upper(:oracle_schema) '||
209: 'and install_group_num is not null';
210: dbms_sql.parse(c, c_statement, dbms_sql.native);
211: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
212: dbms_sql.define_column(c,1,install_group_num);
213: rows_processed := dbms_sql.execute(c);
214: if dbms_sql.fetch_rows(c) > 0 then
215: dbms_sql.column_value(c,1,install_group_num);

Line 212: dbms_sql.define_column(c,1,install_group_num);

208: 'where oracle_username = upper(:oracle_schema) '||
209: 'and install_group_num is not null';
210: dbms_sql.parse(c, c_statement, dbms_sql.native);
211: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
212: dbms_sql.define_column(c,1,install_group_num);
213: rows_processed := dbms_sql.execute(c);
214: if dbms_sql.fetch_rows(c) > 0 then
215: dbms_sql.column_value(c,1,install_group_num);
216:

Line 213: rows_processed := dbms_sql.execute(c);

209: 'and install_group_num is not null';
210: dbms_sql.parse(c, c_statement, dbms_sql.native);
211: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
212: dbms_sql.define_column(c,1,install_group_num);
213: rows_processed := dbms_sql.execute(c);
214: if dbms_sql.fetch_rows(c) > 0 then
215: dbms_sql.column_value(c,1,install_group_num);
216:
217: else

Line 214: if dbms_sql.fetch_rows(c) > 0 then

210: dbms_sql.parse(c, c_statement, dbms_sql.native);
211: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
212: dbms_sql.define_column(c,1,install_group_num);
213: rows_processed := dbms_sql.execute(c);
214: if dbms_sql.fetch_rows(c) > 0 then
215: dbms_sql.column_value(c,1,install_group_num);
216:
217: else
218: raise no_data_found;

Line 215: dbms_sql.column_value(c,1,install_group_num);

211: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
212: dbms_sql.define_column(c,1,install_group_num);
213: rows_processed := dbms_sql.execute(c);
214: if dbms_sql.fetch_rows(c) > 0 then
215: dbms_sql.column_value(c,1,install_group_num);
216:
217: else
218: raise no_data_found;
219: end if;

Line 220: dbms_sql.close_cursor(c);

216:
217: else
218: raise no_data_found;
219: end if;
220: dbms_sql.close_cursor(c);
221: g_Ign_Cache_Tbl(oracle_schema) := install_group_num;
222: exception
223: when others then
224: dbms_sql.close_cursor(c);

Line 224: dbms_sql.close_cursor(c);

220: dbms_sql.close_cursor(c);
221: g_Ign_Cache_Tbl(oracle_schema) := install_group_num;
222: exception
223: when others then
224: dbms_sql.close_cursor(c);
225: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
226: ad_ddl.error_buf;
227: raise;
228: END ; -- Block Find Ign

Line 488: c := dbms_sql.open_cursor;

484: c_statement varchar2(2000);
485: l_install_group_num number;
486: begin
487: print_local_sql := TRUE;
488: c := dbms_sql.open_cursor;
489: c_statement:='select install_group_num from '||
490: davcsap_apps_schema||'.fnd_oracle_userid '||
491: 'where read_only_flag = ''U'' '||
492: 'order by install_group_num';

Line 493: dbms_sql.parse(c, c_statement, dbms_sql.native);

489: c_statement:='select install_group_num from '||
490: davcsap_apps_schema||'.fnd_oracle_userid '||
491: 'where read_only_flag = ''U'' '||
492: 'order by install_group_num';
493: dbms_sql.parse(c, c_statement, dbms_sql.native);
494: dbms_sql.define_column(c,1,l_install_group_num);
495: rows_processed := dbms_sql.execute(c);
496: print_local_sql := FALSE;
497: loop

Line 494: dbms_sql.define_column(c,1,l_install_group_num);

490: davcsap_apps_schema||'.fnd_oracle_userid '||
491: 'where read_only_flag = ''U'' '||
492: 'order by install_group_num';
493: dbms_sql.parse(c, c_statement, dbms_sql.native);
494: dbms_sql.define_column(c,1,l_install_group_num);
495: rows_processed := dbms_sql.execute(c);
496: print_local_sql := FALSE;
497: loop
498: if dbms_sql.fetch_rows(c) > 0 then

Line 495: rows_processed := dbms_sql.execute(c);

491: 'where read_only_flag = ''U'' '||
492: 'order by install_group_num';
493: dbms_sql.parse(c, c_statement, dbms_sql.native);
494: dbms_sql.define_column(c,1,l_install_group_num);
495: rows_processed := dbms_sql.execute(c);
496: print_local_sql := FALSE;
497: loop
498: if dbms_sql.fetch_rows(c) > 0 then
499: dbms_sql.column_value(c,1,l_install_group_num);

Line 498: if dbms_sql.fetch_rows(c) > 0 then

494: dbms_sql.define_column(c,1,l_install_group_num);
495: rows_processed := dbms_sql.execute(c);
496: print_local_sql := FALSE;
497: loop
498: if dbms_sql.fetch_rows(c) > 0 then
499: dbms_sql.column_value(c,1,l_install_group_num);
500: ad_apps_private.get_apps_schema_name(l_install_group_num,
501: davcsap_apps_schema, l_apps_schema, l_mls_apps_schema);
502: -- execute the alter view in the apps schema

Line 499: dbms_sql.column_value(c,1,l_install_group_num);

495: rows_processed := dbms_sql.execute(c);
496: print_local_sql := FALSE;
497: loop
498: if dbms_sql.fetch_rows(c) > 0 then
499: dbms_sql.column_value(c,1,l_install_group_num);
500: ad_apps_private.get_apps_schema_name(l_install_group_num,
501: davcsap_apps_schema, l_apps_schema, l_mls_apps_schema);
502: -- execute the alter view in the apps schema
503: begin

Line 553: dbms_sql.close_cursor(c);

549: end;
550: end if;
551:
552: else
553: dbms_sql.close_cursor(c);
554: exit;
555: end if;
556: end loop;
557: exception

Line 559: dbms_sql.close_cursor(c);

555: end if;
556: end loop;
557: exception
558: when others then
559: dbms_sql.close_cursor(c);
560: if print_local_sql then
561: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
562: ad_ddl.error_buf;
563: end if;

Line 655: c := dbms_sql.open_cursor;

651: c_statement varchar2(2000);
652: l_install_group_num number;
653: begin
654: print_local_sql := TRUE;
655: c := dbms_sql.open_cursor;
656: c_statement:='select distinct install_group_num from '||
657: dctcs_apps_schema||'.fnd_oracle_userid '||
658: 'where read_only_flag = ''U'' '||
659: 'order by install_group_num';

Line 660: dbms_sql.parse(c, c_statement, dbms_sql.native);

656: c_statement:='select distinct install_group_num from '||
657: dctcs_apps_schema||'.fnd_oracle_userid '||
658: 'where read_only_flag = ''U'' '||
659: 'order by install_group_num';
660: dbms_sql.parse(c, c_statement, dbms_sql.native);
661: dbms_sql.define_column(c,1,l_install_group_num);
662: rows_processed := dbms_sql.execute(c);
663: print_local_sql := FALSE;
664: loop

Line 661: dbms_sql.define_column(c,1,l_install_group_num);

657: dctcs_apps_schema||'.fnd_oracle_userid '||
658: 'where read_only_flag = ''U'' '||
659: 'order by install_group_num';
660: dbms_sql.parse(c, c_statement, dbms_sql.native);
661: dbms_sql.define_column(c,1,l_install_group_num);
662: rows_processed := dbms_sql.execute(c);
663: print_local_sql := FALSE;
664: loop
665:

Line 662: rows_processed := dbms_sql.execute(c);

658: 'where read_only_flag = ''U'' '||
659: 'order by install_group_num';
660: dbms_sql.parse(c, c_statement, dbms_sql.native);
661: dbms_sql.define_column(c,1,l_install_group_num);
662: rows_processed := dbms_sql.execute(c);
663: print_local_sql := FALSE;
664: loop
665:
666: if dbms_sql.fetch_rows(c) > 0 then

Line 666: if dbms_sql.fetch_rows(c) > 0 then

662: rows_processed := dbms_sql.execute(c);
663: print_local_sql := FALSE;
664: loop
665:
666: if dbms_sql.fetch_rows(c) > 0 then
667: dbms_sql.column_value(c,1,l_install_group_num);
668:
669: -- get the apps_schema_names for this install group
670: ad_apps_private.get_apps_schema_name(l_install_group_num,

Line 667: dbms_sql.column_value(c,1,l_install_group_num);

663: print_local_sql := FALSE;
664: loop
665:
666: if dbms_sql.fetch_rows(c) > 0 then
667: dbms_sql.column_value(c,1,l_install_group_num);
668:
669: -- get the apps_schema_names for this install group
670: ad_apps_private.get_apps_schema_name(l_install_group_num,
671: dctcs_apps_schema, l_apps_schema, l_mls_apps_schema);

Line 699: dbms_sql.close_cursor(c);

695: end if;
696: end if;
697:
698: else
699: dbms_sql.close_cursor(c);
700: exit;
701: end if;
702: end loop;
703: exception

Line 705: dbms_sql.close_cursor(c);

701: end if;
702: end loop;
703: exception
704: when others then
705: dbms_sql.close_cursor(c);
706: if print_local_sql then
707: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
708: ad_ddl.error_buf;
709: end if;

Line 805: c := dbms_sql.open_cursor;

801: c_statement varchar2(2000);
802: l_install_group_num number;
803: begin
804: print_local_sql := TRUE;
805: c := dbms_sql.open_cursor;
806: c_statement:='select distinct install_group_num from '||
807: dcv_apps_schema||'.fnd_oracle_userid '||
808: 'where read_only_flag = ''U'' '||
809: 'order by install_group_num';

Line 810: dbms_sql.parse(c, c_statement, dbms_sql.native);

806: c_statement:='select distinct install_group_num from '||
807: dcv_apps_schema||'.fnd_oracle_userid '||
808: 'where read_only_flag = ''U'' '||
809: 'order by install_group_num';
810: dbms_sql.parse(c, c_statement, dbms_sql.native);
811: dbms_sql.define_column(c,1,l_install_group_num);
812: rows_processed := dbms_sql.execute(c);
813: print_local_sql := FALSE;
814: loop

Line 811: dbms_sql.define_column(c,1,l_install_group_num);

807: dcv_apps_schema||'.fnd_oracle_userid '||
808: 'where read_only_flag = ''U'' '||
809: 'order by install_group_num';
810: dbms_sql.parse(c, c_statement, dbms_sql.native);
811: dbms_sql.define_column(c,1,l_install_group_num);
812: rows_processed := dbms_sql.execute(c);
813: print_local_sql := FALSE;
814: loop
815: if dbms_sql.fetch_rows(c) > 0 then

Line 812: rows_processed := dbms_sql.execute(c);

808: 'where read_only_flag = ''U'' '||
809: 'order by install_group_num';
810: dbms_sql.parse(c, c_statement, dbms_sql.native);
811: dbms_sql.define_column(c,1,l_install_group_num);
812: rows_processed := dbms_sql.execute(c);
813: print_local_sql := FALSE;
814: loop
815: if dbms_sql.fetch_rows(c) > 0 then
816: dbms_sql.column_value(c,1,l_install_group_num);

Line 815: if dbms_sql.fetch_rows(c) > 0 then

811: dbms_sql.define_column(c,1,l_install_group_num);
812: rows_processed := dbms_sql.execute(c);
813: print_local_sql := FALSE;
814: loop
815: if dbms_sql.fetch_rows(c) > 0 then
816: dbms_sql.column_value(c,1,l_install_group_num);
817:
818: -- get the apps_schema_names for this install group
819: ad_apps_private.get_apps_schema_name(l_install_group_num,

Line 816: dbms_sql.column_value(c,1,l_install_group_num);

812: rows_processed := dbms_sql.execute(c);
813: print_local_sql := FALSE;
814: loop
815: if dbms_sql.fetch_rows(c) > 0 then
816: dbms_sql.column_value(c,1,l_install_group_num);
817:
818: -- get the apps_schema_names for this install group
819: ad_apps_private.get_apps_schema_name(l_install_group_num,
820: dcv_apps_schema, l_apps_schema, l_mls_apps_schema);

Line 863: dbms_sql.close_cursor(c);

859: end if;
860: end if;
861:
862: else
863: dbms_sql.close_cursor(c);
864: exit;
865: end if;
866: end loop;
867: exception

Line 869: dbms_sql.close_cursor(c);

865: end if;
866: end loop;
867: exception
868: when others then
869: dbms_sql.close_cursor(c);
870: if print_local_sql then
871: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
872: ad_ddl.error_buf;
873: end if;

Line 1115: c := dbms_sql.open_cursor;

1111: c integer;
1112: rows_processed number;
1113: c_statement varchar2(2000);
1114: begin
1115: c := dbms_sql.open_cursor;
1116: c_statement:='select install_group_num from '||
1117: apps_schema||'.fnd_oracle_userid '||
1118: 'where oracle_username = upper(:oracle_schema) '||
1119: 'and install_group_num is not null';

Line 1120: dbms_sql.parse(c, c_statement, dbms_sql.native);

1116: c_statement:='select install_group_num from '||
1117: apps_schema||'.fnd_oracle_userid '||
1118: 'where oracle_username = upper(:oracle_schema) '||
1119: 'and install_group_num is not null';
1120: dbms_sql.parse(c, c_statement, dbms_sql.native);
1121: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
1122: dbms_sql.define_column(c,1,install_group_num);
1123: rows_processed := dbms_sql.execute(c);
1124: if dbms_sql.fetch_rows(c) > 0 then

Line 1121: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);

1117: apps_schema||'.fnd_oracle_userid '||
1118: 'where oracle_username = upper(:oracle_schema) '||
1119: 'and install_group_num is not null';
1120: dbms_sql.parse(c, c_statement, dbms_sql.native);
1121: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
1122: dbms_sql.define_column(c,1,install_group_num);
1123: rows_processed := dbms_sql.execute(c);
1124: if dbms_sql.fetch_rows(c) > 0 then
1125: dbms_sql.column_value(c,1,install_group_num);

Line 1122: dbms_sql.define_column(c,1,install_group_num);

1118: 'where oracle_username = upper(:oracle_schema) '||
1119: 'and install_group_num is not null';
1120: dbms_sql.parse(c, c_statement, dbms_sql.native);
1121: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
1122: dbms_sql.define_column(c,1,install_group_num);
1123: rows_processed := dbms_sql.execute(c);
1124: if dbms_sql.fetch_rows(c) > 0 then
1125: dbms_sql.column_value(c,1,install_group_num);
1126:

Line 1123: rows_processed := dbms_sql.execute(c);

1119: 'and install_group_num is not null';
1120: dbms_sql.parse(c, c_statement, dbms_sql.native);
1121: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
1122: dbms_sql.define_column(c,1,install_group_num);
1123: rows_processed := dbms_sql.execute(c);
1124: if dbms_sql.fetch_rows(c) > 0 then
1125: dbms_sql.column_value(c,1,install_group_num);
1126:
1127: else

Line 1124: if dbms_sql.fetch_rows(c) > 0 then

1120: dbms_sql.parse(c, c_statement, dbms_sql.native);
1121: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
1122: dbms_sql.define_column(c,1,install_group_num);
1123: rows_processed := dbms_sql.execute(c);
1124: if dbms_sql.fetch_rows(c) > 0 then
1125: dbms_sql.column_value(c,1,install_group_num);
1126:
1127: else
1128: raise no_data_found;

Line 1125: dbms_sql.column_value(c,1,install_group_num);

1121: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
1122: dbms_sql.define_column(c,1,install_group_num);
1123: rows_processed := dbms_sql.execute(c);
1124: if dbms_sql.fetch_rows(c) > 0 then
1125: dbms_sql.column_value(c,1,install_group_num);
1126:
1127: else
1128: raise no_data_found;
1129: end if;

Line 1130: dbms_sql.close_cursor(c);

1126:
1127: else
1128: raise no_data_found;
1129: end if;
1130: dbms_sql.close_cursor(c);
1131: exception
1132: when others then
1133: dbms_sql.close_cursor(c);
1134: ad_ddl.error_buf := 'c_statement='||c_statement||': '||

Line 1133: dbms_sql.close_cursor(c);

1129: end if;
1130: dbms_sql.close_cursor(c);
1131: exception
1132: when others then
1133: dbms_sql.close_cursor(c);
1134: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
1135: ad_ddl.error_buf;
1136: raise;
1137: end;

Line 2119: c := dbms_sql.open_cursor;

2115: c integer;
2116: rows_processed number;
2117: c_statement varchar2(2000);
2118: begin
2119: c := dbms_sql.open_cursor;
2120: c_statement:='select install_group_num from '||
2121: p_apps_schema||'.fnd_oracle_userid '||
2122: 'where oracle_username = upper(:oracle_schema) '||
2123: 'and install_group_num is not null';

Line 2124: dbms_sql.parse(c, c_statement, dbms_sql.native);

2120: c_statement:='select install_group_num from '||
2121: p_apps_schema||'.fnd_oracle_userid '||
2122: 'where oracle_username = upper(:oracle_schema) '||
2123: 'and install_group_num is not null';
2124: dbms_sql.parse(c, c_statement, dbms_sql.native);
2125: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
2126: dbms_sql.define_column(c,1,install_group_num);
2127: rows_processed := dbms_sql.execute(c);
2128: if dbms_sql.fetch_rows(c) > 0 then

Line 2125: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);

2121: p_apps_schema||'.fnd_oracle_userid '||
2122: 'where oracle_username = upper(:oracle_schema) '||
2123: 'and install_group_num is not null';
2124: dbms_sql.parse(c, c_statement, dbms_sql.native);
2125: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
2126: dbms_sql.define_column(c,1,install_group_num);
2127: rows_processed := dbms_sql.execute(c);
2128: if dbms_sql.fetch_rows(c) > 0 then
2129: dbms_sql.column_value(c,1,install_group_num);

Line 2126: dbms_sql.define_column(c,1,install_group_num);

2122: 'where oracle_username = upper(:oracle_schema) '||
2123: 'and install_group_num is not null';
2124: dbms_sql.parse(c, c_statement, dbms_sql.native);
2125: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
2126: dbms_sql.define_column(c,1,install_group_num);
2127: rows_processed := dbms_sql.execute(c);
2128: if dbms_sql.fetch_rows(c) > 0 then
2129: dbms_sql.column_value(c,1,install_group_num);
2130:

Line 2127: rows_processed := dbms_sql.execute(c);

2123: 'and install_group_num is not null';
2124: dbms_sql.parse(c, c_statement, dbms_sql.native);
2125: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
2126: dbms_sql.define_column(c,1,install_group_num);
2127: rows_processed := dbms_sql.execute(c);
2128: if dbms_sql.fetch_rows(c) > 0 then
2129: dbms_sql.column_value(c,1,install_group_num);
2130:
2131: else

Line 2128: if dbms_sql.fetch_rows(c) > 0 then

2124: dbms_sql.parse(c, c_statement, dbms_sql.native);
2125: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
2126: dbms_sql.define_column(c,1,install_group_num);
2127: rows_processed := dbms_sql.execute(c);
2128: if dbms_sql.fetch_rows(c) > 0 then
2129: dbms_sql.column_value(c,1,install_group_num);
2130:
2131: else
2132: raise no_data_found;

Line 2129: dbms_sql.column_value(c,1,install_group_num);

2125: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
2126: dbms_sql.define_column(c,1,install_group_num);
2127: rows_processed := dbms_sql.execute(c);
2128: if dbms_sql.fetch_rows(c) > 0 then
2129: dbms_sql.column_value(c,1,install_group_num);
2130:
2131: else
2132: raise no_data_found;
2133: end if;

Line 2134: dbms_sql.close_cursor(c);

2130:
2131: else
2132: raise no_data_found;
2133: end if;
2134: dbms_sql.close_cursor(c);
2135: exception
2136: when others then
2137: dbms_sql.close_cursor(c);
2138: ad_ddl.error_buf := 'c_statement='||c_statement||': '||

Line 2137: dbms_sql.close_cursor(c);

2133: end if;
2134: dbms_sql.close_cursor(c);
2135: exception
2136: when others then
2137: dbms_sql.close_cursor(c);
2138: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2139: ad_ddl.error_buf;
2140: raise;
2141: end;

Line 2224: c := dbms_sql.open_cursor;

2220: c_statement varchar2(2000);
2221: l_install_group_num number;
2222: begin
2223: print_local_sql := TRUE;
2224: c := dbms_sql.open_cursor;
2225: c_statement:='select distinct install_group_num from '||
2226: dcv_apps_schema||'.fnd_oracle_userid '||
2227: 'where read_only_flag = ''U'' '||
2228: 'order by install_group_num';

Line 2229: dbms_sql.parse(c, c_statement, dbms_sql.native);

2225: c_statement:='select distinct install_group_num from '||
2226: dcv_apps_schema||'.fnd_oracle_userid '||
2227: 'where read_only_flag = ''U'' '||
2228: 'order by install_group_num';
2229: dbms_sql.parse(c, c_statement, dbms_sql.native);
2230: dbms_sql.define_column(c,1,l_install_group_num);
2231: rows_processed := dbms_sql.execute(c);
2232: print_local_sql := FALSE;
2233: loop

Line 2230: dbms_sql.define_column(c,1,l_install_group_num);

2226: dcv_apps_schema||'.fnd_oracle_userid '||
2227: 'where read_only_flag = ''U'' '||
2228: 'order by install_group_num';
2229: dbms_sql.parse(c, c_statement, dbms_sql.native);
2230: dbms_sql.define_column(c,1,l_install_group_num);
2231: rows_processed := dbms_sql.execute(c);
2232: print_local_sql := FALSE;
2233: loop
2234: if dbms_sql.fetch_rows(c) > 0 then

Line 2231: rows_processed := dbms_sql.execute(c);

2227: 'where read_only_flag = ''U'' '||
2228: 'order by install_group_num';
2229: dbms_sql.parse(c, c_statement, dbms_sql.native);
2230: dbms_sql.define_column(c,1,l_install_group_num);
2231: rows_processed := dbms_sql.execute(c);
2232: print_local_sql := FALSE;
2233: loop
2234: if dbms_sql.fetch_rows(c) > 0 then
2235: dbms_sql.column_value(c,1,l_install_group_num);

Line 2234: if dbms_sql.fetch_rows(c) > 0 then

2230: dbms_sql.define_column(c,1,l_install_group_num);
2231: rows_processed := dbms_sql.execute(c);
2232: print_local_sql := FALSE;
2233: loop
2234: if dbms_sql.fetch_rows(c) > 0 then
2235: dbms_sql.column_value(c,1,l_install_group_num);
2236:
2237: -- get the apps_schema_names for this install group
2238: ad_apps_private.get_apps_schema_name(l_install_group_num,

Line 2235: dbms_sql.column_value(c,1,l_install_group_num);

2231: rows_processed := dbms_sql.execute(c);
2232: print_local_sql := FALSE;
2233: loop
2234: if dbms_sql.fetch_rows(c) > 0 then
2235: dbms_sql.column_value(c,1,l_install_group_num);
2236:
2237: -- get the apps_schema_names for this install group
2238: ad_apps_private.get_apps_schema_name(l_install_group_num,
2239: dcv_apps_schema, l_apps_schema, l_mls_apps_schema);

Line 2251: dbms_sql.close_cursor(c);

2247: dcv_lb, dcv_ub);
2248: end if;
2249:
2250: else
2251: dbms_sql.close_cursor(c);
2252: exit;
2253: end if;
2254: end loop;
2255: exception

Line 2257: dbms_sql.close_cursor(c);

2253: end if;
2254: end loop;
2255: exception
2256: when others then
2257: dbms_sql.close_cursor(c);
2258: if print_local_sql then
2259: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2260: ad_ddl.error_buf;
2261: end if;