SYSTEM.AD_DDL dependencies on DBMS_SQL

Line 228: c := dbms_sql.open_cursor;

224: c integer;
225: rows_processed number;
226: c_statement varchar2(2000);
227: begin
228: c := dbms_sql.open_cursor;
229: c_statement:='select install_group_num from '||
230: p_apps_schema||'.fnd_oracle_userid '||
231: 'where oracle_username = upper(:oracle_schema) '||
232: 'and install_group_num is not null';

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

229: c_statement:='select install_group_num from '||
230: p_apps_schema||'.fnd_oracle_userid '||
231: 'where oracle_username = upper(:oracle_schema) '||
232: 'and install_group_num is not null';
233: dbms_sql.parse(c, c_statement, dbms_sql.native);
234: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
235: dbms_sql.define_column(c,1,install_group_num);
236: rows_processed := dbms_sql.execute(c);
237: if dbms_sql.fetch_rows(c) > 0 then

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

230: p_apps_schema||'.fnd_oracle_userid '||
231: 'where oracle_username = upper(:oracle_schema) '||
232: 'and install_group_num is not null';
233: dbms_sql.parse(c, c_statement, dbms_sql.native);
234: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
235: dbms_sql.define_column(c,1,install_group_num);
236: rows_processed := dbms_sql.execute(c);
237: if dbms_sql.fetch_rows(c) > 0 then
238: dbms_sql.column_value(c,1,install_group_num);

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

231: 'where oracle_username = upper(:oracle_schema) '||
232: 'and install_group_num is not null';
233: dbms_sql.parse(c, c_statement, dbms_sql.native);
234: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
235: dbms_sql.define_column(c,1,install_group_num);
236: rows_processed := dbms_sql.execute(c);
237: if dbms_sql.fetch_rows(c) > 0 then
238: dbms_sql.column_value(c,1,install_group_num);
239:

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

232: 'and install_group_num is not null';
233: dbms_sql.parse(c, c_statement, dbms_sql.native);
234: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
235: dbms_sql.define_column(c,1,install_group_num);
236: rows_processed := dbms_sql.execute(c);
237: if dbms_sql.fetch_rows(c) > 0 then
238: dbms_sql.column_value(c,1,install_group_num);
239:
240: else

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

233: dbms_sql.parse(c, c_statement, dbms_sql.native);
234: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
235: dbms_sql.define_column(c,1,install_group_num);
236: rows_processed := dbms_sql.execute(c);
237: if dbms_sql.fetch_rows(c) > 0 then
238: dbms_sql.column_value(c,1,install_group_num);
239:
240: else
241: raise no_data_found;

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

234: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
235: dbms_sql.define_column(c,1,install_group_num);
236: rows_processed := dbms_sql.execute(c);
237: if dbms_sql.fetch_rows(c) > 0 then
238: dbms_sql.column_value(c,1,install_group_num);
239:
240: else
241: raise no_data_found;
242: end if;

Line 243: dbms_sql.close_cursor(c);

239:
240: else
241: raise no_data_found;
242: end if;
243: dbms_sql.close_cursor(c);
244: g_Ign_Cache_Tbl(oracle_schema) := install_group_num;
245: exception
246: when others then
247: dbms_sql.close_cursor(c);

Line 247: dbms_sql.close_cursor(c);

243: dbms_sql.close_cursor(c);
244: g_Ign_Cache_Tbl(oracle_schema) := install_group_num;
245: exception
246: when others then
247: dbms_sql.close_cursor(c);
248: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
249: ad_ddl.error_buf;
250: raise;
251: END ; -- Block Find Ign

Line 600: c := dbms_sql.open_cursor;

596: c_statement varchar2(2000);
597: l_install_group_num number;
598: begin
599: print_local_sql := TRUE;
600: c := dbms_sql.open_cursor;
601: c_statement:='select install_group_num from '||
602: davcsap_apps_schema||'.fnd_oracle_userid '||
603: 'where read_only_flag = ''U'' '||
604: 'order by install_group_num';

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

