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_TIMERS$XNP_TIMER_REGISTRY dependencies on DBMS_SQL

Line 683: I_CURSOR := dbms_sql.open_cursor;

679:
680: I_QUERY := 'SELECT count(*)' ||
681: substr(ZONE_SQL, I_FROM_POS);
682:
683: I_CURSOR := dbms_sql.open_cursor;
684: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
685: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
686: I_VOID := dbms_sql.execute(I_CURSOR);
687: I_VOID := dbms_sql.fetch_rows(I_CURSOR);

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

680: I_QUERY := 'SELECT count(*)' ||
681: substr(ZONE_SQL, I_FROM_POS);
682:
683: I_CURSOR := dbms_sql.open_cursor;
684: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
685: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
686: I_VOID := dbms_sql.execute(I_CURSOR);
687: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
688: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);

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

681: substr(ZONE_SQL, I_FROM_POS);
682:
683: I_CURSOR := dbms_sql.open_cursor;
684: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
685: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
686: I_VOID := dbms_sql.execute(I_CURSOR);
687: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
688: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
689: dbms_sql.close_cursor(I_CURSOR);

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

682:
683: I_CURSOR := dbms_sql.open_cursor;
684: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
685: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
686: I_VOID := dbms_sql.execute(I_CURSOR);
687: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
688: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
689: dbms_sql.close_cursor(I_CURSOR);
690:

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

683: I_CURSOR := dbms_sql.open_cursor;
684: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
685: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
686: I_VOID := dbms_sql.execute(I_CURSOR);
687: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
688: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
689: dbms_sql.close_cursor(I_CURSOR);
690:
691: return I_COUNT;

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

684: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
685: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
686: I_VOID := dbms_sql.execute(I_CURSOR);
687: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
688: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
689: dbms_sql.close_cursor(I_CURSOR);
690:
691: return I_COUNT;
692:

Line 689: dbms_sql.close_cursor(I_CURSOR);

685: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
686: I_VOID := dbms_sql.execute(I_CURSOR);
687: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
688: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
689: dbms_sql.close_cursor(I_CURSOR);
690:
691: return I_COUNT;
692:
693: exception

Line 1305: I_CURSOR := dbms_sql.open_cursor;

1301:
1302: InitialiseDomain('STATUS');
1303:
1304:
1305: I_CURSOR := dbms_sql.open_cursor;
1306: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1307: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1308: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1309: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);

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

1302: InitialiseDomain('STATUS');
1303:
1304:
1305: I_CURSOR := dbms_sql.open_cursor;
1306: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1307: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1308: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1309: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1310: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);

Line 1307: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);

1303:
1304:
1305: I_CURSOR := dbms_sql.open_cursor;
1306: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1307: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1308: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1309: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1310: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1311: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);

Line 1308: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);

1304:
1305: I_CURSOR := dbms_sql.open_cursor;
1306: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1307: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1308: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1309: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1310: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1311: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1312: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);

Line 1309: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);

1305: I_CURSOR := dbms_sql.open_cursor;
1306: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1307: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1308: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1309: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1310: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1311: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1312: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);
1313: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);

Line 1310: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);

1306: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1307: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1308: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1309: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1310: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1311: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1312: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);
1313: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);
1314: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);

Line 1311: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);

1307: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1308: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1309: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1310: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1311: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1312: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);
1313: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);
1314: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);
1315: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);

Line 1312: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);

1308: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1309: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1310: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1311: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1312: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);
1313: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);
1314: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);
1315: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);
1316:

Line 1313: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);

1309: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1310: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1311: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1312: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);
1313: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);
1314: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);
1315: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);
1316:
1317: I_VOID := dbms_sql.execute(I_CURSOR);

Line 1314: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);

1310: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1311: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1312: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);
1313: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);
1314: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);
1315: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);
1316:
1317: I_VOID := dbms_sql.execute(I_CURSOR);
1318: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 1315: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);

1311: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1312: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);
1313: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);
1314: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);
1315: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);
1316:
1317: I_VOID := dbms_sql.execute(I_CURSOR);
1318: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1319: else

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

1313: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);
1314: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);
1315: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);
1316:
1317: I_VOID := dbms_sql.execute(I_CURSOR);
1318: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1319: else
1320: I_ROWS_FETCHED := 0;
1321: end if;

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

1314: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);
1315: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);
1316:
1317: I_VOID := dbms_sql.execute(I_CURSOR);
1318: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1319: else
1320: I_ROWS_FETCHED := 0;
1321: end if;
1322: I_TOTAL_ROWS := I_ROWS_FETCHED;

Line 1344: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.TIMER_ID);

1340:
1341: while I_ROWS_FETCHED <> 0 loop
1342:
1343: if I_TOTAL_ROWS >= I_START then
1344: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1345: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1346: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1347: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1348: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);

Line 1345: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);

1341: while I_ROWS_FETCHED <> 0 loop
1342:
1343: if I_TOTAL_ROWS >= I_START then
1344: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1345: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1346: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1347: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1348: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1349: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);

Line 1346: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);

1342:
1343: if I_TOTAL_ROWS >= I_START then
1344: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1345: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1346: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1347: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1348: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1349: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1350: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);

Line 1347: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);

1343: if I_TOTAL_ROWS >= I_START then
1344: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1345: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1346: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1347: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1348: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1349: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1350: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);
1351: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);

Line 1348: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);

1344: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1345: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1346: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1347: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1348: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1349: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1350: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);
1351: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);
1352: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);

Line 1349: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);

1345: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1346: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1347: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1348: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1349: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1350: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);
1351: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);
1352: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);
1353: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.TIMER_ID));

Line 1350: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);

1346: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1347: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1348: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1349: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1350: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);
1351: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);
1352: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);
1353: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.TIMER_ID));
1354:

Line 1351: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);

1347: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1348: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1349: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1350: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);
1351: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);
1352: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);
1353: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.TIMER_ID));
1354:
1355:

Line 1352: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);

1348: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1349: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1350: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);
1351: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);
1352: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);
1353: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.TIMER_ID));
1354:
1355:
1356: XNP_WSGL.LayoutRowStart('TOP');

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

1363: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.END_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1364: XNP_WSGL.LayoutData(CURR_VAL.NEXT_TIMER);
1365: XNP_WSGL.LayoutRowEnd;
1366:
1367: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1368: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
1369: if I_ROWS_FETCHED <> 0 then
1370: I_NEXT_BUT := TRUE;
1371: end if;

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

1371: end if;
1372: exit;
1373: end if;
1374: else
1375: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1376: end if;
1377:
1378: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
1379:

Line 1397: dbms_sql.close_cursor(I_CURSOR);

1393: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
1394: end if;
1395:
1396: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1397: dbms_sql.close_cursor(I_CURSOR);
1398: end if;
1399:
1400: htp.formOpen(curl => 'xnp_timers$xnp_timer_registry.querylist', cattributes => 'NAME="frmZero"');
1401: XNP_WSGL.HiddenField('P_ORDER_ID', P_ORDER_ID);

Line 1535: I_CURSOR := dbms_sql.open_cursor;

1531: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
1532: return;
1533: end if;
1534:
1535: I_CURSOR := dbms_sql.open_cursor;
1536: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1537: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1538: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1539: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);

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

1532: return;
1533: end if;
1534:
1535: I_CURSOR := dbms_sql.open_cursor;
1536: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1537: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1538: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1539: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1540: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);

Line 1537: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);

1533: end if;
1534:
1535: I_CURSOR := dbms_sql.open_cursor;
1536: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1537: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1538: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1539: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1540: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1541: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);

Line 1538: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);

1534:
1535: I_CURSOR := dbms_sql.open_cursor;
1536: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1537: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1538: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1539: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1540: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1541: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1542: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);

Line 1539: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);

1535: I_CURSOR := dbms_sql.open_cursor;
1536: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1537: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1538: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1539: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1540: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1541: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1542: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);
1543: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);

Line 1540: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);

1536: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1537: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1538: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1539: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1540: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1541: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1542: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);
1543: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);
1544: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);

Line 1541: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);

1537: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1538: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1539: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1540: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1541: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1542: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);
1543: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);
1544: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);
1545: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);

Line 1542: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);

1538: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1539: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1540: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1541: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1542: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);
1543: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);
1544: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);
1545: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);
1546:

Line 1543: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);

1539: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.REFERENCE_ID, 80);
1540: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1541: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1542: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);
1543: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);
1544: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);
1545: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);
1546:
1547: I_VOID := dbms_sql.execute(I_CURSOR);

Line 1544: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);

1540: dbms_sql.define_column(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK, 2000);
1541: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1542: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);
1543: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);
1544: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);
1545: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);
1546:
1547: I_VOID := dbms_sql.execute(I_CURSOR);
1548:

Line 1545: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);

1541: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE, 20);
1542: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.STATUS, 20);
1543: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);
1544: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);
1545: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);
1546:
1547: I_VOID := dbms_sql.execute(I_CURSOR);
1548:
1549: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

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

1543: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.START_TIME);
1544: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.END_TIME);
1545: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);
1546:
1547: I_VOID := dbms_sql.execute(I_CURSOR);
1548:
1549: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1550:
1551: if I_ROWS_FETCHED = 0 then

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

1545: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.NEXT_TIMER, 20);
1546:
1547: I_VOID := dbms_sql.execute(I_CURSOR);
1548:
1549: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1550:
1551: if I_ROWS_FETCHED = 0 then
1552: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1553: else

Line 1554: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.TIMER_ID);

1550:
1551: if I_ROWS_FETCHED = 0 then
1552: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1553: else
1554: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1555: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1556: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1557: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1558: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);

Line 1555: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);

1551: if I_ROWS_FETCHED = 0 then
1552: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1553: else
1554: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1555: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1556: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1557: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1558: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1559: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);

Line 1556: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);

1552: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1553: else
1554: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1555: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1556: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1557: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1558: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1559: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1560: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);

Line 1557: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);

1553: else
1554: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1555: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1556: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1557: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1558: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1559: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1560: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);
1561: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);

Line 1558: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);

1554: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1555: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1556: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1557: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1558: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1559: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1560: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);
1561: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);
1562: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);

Line 1559: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);

1555: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1556: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1557: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1558: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1559: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1560: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);
1561: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);
1562: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);
1563: xnp_timers$xnp_timer_registry.QueryView(Z_DIRECT_CALL=>TRUE);

Line 1560: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);

1556: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1557: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1558: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1559: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1560: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);
1561: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);
1562: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);
1563: xnp_timers$xnp_timer_registry.QueryView(Z_DIRECT_CALL=>TRUE);
1564: end if;

Line 1561: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);

1557: dbms_sql.column_value(I_CURSOR, 4, NBT_VAL.XML_PAYLOAD_LINK);
1558: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1559: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1560: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);
1561: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);
1562: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);
1563: xnp_timers$xnp_timer_registry.QueryView(Z_DIRECT_CALL=>TRUE);
1564: end if;
1565:

Line 1562: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);

1558: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.TIMER_MESSAGE_CODE);
1559: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1560: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);
1561: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);
1562: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);
1563: xnp_timers$xnp_timer_registry.QueryView(Z_DIRECT_CALL=>TRUE);
1564: end if;
1565:
1566: dbms_sql.close_cursor(I_CURSOR);

Line 1566: dbms_sql.close_cursor(I_CURSOR);

1562: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);
1563: xnp_timers$xnp_timer_registry.QueryView(Z_DIRECT_CALL=>TRUE);
1564: end if;
1565:
1566: dbms_sql.close_cursor(I_CURSOR);
1567:
1568: exception
1569: when others then
1570: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',