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

Line 466: l_denorm_csr := DBMS_SQL.open_cursor;

462: FND_DSQL.add_text(' and qualifier_context not in (''MODLIST'') ');
463: FND_DSQL.add_text(' and qualifier_attribute < ''A'' ');
464: FND_DSQL.add_text(')');
465:
466: l_denorm_csr := DBMS_SQL.open_cursor;
467: FND_DSQL.set_cursor(l_denorm_csr);
468: l_stmt_debug := FND_DSQL.get_text(TRUE);
469: l_stmt_denorm := FND_DSQL.get_text(FALSE);
470: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

Line 470: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

466: l_denorm_csr := DBMS_SQL.open_cursor;
467: FND_DSQL.set_cursor(l_denorm_csr);
468: l_stmt_debug := FND_DSQL.get_text(TRUE);
469: l_stmt_denorm := FND_DSQL.get_text(FALSE);
470: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
471: FND_DSQL.do_binds;
472: l_ignore := DBMS_SQL.execute(l_denorm_csr);
473: dbms_sql.close_cursor(l_denorm_csr);
474: --

Line 472: l_ignore := DBMS_SQL.execute(l_denorm_csr);

468: l_stmt_debug := FND_DSQL.get_text(TRUE);
469: l_stmt_denorm := FND_DSQL.get_text(FALSE);
470: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
471: FND_DSQL.do_binds;
472: l_ignore := DBMS_SQL.execute(l_denorm_csr);
473: dbms_sql.close_cursor(l_denorm_csr);
474: --
475: END IF;
476:

Line 473: dbms_sql.close_cursor(l_denorm_csr);

469: l_stmt_denorm := FND_DSQL.get_text(FALSE);
470: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
471: FND_DSQL.do_binds;
472: l_ignore := DBMS_SQL.execute(l_denorm_csr);
473: dbms_sql.close_cursor(l_denorm_csr);
474: --
475: END IF;
476:
477: EXCEPTION

Line 700: l_denorm_csr := DBMS_SQL.open_cursor;

696: END LOOP;
697:
698: FND_DSQL.add_text(')');
699:
700: l_denorm_csr := DBMS_SQL.open_cursor;
701: FND_DSQL.set_cursor(l_denorm_csr);
702: l_stmt_debug := FND_DSQL.get_text(TRUE);
703: l_stmt_denorm := FND_DSQL.get_text(FALSE);
704: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

Line 704: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

700: l_denorm_csr := DBMS_SQL.open_cursor;
701: FND_DSQL.set_cursor(l_denorm_csr);
702: l_stmt_debug := FND_DSQL.get_text(TRUE);
703: l_stmt_denorm := FND_DSQL.get_text(FALSE);
704: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
705: FND_DSQL.do_binds;
706: l_ignore := DBMS_SQL.execute(l_denorm_csr);
707: dbms_sql.close_cursor(l_denorm_csr);
708: --

Line 706: l_ignore := DBMS_SQL.execute(l_denorm_csr);

702: l_stmt_debug := FND_DSQL.get_text(TRUE);
703: l_stmt_denorm := FND_DSQL.get_text(FALSE);
704: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
705: FND_DSQL.do_binds;
706: l_ignore := DBMS_SQL.execute(l_denorm_csr);
707: dbms_sql.close_cursor(l_denorm_csr);
708: --
709: END LOOP;
710:

Line 707: dbms_sql.close_cursor(l_denorm_csr);

703: l_stmt_denorm := FND_DSQL.get_text(FALSE);
704: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
705: FND_DSQL.do_binds;
706: l_ignore := DBMS_SQL.execute(l_denorm_csr);
707: dbms_sql.close_cursor(l_denorm_csr);
708: --
709: END LOOP;
710:
711: EXCEPTION

Line 919: l_denorm_csr := DBMS_SQL.open_cursor;

915: --amitamku - End of - Added for Bug fix 13510229
916:
917: FND_DSQL.add_text(')');
918:
919: l_denorm_csr := DBMS_SQL.open_cursor;
920: FND_DSQL.set_cursor(l_denorm_csr);
921: l_stmt_debug := FND_DSQL.get_text(TRUE);
922: l_stmt_denorm := FND_DSQL.get_text(FALSE);
923: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

Line 923: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

919: l_denorm_csr := DBMS_SQL.open_cursor;
920: FND_DSQL.set_cursor(l_denorm_csr);
921: l_stmt_debug := FND_DSQL.get_text(TRUE);
922: l_stmt_denorm := FND_DSQL.get_text(FALSE);
923: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
924: FND_DSQL.do_binds;
925: l_ignore := DBMS_SQL.execute(l_denorm_csr);
926: dbms_sql.close_cursor(l_denorm_csr);
927:

Line 925: l_ignore := DBMS_SQL.execute(l_denorm_csr);

921: l_stmt_debug := FND_DSQL.get_text(TRUE);
922: l_stmt_denorm := FND_DSQL.get_text(FALSE);
923: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
924: FND_DSQL.do_binds;
925: l_ignore := DBMS_SQL.execute(l_denorm_csr);
926: dbms_sql.close_cursor(l_denorm_csr);
927:
928:
929:

Line 926: dbms_sql.close_cursor(l_denorm_csr);

922: l_stmt_denorm := FND_DSQL.get_text(FALSE);
923: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
924: FND_DSQL.do_binds;
925: l_ignore := DBMS_SQL.execute(l_denorm_csr);
926: dbms_sql.close_cursor(l_denorm_csr);
927:
928:
929:
930: --