eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_DATA_SECURITY dependencies on DBMS_SQL

Line 1542: l_cursor := dbms_sql.open_cursor;

1538: c_log_head || l_api_name || '.create_dy_sql',
1539: 'dynamic_sql:'||dynamic_sql);
1540: end if;
1541:
1542: l_cursor := dbms_sql.open_cursor;
1543: dbms_sql.parse(l_cursor, dynamic_sql, dbms_sql.native);
1544:
1545: if l_bind_pk1 then
1546: dbms_sql.bind_variable(

Line 1543: dbms_sql.parse(l_cursor, dynamic_sql, dbms_sql.native);

1539: 'dynamic_sql:'||dynamic_sql);
1540: end if;
1541:
1542: l_cursor := dbms_sql.open_cursor;
1543: dbms_sql.parse(l_cursor, dynamic_sql, dbms_sql.native);
1544:
1545: if l_bind_pk1 then
1546: dbms_sql.bind_variable(
1547: l_cursor, 'pk1_val', l_instance_pk1_value);

Line 1546: dbms_sql.bind_variable(

1542: l_cursor := dbms_sql.open_cursor;
1543: dbms_sql.parse(l_cursor, dynamic_sql, dbms_sql.native);
1544:
1545: if l_bind_pk1 then
1546: dbms_sql.bind_variable(
1547: l_cursor, 'pk1_val', l_instance_pk1_value);
1548: if (fnd_log.LEVEL_STATEMENT >=
1549: fnd_log.g_current_runtime_level) then
1550: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1557: dbms_sql.bind_variable(

1553: end if;
1554: end if;
1555:
1556: if l_bind_pk2 then
1557: dbms_sql.bind_variable(
1558: l_cursor, 'pk2_val', l_instance_pk2_value);
1559: if (fnd_log.LEVEL_STATEMENT >=
1560: fnd_log.g_current_runtime_level) then
1561: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1568: dbms_sql.bind_variable(

1564: end if;
1565: end if;
1566:
1567: if l_bind_pk3 then
1568: dbms_sql.bind_variable(
1569: l_cursor, 'pk3_val', l_instance_pk3_value);
1570: if (fnd_log.LEVEL_STATEMENT >=
1571: fnd_log.g_current_runtime_level) then
1572: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1579: dbms_sql.bind_variable(

1575: end if;
1576: end if;
1577:
1578: if l_bind_pk4 then
1579: dbms_sql.bind_variable(
1580: l_cursor, 'pk4_val', l_instance_pk4_value);
1581: if (fnd_log.LEVEL_STATEMENT >=
1582: fnd_log.g_current_runtime_level) then
1583: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1590: dbms_sql.bind_variable(

1586: end if;
1587: end if;
1588:
1589: if l_bind_pk5 then
1590: dbms_sql.bind_variable(
1591: l_cursor, 'pk5_val', l_instance_pk5_value);
1592: if (fnd_log.LEVEL_STATEMENT >=
1593: fnd_log.g_current_runtime_level) then
1594: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1608: dbms_sql.bind_variable(

1604: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1605: c_log_head || l_api_name || '.fnidbind',
1606: ' l_function_id:'||l_function_id);
1607: end if;
1608: dbms_sql.bind_variable(
1609: l_cursor, 'FUNCTION_ID_BIND',l_function_id);
1610: end if;
1611:
1612: if(l_object_id is not NULL) then

Line 1619: dbms_sql.bind_variable(

1615: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1616: c_log_head || l_api_name || '.objidbind',
1617: ' l_object_id:'||l_object_id);
1618: end if;
1619: dbms_sql.bind_variable(
1620: l_cursor, 'OBJECT_ID_BIND',l_object_id);
1621: end if;
1622:
1623: dbms_sql.define_column(l_cursor, 1, dummy_item_id);

Line 1623: dbms_sql.define_column(l_cursor, 1, dummy_item_id);

1619: dbms_sql.bind_variable(
1620: l_cursor, 'OBJECT_ID_BIND',l_object_id);
1621: end if;
1622:
1623: dbms_sql.define_column(l_cursor, 1, dummy_item_id);
1624: l_rows_processed := dbms_sql.execute(l_cursor);
1625:
1626: IF( dbms_sql.fetch_rows(l_cursor) > 0 ) THEN
1627: dbms_sql.close_cursor(l_cursor); -- close cursor

Line 1624: l_rows_processed := dbms_sql.execute(l_cursor);

1620: l_cursor, 'OBJECT_ID_BIND',l_object_id);
1621: end if;
1622:
1623: dbms_sql.define_column(l_cursor, 1, dummy_item_id);
1624: l_rows_processed := dbms_sql.execute(l_cursor);
1625:
1626: IF( dbms_sql.fetch_rows(l_cursor) > 0 ) THEN
1627: dbms_sql.close_cursor(l_cursor); -- close cursor
1628: if (fnd_log.LEVEL_PROCEDURE >=

Line 1626: IF( dbms_sql.fetch_rows(l_cursor) > 0 ) THEN

1622:
1623: dbms_sql.define_column(l_cursor, 1, dummy_item_id);
1624: l_rows_processed := dbms_sql.execute(l_cursor);
1625:
1626: IF( dbms_sql.fetch_rows(l_cursor) > 0 ) THEN
1627: dbms_sql.close_cursor(l_cursor); -- close cursor
1628: if (fnd_log.LEVEL_PROCEDURE >=
1629: fnd_log.g_current_runtime_level) then
1630: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

Line 1627: dbms_sql.close_cursor(l_cursor); -- close cursor

1623: dbms_sql.define_column(l_cursor, 1, dummy_item_id);
1624: l_rows_processed := dbms_sql.execute(l_cursor);
1625:
1626: IF( dbms_sql.fetch_rows(l_cursor) > 0 ) THEN
1627: dbms_sql.close_cursor(l_cursor); -- close cursor
1628: if (fnd_log.LEVEL_PROCEDURE >=
1629: fnd_log.g_current_runtime_level) then
1630: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1631: c_log_head || l_api_name || '.end_found',

Line 1636: dbms_sql.close_cursor(l_cursor); -- close cursor

1632: 'T');
1633: end if;
1634: RETURN 'T';
1635: ELSE
1636: dbms_sql.close_cursor(l_cursor); -- close cursor
1637: if (fnd_log.LEVEL_PROCEDURE >=
1638: fnd_log.g_current_runtime_level) then
1639: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1640: c_log_head || l_api_name || '.end_notfnd',