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_SV_ORDERS$SOA_SV dependencies on DBMS_SQL

Line 583: I_CURSOR := dbms_sql.open_cursor;

579:
580: I_QUERY := 'SELECT count(*)' ||
581: substr(ZONE_SQL, I_FROM_POS);
582:
583: I_CURSOR := dbms_sql.open_cursor;
584: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
585: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
586: I_VOID := dbms_sql.execute(I_CURSOR);
587: I_VOID := dbms_sql.fetch_rows(I_CURSOR);

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

580: I_QUERY := 'SELECT count(*)' ||
581: substr(ZONE_SQL, I_FROM_POS);
582:
583: I_CURSOR := dbms_sql.open_cursor;
584: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
585: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
586: I_VOID := dbms_sql.execute(I_CURSOR);
587: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
588: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);

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

581: substr(ZONE_SQL, I_FROM_POS);
582:
583: I_CURSOR := dbms_sql.open_cursor;
584: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
585: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
586: I_VOID := dbms_sql.execute(I_CURSOR);
587: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
588: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
589: dbms_sql.close_cursor(I_CURSOR);

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

582:
583: I_CURSOR := dbms_sql.open_cursor;
584: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
585: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
586: I_VOID := dbms_sql.execute(I_CURSOR);
587: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
588: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
589: dbms_sql.close_cursor(I_CURSOR);
590:

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

583: I_CURSOR := dbms_sql.open_cursor;
584: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
585: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
586: I_VOID := dbms_sql.execute(I_CURSOR);
587: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
588: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
589: dbms_sql.close_cursor(I_CURSOR);
590:
591: return I_COUNT;

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

584: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
585: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
586: I_VOID := dbms_sql.execute(I_CURSOR);
587: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
588: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
589: dbms_sql.close_cursor(I_CURSOR);
590:
591: return I_COUNT;
592:

Line 589: dbms_sql.close_cursor(I_CURSOR);

585: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
586: I_VOID := dbms_sql.execute(I_CURSOR);
587: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
588: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
589: dbms_sql.close_cursor(I_CURSOR);
590:
591: return I_COUNT;
592:
593: exception

Line 1459: I_CURSOR := dbms_sql.open_cursor;

1455: end if;
1456:
1457:
1458:
1459: I_CURSOR := dbms_sql.open_cursor;
1460: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1461: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.PORTING_ID, 80);
1462: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);
1463: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);

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

1456:
1457:
1458:
1459: I_CURSOR := dbms_sql.open_cursor;
1460: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1461: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.PORTING_ID, 80);
1462: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);
1463: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);
1464: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);

Line 1461: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.PORTING_ID, 80);

1457:
1458:
1459: I_CURSOR := dbms_sql.open_cursor;
1460: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1461: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.PORTING_ID, 80);
1462: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);
1463: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);
1464: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1465:

Line 1462: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);

1458:
1459: I_CURSOR := dbms_sql.open_cursor;
1460: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1461: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.PORTING_ID, 80);
1462: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);
1463: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);
1464: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1465:
1466: I_VOID := dbms_sql.execute(I_CURSOR);

Line 1463: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);

1459: I_CURSOR := dbms_sql.open_cursor;
1460: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1461: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.PORTING_ID, 80);
1462: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);
1463: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);
1464: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1465:
1466: I_VOID := dbms_sql.execute(I_CURSOR);
1467: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 1464: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);

1460: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1461: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.PORTING_ID, 80);
1462: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);
1463: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);
1464: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1465:
1466: I_VOID := dbms_sql.execute(I_CURSOR);
1467: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1468: else

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

1462: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);
1463: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);
1464: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1465:
1466: I_VOID := dbms_sql.execute(I_CURSOR);
1467: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1468: else
1469: I_ROWS_FETCHED := 0;
1470: end if;

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

1463: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);
1464: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1465:
1466: I_VOID := dbms_sql.execute(I_CURSOR);
1467: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1468: else
1469: I_ROWS_FETCHED := 0;
1470: end if;
1471: I_TOTAL_ROWS := I_ROWS_FETCHED;

Line 1488: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.PORTING_ID);

1484:
1485: while I_ROWS_FETCHED <> 0 loop
1486:
1487: if I_TOTAL_ROWS >= I_START then
1488: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.PORTING_ID);
1489: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN);
1490: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME);
1491: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1492: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SOA_ID));

Line 1489: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN);

1485: while I_ROWS_FETCHED <> 0 loop
1486:
1487: if I_TOTAL_ROWS >= I_START then
1488: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.PORTING_ID);
1489: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN);
1490: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME);
1491: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1492: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SOA_ID));
1493:

Line 1490: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME);

1486:
1487: if I_TOTAL_ROWS >= I_START then
1488: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.PORTING_ID);
1489: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN);
1490: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME);
1491: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1492: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SOA_ID));
1493:
1494:

Line 1491: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);

1487: if I_TOTAL_ROWS >= I_START then
1488: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.PORTING_ID);
1489: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN);
1490: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME);
1491: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1492: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SOA_ID));
1493:
1494:
1495: XNP_WSGL.LayoutRowStart('TOP');

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

1497: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);
1498: XNP_WSGL.LayoutData(CURR_VAL.STATUS_DISPLAY_NAME);
1499: XNP_WSGL.LayoutRowEnd;
1500:
1501: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1502: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
1503: if I_ROWS_FETCHED <> 0 then
1504: I_NEXT_BUT := TRUE;
1505: end if;

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

1505: end if;
1506: exit;
1507: end if;
1508: else
1509: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1510: end if;
1511:
1512: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
1513:

Line 1531: dbms_sql.close_cursor(I_CURSOR);

1527: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
1528: end if;
1529:
1530: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1531: dbms_sql.close_cursor(I_CURSOR);
1532: end if;
1533:
1534: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.querylist', cattributes => 'NAME="frmZero"');
1535: XNP_WSGL.HiddenField('P_PORTING_ID', P_PORTING_ID);

Line 1677: I_CURSOR := dbms_sql.open_cursor;

1673: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
1674: return;
1675: end if;
1676:
1677: I_CURSOR := dbms_sql.open_cursor;
1678: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1679: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.PORTING_ID, 80);
1680: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);
1681: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);

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

1674: return;
1675: end if;
1676:
1677: I_CURSOR := dbms_sql.open_cursor;
1678: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1679: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.PORTING_ID, 80);
1680: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);
1681: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);
1682: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);

Line 1679: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.PORTING_ID, 80);

1675: end if;
1676:
1677: I_CURSOR := dbms_sql.open_cursor;
1678: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1679: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.PORTING_ID, 80);
1680: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);
1681: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);
1682: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1683:

Line 1680: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);

1676:
1677: I_CURSOR := dbms_sql.open_cursor;
1678: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1679: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.PORTING_ID, 80);
1680: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);
1681: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);
1682: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1683:
1684: I_VOID := dbms_sql.execute(I_CURSOR);

Line 1681: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);

1677: I_CURSOR := dbms_sql.open_cursor;
1678: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1679: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.PORTING_ID, 80);
1680: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);
1681: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);
1682: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1683:
1684: I_VOID := dbms_sql.execute(I_CURSOR);
1685:

Line 1682: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);

1678: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1679: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.PORTING_ID, 80);
1680: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);
1681: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);
1682: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1683:
1684: I_VOID := dbms_sql.execute(I_CURSOR);
1685:
1686: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

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

1680: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN, 20);
1681: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME, 40);
1682: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1683:
1684: I_VOID := dbms_sql.execute(I_CURSOR);
1685:
1686: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1687:
1688: if I_ROWS_FETCHED = 0 then

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

1682: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1683:
1684: I_VOID := dbms_sql.execute(I_CURSOR);
1685:
1686: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1687:
1688: if I_ROWS_FETCHED = 0 then
1689: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1690: else

Line 1691: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.PORTING_ID);

1687:
1688: if I_ROWS_FETCHED = 0 then
1689: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1690: else
1691: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.PORTING_ID);
1692: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN);
1693: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME);
1694: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1695: xnp_sv_orders$soa_sv.QueryView(Z_DIRECT_CALL=>TRUE);

Line 1692: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN);

1688: if I_ROWS_FETCHED = 0 then
1689: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1690: else
1691: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.PORTING_ID);
1692: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN);
1693: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME);
1694: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1695: xnp_sv_orders$soa_sv.QueryView(Z_DIRECT_CALL=>TRUE);
1696: end if;

Line 1693: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME);

1689: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1690: else
1691: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.PORTING_ID);
1692: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN);
1693: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME);
1694: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1695: xnp_sv_orders$soa_sv.QueryView(Z_DIRECT_CALL=>TRUE);
1696: end if;
1697:

Line 1694: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);

1690: else
1691: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.PORTING_ID);
1692: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN);
1693: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME);
1694: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1695: xnp_sv_orders$soa_sv.QueryView(Z_DIRECT_CALL=>TRUE);
1696: end if;
1697:
1698: dbms_sql.close_cursor(I_CURSOR);

Line 1698: dbms_sql.close_cursor(I_CURSOR);

1694: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1695: xnp_sv_orders$soa_sv.QueryView(Z_DIRECT_CALL=>TRUE);
1696: end if;
1697:
1698: dbms_sql.close_cursor(I_CURSOR);
1699:
1700: exception
1701: when others then
1702: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',