APPS.FA_RECLASS_UTIL_PVT dependencies on DBMS_SQL

Line 1086: v_cursorid := dbms_sql.open_cursor;

1082: v_sqlstmt := v_sqlstmt || ' from ' || h_table_name;
1083: v_sqlstmt := v_sqlstmt || ' where ' || h_ccid_col_name || ' = ';
1084: v_sqlstmt := v_sqlstmt || to_char(px_asset_cat_rec_new.category_id);
1085:
1086: v_cursorid := dbms_sql.open_cursor;
1087: dbms_sql.parse(v_cursorid, v_sqlstmt, DBMS_SQL.V7);
1088:
1089: for seg_ctr in 1 .. num_segs loop
1090:

Line 1087: dbms_sql.parse(v_cursorid, v_sqlstmt, DBMS_SQL.V7);

1083: v_sqlstmt := v_sqlstmt || ' where ' || h_ccid_col_name || ' = ';
1084: v_sqlstmt := v_sqlstmt || to_char(px_asset_cat_rec_new.category_id);
1085:
1086: v_cursorid := dbms_sql.open_cursor;
1087: dbms_sql.parse(v_cursorid, v_sqlstmt, DBMS_SQL.V7);
1088:
1089: for seg_ctr in 1 .. num_segs loop
1090:
1091: --bugfix 3128860 msiddiqu

Line 1092: --dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 25);

1088:
1089: for seg_ctr in 1 .. num_segs loop
1090:
1091: --bugfix 3128860 msiddiqu
1092: --dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 25);
1093: dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 30);
1094:
1095: end loop;
1096:

Line 1093: dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 30);

1089: for seg_ctr in 1 .. num_segs loop
1090:
1091: --bugfix 3128860 msiddiqu
1092: --dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 25);
1093: dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 30);
1094:
1095: end loop;
1096:
1097: v_return := dbms_sql.execute(v_cursorid);

Line 1097: v_return := dbms_sql.execute(v_cursorid);

1093: dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 30);
1094:
1095: end loop;
1096:
1097: v_return := dbms_sql.execute(v_cursorid);
1098: v_return := dbms_sql.fetch_rows(v_cursorid);
1099:
1100: for seg_ctr in 1 .. num_segs loop
1101: dbms_sql.column_value(v_cursorid, seg_ctr, segarray(seg_ctr));

Line 1098: v_return := dbms_sql.fetch_rows(v_cursorid);

1094:
1095: end loop;
1096:
1097: v_return := dbms_sql.execute(v_cursorid);
1098: v_return := dbms_sql.fetch_rows(v_cursorid);
1099:
1100: for seg_ctr in 1 .. num_segs loop
1101: dbms_sql.column_value(v_cursorid, seg_ctr, segarray(seg_ctr));
1102:

Line 1101: dbms_sql.column_value(v_cursorid, seg_ctr, segarray(seg_ctr));

1097: v_return := dbms_sql.execute(v_cursorid);
1098: v_return := dbms_sql.fetch_rows(v_cursorid);
1099:
1100: for seg_ctr in 1 .. num_segs loop
1101: dbms_sql.column_value(v_cursorid, seg_ctr, segarray(seg_ctr));
1102:
1103: end loop;
1104:
1105: for seg_ctr in 1 .. num_segs loop

Line 1112: dbms_sql.close_cursor(v_cursorid);

1108: end loop;
1109:
1110: concat_string := rtrim(concat_string,delim);
1111:
1112: dbms_sql.close_cursor(v_cursorid);
1113:
1114: -- End replacing fa_rx_shared_pkg. This is what we finally need.
1115: l_concat_cat := concat_string;
1116: