APPS.AP_ACCTG_DATA_FIX_PKG dependencies on DBMS_SQL

Line 393: cur INTEGER := DBMS_SQL.OPEN_CURSOR;

389: owner_nm VARCHAR2(100) := USER;
390: table_nm VARCHAR2(100) := UPPER (p_table_in);
391: where_clause VARCHAR2(1000) := LTRIM (UPPER (p_where_in));
392:
393: cur INTEGER := DBMS_SQL.OPEN_CURSOR;
394: fdbk INTEGER := 0;
395:
396: string_value VARCHAR2(2000);
397: number_value NUMBER;

Line 463: DBMS_SQL.PARSE

459: 'WHERE ' || LTRIM (where_clause, 'WHERE');
460: END IF;
461: END IF;
462:
463: DBMS_SQL.PARSE
464: (cur,
465: 'SELECT ' || col_list ||
466: ' FROM ' || p_table_in || ' ' || where_clause,
467: 1);

Line 473: DBMS_SQL.DEFINE_COLUMN

469: FOR col_ind IN 1 .. col_count
470: LOOP
471: IF (coltype(col_ind) IN ('CHAR', 'VARCHAR2'))
472: THEN
473: DBMS_SQL.DEFINE_COLUMN
474: (cur, col_ind, string_value, collen (col_ind));
475: ELSIF (coltype(col_ind) = 'NUMBER')
476: THEN
477: DBMS_SQL.DEFINE_COLUMN (cur, col_ind, number_value);

Line 477: DBMS_SQL.DEFINE_COLUMN (cur, col_ind, number_value);

473: DBMS_SQL.DEFINE_COLUMN
474: (cur, col_ind, string_value, collen (col_ind));
475: ELSIF (coltype(col_ind) = 'NUMBER')
476: THEN
477: DBMS_SQL.DEFINE_COLUMN (cur, col_ind, number_value);
478:
479: ELSIF (coltype(col_ind) = 'DATE')
480: THEN
481: DBMS_SQL.DEFINE_COLUMN (cur, col_ind, date_value);

Line 481: DBMS_SQL.DEFINE_COLUMN (cur, col_ind, date_value);

477: DBMS_SQL.DEFINE_COLUMN (cur, col_ind, number_value);
478:
479: ELSIF (coltype(col_ind) = 'DATE')
480: THEN
481: DBMS_SQL.DEFINE_COLUMN (cur, col_ind, date_value);
482: END IF;
483: END LOOP;
484:
485: fdbk := DBMS_SQL.EXECUTE (cur);

Line 485: fdbk := DBMS_SQL.EXECUTE (cur);

481: DBMS_SQL.DEFINE_COLUMN (cur, col_ind, date_value);
482: END IF;
483: END LOOP;
484:
485: fdbk := DBMS_SQL.EXECUTE (cur);
486: LOOP
487: fdbk := DBMS_SQL.FETCH_ROWS (cur);
488: EXIT WHEN fdbk = 0;
489:

Line 487: fdbk := DBMS_SQL.FETCH_ROWS (cur);

483: END LOOP;
484:
485: fdbk := DBMS_SQL.EXECUTE (cur);
486: LOOP
487: fdbk := DBMS_SQL.FETCH_ROWS (cur);
488: EXIT WHEN fdbk = 0;
489:
490: col_line := NULL;
491: l_message:='';

Line 497: DBMS_SQL.COLUMN_VALUE

493: LOOP
494: IF (coltype(col_ind) IN ('CHAR', 'VARCHAR2'))
495: THEN
496:
497: DBMS_SQL.COLUMN_VALUE
498: (cur, col_ind, string_value);
499:
500: ELSIF (coltype(col_ind) = 'NUMBER')
501: THEN

Line 503: DBMS_SQL.COLUMN_VALUE

499:
500: ELSIF (coltype(col_ind) = 'NUMBER')
501: THEN
502:
503: DBMS_SQL.COLUMN_VALUE
504: (cur, col_ind, number_value);
505: string_value := TO_CHAR (number_value);
506:
507: ELSIF (coltype(col_ind) = 'DATE')

Line 510: DBMS_SQL.COLUMN_VALUE

506:
507: ELSIF (coltype(col_ind) = 'DATE')
508: THEN
509:
510: DBMS_SQL.COLUMN_VALUE
511: (cur, col_ind, date_value);
512: string_value := date_value;
513: END IF;
514: