APPS.AD_MORG dependencies on DBMS_SQL

Line 1705: c := dbms_sql.open_cursor;

1701: ') order by 1';
1702:
1703: debugln(statement, MSG_LEVEL_SQL, 1);
1704:
1705: c := dbms_sql.open_cursor;
1706: dbms_sql.parse(c, statement, dbms_sql.native);
1707: dbms_sql.define_column(c, 1, pk_value, 600);
1708: row_processed := dbms_sql.execute(c);
1709:

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

1702:
1703: debugln(statement, MSG_LEVEL_SQL, 1);
1704:
1705: c := dbms_sql.open_cursor;
1706: dbms_sql.parse(c, statement, dbms_sql.native);
1707: dbms_sql.define_column(c, 1, pk_value, 600);
1708: row_processed := dbms_sql.execute(c);
1709:
1710: l_count := 0;

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

1703: debugln(statement, MSG_LEVEL_SQL, 1);
1704:
1705: c := dbms_sql.open_cursor;
1706: dbms_sql.parse(c, statement, dbms_sql.native);
1707: dbms_sql.define_column(c, 1, pk_value, 600);
1708: row_processed := dbms_sql.execute(c);
1709:
1710: l_count := 0;
1711:

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

1704:
1705: c := dbms_sql.open_cursor;
1706: dbms_sql.parse(c, statement, dbms_sql.native);
1707: dbms_sql.define_column(c, 1, pk_value, 600);
1708: row_processed := dbms_sql.execute(c);
1709:
1710: l_count := 0;
1711:
1712: loop

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

1709:
1710: l_count := 0;
1711:
1712: loop
1713: if dbms_sql.fetch_rows(c) > 0 then
1714: if (l_count = 0) then
1715: debug('There are seed data row(s) missing from the table. '||
1716: 'The primary key values for these rows are as follows ',
1717: MSG_LEVEL_DATA, 1);

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

1719: MSG_LEVEL_DATA, 2);
1720: debugln(rpad('-', length(pk_list_simple), '-'),
1721: MSG_LEVEL_DATA, 2);
1722: end if;
1723: dbms_sql.column_value(c, 1, pk_value);
1724: l_count := l_count + 1;
1725: if (pk_value is null) then
1726: debug('Primary key is null', MSG_LEVEL_DATA, 2);
1727: else

Line 1731: dbms_sql.close_cursor(c);

1727: else
1728: debug(pk_value, MSG_LEVEL_DATA, 2);
1729: end if;
1730: else
1731: dbms_sql.close_cursor(c);
1732: exit;
1733: end if;
1734: end loop;
1735: