50: aPlsqlItem.ONHAND_QUANTITY := aSqlItem.ONHAND_QUANTITY;
51: RETURN aPlsqlItem;
52: END SQL_TO_PL2;
53: FUNCTION PL_TO_SQL3(aPlsqlItem DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_RCT_TBL_TYPE)
54: RETURN DPPCOVEREDINVENTORYPVTDPP4_DP IS
55: aSqlItem DPPCOVEREDINVENTORYPVTDPP4_DP;
56: BEGIN
57: -- initialize the table
58: aSqlItem := DPPCOVEREDINVENTORYPVTDPP4_DP();
51: RETURN aPlsqlItem;
52: END SQL_TO_PL2;
53: FUNCTION PL_TO_SQL3(aPlsqlItem DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_RCT_TBL_TYPE)
54: RETURN DPPCOVEREDINVENTORYPVTDPP4_DP IS
55: aSqlItem DPPCOVEREDINVENTORYPVTDPP4_DP;
56: BEGIN
57: -- initialize the table
58: aSqlItem := DPPCOVEREDINVENTORYPVTDPP4_DP();
59: aSqlItem.EXTEND(aPlsqlItem.COUNT);
54: RETURN DPPCOVEREDINVENTORYPVTDPP4_DP IS
55: aSqlItem DPPCOVEREDINVENTORYPVTDPP4_DP;
56: BEGIN
57: -- initialize the table
58: aSqlItem := DPPCOVEREDINVENTORYPVTDPP4_DP();
59: aSqlItem.EXTEND(aPlsqlItem.COUNT);
60: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
61: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL2(aPlsqlItem(I));
62: END LOOP;
61: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL2(aPlsqlItem(I));
62: END LOOP;
63: RETURN aSqlItem;
64: END PL_TO_SQL3;
65: FUNCTION SQL_TO_PL3(aSqlItem DPPCOVEREDINVENTORYPVTDPP4_DP)
66: RETURN DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_RCT_TBL_TYPE IS
67: aPlsqlItem DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_RCT_TBL_TYPE;
68: BEGIN
69: FOR I IN 1..aSqlItem.COUNT LOOP