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 681: l_denorm_csr := DBMS_SQL.open_cursor;

677: END LOOP;
678:
679: FND_DSQL.add_text(')');
680:
681: l_denorm_csr := DBMS_SQL.open_cursor;
682: FND_DSQL.set_cursor(l_denorm_csr);
683: l_stmt_debug := FND_DSQL.get_text(TRUE);
684: l_stmt_denorm := FND_DSQL.get_text(FALSE);
685: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

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

681: l_denorm_csr := DBMS_SQL.open_cursor;
682: FND_DSQL.set_cursor(l_denorm_csr);
683: l_stmt_debug := FND_DSQL.get_text(TRUE);
684: l_stmt_denorm := FND_DSQL.get_text(FALSE);
685: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
686: FND_DSQL.do_binds;
687: l_ignore := DBMS_SQL.execute(l_denorm_csr);
688: dbms_sql.close_cursor(l_denorm_csr);
689: --

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

683: l_stmt_debug := FND_DSQL.get_text(TRUE);
684: l_stmt_denorm := FND_DSQL.get_text(FALSE);
685: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
686: FND_DSQL.do_binds;
687: l_ignore := DBMS_SQL.execute(l_denorm_csr);
688: dbms_sql.close_cursor(l_denorm_csr);
689: --
690: END LOOP;
691:

Line 688: dbms_sql.close_cursor(l_denorm_csr);

684: l_stmt_denorm := FND_DSQL.get_text(FALSE);
685: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
686: FND_DSQL.do_binds;
687: l_ignore := DBMS_SQL.execute(l_denorm_csr);
688: dbms_sql.close_cursor(l_denorm_csr);
689: --
690: END LOOP;
691:
692: EXCEPTION

Line 824: l_denorm_csr := DBMS_SQL.open_cursor;

820: END IF;
821:
822: FND_DSQL.add_text(')');
823:
824: l_denorm_csr := DBMS_SQL.open_cursor;
825: FND_DSQL.set_cursor(l_denorm_csr);
826: l_stmt_debug := FND_DSQL.get_text(TRUE);
827: l_stmt_denorm := FND_DSQL.get_text(FALSE);
828: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

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

824: l_denorm_csr := DBMS_SQL.open_cursor;
825: FND_DSQL.set_cursor(l_denorm_csr);
826: l_stmt_debug := FND_DSQL.get_text(TRUE);
827: l_stmt_denorm := FND_DSQL.get_text(FALSE);
828: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
829: FND_DSQL.do_binds;
830: l_ignore := DBMS_SQL.execute(l_denorm_csr);
831: dbms_sql.close_cursor(l_denorm_csr);
832:

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

826: l_stmt_debug := FND_DSQL.get_text(TRUE);
827: l_stmt_denorm := FND_DSQL.get_text(FALSE);
828: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
829: FND_DSQL.do_binds;
830: l_ignore := DBMS_SQL.execute(l_denorm_csr);
831: dbms_sql.close_cursor(l_denorm_csr);
832:
833:
834:

Line 831: dbms_sql.close_cursor(l_denorm_csr);

827: l_stmt_denorm := FND_DSQL.get_text(FALSE);
828: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
829: FND_DSQL.do_binds;
830: l_ignore := DBMS_SQL.execute(l_denorm_csr);
831: dbms_sql.close_cursor(l_denorm_csr);
832:
833:
834:
835: --