1441: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
1442: x_return_status OUT NOCOPY VARCHAR2)
1443: IS
1444:
1445: CURSOR c_sort(c_tab IN WSH_OTM_RIQ_SORT_TAB)
1446: IS
1447: SELECT position
1448: FROM TABLE (CAST (c_tab AS WSH_OTM_RIQ_SORT_TAB))
1449: ORDER BY numberValue;
1444:
1445: CURSOR c_sort(c_tab IN WSH_OTM_RIQ_SORT_TAB)
1446: IS
1447: SELECT position
1448: FROM TABLE (CAST (c_tab AS WSH_OTM_RIQ_SORT_TAB))
1449: ORDER BY numberValue;
1450:
1451: i NUMBER;
1452: j NUMBER;
1451: i NUMBER;
1452: j NUMBER;
1453: l_count NUMBER;
1454:
1455: l_sort_tab WSH_OTM_RIQ_SORT_TAB;
1456: l_sort_rec WSH_OTM_RIQ_SORT_REC;
1457: l_index_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
1458: l_out_tab FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB;
1459:
1482: IF (l_count > 0)
1483: THEN
1484:
1485: l_sort_rec:= NEW WSH_OTM_RIQ_SORT_REC();
1486: l_sort_tab:= NEW WSH_OTM_RIQ_SORT_TAB(l_sort_rec);
1487: j:=l_sort_tab.FIRST;
1488: l_sort_tab.EXTEND(l_count-1,j);
1489:
1490: --l_sort_tab now has l_count unitialized records