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.XNP_MSG_DIAGNOSTICS$XNP_MSGS dependencies on DBMS_SQL

Line 571: I_CURSOR := dbms_sql.open_cursor;

567:
568: I_QUERY := 'SELECT count(*)' ||
569: substr(ZONE_SQL, I_FROM_POS);
570:
571: I_CURSOR := dbms_sql.open_cursor;
572: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
573: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
574: I_VOID := dbms_sql.execute(I_CURSOR);
575: I_VOID := dbms_sql.fetch_rows(I_CURSOR);

Line 572: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);

568: I_QUERY := 'SELECT count(*)' ||
569: substr(ZONE_SQL, I_FROM_POS);
570:
571: I_CURSOR := dbms_sql.open_cursor;
572: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
573: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
574: I_VOID := dbms_sql.execute(I_CURSOR);
575: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
576: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);

Line 573: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);

569: substr(ZONE_SQL, I_FROM_POS);
570:
571: I_CURSOR := dbms_sql.open_cursor;
572: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
573: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
574: I_VOID := dbms_sql.execute(I_CURSOR);
575: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
576: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
577: dbms_sql.close_cursor(I_CURSOR);

Line 574: I_VOID := dbms_sql.execute(I_CURSOR);

570:
571: I_CURSOR := dbms_sql.open_cursor;
572: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
573: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
574: I_VOID := dbms_sql.execute(I_CURSOR);
575: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
576: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
577: dbms_sql.close_cursor(I_CURSOR);
578:

Line 575: I_VOID := dbms_sql.fetch_rows(I_CURSOR);

571: I_CURSOR := dbms_sql.open_cursor;
572: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
573: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
574: I_VOID := dbms_sql.execute(I_CURSOR);
575: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
576: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
577: dbms_sql.close_cursor(I_CURSOR);
578:
579: return I_COUNT;

Line 576: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);

572: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
573: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
574: I_VOID := dbms_sql.execute(I_CURSOR);
575: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
576: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
577: dbms_sql.close_cursor(I_CURSOR);
578:
579: return I_COUNT;
580:

Line 577: dbms_sql.close_cursor(I_CURSOR);

573: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
574: I_VOID := dbms_sql.execute(I_CURSOR);
575: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
576: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
577: dbms_sql.close_cursor(I_CURSOR);
578:
579: return I_COUNT;
580:
581: exception

Line 1406: I_CURSOR := dbms_sql.open_cursor;

1402: InitialiseDomain('MSG_STATUS');
1403: InitialiseDomain('DIRECTION_INDICATOR');
1404:
1405:
1406: I_CURSOR := dbms_sql.open_cursor;
1407: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1408: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);
1409: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1410: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);

Line 1407: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);

1403: InitialiseDomain('DIRECTION_INDICATOR');
1404:
1405:
1406: I_CURSOR := dbms_sql.open_cursor;
1407: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1408: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);
1409: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1410: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1411: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);

Line 1408: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);

1404:
1405:
1406: I_CURSOR := dbms_sql.open_cursor;
1407: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1408: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);
1409: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1410: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1411: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1412: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);

Line 1409: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);

1405:
1406: I_CURSOR := dbms_sql.open_cursor;
1407: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1408: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);
1409: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1410: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1411: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1412: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1413: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);

Line 1410: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);

1406: I_CURSOR := dbms_sql.open_cursor;
1407: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1408: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);
1409: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1410: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1411: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1412: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1413: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1414: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);

Line 1411: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);

1407: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1408: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);
1409: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1410: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1411: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1412: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1413: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1414: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1415: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);

Line 1412: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);

1408: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);
1409: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1410: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1411: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1412: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1413: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1414: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1415: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1416: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);

Line 1413: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);

1409: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1410: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1411: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1412: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1413: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1414: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1415: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1416: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1417: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);

Line 1414: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);

1410: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1411: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1412: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1413: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1414: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1415: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1416: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1417: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1418: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);

Line 1415: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);

1411: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1412: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1413: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1414: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1415: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1416: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1417: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1418: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1419: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);

Line 1416: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);

1412: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1413: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1414: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1415: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1416: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1417: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1418: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1419: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);
1420: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763

Line 1417: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);

1413: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1414: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1415: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1416: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1417: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1418: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1419: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);
1420: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763
1421: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);

Line 1418: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);

1414: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1415: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1416: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1417: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1418: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1419: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);
1420: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763
1421: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);
1422: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);

Line 1419: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);

1415: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1416: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1417: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1418: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1419: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);
1420: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763
1421: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);
1422: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);
1423:

Line 1420: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763

1416: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1417: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1418: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1419: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);
1420: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763
1421: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);
1422: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);
1423:
1424: I_VOID := dbms_sql.execute(I_CURSOR);

Line 1421: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);

1417: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1418: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1419: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);
1420: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763
1421: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);
1422: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);
1423:
1424: I_VOID := dbms_sql.execute(I_CURSOR);
1425: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 1422: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);

1418: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1419: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);
1420: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763
1421: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);
1422: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);
1423:
1424: I_VOID := dbms_sql.execute(I_CURSOR);
1425: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1426: else

Line 1424: I_VOID := dbms_sql.execute(I_CURSOR);

1420: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763
1421: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);
1422: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);
1423:
1424: I_VOID := dbms_sql.execute(I_CURSOR);
1425: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1426: else
1427: I_ROWS_FETCHED := 0;
1428: end if;

Line 1425: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

1421: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);
1422: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);
1423:
1424: I_VOID := dbms_sql.execute(I_CURSOR);
1425: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1426: else
1427: I_ROWS_FETCHED := 0;
1428: end if;
1429: I_TOTAL_ROWS := I_ROWS_FETCHED;

Line 1457: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.MSG_ID);

1453:
1454: while I_ROWS_FETCHED <> 0 loop
1455:
1456: if I_TOTAL_ROWS >= I_START then
1457: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.MSG_ID);
1458: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);
1459: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1460: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1461: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);

Line 1458: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);

1454: while I_ROWS_FETCHED <> 0 loop
1455:
1456: if I_TOTAL_ROWS >= I_START then
1457: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.MSG_ID);
1458: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);
1459: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1460: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1461: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1462: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);

Line 1459: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);

1455:
1456: if I_TOTAL_ROWS >= I_START then
1457: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.MSG_ID);
1458: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);
1459: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1460: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1461: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1462: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1463: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);

Line 1460: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);

1456: if I_TOTAL_ROWS >= I_START then
1457: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.MSG_ID);
1458: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);
1459: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1460: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1461: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1462: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1463: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1464: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);

Line 1461: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);

1457: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.MSG_ID);
1458: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);
1459: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1460: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1461: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1462: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1463: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1464: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1465: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);

Line 1462: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);

1458: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);
1459: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1460: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1461: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1462: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1463: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1464: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1465: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1466: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);

Line 1463: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);

1459: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1460: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1461: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1462: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1463: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1464: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1465: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1466: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1467: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);

Line 1464: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);

1460: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1461: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1462: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1463: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1464: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1465: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1466: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1467: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1468: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);

Line 1465: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);

1461: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1462: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1463: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1464: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1465: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1466: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1467: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1468: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);
1469: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);

Line 1466: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);

1462: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1463: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1464: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1465: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1466: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1467: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1468: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);
1469: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);
1470: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);

Line 1467: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);

1463: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1464: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1465: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1466: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1467: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1468: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);
1469: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);
1470: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);
1471: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.MSG_ID));

Line 1468: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);

1464: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1465: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1466: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1467: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1468: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);
1469: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);
1470: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);
1471: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.MSG_ID));
1472:

Line 1469: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);

1465: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1466: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1467: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1468: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);
1469: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);
1470: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);
1471: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.MSG_ID));
1472:
1473:

