APPS.FA_RECLASS_UTIL_PVT dependencies on DBMS_SQL

Line 1056: v_cursorid := dbms_sql.open_cursor;

1052: v_sqlstmt := v_sqlstmt || ' from ' || h_table_name;
1053: v_sqlstmt := v_sqlstmt || ' where ' || h_ccid_col_name || ' = ';
1054: v_sqlstmt := v_sqlstmt || to_char(px_asset_cat_rec_new.category_id);
1055:
1056: v_cursorid := dbms_sql.open_cursor;
1057: dbms_sql.parse(v_cursorid, v_sqlstmt, DBMS_SQL.V7);
1058:
1059: for seg_ctr in 1 .. num_segs loop
1060:

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

1053: v_sqlstmt := v_sqlstmt || ' where ' || h_ccid_col_name || ' = ';
1054: v_sqlstmt := v_sqlstmt || to_char(px_asset_cat_rec_new.category_id);
1055:
1056: v_cursorid := dbms_sql.open_cursor;
1057: dbms_sql.parse(v_cursorid, v_sqlstmt, DBMS_SQL.V7);
1058:
1059: for seg_ctr in 1 .. num_segs loop
1060:
1061: --bugfix 3128860 msiddiqu

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

1058:
1059: for seg_ctr in 1 .. num_segs loop
1060:
1061: --bugfix 3128860 msiddiqu
1062: --dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 25);
1063: dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 30);
1064:
1065: end loop;
1066:

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

1059: for seg_ctr in 1 .. num_segs loop
1060:
1061: --bugfix 3128860 msiddiqu
1062: --dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 25);
1063: dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 30);
1064:
1065: end loop;
1066:
1067: v_return := dbms_sql.execute(v_cursorid);

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

1063: dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 30);
1064:
1065: end loop;
1066:
1067: v_return := dbms_sql.execute(v_cursorid);
1068: v_return := dbms_sql.fetch_rows(v_cursorid);
1069:
1070: for seg_ctr in 1 .. num_segs loop
1071: dbms_sql.column_value(v_cursorid, seg_ctr, segarray(seg_ctr));

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

1064:
1065: end loop;
1066:
1067: v_return := dbms_sql.execute(v_cursorid);
1068: v_return := dbms_sql.fetch_rows(v_cursorid);
1069:
1070: for seg_ctr in 1 .. num_segs loop
1071: dbms_sql.column_value(v_cursorid, seg_ctr, segarray(seg_ctr));
1072:

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

1067: v_return := dbms_sql.execute(v_cursorid);
1068: v_return := dbms_sql.fetch_rows(v_cursorid);
1069:
1070: for seg_ctr in 1 .. num_segs loop
1071: dbms_sql.column_value(v_cursorid, seg_ctr, segarray(seg_ctr));
1072:
1073: end loop;
1074:
1075: for seg_ctr in 1 .. num_segs loop

Line 1082: dbms_sql.close_cursor(v_cursorid);

1078: end loop;
1079:
1080: concat_string := rtrim(concat_string,delim);
1081:
1082: dbms_sql.close_cursor(v_cursorid);
1083:
1084: -- End replacing fa_rx_shared_pkg. This is what we finally need.
1085: l_concat_cat := concat_string;
1086: