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.JTF_RESOURCE_UTL dependencies on DBMS_SQL

Line 89: v_cursorid := dbms_sql.open_cursor ;

85: BEGIN
86: x_return_status := fnd_api.g_ret_sts_success;
87:
88: FOR i IN c1 LOOP
89: v_cursorid := dbms_sql.open_cursor ;
90: /* BINDVAR_SCAN_IGNORE [1] */
91: v_blockstr := ' begin '||i.hook_PACKAGE || '.' ||i.hook_api||'(:1); end; ' ;
92: dbms_sql.parse( v_cursorid , v_blockstr , dbms_sql.v7 ) ;
93: dbms_sql.bind_variable( v_cursorid , ':1' , x_return_status , 20 );

Line 92: dbms_sql.parse( v_cursorid , v_blockstr , dbms_sql.v7 ) ;

88: FOR i IN c1 LOOP
89: v_cursorid := dbms_sql.open_cursor ;
90: /* BINDVAR_SCAN_IGNORE [1] */
91: v_blockstr := ' begin '||i.hook_PACKAGE || '.' ||i.hook_api||'(:1); end; ' ;
92: dbms_sql.parse( v_cursorid , v_blockstr , dbms_sql.v7 ) ;
93: dbms_sql.bind_variable( v_cursorid , ':1' , x_return_status , 20 );
94: v_dummy := dbms_sql.execute(v_cursorid);
95: dbms_sql.variable_value( v_cursorid , ':1' , x_return_status );
96: dbms_sql.close_cursor(v_cursorid);

Line 93: dbms_sql.bind_variable( v_cursorid , ':1' , x_return_status , 20 );

89: v_cursorid := dbms_sql.open_cursor ;
90: /* BINDVAR_SCAN_IGNORE [1] */
91: v_blockstr := ' begin '||i.hook_PACKAGE || '.' ||i.hook_api||'(:1); end; ' ;
92: dbms_sql.parse( v_cursorid , v_blockstr , dbms_sql.v7 ) ;
93: dbms_sql.bind_variable( v_cursorid , ':1' , x_return_status , 20 );
94: v_dummy := dbms_sql.execute(v_cursorid);
95: dbms_sql.variable_value( v_cursorid , ':1' , x_return_status );
96: dbms_sql.close_cursor(v_cursorid);
97:

Line 94: v_dummy := dbms_sql.execute(v_cursorid);

90: /* BINDVAR_SCAN_IGNORE [1] */
91: v_blockstr := ' begin '||i.hook_PACKAGE || '.' ||i.hook_api||'(:1); end; ' ;
92: dbms_sql.parse( v_cursorid , v_blockstr , dbms_sql.v7 ) ;
93: dbms_sql.bind_variable( v_cursorid , ':1' , x_return_status , 20 );
94: v_dummy := dbms_sql.execute(v_cursorid);
95: dbms_sql.variable_value( v_cursorid , ':1' , x_return_status );
96: dbms_sql.close_cursor(v_cursorid);
97:
98: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

Line 95: dbms_sql.variable_value( v_cursorid , ':1' , x_return_status );

91: v_blockstr := ' begin '||i.hook_PACKAGE || '.' ||i.hook_api||'(:1); end; ' ;
92: dbms_sql.parse( v_cursorid , v_blockstr , dbms_sql.v7 ) ;
93: dbms_sql.bind_variable( v_cursorid , ':1' , x_return_status , 20 );
94: v_dummy := dbms_sql.execute(v_cursorid);
95: dbms_sql.variable_value( v_cursorid , ':1' , x_return_status );
96: dbms_sql.close_cursor(v_cursorid);
97:
98: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
99: THEN

Line 96: dbms_sql.close_cursor(v_cursorid);

92: dbms_sql.parse( v_cursorid , v_blockstr , dbms_sql.v7 ) ;
93: dbms_sql.bind_variable( v_cursorid , ':1' , x_return_status , 20 );
94: v_dummy := dbms_sql.execute(v_cursorid);
95: dbms_sql.variable_value( v_cursorid , ':1' , x_return_status );
96: dbms_sql.close_cursor(v_cursorid);
97:
98: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
99: THEN
100: fnd_message.set_name ('JTF', 'JTF_RS_MISSING_RETURN_STATUS');

Line 1554: l_cursorid := DBMS_SQL.OPEN_CURSOR;

1550:
1551: END IF;
1552:
1553: --process the dynamic sql statement
1554: l_cursorid := DBMS_SQL.OPEN_CURSOR;
1555:
1556: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1557: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1558:

Line 1556: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);

1552:
1553: --process the dynamic sql statement
1554: l_cursorid := DBMS_SQL.OPEN_CURSOR;
1555:
1556: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1557: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1558:
1559: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1560:

Line 1557: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);

1553: --process the dynamic sql statement
1554: l_cursorid := DBMS_SQL.OPEN_CURSOR;
1555:
1556: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1557: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1558:
1559: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1560:
1561:

Line 1559: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);

1555:
1556: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1557: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1558:
1559: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1560:
1561:
1562: IF DBMS_SQL.FETCH_ROWS(l_cursorid) = 0
1563: THEN

Line 1562: IF DBMS_SQL.FETCH_ROWS(l_cursorid) = 0

1558:
1559: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1560:
1561:
1562: IF DBMS_SQL.FETCH_ROWS(l_cursorid) = 0
1563: THEN
1564: X_FOUND := FALSE;
1565: ELSE
1566: X_FOUND := TRUE;

Line 1569: DBMS_SQL.CLOSE_CURSOR(l_cursorid);

1565: ELSE
1566: X_FOUND := TRUE;
1567: END IF;
1568:
1569: DBMS_SQL.CLOSE_CURSOR(l_cursorid);
1570:
1571: end if;
1572: ELSE
1573: --if object not found

Line 1775: l_cursorid := DBMS_SQL.OPEN_CURSOR;

1771:
1772: END IF;
1773:
1774: --process the dynamic sql statement
1775: l_cursorid := DBMS_SQL.OPEN_CURSOR;
1776:
1777: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1778:
1779: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);

Line 1777: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);

1773:
1774: --process the dynamic sql statement
1775: l_cursorid := DBMS_SQL.OPEN_CURSOR;
1776:
1777: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1778:
1779: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1780: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1781:

Line 1779: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);

1775: l_cursorid := DBMS_SQL.OPEN_CURSOR;
1776:
1777: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1778:
1779: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1780: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1781:
1782:
1783: IF DBMS_SQL.FETCH_ROWS(l_cursorid) = 0

Line 1780: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);

1776:
1777: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1778:
1779: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1780: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1781:
1782:
1783: IF DBMS_SQL.FETCH_ROWS(l_cursorid) = 0
1784: THEN

Line 1783: IF DBMS_SQL.FETCH_ROWS(l_cursorid) = 0

1779: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1780: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1781:
1782:
1783: IF DBMS_SQL.FETCH_ROWS(l_cursorid) = 0
1784: THEN
1785: X_FOUND := FALSE;
1786: ELSE
1787: X_FOUND := TRUE;

Line 1790: DBMS_SQL.CLOSE_CURSOR(l_cursorid);

1786: ELSE
1787: X_FOUND := TRUE;
1788: END IF;
1789:
1790: DBMS_SQL.CLOSE_CURSOR(l_cursorid);
1791:
1792: ELSE
1793: --if object not found
1794: x_return_status := fnd_api.g_ret_sts_unexp_error;