601: c_statement:='select install_group_num from '||
602: davcsap_apps_schema||'.fnd_oracle_userid '||
603: 'where read_only_flag = ''U'' '||
604: 'order by install_group_num';
605: dbms_sql.parse(c, c_statement, dbms_sql.native);
606: dbms_sql.define_column(c,1,l_install_group_num);
607: rows_processed := dbms_sql.execute(c);
608: print_local_sql := FALSE;
609: loop

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

602: davcsap_apps_schema||'.fnd_oracle_userid '||
603: 'where read_only_flag = ''U'' '||
604: 'order by install_group_num';
605: dbms_sql.parse(c, c_statement, dbms_sql.native);
606: dbms_sql.define_column(c,1,l_install_group_num);
607: rows_processed := dbms_sql.execute(c);
608: print_local_sql := FALSE;
609: loop
610: if dbms_sql.fetch_rows(c) > 0 then

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

603: 'where read_only_flag = ''U'' '||
604: 'order by install_group_num';
605: dbms_sql.parse(c, c_statement, dbms_sql.native);
606: dbms_sql.define_column(c,1,l_install_group_num);
607: rows_processed := dbms_sql.execute(c);
608: print_local_sql := FALSE;
609: loop
610: if dbms_sql.fetch_rows(c) > 0 then
611: dbms_sql.column_value(c,1,l_install_group_num);

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

606: dbms_sql.define_column(c,1,l_install_group_num);
607: rows_processed := dbms_sql.execute(c);
608: print_local_sql := FALSE;
609: loop
610: if dbms_sql.fetch_rows(c) > 0 then
611: dbms_sql.column_value(c,1,l_install_group_num);
612: ad_apps_private.get_apps_schema_name(l_install_group_num,
613: davcsap_apps_schema, l_apps_schema, l_mls_apps_schema);
614: -- execute the alter view in the apps schema

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

607: rows_processed := dbms_sql.execute(c);
608: print_local_sql := FALSE;
609: loop
610: if dbms_sql.fetch_rows(c) > 0 then
611: dbms_sql.column_value(c,1,l_install_group_num);
612: ad_apps_private.get_apps_schema_name(l_install_group_num,
613: davcsap_apps_schema, l_apps_schema, l_mls_apps_schema);
614: -- execute the alter view in the apps schema
615: begin

Line 669: dbms_sql.close_cursor(c);

665: end;
666: end if;
667:
668: else
669: dbms_sql.close_cursor(c);
670: exit;
671: end if;
672: end loop;
673: exception

Line 675: dbms_sql.close_cursor(c);

671: end if;
672: end loop;
673: exception
674: when others then
675: dbms_sql.close_cursor(c);
676: if print_local_sql then
677: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
678: ad_ddl.error_buf;
679: end if;

Line 796: c := dbms_sql.open_cursor;

792: c_statement varchar2(2000);
793: l_install_group_num number;
794: begin
795: print_local_sql := TRUE;
796: c := dbms_sql.open_cursor;
797: c_statement:='select distinct install_group_num from '||
798: dctcs_apps_schema||'.fnd_oracle_userid '||
799: 'where read_only_flag = ''U'' '||
800: 'order by install_group_num';

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

797: c_statement:='select distinct install_group_num from '||
798: dctcs_apps_schema||'.fnd_oracle_userid '||
799: 'where read_only_flag = ''U'' '||
800: 'order by install_group_num';
801: dbms_sql.parse(c, c_statement, dbms_sql.native);
802: dbms_sql.define_column(c,1,l_install_group_num);
803: rows_processed := dbms_sql.execute(c);
804: print_local_sql := FALSE;
805: loop

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

798: dctcs_apps_schema||'.fnd_oracle_userid '||
799: 'where read_only_flag = ''U'' '||
800: 'order by install_group_num';
801: dbms_sql.parse(c, c_statement, dbms_sql.native);
802: dbms_sql.define_column(c,1,l_install_group_num);
803: rows_processed := dbms_sql.execute(c);
804: print_local_sql := FALSE;
805: loop
806:

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