Line 1470: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);

1466: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1467: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1468: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);
1469: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);
1470: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);
1471: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.MSG_ID));
1472:
1473:
1474: XNP_WSGL.LayoutRowStart('TOP');

Line 1491: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

1487: XNP_WSGL.LayoutData(CURR_VAL.ADAPTER_NAME);
1488: XNP_WSGL.LayoutData(CURR_VAL.FE_NAME);
1489: XNP_WSGL.LayoutRowEnd;
1490:
1491: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1492: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
1493: if I_ROWS_FETCHED <> 0 then
1494: I_NEXT_BUT := TRUE;
1495: end if;

Line 1499: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

1495: end if;
1496: exit;
1497: end if;
1498: else
1499: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1500: end if;
1501:
1502: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
1503:

Line 1521: dbms_sql.close_cursor(I_CURSOR);

1517: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
1518: end if;
1519:
1520: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1521: dbms_sql.close_cursor(I_CURSOR);
1522: end if;
1523:
1524: htp.formOpen(curl => 'xnp_msg_diagnostics$xnp_msgs.querylist', cattributes => 'NAME="frmZero"');
1525: XNP_WSGL.HiddenField('P_MSG_ID', P_MSG_ID);

Line 1674: I_CURSOR := dbms_sql.open_cursor;

1670: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
1671: return;
1672: end if;
1673:
1674: I_CURSOR := dbms_sql.open_cursor;
1675: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1676: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);
1677: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1678: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);

Line 1675: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);

1671: return;
1672: end if;
1673:
1674: I_CURSOR := dbms_sql.open_cursor;
1675: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1676: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);
1677: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1678: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1679: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);

Line 1676: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);

1672: end if;
1673:
1674: I_CURSOR := dbms_sql.open_cursor;
1675: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1676: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);
1677: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1678: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1679: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1680: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);

Line 1677: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);

1673:
1674: I_CURSOR := dbms_sql.open_cursor;
1675: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1676: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);
1677: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1678: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1679: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1680: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1681: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);

Line 1678: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);

1674: I_CURSOR := dbms_sql.open_cursor;
1675: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1676: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);
1677: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1678: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1679: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1680: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1681: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1682: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);

Line 1679: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);

1675: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1676: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);
1677: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1678: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1679: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1680: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1681: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1682: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1683: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);

Line 1680: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);

1676: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.MSG_ID);
1677: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1678: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1679: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1680: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1681: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1682: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1683: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1684: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);

Line 1681: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);

1677: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1678: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1679: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1680: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1681: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1682: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1683: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1684: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1685: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);

Line 1682: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);

1678: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1679: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1680: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1681: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1682: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1683: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1684: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1685: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1686: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);

Line 1683: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);

1679: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.MSG_STATUS, 10);
1680: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1681: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1682: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1683: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1684: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1685: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1686: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1687: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);

Line 1684: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);

1680: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR, 1);
1681: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1682: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1683: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1684: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1685: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1686: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1687: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);
1688: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763

Line 1685: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);

1681: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.REFERENCE_ID, 1024);
1682: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1683: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1684: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1685: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1686: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1687: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);
1688: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763
1689: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);

Line 1686: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);

1682: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID, 40);
1683: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1684: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1685: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1686: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1687: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);
1688: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763
1689: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);
1690: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);

Line 1687: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);

1683: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1684: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1685: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1686: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1687: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);
1688: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763
1689: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);
1690: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);
1691:

Line 1688: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763

1684: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1685: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1686: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1687: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);
1688: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763
1689: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);
1690: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);
1691:
1692: I_VOID := dbms_sql.execute(I_CURSOR);

Line 1689: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);

1685: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1686: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1687: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);
1688: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763
1689: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);
1690: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);
1691:
1692: I_VOID := dbms_sql.execute(I_CURSOR);
1693:

Line 1690: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);

1686: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME, 40);
1687: -- dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 40);
1688: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763
1689: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);
1690: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);
1691:
1692: I_VOID := dbms_sql.execute(I_CURSOR);
1693:
1694: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 1692: I_VOID := dbms_sql.execute(I_CURSOR);

1688: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.SENDER_NAME, 60); -- increased the size from 40 to 60 for 6880763
1689: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME, 40);
1690: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);
1691:
1692: I_VOID := dbms_sql.execute(I_CURSOR);
1693:
1694: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1695:
1696: if I_ROWS_FETCHED = 0 then

Line 1694: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

1690: dbms_sql.define_column(I_CURSOR, 14, CURR_VAL.FE_NAME, 40);
1691:
1692: I_VOID := dbms_sql.execute(I_CURSOR);
1693:
1694: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1695:
1696: if I_ROWS_FETCHED = 0 then
1697: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1698: else

Line 1699: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.MSG_ID);

1695:
1696: if I_ROWS_FETCHED = 0 then
1697: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1698: else
1699: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.MSG_ID);
1700: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);
1701: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1702: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1703: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);

Line 1700: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);

1696: if I_ROWS_FETCHED = 0 then
1697: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1698: else
1699: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.MSG_ID);
1700: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);
1701: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1702: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1703: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1704: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);

Line 1701: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);

1697: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1698: else
1699: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.MSG_ID);
1700: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);
1701: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1702: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1703: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1704: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1705: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);

Line 1702: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);

1698: else
1699: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.MSG_ID);
1700: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);
1701: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1702: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1703: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1704: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1705: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1706: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);

Line 1703: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);

1699: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.MSG_ID);
1700: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);
1701: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1702: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1703: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1704: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1705: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1706: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1707: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);

Line 1704: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);

1700: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);
1701: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1702: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1703: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1704: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1705: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1706: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1707: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1708: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);

Line 1705: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);

1701: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1702: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1703: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1704: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1705: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1706: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1707: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1708: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1709: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);

Line 1706: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);

1702: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.MSG_STATUS);
1703: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1704: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1705: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1706: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1707: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1708: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1709: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1710: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);

Line 1707: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);

1703: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.DIRECTION_INDICATOR);
1704: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1705: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1706: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1707: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1708: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1709: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1710: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);
1711: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);

Line 1708: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);

1704: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.REFERENCE_ID);
1705: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1706: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1707: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1708: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1709: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1710: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);
1711: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);
1712: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);

Line 1709: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);

1705: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.OPP_REFERENCE_ID);
1706: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1707: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1708: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1709: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1710: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);
1711: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);
1712: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);
1713: xnp_msg_diagnostics$xnp_msgs.QueryView(Z_DIRECT_CALL=>TRUE);

Line 1710: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);

1706: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.MSG_VERSION);
1707: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1708: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1709: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1710: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);
1711: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);
1712: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);
1713: xnp_msg_diagnostics$xnp_msgs.QueryView(Z_DIRECT_CALL=>TRUE);
1714: end if;

Line 1711: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);

1707: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.MSG_CREATION_DATE);
1708: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1709: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1710: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);
1711: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);
1712: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);
1713: xnp_msg_diagnostics$xnp_msgs.QueryView(Z_DIRECT_CALL=>TRUE);
1714: end if;
1715:

Line 1712: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);

1708: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.SEND_RCV_DATE);
1709: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1710: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);
1711: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);
1712: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);
1713: xnp_msg_diagnostics$xnp_msgs.QueryView(Z_DIRECT_CALL=>TRUE);
1714: end if;
1715:
1716: dbms_sql.close_cursor(I_CURSOR);

Line 1716: dbms_sql.close_cursor(I_CURSOR);

1712: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);
1713: xnp_msg_diagnostics$xnp_msgs.QueryView(Z_DIRECT_CALL=>TRUE);
1714: end if;
1715:
1716: dbms_sql.close_cursor(I_CURSOR);
1717:
1718: exception
1719: when others then
1720: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',