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

Line 8: l_header DBMS_SQL.VARCHAR2S;

4: -- Variable declarations
5: --
6: TYPE mt_table IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;
7: l_dummy NUMBER;
8: l_header DBMS_SQL.VARCHAR2S;
9: l_body DBMS_SQL.VARCHAR2S;
10: l_header_line NUMBER:=0;
11: l_body_line NUMBER:=0;
12: l_package_name VARCHAR2(255);

Line 9: l_body DBMS_SQL.VARCHAR2S;

5: --
6: TYPE mt_table IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;
7: l_dummy NUMBER;
8: l_header DBMS_SQL.VARCHAR2S;
9: l_body DBMS_SQL.VARCHAR2S;
10: l_header_line NUMBER:=0;
11: l_body_line NUMBER:=0;
12: l_package_name VARCHAR2(255);
13: l_csr_sql NUMBER;

Line 241: l_csr_sql := dbms_sql.open_cursor;

237: --
238: -- Execute the dynamic code.
239: --
240:
241: l_csr_sql := dbms_sql.open_cursor;
242: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );
243: l_rows := dbms_sql.EXECUTE( l_csr_sql );
244: dbms_sql.close_cursor( l_csr_sql );
245:

Line 242: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );

238: -- Execute the dynamic code.
239: --
240:
241: l_csr_sql := dbms_sql.open_cursor;
242: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );
243: l_rows := dbms_sql.EXECUTE( l_csr_sql );
244: dbms_sql.close_cursor( l_csr_sql );
245:
246: --

Line 243: l_rows := dbms_sql.EXECUTE( l_csr_sql );

239: --
240:
241: l_csr_sql := dbms_sql.open_cursor;
242: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );
243: l_rows := dbms_sql.EXECUTE( l_csr_sql );
244: dbms_sql.close_cursor( l_csr_sql );
245:
246: --
247: -- Reinitialize the variables.

Line 244: dbms_sql.close_cursor( l_csr_sql );

240:
241: l_csr_sql := dbms_sql.open_cursor;
242: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );
243: l_rows := dbms_sql.EXECUTE( l_csr_sql );
244: dbms_sql.close_cursor( l_csr_sql );
245:
246: --
247: -- Reinitialize the variables.
248: --

Line 1587: l_csr_sql := dbms_sql.open_cursor;

1583: add_body_line('');
1584: add_body_line('END '||l_package_name ||';');
1585: add_header_line('END ' ||l_package_name||';');
1586:
1587: l_csr_sql := dbms_sql.open_cursor;
1588: dbms_sql.parse( l_csr_sql, l_header,0,l_header_line-1,FALSE, dbms_sql.v7 );
1589: l_rows := dbms_sql.EXECUTE( l_csr_sql );
1590: dbms_sql.close_cursor( l_csr_sql );
1591:

Line 1588: dbms_sql.parse( l_csr_sql, l_header,0,l_header_line-1,FALSE, dbms_sql.v7 );

1584: add_body_line('END '||l_package_name ||';');
1585: add_header_line('END ' ||l_package_name||';');
1586:
1587: l_csr_sql := dbms_sql.open_cursor;
1588: dbms_sql.parse( l_csr_sql, l_header,0,l_header_line-1,FALSE, dbms_sql.v7 );
1589: l_rows := dbms_sql.EXECUTE( l_csr_sql );
1590: dbms_sql.close_cursor( l_csr_sql );
1591:
1592: l_csr_sql := dbms_sql.open_cursor;

Line 1589: l_rows := dbms_sql.EXECUTE( l_csr_sql );

1585: add_header_line('END ' ||l_package_name||';');
1586:
1587: l_csr_sql := dbms_sql.open_cursor;
1588: dbms_sql.parse( l_csr_sql, l_header,0,l_header_line-1,FALSE, dbms_sql.v7 );
1589: l_rows := dbms_sql.EXECUTE( l_csr_sql );
1590: dbms_sql.close_cursor( l_csr_sql );
1591:
1592: l_csr_sql := dbms_sql.open_cursor;
1593: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );

Line 1590: dbms_sql.close_cursor( l_csr_sql );

1586:
1587: l_csr_sql := dbms_sql.open_cursor;
1588: dbms_sql.parse( l_csr_sql, l_header,0,l_header_line-1,FALSE, dbms_sql.v7 );
1589: l_rows := dbms_sql.EXECUTE( l_csr_sql );
1590: dbms_sql.close_cursor( l_csr_sql );
1591:
1592: l_csr_sql := dbms_sql.open_cursor;
1593: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );
1594: l_rows := dbms_sql.EXECUTE( l_csr_sql );

Line 1592: l_csr_sql := dbms_sql.open_cursor;

1588: dbms_sql.parse( l_csr_sql, l_header,0,l_header_line-1,FALSE, dbms_sql.v7 );
1589: l_rows := dbms_sql.EXECUTE( l_csr_sql );
1590: dbms_sql.close_cursor( l_csr_sql );
1591:
1592: l_csr_sql := dbms_sql.open_cursor;
1593: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );
1594: l_rows := dbms_sql.EXECUTE( l_csr_sql );
1595: dbms_sql.close_cursor( l_csr_sql );
1596:

Line 1593: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );

1589: l_rows := dbms_sql.EXECUTE( l_csr_sql );
1590: dbms_sql.close_cursor( l_csr_sql );
1591:
1592: l_csr_sql := dbms_sql.open_cursor;
1593: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );
1594: l_rows := dbms_sql.EXECUTE( l_csr_sql );
1595: dbms_sql.close_cursor( l_csr_sql );
1596:
1597: l_header_line :=0;

Line 1594: l_rows := dbms_sql.EXECUTE( l_csr_sql );

