84: aPlsqlItem.REASON_FOR_FAILURE := aSqlItem.REASON_FOR_FAILURE;
85: RETURN aPlsqlItem;
86: END SQL_TO_PL16;
87: FUNCTION PL_TO_SQL16(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_TBL_TYPE)
88: RETURN DPPPURCHASEPRICEPVTDPPIT9_DPP IS
89: aSqlItem DPPPURCHASEPRICEPVTDPPIT9_DPP;
90: BEGIN
91: -- initialize the table
92: aSqlItem := DPPPURCHASEPRICEPVTDPPIT9_DPP();
85: RETURN aPlsqlItem;
86: END SQL_TO_PL16;
87: FUNCTION PL_TO_SQL16(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_TBL_TYPE)
88: RETURN DPPPURCHASEPRICEPVTDPPIT9_DPP IS
89: aSqlItem DPPPURCHASEPRICEPVTDPPIT9_DPP;
90: BEGIN
91: -- initialize the table
92: aSqlItem := DPPPURCHASEPRICEPVTDPPIT9_DPP();
93: aSqlItem.EXTEND(aPlsqlItem.COUNT);
88: RETURN DPPPURCHASEPRICEPVTDPPIT9_DPP IS
89: aSqlItem DPPPURCHASEPRICEPVTDPPIT9_DPP;
90: BEGIN
91: -- initialize the table
92: aSqlItem := DPPPURCHASEPRICEPVTDPPIT9_DPP();
93: aSqlItem.EXTEND(aPlsqlItem.COUNT);
94: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
95: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL15(aPlsqlItem(I));
96: END LOOP;
95: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL15(aPlsqlItem(I));
96: END LOOP;
97: RETURN aSqlItem;
98: END PL_TO_SQL16;
99: FUNCTION SQL_TO_PL17(aSqlItem DPPPURCHASEPRICEPVTDPPIT9_DPP)
100: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_TBL_TYPE IS
101: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_TBL_TYPE;
102: BEGIN
103: FOR I IN 1..aSqlItem.COUNT LOOP