APPS.AP_ACCTG_DATA_FIX_PKG dependencies on DBMS_SQL

Line 316: cur INTEGER := DBMS_SQL.OPEN_CURSOR;

312: owner_nm VARCHAR2(100) := USER;
313: table_nm VARCHAR2(100) := UPPER (p_table_in);
314: where_clause VARCHAR2(1000) := LTRIM (UPPER (p_where_in));
315:
316: cur INTEGER := DBMS_SQL.OPEN_CURSOR;
317: fdbk INTEGER := 0;
318:
319: string_value VARCHAR2(2000);
320: number_value NUMBER;

Line 395: DBMS_SQL.PARSE

391: END IF;
392: END IF;
393: --print('stg11');
394:
395: DBMS_SQL.PARSE
396: (cur,
397: 'SELECT ' || col_list ||
398: ' FROM ' || p_table_in || ' ' || where_clause,
399: 1);

Line 406: DBMS_SQL.DEFINE_COLUMN

402: FOR col_ind IN 1 .. col_count
403: LOOP
404: IF (coltype(col_ind) IN ('CHAR', 'VARCHAR2'))
405: THEN
406: DBMS_SQL.DEFINE_COLUMN
407: (cur, col_ind, string_value, collen (col_ind));
408: ELSIF (coltype(col_ind) = 'NUMBER')
409: THEN
410: DBMS_SQL.DEFINE_COLUMN (cur, col_ind, number_value);

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

406: DBMS_SQL.DEFINE_COLUMN
407: (cur, col_ind, string_value, collen (col_ind));
408: ELSIF (coltype(col_ind) = 'NUMBER')
409: THEN
410: DBMS_SQL.DEFINE_COLUMN (cur, col_ind, number_value);
411:
412: ELSIF (coltype(col_ind) = 'DATE')
413: THEN
414: DBMS_SQL.DEFINE_COLUMN (cur, col_ind, date_value);

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

410: DBMS_SQL.DEFINE_COLUMN (cur, col_ind, number_value);
411:
412: ELSIF (coltype(col_ind) = 'DATE')
413: THEN
414: DBMS_SQL.DEFINE_COLUMN (cur, col_ind, date_value);
415: END IF;
416: END LOOP;
417: --print('stg13');
418:

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

415: END IF;
416: END LOOP;
417: --print('stg13');
418:
419: fdbk := DBMS_SQL.EXECUTE (cur);
420: LOOP
421: fdbk := DBMS_SQL.FETCH_ROWS (cur);
422: EXIT WHEN fdbk = 0;
423:

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

417: --print('stg13');
418:
419: fdbk := DBMS_SQL.EXECUTE (cur);
420: LOOP
421: fdbk := DBMS_SQL.FETCH_ROWS (cur);
422: EXIT WHEN fdbk = 0;
423:
424: col_line := NULL;
425: l_message:='';

Line 430: DBMS_SQL.COLUMN_VALUE

426: FOR col_ind IN 1 .. col_count
427: LOOP
428: IF (coltype(col_ind) IN ('CHAR', 'VARCHAR2'))
429: THEN
430: DBMS_SQL.COLUMN_VALUE
431: (cur, col_ind, string_value);
432:
433: ELSIF (coltype(col_ind) = 'NUMBER')
434: THEN

Line 435: DBMS_SQL.COLUMN_VALUE

431: (cur, col_ind, string_value);
432:
433: ELSIF (coltype(col_ind) = 'NUMBER')
434: THEN
435: DBMS_SQL.COLUMN_VALUE
436: (cur, col_ind, number_value);
437: string_value := TO_CHAR (number_value);
438:
439: ELSIF (coltype(col_ind) = 'DATE')

Line 441: DBMS_SQL.COLUMN_VALUE

437: string_value := TO_CHAR (number_value);
438:
439: ELSIF (coltype(col_ind) = 'DATE')
440: THEN
441: DBMS_SQL.COLUMN_VALUE
442: (cur, col_ind, date_value);
443: string_value := date_value;
444: END IF;
445: