APPS.OKC_CTC_PVT dependencies on DBMS_SQL

Line 867: v_cursorID := DBMS_SQL.OPEN_CURSOR;

863: END IF;
864:
865: l_sql_stmt := 'SELECT PARTY_ID FROM '|| l_sql_stmt;
866:
867: v_cursorID := DBMS_SQL.OPEN_CURSOR;
868: -- dbms_output.put_line(l_sql_stmt);
869: DBMS_SQL.PARSE(v_cursorID,l_sql_stmt,dbms_sql.native);
870: DBMS_SQL.DEFINE_COLUMN(v_cursorID,1,v_party_id,100);
871: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);

Line 869: DBMS_SQL.PARSE(v_cursorID,l_sql_stmt,dbms_sql.native);

865: l_sql_stmt := 'SELECT PARTY_ID FROM '|| l_sql_stmt;
866:
867: v_cursorID := DBMS_SQL.OPEN_CURSOR;
868: -- dbms_output.put_line(l_sql_stmt);
869: DBMS_SQL.PARSE(v_cursorID,l_sql_stmt,dbms_sql.native);
870: DBMS_SQL.DEFINE_COLUMN(v_cursorID,1,v_party_id,100);
871: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);
872: IF DBMS_SQL.FETCH_ROWS(v_cursorID)= 0 THEN
873: RETURN '-1';

Line 870: DBMS_SQL.DEFINE_COLUMN(v_cursorID,1,v_party_id,100);

866:
867: v_cursorID := DBMS_SQL.OPEN_CURSOR;
868: -- dbms_output.put_line(l_sql_stmt);
869: DBMS_SQL.PARSE(v_cursorID,l_sql_stmt,dbms_sql.native);
870: DBMS_SQL.DEFINE_COLUMN(v_cursorID,1,v_party_id,100);
871: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);
872: IF DBMS_SQL.FETCH_ROWS(v_cursorID)= 0 THEN
873: RETURN '-1';
874: END IF;

Line 871: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);

867: v_cursorID := DBMS_SQL.OPEN_CURSOR;
868: -- dbms_output.put_line(l_sql_stmt);
869: DBMS_SQL.PARSE(v_cursorID,l_sql_stmt,dbms_sql.native);
870: DBMS_SQL.DEFINE_COLUMN(v_cursorID,1,v_party_id,100);
871: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);
872: IF DBMS_SQL.FETCH_ROWS(v_cursorID)= 0 THEN
873: RETURN '-1';
874: END IF;
875: DBMS_SQL.COLUMN_VALUE(v_cursorID,1,v_party_id);

Line 872: IF DBMS_SQL.FETCH_ROWS(v_cursorID)= 0 THEN

868: -- dbms_output.put_line(l_sql_stmt);
869: DBMS_SQL.PARSE(v_cursorID,l_sql_stmt,dbms_sql.native);
870: DBMS_SQL.DEFINE_COLUMN(v_cursorID,1,v_party_id,100);
871: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);
872: IF DBMS_SQL.FETCH_ROWS(v_cursorID)= 0 THEN
873: RETURN '-1';
874: END IF;
875: DBMS_SQL.COLUMN_VALUE(v_cursorID,1,v_party_id);
876: DBMS_SQL.CLOSE_CURSOR(v_cursorID);

Line 875: DBMS_SQL.COLUMN_VALUE(v_cursorID,1,v_party_id);

871: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);
872: IF DBMS_SQL.FETCH_ROWS(v_cursorID)= 0 THEN
873: RETURN '-1';
874: END IF;
875: DBMS_SQL.COLUMN_VALUE(v_cursorID,1,v_party_id);
876: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
877:
878: return v_party_id;
879:

Line 876: DBMS_SQL.CLOSE_CURSOR(v_cursorID);

872: IF DBMS_SQL.FETCH_ROWS(v_cursorID)= 0 THEN
873: RETURN '-1';
874: END IF;
875: DBMS_SQL.COLUMN_VALUE(v_cursorID,1,v_party_id);
876: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
877:
878: return v_party_id;
879:
880: EXCEPTION