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

Line 544: curs := DBMS_SQL.OPEN_CURSOR;

540: FROM az_contexts_sql
541: WHERE context = ctx_type
542: AND purpose = 'GET_NAME';
543:
544: curs := DBMS_SQL.OPEN_CURSOR;
545: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
546:
547: DBMS_SQL.DEFINE_COLUMN(curs, 1, v_ctxt_name, 80);
548: DBMS_SQL.BIND_VARIABLE(curs, ':ctx_id', ctx_id);

Line 545: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);

541: WHERE context = ctx_type
542: AND purpose = 'GET_NAME';
543:
544: curs := DBMS_SQL.OPEN_CURSOR;
545: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
546:
547: DBMS_SQL.DEFINE_COLUMN(curs, 1, v_ctxt_name, 80);
548: DBMS_SQL.BIND_VARIABLE(curs, ':ctx_id', ctx_id);
549:

Line 547: DBMS_SQL.DEFINE_COLUMN(curs, 1, v_ctxt_name, 80);

543:
544: curs := DBMS_SQL.OPEN_CURSOR;
545: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
546:
547: DBMS_SQL.DEFINE_COLUMN(curs, 1, v_ctxt_name, 80);
548: DBMS_SQL.BIND_VARIABLE(curs, ':ctx_id', ctx_id);
549:
550: rows := DBMS_SQL.EXECUTE(curs);
551: rows := DBMS_SQL.FETCH_ROWS(curs);

Line 548: DBMS_SQL.BIND_VARIABLE(curs, ':ctx_id', ctx_id);

544: curs := DBMS_SQL.OPEN_CURSOR;
545: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
546:
547: DBMS_SQL.DEFINE_COLUMN(curs, 1, v_ctxt_name, 80);
548: DBMS_SQL.BIND_VARIABLE(curs, ':ctx_id', ctx_id);
549:
550: rows := DBMS_SQL.EXECUTE(curs);
551: rows := DBMS_SQL.FETCH_ROWS(curs);
552:

Line 550: rows := DBMS_SQL.EXECUTE(curs);

546:
547: DBMS_SQL.DEFINE_COLUMN(curs, 1, v_ctxt_name, 80);
548: DBMS_SQL.BIND_VARIABLE(curs, ':ctx_id', ctx_id);
549:
550: rows := DBMS_SQL.EXECUTE(curs);
551: rows := DBMS_SQL.FETCH_ROWS(curs);
552:
553: DBMS_SQL.COLUMN_VALUE(curs, 1, v_ctxt_name);
554: DBMS_SQL.CLOSE_CURSOR(curs);

Line 551: rows := DBMS_SQL.FETCH_ROWS(curs);

547: DBMS_SQL.DEFINE_COLUMN(curs, 1, v_ctxt_name, 80);
548: DBMS_SQL.BIND_VARIABLE(curs, ':ctx_id', ctx_id);
549:
550: rows := DBMS_SQL.EXECUTE(curs);
551: rows := DBMS_SQL.FETCH_ROWS(curs);
552:
553: DBMS_SQL.COLUMN_VALUE(curs, 1, v_ctxt_name);
554: DBMS_SQL.CLOSE_CURSOR(curs);
555:

Line 553: DBMS_SQL.COLUMN_VALUE(curs, 1, v_ctxt_name);

549:
550: rows := DBMS_SQL.EXECUTE(curs);
551: rows := DBMS_SQL.FETCH_ROWS(curs);
552:
553: DBMS_SQL.COLUMN_VALUE(curs, 1, v_ctxt_name);
554: DBMS_SQL.CLOSE_CURSOR(curs);
555:
556: RETURN v_ctxt_name;
557:

Line 554: DBMS_SQL.CLOSE_CURSOR(curs);

550: rows := DBMS_SQL.EXECUTE(curs);
551: rows := DBMS_SQL.FETCH_ROWS(curs);
552:
553: DBMS_SQL.COLUMN_VALUE(curs, 1, v_ctxt_name);
554: DBMS_SQL.CLOSE_CURSOR(curs);
555:
556: RETURN v_ctxt_name;
557:
558: EXCEPTION

Line 560: IF DBMS_SQL.IS_OPEN(curs) then

556: RETURN v_ctxt_name;
557:
558: EXCEPTION
559: WHEN OTHERS THEN
560: IF DBMS_SQL.IS_OPEN(curs) then
561: DBMS_SQL.CLOSE_CURSOR(curs);
562: END IF;
563:
564: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

Line 561: DBMS_SQL.CLOSE_CURSOR(curs);

557:
558: EXCEPTION
559: WHEN OTHERS THEN
560: IF DBMS_SQL.IS_OPEN(curs) then
561: DBMS_SQL.CLOSE_CURSOR(curs);
562: END IF;
563:
564: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
565: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 986: curs := DBMS_SQL.OPEN_CURSOR;

982: FROM az_contexts_sql
983: WHERE context = ctx_type
984: AND purpose = 'POPULATE';
985:
986: curs := DBMS_SQL.OPEN_CURSOR;
987: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
988:
989: DBMS_SQL.DEFINE_COLUMN(curs, 1, t1);
990: DBMS_SQL.DEFINE_COLUMN(curs, 2, t2, 40);

Line 987: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);

983: WHERE context = ctx_type
984: AND purpose = 'POPULATE';
985:
986: curs := DBMS_SQL.OPEN_CURSOR;
987: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
988:
989: DBMS_SQL.DEFINE_COLUMN(curs, 1, t1);
990: DBMS_SQL.DEFINE_COLUMN(curs, 2, t2, 40);
991:

Line 989: DBMS_SQL.DEFINE_COLUMN(curs, 1, t1);

985:
986: curs := DBMS_SQL.OPEN_CURSOR;
987: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
988:
989: DBMS_SQL.DEFINE_COLUMN(curs, 1, t1);
990: DBMS_SQL.DEFINE_COLUMN(curs, 2, t2, 40);
991:
992: rows := DBMS_SQL.EXECUTE(curs);
993:

Line 990: DBMS_SQL.DEFINE_COLUMN(curs, 2, t2, 40);

986: curs := DBMS_SQL.OPEN_CURSOR;
987: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
988:
989: DBMS_SQL.DEFINE_COLUMN(curs, 1, t1);
990: DBMS_SQL.DEFINE_COLUMN(curs, 2, t2, 40);
991:
992: rows := DBMS_SQL.EXECUTE(curs);
993:
994: LOOP

Line 992: rows := DBMS_SQL.EXECUTE(curs);

988:
989: DBMS_SQL.DEFINE_COLUMN(curs, 1, t1);
990: DBMS_SQL.DEFINE_COLUMN(curs, 2, t2, 40);
991:
992: rows := DBMS_SQL.EXECUTE(curs);
993:
994: LOOP
995: IF DBMS_SQL.FETCH_ROWS(curs) > 0 THEN
996:

Line 995: IF DBMS_SQL.FETCH_ROWS(curs) > 0 THEN

991:
992: rows := DBMS_SQL.EXECUTE(curs);
993:
994: LOOP
995: IF DBMS_SQL.FETCH_ROWS(curs) > 0 THEN
996:
997: DBMS_SQL.COLUMN_VALUE(curs, 1, t1);
998: DBMS_SQL.COLUMN_VALUE(curs, 2, t2);
999:

Line 997: DBMS_SQL.COLUMN_VALUE(curs, 1, t1);

993:
994: LOOP
995: IF DBMS_SQL.FETCH_ROWS(curs) > 0 THEN
996:
997: DBMS_SQL.COLUMN_VALUE(curs, 1, t1);
998: DBMS_SQL.COLUMN_VALUE(curs, 2, t2);
999:
1000: IF (t1 IS NOT NULL) THEN
1001: i := i + 1;

Line 998: DBMS_SQL.COLUMN_VALUE(curs, 2, t2);

994: LOOP
995: IF DBMS_SQL.FETCH_ROWS(curs) > 0 THEN
996:
997: DBMS_SQL.COLUMN_VALUE(curs, 1, t1);
998: DBMS_SQL.COLUMN_VALUE(curs, 2, t2);
999:
1000: IF (t1 IS NOT NULL) THEN
1001: i := i + 1;
1002: ctx_table(i).context_id := t1;

Line 1012: DBMS_SQL.CLOSE_CURSOR(curs);

1008:
1009: END IF;
1010: END LOOP;
1011:
1012: DBMS_SQL.CLOSE_CURSOR(curs);
1013:
1014:
1015: EXCEPTION
1016: WHEN OTHERS THEN

Line 1018: if DBMS_SQL.IS_OPEN(curs) then

1014:
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017:
1018: if DBMS_SQL.IS_OPEN(curs) then
1019: DBMS_SQL.CLOSE_CURSOR(curs);
1020: end if;
1021:
1022: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

Line 1019: DBMS_SQL.CLOSE_CURSOR(curs);

1015: EXCEPTION
1016: WHEN OTHERS THEN
1017:
1018: if DBMS_SQL.IS_OPEN(curs) then
1019: DBMS_SQL.CLOSE_CURSOR(curs);
1020: end if;
1021:
1022: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1023: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 1284: curs := DBMS_SQL.OPEN_CURSOR;

1280: FROM az_contexts_sql
1281: WHERE context = ctx_type
1282: AND purpose = 'DELETE';
1283:
1284: curs := DBMS_SQL.OPEN_CURSOR;
1285: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
1286: DBMS_SQL.BIND_VARIABLE(curs, ':ctx_type', ctx_type);
1287:
1288: rows := DBMS_SQL.EXECUTE(curs);

Line 1285: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);

1281: WHERE context = ctx_type
1282: AND purpose = 'DELETE';
1283:
1284: curs := DBMS_SQL.OPEN_CURSOR;
1285: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
1286: DBMS_SQL.BIND_VARIABLE(curs, ':ctx_type', ctx_type);
1287:
1288: rows := DBMS_SQL.EXECUTE(curs);
1289:

Line 1286: DBMS_SQL.BIND_VARIABLE(curs, ':ctx_type', ctx_type);

1282: AND purpose = 'DELETE';
1283:
1284: curs := DBMS_SQL.OPEN_CURSOR;
1285: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
1286: DBMS_SQL.BIND_VARIABLE(curs, ':ctx_type', ctx_type);
1287:
1288: rows := DBMS_SQL.EXECUTE(curs);
1289:
1290: DBMS_SQL.CLOSE_CURSOR(curs);

Line 1288: rows := DBMS_SQL.EXECUTE(curs);

1284: curs := DBMS_SQL.OPEN_CURSOR;
1285: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
1286: DBMS_SQL.BIND_VARIABLE(curs, ':ctx_type', ctx_type);
1287:
1288: rows := DBMS_SQL.EXECUTE(curs);
1289:
1290: DBMS_SQL.CLOSE_CURSOR(curs);
1291:
1292: EXCEPTION

Line 1290: DBMS_SQL.CLOSE_CURSOR(curs);

1286: DBMS_SQL.BIND_VARIABLE(curs, ':ctx_type', ctx_type);
1287:
1288: rows := DBMS_SQL.EXECUTE(curs);
1289:
1290: DBMS_SQL.CLOSE_CURSOR(curs);
1291:
1292: EXCEPTION
1293: WHEN OTHERS THEN
1294: IF DBMS_SQL.IS_OPEN(curs) then

Line 1294: IF DBMS_SQL.IS_OPEN(curs) then

1290: DBMS_SQL.CLOSE_CURSOR(curs);
1291:
1292: EXCEPTION
1293: WHEN OTHERS THEN
1294: IF DBMS_SQL.IS_OPEN(curs) then
1295: DBMS_SQL.CLOSE_CURSOR(curs);
1296: END IF;
1297:
1298: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

Line 1295: DBMS_SQL.CLOSE_CURSOR(curs);

1291:
1292: EXCEPTION
1293: WHEN OTHERS THEN
1294: IF DBMS_SQL.IS_OPEN(curs) then
1295: DBMS_SQL.CLOSE_CURSOR(curs);
1296: END IF;
1297:
1298: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1299: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);