APPS.AD_MORG dependencies on DBMS_SQL

Line 1747: c := dbms_sql.open_cursor;

1743: ') order by 1';
1744:
1745: debugln(statement, MSG_LEVEL_SQL, 1);
1746:
1747: c := dbms_sql.open_cursor;
1748: dbms_sql.parse(c, statement, dbms_sql.native);
1749: dbms_sql.define_column(c, 1, pk_value, 600);
1750: row_processed := dbms_sql.execute(c);
1751:

Line 1748: dbms_sql.parse(c, statement, dbms_sql.native);

1744:
1745: debugln(statement, MSG_LEVEL_SQL, 1);
1746:
1747: c := dbms_sql.open_cursor;
1748: dbms_sql.parse(c, statement, dbms_sql.native);
1749: dbms_sql.define_column(c, 1, pk_value, 600);
1750: row_processed := dbms_sql.execute(c);
1751:
1752: l_count := 0;

Line 1749: dbms_sql.define_column(c, 1, pk_value, 600);

1745: debugln(statement, MSG_LEVEL_SQL, 1);
1746:
1747: c := dbms_sql.open_cursor;
1748: dbms_sql.parse(c, statement, dbms_sql.native);
1749: dbms_sql.define_column(c, 1, pk_value, 600);
1750: row_processed := dbms_sql.execute(c);
1751:
1752: l_count := 0;
1753:

Line 1750: row_processed := dbms_sql.execute(c);

1746:
1747: c := dbms_sql.open_cursor;
1748: dbms_sql.parse(c, statement, dbms_sql.native);
1749: dbms_sql.define_column(c, 1, pk_value, 600);
1750: row_processed := dbms_sql.execute(c);
1751:
1752: l_count := 0;
1753:
1754: loop

Line 1755: if dbms_sql.fetch_rows(c) > 0 then

1751:
1752: l_count := 0;
1753:
1754: loop
1755: if dbms_sql.fetch_rows(c) > 0 then
1756: if (l_count = 0) then
1757: debug('There are seed data row(s) missing from the table. '||
1758: 'The primary key values for these rows are as follows ',
1759: MSG_LEVEL_DATA, 1);

Line 1765: dbms_sql.column_value(c, 1, pk_value);

1761: MSG_LEVEL_DATA, 2);
1762: debugln(rpad('-', length(pk_list_simple), '-'),
1763: MSG_LEVEL_DATA, 2);
1764: end if;
1765: dbms_sql.column_value(c, 1, pk_value);
1766: l_count := l_count + 1;
1767: if (pk_value is null) then
1768: debug('Primary key is null', MSG_LEVEL_DATA, 2);
1769: else

Line 1773: dbms_sql.close_cursor(c);

1769: else
1770: debug(pk_value, MSG_LEVEL_DATA, 2);
1771: end if;
1772: else
1773: dbms_sql.close_cursor(c);
1774: exit;
1775: end if;
1776: end loop;
1777: