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_NUMBER_SPLITS$NUMBER_SPLIT dependencies on DBMS_SQL

Line 770: I_CURSOR := dbms_sql.open_cursor;

766:
767: I_QUERY := 'SELECT count(*)' ||
768: substr(ZONE_SQL, I_FROM_POS);
769:
770: I_CURSOR := dbms_sql.open_cursor;
771: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
772: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
773: I_VOID := dbms_sql.execute(I_CURSOR);
774: I_VOID := dbms_sql.fetch_rows(I_CURSOR);

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

767: I_QUERY := 'SELECT count(*)' ||
768: substr(ZONE_SQL, I_FROM_POS);
769:
770: I_CURSOR := dbms_sql.open_cursor;
771: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
772: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
773: I_VOID := dbms_sql.execute(I_CURSOR);
774: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
775: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);

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

768: substr(ZONE_SQL, I_FROM_POS);
769:
770: I_CURSOR := dbms_sql.open_cursor;
771: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
772: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
773: I_VOID := dbms_sql.execute(I_CURSOR);
774: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
775: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
776: dbms_sql.close_cursor(I_CURSOR);

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

769:
770: I_CURSOR := dbms_sql.open_cursor;
771: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
772: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
773: I_VOID := dbms_sql.execute(I_CURSOR);
774: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
775: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
776: dbms_sql.close_cursor(I_CURSOR);
777:

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

770: I_CURSOR := dbms_sql.open_cursor;
771: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
772: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
773: I_VOID := dbms_sql.execute(I_CURSOR);
774: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
775: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
776: dbms_sql.close_cursor(I_CURSOR);
777:
778: return I_COUNT;

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

771: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
772: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
773: I_VOID := dbms_sql.execute(I_CURSOR);
774: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
775: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
776: dbms_sql.close_cursor(I_CURSOR);
777:
778: return I_COUNT;
779:

Line 776: dbms_sql.close_cursor(I_CURSOR);

772: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
773: I_VOID := dbms_sql.execute(I_CURSOR);
774: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
775: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
776: dbms_sql.close_cursor(I_CURSOR);
777:
778: return I_COUNT;
779:
780: exception

Line 1401: I_CURSOR := dbms_sql.open_cursor;

1397: end if;
1398:
1399:
1400:
1401: I_CURSOR := dbms_sql.open_cursor;
1402: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1403: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1404: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);
1405: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);

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

1398:
1399:
1400:
1401: I_CURSOR := dbms_sql.open_cursor;
1402: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1403: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1404: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);
1405: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);
1406: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);

Line 1403: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);

1399:
1400:
1401: I_CURSOR := dbms_sql.open_cursor;
1402: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1403: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1404: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);
1405: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);
1406: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1407: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);

Line 1404: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);

1400:
1401: I_CURSOR := dbms_sql.open_cursor;
1402: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1403: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1404: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);
1405: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);
1406: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1407: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1408:

Line 1405: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);

1401: I_CURSOR := dbms_sql.open_cursor;
1402: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1403: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1404: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);
1405: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);
1406: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1407: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1408:
1409: I_VOID := dbms_sql.execute(I_CURSOR);

Line 1406: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);

1402: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1403: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1404: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);
1405: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);
1406: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1407: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1408:
1409: I_VOID := dbms_sql.execute(I_CURSOR);
1410: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 1407: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);

1403: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1404: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);
1405: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);
1406: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1407: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1408:
1409: I_VOID := dbms_sql.execute(I_CURSOR);
1410: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1411: else

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

1405: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);
1406: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1407: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1408:
1409: I_VOID := dbms_sql.execute(I_CURSOR);
1410: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1411: else
1412: I_ROWS_FETCHED := 0;
1413: end if;

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

1406: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1407: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1408:
1409: I_VOID := dbms_sql.execute(I_CURSOR);
1410: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1411: else
1412: I_ROWS_FETCHED := 0;
1413: end if;
1414: I_TOTAL_ROWS := I_ROWS_FETCHED;

Line 1432: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);

1428:
1429: while I_ROWS_FETCHED <> 0 loop
1430:
1431: if I_TOTAL_ROWS >= I_START then
1432: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1433: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE);
1434: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE);
1435: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1436: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);

Line 1433: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE);

1429: while I_ROWS_FETCHED <> 0 loop
1430:
1431: if I_TOTAL_ROWS >= I_START then
1432: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1433: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE);
1434: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE);
1435: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1436: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1437: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.NUMBER_SPLIT_ID));

Line 1434: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE);

1430:
1431: if I_TOTAL_ROWS >= I_START then
1432: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1433: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE);
1434: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE);
1435: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1436: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1437: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.NUMBER_SPLIT_ID));
1438:

Line 1435: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);

1431: if I_TOTAL_ROWS >= I_START then
1432: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1433: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE);
1434: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE);
1435: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1436: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1437: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.NUMBER_SPLIT_ID));
1438:
1439:

Line 1436: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);

1432: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1433: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE);
1434: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE);
1435: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1436: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1437: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.NUMBER_SPLIT_ID));
1438:
1439:
1440: XNP_WSGL.LayoutRowStart('TOP');

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

1443: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.PERMISSIVE_DIAL_START_DATE, 'DD-MON-RRRR')));
1444: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.PERMISSIVE_DIAL_END_DATE, 'DD-MON-RRRR')));
1445: XNP_WSGL.LayoutRowEnd;
1446:
1447: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1448: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
1449: if I_ROWS_FETCHED <> 0 then
1450: I_NEXT_BUT := TRUE;
1451: end if;

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

1451: end if;
1452: exit;
1453: end if;
1454: else
1455: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1456: end if;
1457:
1458: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
1459:

Line 1477: dbms_sql.close_cursor(I_CURSOR);

1473: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
1474: end if;
1475:
1476: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1477: dbms_sql.close_cursor(I_CURSOR);
1478: end if;
1479:
1480: htp.formOpen(curl => 'xnp_number_splits$number_split.querylist', cattributes => 'NAME="frmZero"');
1481: XNP_WSGL.HiddenField('P_L_NRE_OBJECT_REFERENCE', P_L_NRE_OBJECT_REFERENCE);

Line 1628: I_CURSOR := dbms_sql.open_cursor;

1624: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1625: return;
1626: end if;
1627:
1628: I_CURSOR := dbms_sql.open_cursor;
1629: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1630: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1631: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);
1632: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);

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

1625: return;
1626: end if;
1627:
1628: I_CURSOR := dbms_sql.open_cursor;
1629: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1630: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1631: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);
1632: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);
1633: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);

Line 1630: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);

1626: end if;
1627:
1628: I_CURSOR := dbms_sql.open_cursor;
1629: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1630: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1631: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);
1632: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);
1633: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1634: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);

Line 1631: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);

1627:
1628: I_CURSOR := dbms_sql.open_cursor;
1629: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1630: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1631: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);
1632: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);
1633: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1634: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1635:

Line 1632: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);

1628: I_CURSOR := dbms_sql.open_cursor;
1629: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1630: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1631: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);
1632: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);
1633: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1634: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1635:
1636: I_VOID := dbms_sql.execute(I_CURSOR);

Line 1633: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);

1629: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1630: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1631: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);
1632: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);
1633: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1634: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1635:
1636: I_VOID := dbms_sql.execute(I_CURSOR);
1637:

Line 1634: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);

1630: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1631: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE, 80);
1632: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);
1633: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1634: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1635:
1636: I_VOID := dbms_sql.execute(I_CURSOR);
1637:
1638: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

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

1632: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE, 80);
1633: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1634: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1635:
1636: I_VOID := dbms_sql.execute(I_CURSOR);
1637:
1638: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1639:
1640: if I_ROWS_FETCHED = 0 then

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

1634: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1635:
1636: I_VOID := dbms_sql.execute(I_CURSOR);
1637:
1638: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1639:
1640: if I_ROWS_FETCHED = 0 then
1641: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1642: else

Line 1643: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);

1639:
1640: if I_ROWS_FETCHED = 0 then
1641: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1642: else
1643: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1644: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE);
1645: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE);
1646: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1647: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);

Line 1644: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE);

1640: if I_ROWS_FETCHED = 0 then
1641: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1642: else
1643: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1644: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE);
1645: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE);
1646: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1647: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1648: xnp_number_splits$number_split.QueryView(Z_DIRECT_CALL=>TRUE);

Line 1645: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE);

1641: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1642: else
1643: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1644: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE);
1645: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE);
1646: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1647: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1648: xnp_number_splits$number_split.QueryView(Z_DIRECT_CALL=>TRUE);
1649: end if;

Line 1646: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);

1642: else
1643: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1644: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE);
1645: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE);
1646: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1647: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1648: xnp_number_splits$number_split.QueryView(Z_DIRECT_CALL=>TRUE);
1649: end if;
1650:

Line 1647: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);

1643: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
1644: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE);
1645: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE);
1646: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1647: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1648: xnp_number_splits$number_split.QueryView(Z_DIRECT_CALL=>TRUE);
1649: end if;
1650:
1651: dbms_sql.close_cursor(I_CURSOR);

Line 1651: dbms_sql.close_cursor(I_CURSOR);

1647: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1648: xnp_number_splits$number_split.QueryView(Z_DIRECT_CALL=>TRUE);
1649: end if;
1650:
1651: dbms_sql.close_cursor(I_CURSOR);
1652:
1653: exception
1654: when others then
1655: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',