1590: dbms_sql.close_cursor( l_csr_sql );
1591:
1592: l_csr_sql := dbms_sql.open_cursor;
1593: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );
1594: l_rows := dbms_sql.EXECUTE( l_csr_sql );
1595: dbms_sql.close_cursor( l_csr_sql );
1596:
1597: l_header_line :=0;
1598: l_body_line :=0;

Line 1595: dbms_sql.close_cursor( l_csr_sql );

1591:
1592: l_csr_sql := dbms_sql.open_cursor;
1593: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );
1594: l_rows := dbms_sql.EXECUTE( l_csr_sql );
1595: dbms_sql.close_cursor( l_csr_sql );
1596:
1597: l_header_line :=0;
1598: l_body_line :=0;
1599:

Line 1698: add_body_line(' l_body DBMS_SQL.VARCHAR2S;');

1694: add_body_line('--');
1695: add_body_line('-- Variable declarations');
1696: add_body_line('--');
1697: add_body_line(' l_body_line NUMBER:=0;');
1698: add_body_line(' l_body DBMS_SQL.VARCHAR2S;');
1699: add_body_line(' l_csr_sql NUMBER;');
1700: add_body_line(' l_rows NUMBER;');
1701: add_body_line('');
1702: add_body_line('-----------------------------------------------------------------------');

Line 3273: l_csr_sql := dbms_sql.open_cursor;

3269: add_body_line('');
3270: add_body_line('END '||l_package_name ||';');
3271: add_header_line('END ' ||l_package_name||';');
3272:
3273: l_csr_sql := dbms_sql.open_cursor;
3274: dbms_sql.parse( l_csr_sql, l_header,0,l_header_line-1,FALSE, dbms_sql.v7 );
3275: l_rows := dbms_sql.EXECUTE( l_csr_sql );
3276: dbms_sql.close_cursor( l_csr_sql );
3277:

Line 3274: dbms_sql.parse( l_csr_sql, l_header,0,l_header_line-1,FALSE, dbms_sql.v7 );

3270: add_body_line('END '||l_package_name ||';');
3271: add_header_line('END ' ||l_package_name||';');
3272:
3273: l_csr_sql := dbms_sql.open_cursor;
3274: dbms_sql.parse( l_csr_sql, l_header,0,l_header_line-1,FALSE, dbms_sql.v7 );
3275: l_rows := dbms_sql.EXECUTE( l_csr_sql );
3276: dbms_sql.close_cursor( l_csr_sql );
3277:
3278: l_csr_sql := dbms_sql.open_cursor;

Line 3275: l_rows := dbms_sql.EXECUTE( l_csr_sql );

3271: add_header_line('END ' ||l_package_name||';');
3272:
3273: l_csr_sql := dbms_sql.open_cursor;
3274: dbms_sql.parse( l_csr_sql, l_header,0,l_header_line-1,FALSE, dbms_sql.v7 );
3275: l_rows := dbms_sql.EXECUTE( l_csr_sql );
3276: dbms_sql.close_cursor( l_csr_sql );
3277:
3278: l_csr_sql := dbms_sql.open_cursor;
3279: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );

Line 3276: dbms_sql.close_cursor( l_csr_sql );

3272:
3273: l_csr_sql := dbms_sql.open_cursor;
3274: dbms_sql.parse( l_csr_sql, l_header,0,l_header_line-1,FALSE, dbms_sql.v7 );
3275: l_rows := dbms_sql.EXECUTE( l_csr_sql );
3276: dbms_sql.close_cursor( l_csr_sql );
3277:
3278: l_csr_sql := dbms_sql.open_cursor;
3279: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );
3280: l_rows := dbms_sql.EXECUTE( l_csr_sql );

Line 3278: l_csr_sql := dbms_sql.open_cursor;

3274: dbms_sql.parse( l_csr_sql, l_header,0,l_header_line-1,FALSE, dbms_sql.v7 );
3275: l_rows := dbms_sql.EXECUTE( l_csr_sql );
3276: dbms_sql.close_cursor( l_csr_sql );
3277:
3278: l_csr_sql := dbms_sql.open_cursor;
3279: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );
3280: l_rows := dbms_sql.EXECUTE( l_csr_sql );
3281: dbms_sql.close_cursor( l_csr_sql );
3282:

Line 3279: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );

3275: l_rows := dbms_sql.EXECUTE( l_csr_sql );
3276: dbms_sql.close_cursor( l_csr_sql );
3277:
3278: l_csr_sql := dbms_sql.open_cursor;
3279: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );
3280: l_rows := dbms_sql.EXECUTE( l_csr_sql );
3281: dbms_sql.close_cursor( l_csr_sql );
3282:
3283: EXCEPTION

Line 3280: l_rows := dbms_sql.EXECUTE( l_csr_sql );

3276: dbms_sql.close_cursor( l_csr_sql );
3277:
3278: l_csr_sql := dbms_sql.open_cursor;
3279: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );
3280: l_rows := dbms_sql.EXECUTE( l_csr_sql );
3281: dbms_sql.close_cursor( l_csr_sql );
3282:
3283: EXCEPTION
3284: WHEN OTHERS THEN

Line 3281: dbms_sql.close_cursor( l_csr_sql );

3277:
3278: l_csr_sql := dbms_sql.open_cursor;
3279: dbms_sql.parse( l_csr_sql, l_body,0,l_body_line-1,FALSE, dbms_sql.v7 );
3280: l_rows := dbms_sql.EXECUTE( l_csr_sql );
3281: dbms_sql.close_cursor( l_csr_sql );
3282:
3283: EXCEPTION
3284: WHEN OTHERS THEN
3285: fnd_file.put_line(fnd_file.output,'Error occured in installation of HR Multi tenancy '|| sqlerrm);