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 1550: l_cursorid := DBMS_SQL.OPEN_CURSOR;

1546:
1547: END IF;
1548:
1549: --process the dynamic sql statement
1550: l_cursorid := DBMS_SQL.OPEN_CURSOR;
1551:
1552: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1553: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1554:

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

1548:
1549: --process the dynamic sql statement
1550: l_cursorid := DBMS_SQL.OPEN_CURSOR;
1551:
1552: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1553: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1554:
1555: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1556:

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

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

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

1551:
1552: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1553: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1554:
1555: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1556:
1557:
1558: IF DBMS_SQL.FETCH_ROWS(l_cursorid) = 0
1559: THEN

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

1554:
1555: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1556:
1557:
1558: IF DBMS_SQL.FETCH_ROWS(l_cursorid) = 0
1559: THEN
1560: X_FOUND := FALSE;
1561: ELSE
1562: X_FOUND := TRUE;

Line 1565: DBMS_SQL.CLOSE_CURSOR(l_cursorid);

1561: ELSE
1562: X_FOUND := TRUE;
1563: END IF;
1564:
1565: DBMS_SQL.CLOSE_CURSOR(l_cursorid);
1566:
1567: end if;
1568: ELSE
1569: --if object not found

Line 1771: l_cursorid := DBMS_SQL.OPEN_CURSOR;

1767:
1768: END IF;
1769:
1770: --process the dynamic sql statement
1771: l_cursorid := DBMS_SQL.OPEN_CURSOR;
1772:
1773: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1774:
1775: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);

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

1769:
1770: --process the dynamic sql statement
1771: l_cursorid := DBMS_SQL.OPEN_CURSOR;
1772:
1773: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1774:
1775: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1776: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1777:

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

1771: l_cursorid := DBMS_SQL.OPEN_CURSOR;
1772:
1773: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1774:
1775: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1776: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1777:
1778:
1779: IF DBMS_SQL.FETCH_ROWS(l_cursorid) = 0

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

1772:
1773: DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);
1774:
1775: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1776: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1777:
1778:
1779: IF DBMS_SQL.FETCH_ROWS(l_cursorid) = 0
1780: THEN

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

1775: DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);
1776: v_dummy := DBMS_SQL.EXECUTE(l_cursorid);
1777:
1778:
1779: IF DBMS_SQL.FETCH_ROWS(l_cursorid) = 0
1780: THEN
1781: X_FOUND := FALSE;
1782: ELSE
1783: X_FOUND := TRUE;

Line 1786: DBMS_SQL.CLOSE_CURSOR(l_cursorid);

1782: ELSE
1783: X_FOUND := TRUE;
1784: END IF;
1785:
1786: DBMS_SQL.CLOSE_CURSOR(l_cursorid);
1787:
1788: ELSE
1789: --if object not found
1790: x_return_status := fnd_api.g_ret_sts_unexp_error;