APPS.FA_RX_SHARED_PKG dependencies on DBMS_SQL

Line 832: v_cursorid := dbms_sql.open_cursor;

828: v_sqlstmt := v_sqlstmt || ' where ' || ccid_col_name || ' = ';
829: v_sqlstmt := v_sqlstmt || to_char(ccid);*/
830: v_sqlstmt := v_sqlstmt || ' where ' || ccid_col_name || ' =:x ';
831:
832: v_cursorid := dbms_sql.open_cursor;
833: dbms_sql.parse(v_cursorid, v_sqlstmt, DBMS_SQL.V7);
834: --Added code for bug 9351332
835: dbms_sql.bind_variable(v_cursorid,':x', to_char(ccid));
836:

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

829: v_sqlstmt := v_sqlstmt || to_char(ccid);*/
830: v_sqlstmt := v_sqlstmt || ' where ' || ccid_col_name || ' =:x ';
831:
832: v_cursorid := dbms_sql.open_cursor;
833: dbms_sql.parse(v_cursorid, v_sqlstmt, DBMS_SQL.V7);
834: --Added code for bug 9351332
835: dbms_sql.bind_variable(v_cursorid,':x', to_char(ccid));
836:
837: for seg_ctr in 1 .. num_segs loop

Line 835: dbms_sql.bind_variable(v_cursorid,':x', to_char(ccid));

831:
832: v_cursorid := dbms_sql.open_cursor;
833: dbms_sql.parse(v_cursorid, v_sqlstmt, DBMS_SQL.V7);
834: --Added code for bug 9351332
835: dbms_sql.bind_variable(v_cursorid,':x', to_char(ccid));
836:
837: for seg_ctr in 1 .. num_segs loop
838:
839: dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 30);

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

835: dbms_sql.bind_variable(v_cursorid,':x', to_char(ccid));
836:
837: for seg_ctr in 1 .. num_segs loop
838:
839: dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 30);
840:
841: end loop;
842:
843: v_return := dbms_sql.execute(v_cursorid);

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

839: dbms_sql.define_column(v_cursorid, seg_ctr, segarray(seg_ctr), 30);
840:
841: end loop;
842:
843: v_return := dbms_sql.execute(v_cursorid);
844: v_return := dbms_sql.fetch_rows(v_cursorid);
845:
846: for seg_ctr in 1 .. num_segs loop
847: dbms_sql.column_value(v_cursorid, seg_ctr, segarray(seg_ctr));

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

840:
841: end loop;
842:
843: v_return := dbms_sql.execute(v_cursorid);
844: v_return := dbms_sql.fetch_rows(v_cursorid);
845:
846: for seg_ctr in 1 .. num_segs loop
847: dbms_sql.column_value(v_cursorid, seg_ctr, segarray(seg_ctr));
848:

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

843: v_return := dbms_sql.execute(v_cursorid);
844: v_return := dbms_sql.fetch_rows(v_cursorid);
845:
846: for seg_ctr in 1 .. num_segs loop
847: dbms_sql.column_value(v_cursorid, seg_ctr, segarray(seg_ctr));
848:
849: end loop;
850:
851: for seg_ctr in 1 .. num_segs loop

Line 858: dbms_sql.close_cursor(v_cursorid);

854: end loop;
855:
856: concat_string := rtrim(concat_string,delim);
857:
858: dbms_sql.close_cursor(v_cursorid);
859:
860: exception
861: when others then
862: