APPS.FND_ADG_OBJECT dependencies on DBMS_SQL

Line 1092: l_stmt dbms_sql.varchar2a;

1088:
1089: l_compile_status number := -2;
1090: l_err_msg varchar2(2048);
1091:
1092: l_stmt dbms_sql.varchar2a;
1093: l_clob_len number;
1094: l_no_chunks number;
1095:
1096: l_csr integer;

Line 1142: l_csr := dbms_sql.open_cursor;

1138: sys.dbms_output.put_line(l_stmt(i));
1139: end loop;
1140: */
1141:
1142: l_csr := dbms_sql.open_cursor;
1143:
1144: begin
1145:
1146: dbms_sql.parse(l_csr,l_stmt,1,l_stmt.count,false,1);

Line 1146: dbms_sql.parse(l_csr,l_stmt,1,l_stmt.count,false,1);

1142: l_csr := dbms_sql.open_cursor;
1143:
1144: begin
1145:
1146: dbms_sql.parse(l_csr,l_stmt,1,l_stmt.count,false,1);
1147:
1148: l_compile_status := 0;
1149:
1150: exception

Line 1156: if ( dbms_sql.is_open(l_csr) )

1152: l_compile_status := 1;
1153:
1154: when others then
1155:
1156: if ( dbms_sql.is_open(l_csr) )
1157: then
1158: dbms_sql.close_cursor(l_csr);
1159: end if;
1160:

Line 1158: dbms_sql.close_cursor(l_csr);

1154: when others then
1155:
1156: if ( dbms_sql.is_open(l_csr) )
1157: then
1158: dbms_sql.close_cursor(l_csr);
1159: end if;
1160:
1161: raise;
1162: end;

Line 1164: if ( dbms_sql.is_open(l_csr) )

1160:
1161: raise;
1162: end;
1163:
1164: if ( dbms_sql.is_open(l_csr) )
1165: then
1166: dbms_sql.close_cursor(l_csr);
1167: end if;
1168:

Line 1166: dbms_sql.close_cursor(l_csr);

1162: end;
1163:
1164: if ( dbms_sql.is_open(l_csr) )
1165: then
1166: dbms_sql.close_cursor(l_csr);
1167: end if;
1168:
1169: /* dbms_sql.parse with varchar2a doesn't raise -24344 ! */
1170:

Line 1169: /* dbms_sql.parse with varchar2a doesn't raise -24344 ! */

1165: then
1166: dbms_sql.close_cursor(l_csr);
1167: end if;
1168:
1169: /* dbms_sql.parse with varchar2a doesn't raise -24344 ! */
1170:
1171: if ( p_package_name = C_COMPILE_DIRECTIVE_PACKAGE )
1172: then
1173: select count(*)