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

Line 781: cursor_id := DBMS_SQL.open_cursor;

777:
778: cep_standard.debug('created tmp_query = '|| tmp_query);
779: cep_standard.debug('open_cursor');
780:
781: cursor_id := DBMS_SQL.open_cursor;
782: cep_standard.debug('Cursor opened sucessfully with cursor_id: '||
783: to_char(cursor_id));
784:
785: cep_standard.debug('parse sql');

Line 786: --DBMS_SQL.Parse(cursor_id, tmp_query, DBMS_SQL.native);

782: cep_standard.debug('Cursor opened sucessfully with cursor_id: '||
783: to_char(cursor_id));
784:
785: cep_standard.debug('parse sql');
786: --DBMS_SQL.Parse(cursor_id, tmp_query, DBMS_SQL.native);
787: DBMS_SQL.Parse(cursor_id, tmp_query, DBMS_SQL.v7);
788:
789: cep_standard.debug('define column');
790: DBMS_SQL.Define_Column(cursor_id, 1, count_pay_eft1);

Line 787: DBMS_SQL.Parse(cursor_id, tmp_query, DBMS_SQL.v7);

783: to_char(cursor_id));
784:
785: cep_standard.debug('parse sql');
786: --DBMS_SQL.Parse(cursor_id, tmp_query, DBMS_SQL.native);
787: DBMS_SQL.Parse(cursor_id, tmp_query, DBMS_SQL.v7);
788:
789: cep_standard.debug('define column');
790: DBMS_SQL.Define_Column(cursor_id, 1, count_pay_eft1);
791:

Line 790: DBMS_SQL.Define_Column(cursor_id, 1, count_pay_eft1);

786: --DBMS_SQL.Parse(cursor_id, tmp_query, DBMS_SQL.native);
787: DBMS_SQL.Parse(cursor_id, tmp_query, DBMS_SQL.v7);
788:
789: cep_standard.debug('define column');
790: DBMS_SQL.Define_Column(cursor_id, 1, count_pay_eft1);
791:
792: cep_standard.debug('execute cursor');
793: exec_id := dbms_sql.execute(cursor_id);
794:

Line 793: exec_id := dbms_sql.execute(cursor_id);

789: cep_standard.debug('define column');
790: DBMS_SQL.Define_Column(cursor_id, 1, count_pay_eft1);
791:
792: cep_standard.debug('execute cursor');
793: exec_id := dbms_sql.execute(cursor_id);
794:
795: cep_standard.debug('column_value');
796:
797: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN

Line 797: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN

793: exec_id := dbms_sql.execute(cursor_id);
794:
795: cep_standard.debug('column_value');
796:
797: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
798: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, count_pay_eft1);
799: END IF;
800:
801: cep_standard.debug('count_pay_eft1 = '|| count_pay_eft1);

Line 798: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, count_pay_eft1);

794:
795: cep_standard.debug('column_value');
796:
797: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
798: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, count_pay_eft1);
799: END IF;
800:
801: cep_standard.debug('count_pay_eft1 = '|| count_pay_eft1);
802: cep_standard.debug('<

Line 809: IF DBMS_SQL.IS_OPEN(cursor_id) THEN

805:
806: EXCEPTION
807: WHEN OTHERS THEN
808: cep_standard.debug('EXCEPTION - OTHERS: CE_AUTO_BANK_CLEAR.trx_remain' );
809: IF DBMS_SQL.IS_OPEN(cursor_id) THEN
810: DBMS_SQL.CLOSE_CURSOR(cursor_id);
811: cep_standard.debug('Cursor Closed');
812: END IF;
813: RAISE;

Line 810: DBMS_SQL.CLOSE_CURSOR(cursor_id);

806: EXCEPTION
807: WHEN OTHERS THEN
808: cep_standard.debug('EXCEPTION - OTHERS: CE_AUTO_BANK_CLEAR.trx_remain' );
809: IF DBMS_SQL.IS_OPEN(cursor_id) THEN
810: DBMS_SQL.CLOSE_CURSOR(cursor_id);
811: cep_standard.debug('Cursor Closed');
812: END IF;
813: RAISE;
814: END trx_remain;