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 1543: l_cursor := dbms_sql.open_cursor;

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

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

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

Line 1547: dbms_sql.bind_variable(

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

Line 1558: dbms_sql.bind_variable(

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

Line 1569: dbms_sql.bind_variable(

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

Line 1580: dbms_sql.bind_variable(

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

Line 1591: dbms_sql.bind_variable(

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

Line 1609: dbms_sql.bind_variable(

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

Line 1620: dbms_sql.bind_variable(

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

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

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

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

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

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

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

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

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

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

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