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_CALLBACK_EVENTS$XNP_CALLBA dependencies on DBMS_SQL

Line 526: I_CURSOR := dbms_sql.open_cursor;

522:
523: I_QUERY := 'SELECT count(*)' ||
524: substr(ZONE_SQL, I_FROM_POS);
525:
526: I_CURSOR := dbms_sql.open_cursor;
527: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
528: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
529: I_VOID := dbms_sql.execute(I_CURSOR);
530: I_VOID := dbms_sql.fetch_rows(I_CURSOR);

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

523: I_QUERY := 'SELECT count(*)' ||
524: substr(ZONE_SQL, I_FROM_POS);
525:
526: I_CURSOR := dbms_sql.open_cursor;
527: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
528: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
529: I_VOID := dbms_sql.execute(I_CURSOR);
530: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
531: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);

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

524: substr(ZONE_SQL, I_FROM_POS);
525:
526: I_CURSOR := dbms_sql.open_cursor;
527: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
528: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
529: I_VOID := dbms_sql.execute(I_CURSOR);
530: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
531: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
532: dbms_sql.close_cursor(I_CURSOR);

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

525:
526: I_CURSOR := dbms_sql.open_cursor;
527: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
528: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
529: I_VOID := dbms_sql.execute(I_CURSOR);
530: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
531: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
532: dbms_sql.close_cursor(I_CURSOR);
533:

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

526: I_CURSOR := dbms_sql.open_cursor;
527: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
528: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
529: I_VOID := dbms_sql.execute(I_CURSOR);
530: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
531: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
532: dbms_sql.close_cursor(I_CURSOR);
533:
534: return I_COUNT;

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

527: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
528: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
529: I_VOID := dbms_sql.execute(I_CURSOR);
530: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
531: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
532: dbms_sql.close_cursor(I_CURSOR);
533:
534: return I_COUNT;
535:

Line 532: dbms_sql.close_cursor(I_CURSOR);

528: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
529: I_VOID := dbms_sql.execute(I_CURSOR);
530: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
531: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
532: dbms_sql.close_cursor(I_CURSOR);
533:
534: return I_COUNT;
535:
536: exception

Line 1029: I_CURSOR := dbms_sql.open_cursor;

1025: InitialiseDomain('CALLBACK_TYPE');
1026: InitialiseDomain('CLOSE_REQD_FLAG');
1027:
1028:
1029: I_CURSOR := dbms_sql.open_cursor;
1030: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1031: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.ORDER_ID);
1032: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.STATUS, 10);
1033: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);

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

1026: InitialiseDomain('CLOSE_REQD_FLAG');
1027:
1028:
1029: I_CURSOR := dbms_sql.open_cursor;
1030: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1031: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.ORDER_ID);
1032: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.STATUS, 10);
1033: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1034: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME, 80);

Line 1031: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.ORDER_ID);

1027:
1028:
1029: I_CURSOR := dbms_sql.open_cursor;
1030: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1031: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.ORDER_ID);
1032: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.STATUS, 10);
1033: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1034: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME, 80);
1035: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE, 20);

Line 1032: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.STATUS, 10);

1028:
1029: I_CURSOR := dbms_sql.open_cursor;
1030: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1031: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.ORDER_ID);
1032: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.STATUS, 10);
1033: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1034: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME, 80);
1035: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE, 20);
1036: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE, 512);

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

1029: I_CURSOR := dbms_sql.open_cursor;
1030: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1031: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.ORDER_ID);
1032: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.STATUS, 10);
1033: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1034: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME, 80);
1035: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE, 20);
1036: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE, 512);
1037: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.REFERENCE_ID, 80);

Line 1034: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME, 80);

1030: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1031: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.ORDER_ID);
1032: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.STATUS, 10);
1033: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1034: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME, 80);
1035: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE, 20);
1036: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE, 512);
1037: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.REFERENCE_ID, 80);
1038: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG, 1);

Line 1035: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE, 20);

1031: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.ORDER_ID);
1032: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.STATUS, 10);
1033: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1034: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME, 80);
1035: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE, 20);
1036: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE, 512);
1037: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.REFERENCE_ID, 80);
1038: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG, 1);
1039: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);

Line 1036: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE, 512);

1032: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.STATUS, 10);
1033: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1034: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME, 80);
1035: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE, 20);
1036: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE, 512);
1037: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.REFERENCE_ID, 80);
1038: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG, 1);
1039: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1040: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);

Line 1037: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.REFERENCE_ID, 80);

1033: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.MSG_CODE, 20);
1034: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME, 80);
1035: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE, 20);
1036: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE, 512);
1037: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.REFERENCE_ID, 80);
1038: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG, 1);
1039: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1040: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);
1041: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);

Line 1038: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG, 1);

1034: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME, 80);
1035: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE, 20);
1036: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE, 512);
1037: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.REFERENCE_ID, 80);
1038: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG, 1);
1039: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1040: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);
1041: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);
1042: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);

Line 1039: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);

1035: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE, 20);
1036: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE, 512);
1037: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.REFERENCE_ID, 80);
1038: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG, 1);
1039: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1040: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);
1041: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);
1042: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);
1043: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.FA_INSTANCE_ID);

Line 1040: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);

1036: dbms_sql.define_column(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE, 512);
1037: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.REFERENCE_ID, 80);
1038: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG, 1);
1039: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1040: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);
1041: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);
1042: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);
1043: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.FA_INSTANCE_ID);
1044:

Line 1041: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);

1037: dbms_sql.define_column(I_CURSOR, 7, CURR_VAL.REFERENCE_ID, 80);
1038: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG, 1);
1039: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1040: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);
1041: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);
1042: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);
1043: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.FA_INSTANCE_ID);
1044:
1045: I_VOID := dbms_sql.execute(I_CURSOR);