799: 'where read_only_flag = ''U'' '||
800: 'order by install_group_num';
801: dbms_sql.parse(c, c_statement, dbms_sql.native);
802: dbms_sql.define_column(c,1,l_install_group_num);
803: rows_processed := dbms_sql.execute(c);
804: print_local_sql := FALSE;
805: loop
806:
807: if dbms_sql.fetch_rows(c) > 0 then

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

803: rows_processed := dbms_sql.execute(c);
804: print_local_sql := FALSE;
805: loop
806:
807: if dbms_sql.fetch_rows(c) > 0 then
808: dbms_sql.column_value(c,1,l_install_group_num);
809:
810: -- get the apps_schema_names for this install group
811: ad_apps_private.get_apps_schema_name(l_install_group_num,

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

804: print_local_sql := FALSE;
805: loop
806:
807: if dbms_sql.fetch_rows(c) > 0 then
808: dbms_sql.column_value(c,1,l_install_group_num);
809:
810: -- get the apps_schema_names for this install group
811: ad_apps_private.get_apps_schema_name(l_install_group_num,
812: dctcs_apps_schema, l_apps_schema, l_mls_apps_schema);

Line 847: dbms_sql.close_cursor(c);

843: end if;
844: end if;
845:
846: else
847: dbms_sql.close_cursor(c);
848: exit;
849: end if;
850: end loop;
851: exception

Line 853: dbms_sql.close_cursor(c);

849: end if;
850: end loop;
851: exception
852: when others then
853: dbms_sql.close_cursor(c);
854: if print_local_sql then
855: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
856: ad_ddl.error_buf;
857: end if;

Line 970: c := dbms_sql.open_cursor;

966: c_statement varchar2(2000);
967: l_install_group_num number;
968: begin
969: print_local_sql := TRUE;
970: c := dbms_sql.open_cursor;
971: c_statement:='select distinct install_group_num from '||
972: dcv_apps_schema||'.fnd_oracle_userid '||
973: 'where read_only_flag = ''U'' '||
974: 'order by install_group_num';

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

971: c_statement:='select distinct install_group_num from '||
972: dcv_apps_schema||'.fnd_oracle_userid '||
973: 'where read_only_flag = ''U'' '||
974: 'order by install_group_num';
975: dbms_sql.parse(c, c_statement, dbms_sql.native);
976: dbms_sql.define_column(c,1,l_install_group_num);
977: rows_processed := dbms_sql.execute(c);
978: print_local_sql := FALSE;
979: loop

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

972: dcv_apps_schema||'.fnd_oracle_userid '||
973: 'where read_only_flag = ''U'' '||
974: 'order by install_group_num';
975: dbms_sql.parse(c, c_statement, dbms_sql.native);
976: dbms_sql.define_column(c,1,l_install_group_num);
977: rows_processed := dbms_sql.execute(c);
978: print_local_sql := FALSE;
979: loop
980: if dbms_sql.fetch_rows(c) > 0 then

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

973: 'where read_only_flag = ''U'' '||
974: 'order by install_group_num';
975: dbms_sql.parse(c, c_statement, dbms_sql.native);
976: dbms_sql.define_column(c,1,l_install_group_num);
977: rows_processed := dbms_sql.execute(c);
978: print_local_sql := FALSE;
979: loop
980: if dbms_sql.fetch_rows(c) > 0 then
981: dbms_sql.column_value(c,1,l_install_group_num);

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

976: dbms_sql.define_column(c,1,l_install_group_num);
977: rows_processed := dbms_sql.execute(c);
978: print_local_sql := FALSE;
979: loop
980: if dbms_sql.fetch_rows(c) > 0 then
981: dbms_sql.column_value(c,1,l_install_group_num);
982:
983: -- get the apps_schema_names for this install group
984: ad_apps_private.get_apps_schema_name(l_install_group_num,

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

977: rows_processed := dbms_sql.execute(c);
978: print_local_sql := FALSE;
979: loop
980: if dbms_sql.fetch_rows(c) > 0 then
981: dbms_sql.column_value(c,1,l_install_group_num);
982:
983: -- get the apps_schema_names for this install group
984: ad_apps_private.get_apps_schema_name(l_install_group_num,
985: dcv_apps_schema, l_apps_schema, l_mls_apps_schema);

Line 1044: dbms_sql.close_cursor(c);

1040: end if;
1041: end if;
1042:
1043: else
1044: dbms_sql.close_cursor(c);
1045: exit;
1046: end if;
1047: end loop;
1048: exception

Line 1050: dbms_sql.close_cursor(c);

1046: end if;
1047: end loop;
1048: exception
1049: when others then
1050: dbms_sql.close_cursor(c);
1051: if print_local_sql then
1052: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
1053: ad_ddl.error_buf;
1054: end if;

Line 1296: c := dbms_sql.open_cursor;

1292: c integer;
1293: rows_processed number;
1294: c_statement varchar2(2000);
1295: begin
1296: c := dbms_sql.open_cursor;
1297: c_statement:='select install_group_num from '||
1298: apps_schema||'.fnd_oracle_userid '||
1299: 'where oracle_username = upper(:oracle_schema) '||
1300: 'and install_group_num is not null';

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

1297: c_statement:='select install_group_num from '||
1298: apps_schema||'.fnd_oracle_userid '||
1299: 'where oracle_username = upper(:oracle_schema) '||
1300: 'and install_group_num is not null';
1301: dbms_sql.parse(c, c_statement, dbms_sql.native);
1302: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
1303: dbms_sql.define_column(c,1,install_group_num);
1304: rows_processed := dbms_sql.execute(c);
1305: if dbms_sql.fetch_rows(c) > 0 then

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

1298: apps_schema||'.fnd_oracle_userid '||
1299: 'where oracle_username = upper(:oracle_schema) '||
1300: 'and install_group_num is not null';
1301: dbms_sql.parse(c, c_statement, dbms_sql.native);
1302: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
1303: dbms_sql.define_column(c,1,install_group_num);
1304: rows_processed := dbms_sql.execute(c);
1305: if dbms_sql.fetch_rows(c) > 0 then
1306: dbms_sql.column_value(c,1,install_group_num);

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

1299: 'where oracle_username = upper(:oracle_schema) '||
1300: 'and install_group_num is not null';
1301: dbms_sql.parse(c, c_statement, dbms_sql.native);
1302: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
1303: dbms_sql.define_column(c,1,install_group_num);
1304: rows_processed := dbms_sql.execute(c);
1305: if dbms_sql.fetch_rows(c) > 0 then
1306: dbms_sql.column_value(c,1,install_group_num);
1307:

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

1300: 'and install_group_num is not null';
1301: dbms_sql.parse(c, c_statement, dbms_sql.native);
1302: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
1303: dbms_sql.define_column(c,1,install_group_num);
1304: rows_processed := dbms_sql.execute(c);
1305: if dbms_sql.fetch_rows(c) > 0 then
1306: dbms_sql.column_value(c,1,install_group_num);
1307:
1308: else

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

1301: dbms_sql.parse(c, c_statement, dbms_sql.native);
1302: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
1303: dbms_sql.define_column(c,1,install_group_num);
1304: rows_processed := dbms_sql.execute(c);
1305: if dbms_sql.fetch_rows(c) > 0 then
1306: dbms_sql.column_value(c,1,install_group_num);
1307:
1308: else
1309: raise no_data_found;

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

1302: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
1303: dbms_sql.define_column(c,1,install_group_num);
1304: rows_processed := dbms_sql.execute(c);
1305: if dbms_sql.fetch_rows(c) > 0 then
1306: dbms_sql.column_value(c,1,install_group_num);
1307:
1308: else
1309: raise no_data_found;
1310: end if;

Line 1311: dbms_sql.close_cursor(c);

1307:
1308: else
1309: raise no_data_found;
1310: end if;
1311: dbms_sql.close_cursor(c);
1312: exception
1313: when others then
1314: dbms_sql.close_cursor(c);
1315: ad_ddl.error_buf := 'c_statement='||c_statement||': '||

Line 1314: dbms_sql.close_cursor(c);

1310: end if;
1311: dbms_sql.close_cursor(c);
1312: exception
1313: when others then
1314: dbms_sql.close_cursor(c);
1315: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
1316: ad_ddl.error_buf;
1317: raise;
1318: end;

Line 2300: c := dbms_sql.open_cursor;

2296: c integer;
2297: rows_processed number;
2298: c_statement varchar2(2000);
2299: begin
2300: c := dbms_sql.open_cursor;
2301: c_statement:='select install_group_num from '||
2302: p_apps_schema||'.fnd_oracle_userid '||
2303: 'where oracle_username = upper(:oracle_schema) '||
2304: 'and install_group_num is not null';

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

2301: c_statement:='select install_group_num from '||
2302: p_apps_schema||'.fnd_oracle_userid '||
2303: 'where oracle_username = upper(:oracle_schema) '||
2304: 'and install_group_num is not null';
2305: dbms_sql.parse(c, c_statement, dbms_sql.native);
2306: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
2307: dbms_sql.define_column(c,1,install_group_num);
2308: rows_processed := dbms_sql.execute(c);
2309: if dbms_sql.fetch_rows(c) > 0 then

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

2302: p_apps_schema||'.fnd_oracle_userid '||
2303: 'where oracle_username = upper(:oracle_schema) '||
2304: 'and install_group_num is not null';
2305: dbms_sql.parse(c, c_statement, dbms_sql.native);
2306: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
2307: dbms_sql.define_column(c,1,install_group_num);
2308: rows_processed := dbms_sql.execute(c);
2309: if dbms_sql.fetch_rows(c) > 0 then
2310: dbms_sql.column_value(c,1,install_group_num);

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

2303: 'where oracle_username = upper(:oracle_schema) '||
2304: 'and install_group_num is not null';
2305: dbms_sql.parse(c, c_statement, dbms_sql.native);
2306: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
2307: dbms_sql.define_column(c,1,install_group_num);
2308: rows_processed := dbms_sql.execute(c);
2309: if dbms_sql.fetch_rows(c) > 0 then
2310: dbms_sql.column_value(c,1,install_group_num);
2311:

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

2304: 'and install_group_num is not null';
2305: dbms_sql.parse(c, c_statement, dbms_sql.native);
2306: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
2307: dbms_sql.define_column(c,1,install_group_num);
2308: rows_processed := dbms_sql.execute(c);
2309: if dbms_sql.fetch_rows(c) > 0 then
2310: dbms_sql.column_value(c,1,install_group_num);
2311:
2312: else

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

2305: dbms_sql.parse(c, c_statement, dbms_sql.native);
2306: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
2307: dbms_sql.define_column(c,1,install_group_num);
2308: rows_processed := dbms_sql.execute(c);
2309: if dbms_sql.fetch_rows(c) > 0 then
2310: dbms_sql.column_value(c,1,install_group_num);
2311:
2312: else
2313: raise no_data_found;

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

2306: dbms_sql.bind_variable(c,'oracle_schema',oracle_schema,30);
2307: dbms_sql.define_column(c,1,install_group_num);
2308: rows_processed := dbms_sql.execute(c);
2309: if dbms_sql.fetch_rows(c) > 0 then
2310: dbms_sql.column_value(c,1,install_group_num);
2311:
2312: else
2313: raise no_data_found;
2314: end if;

Line 2315: dbms_sql.close_cursor(c);

2311:
2312: else
2313: raise no_data_found;
2314: end if;
2315: dbms_sql.close_cursor(c);
2316: exception
2317: when others then
2318: dbms_sql.close_cursor(c);
2319: ad_ddl.error_buf := 'c_statement='||c_statement||': '||

Line 2318: dbms_sql.close_cursor(c);

2314: end if;
2315: dbms_sql.close_cursor(c);
2316: exception
2317: when others then
2318: dbms_sql.close_cursor(c);
2319: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2320: ad_ddl.error_buf;
2321: raise;
2322: end;

Line 2405: c := dbms_sql.open_cursor;

2401: c_statement varchar2(2000);
2402: l_install_group_num number;
2403: begin
2404: print_local_sql := TRUE;
2405: c := dbms_sql.open_cursor;
2406: c_statement:='select distinct install_group_num from '||
2407: dcv_apps_schema||'.fnd_oracle_userid '||
2408: 'where read_only_flag = ''U'' '||
2409: 'order by install_group_num';

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

2406: c_statement:='select distinct install_group_num from '||
2407: dcv_apps_schema||'.fnd_oracle_userid '||
2408: 'where read_only_flag = ''U'' '||
2409: 'order by install_group_num';
2410: dbms_sql.parse(c, c_statement, dbms_sql.native);
2411: dbms_sql.define_column(c,1,l_install_group_num);
2412: rows_processed := dbms_sql.execute(c);
2413: print_local_sql := FALSE;
2414: loop

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

2407: dcv_apps_schema||'.fnd_oracle_userid '||
2408: 'where read_only_flag = ''U'' '||
2409: 'order by install_group_num';
2410: dbms_sql.parse(c, c_statement, dbms_sql.native);
2411: dbms_sql.define_column(c,1,l_install_group_num);
2412: rows_processed := dbms_sql.execute(c);
2413: print_local_sql := FALSE;
2414: loop
2415: if dbms_sql.fetch_rows(c) > 0 then

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

2408: 'where read_only_flag = ''U'' '||
2409: 'order by install_group_num';
2410: dbms_sql.parse(c, c_statement, dbms_sql.native);
2411: dbms_sql.define_column(c,1,l_install_group_num);
2412: rows_processed := dbms_sql.execute(c);
2413: print_local_sql := FALSE;
2414: loop
2415: if dbms_sql.fetch_rows(c) > 0 then
2416: dbms_sql.column_value(c,1,l_install_group_num);

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

2411: dbms_sql.define_column(c,1,l_install_group_num);
2412: rows_processed := dbms_sql.execute(c);
2413: print_local_sql := FALSE;
2414: loop
2415: if dbms_sql.fetch_rows(c) > 0 then
2416: dbms_sql.column_value(c,1,l_install_group_num);
2417:
2418: -- get the apps_schema_names for this install group
2419: ad_apps_private.get_apps_schema_name(l_install_group_num,

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

2412: rows_processed := dbms_sql.execute(c);
2413: print_local_sql := FALSE;
2414: loop
2415: if dbms_sql.fetch_rows(c) > 0 then
2416: dbms_sql.column_value(c,1,l_install_group_num);
2417:
2418: -- get the apps_schema_names for this install group
2419: ad_apps_private.get_apps_schema_name(l_install_group_num,
2420: dcv_apps_schema, l_apps_schema, l_mls_apps_schema);

Line 2432: dbms_sql.close_cursor(c);

2428: dcv_lb, dcv_ub,dcv_object_name,'VIEW');
2429: end if;
2430:
2431: else
2432: dbms_sql.close_cursor(c);
2433: exit;
2434: end if;
2435: end loop;
2436: exception

Line 2438: dbms_sql.close_cursor(c);

2434: end if;
2435: end loop;
2436: exception
2437: when others then
2438: dbms_sql.close_cursor(c);
2439: if print_local_sql then
2440: ad_ddl.error_buf := 'c_statement='||c_statement||': '||
2441: ad_ddl.error_buf;
2442: end if;