Line 1042: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);

1038: dbms_sql.define_column(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG, 1);
1039: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1040: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);
1041: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);
1042: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);
1043: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.FA_INSTANCE_ID);
1044:
1045: I_VOID := dbms_sql.execute(I_CURSOR);
1046: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 1043: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.FA_INSTANCE_ID);

1039: dbms_sql.define_column(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1040: dbms_sql.define_column(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);
1041: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);
1042: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);
1043: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.FA_INSTANCE_ID);
1044:
1045: I_VOID := dbms_sql.execute(I_CURSOR);
1046: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1047: else

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

1041: dbms_sql.define_column(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);
1042: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);
1043: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.FA_INSTANCE_ID);
1044:
1045: I_VOID := dbms_sql.execute(I_CURSOR);
1046: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1047: else
1048: I_ROWS_FETCHED := 0;
1049: end if;

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

1042: dbms_sql.define_column(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);
1043: dbms_sql.define_column(I_CURSOR, 13, CURR_VAL.FA_INSTANCE_ID);
1044:
1045: I_VOID := dbms_sql.execute(I_CURSOR);
1046: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1047: else
1048: I_ROWS_FETCHED := 0;
1049: end if;
1050: I_TOTAL_ROWS := I_ROWS_FETCHED;

Line 1076: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.ORDER_ID);

1072:
1073: while I_ROWS_FETCHED <> 0 loop
1074:
1075: if I_TOTAL_ROWS >= I_START then
1076: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.ORDER_ID);
1077: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.STATUS);
1078: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1079: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME);
1080: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE);

Line 1077: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.STATUS);

1073: while I_ROWS_FETCHED <> 0 loop
1074:
1075: if I_TOTAL_ROWS >= I_START then
1076: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.ORDER_ID);
1077: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.STATUS);
1078: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1079: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME);
1080: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE);
1081: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE);

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

1074:
1075: if I_TOTAL_ROWS >= I_START then
1076: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.ORDER_ID);
1077: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.STATUS);
1078: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1079: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME);
1080: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE);
1081: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE);
1082: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.REFERENCE_ID);

Line 1079: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME);

1075: if I_TOTAL_ROWS >= I_START then
1076: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.ORDER_ID);
1077: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.STATUS);
1078: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1079: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME);
1080: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE);
1081: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE);
1082: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.REFERENCE_ID);
1083: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG);

Line 1080: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE);

1076: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.ORDER_ID);
1077: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.STATUS);
1078: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1079: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME);
1080: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE);
1081: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE);
1082: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.REFERENCE_ID);
1083: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG);
1084: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);

Line 1081: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE);

1077: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.STATUS);
1078: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1079: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME);
1080: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE);
1081: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE);
1082: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.REFERENCE_ID);
1083: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG);
1084: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1085: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);

Line 1082: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.REFERENCE_ID);

1078: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1079: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME);
1080: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE);
1081: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE);
1082: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.REFERENCE_ID);
1083: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG);
1084: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1085: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);
1086: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);

Line 1083: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG);

1079: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.CALLBACK_PROC_NAME);
1080: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE);
1081: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE);
1082: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.REFERENCE_ID);
1083: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG);
1084: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1085: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);
1086: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);
1087: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);

Line 1084: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);

1080: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.CALLBACK_TYPE);
1081: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE);
1082: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.REFERENCE_ID);
1083: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG);
1084: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1085: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);
1086: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);
1087: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);
1088: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.FA_INSTANCE_ID);

Line 1085: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);

1081: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.PROCESS_REFERENCE);
1082: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.REFERENCE_ID);
1083: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG);
1084: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1085: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);
1086: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);
1087: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);
1088: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.FA_INSTANCE_ID);
1089: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.CALLBACK_EVENT_ID));

Line 1086: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);

1082: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.REFERENCE_ID);
1083: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG);
1084: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1085: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);
1086: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);
1087: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);
1088: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.FA_INSTANCE_ID);
1089: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.CALLBACK_EVENT_ID));
1090:

Line 1087: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);

1083: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.CLOSE_REQD_FLAG);
1084: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1085: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);
1086: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);
1087: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);
1088: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.FA_INSTANCE_ID);
1089: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.CALLBACK_EVENT_ID));
1090:
1091:

Line 1088: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.FA_INSTANCE_ID);

1084: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.CALLBACK_EVENT_ID);
1085: dbms_sql.column_value(I_CURSOR, 10, CURR_VAL.CALLBACK_TIMESTAMP);
1086: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.REGISTERED_TIMESTAMP);
1087: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.WI_INSTANCE_ID);
1088: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.FA_INSTANCE_ID);
1089: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.CALLBACK_EVENT_ID));
1090:
1091:
1092: XNP_WSGL.LayoutRowStart('TOP');

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

1103: XNP_WSGL.LayoutData(CURR_VAL.WI_INSTANCE_ID);
1104: XNP_WSGL.LayoutData(CURR_VAL.FA_INSTANCE_ID);
1105: XNP_WSGL.LayoutRowEnd;
1106:
1107: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1108: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
1109: if I_ROWS_FETCHED <> 0 then
1110: I_NEXT_BUT := TRUE;
1111: end if;

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

1111: end if;
1112: exit;
1113: end if;
1114: else
1115: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1116: end if;
1117:
1118: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
1119:

Line 1137: dbms_sql.close_cursor(I_CURSOR);

1133: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
1134: end if;
1135:
1136: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1137: dbms_sql.close_cursor(I_CURSOR);
1138: end if;
1139:
1140: htp.formOpen(curl => 'xnp_callback_events$xnp_callba.querylist', cattributes => 'NAME="frmZero"');
1141: XNP_WSGL.HiddenField('P_ORDER_ID', P_ORDER_ID);