81: aPlsqlItem.PRIOR_COST := aSqlItem.PRIOR_COST;
82: RETURN aPlsqlItem;
83: END SQL_TO_PL11;
84: FUNCTION PL_TO_SQL11(aPlsqlItem DPP_ITEMCOST_PVT.INV_ORG_DETAILS_TBL_TYPE)
85: RETURN DPPITEMCOSTPVTDPPTXNLIN7_INV_ IS
86: aSqlItem DPPITEMCOSTPVTDPPTXNLIN7_INV_;
87: BEGIN
88: -- initialize the table
89: aSqlItem := DPPITEMCOSTPVTDPPTXNLIN7_INV_();
82: RETURN aPlsqlItem;
83: END SQL_TO_PL11;
84: FUNCTION PL_TO_SQL11(aPlsqlItem DPP_ITEMCOST_PVT.INV_ORG_DETAILS_TBL_TYPE)
85: RETURN DPPITEMCOSTPVTDPPTXNLIN7_INV_ IS
86: aSqlItem DPPITEMCOSTPVTDPPTXNLIN7_INV_;
87: BEGIN
88: -- initialize the table
89: aSqlItem := DPPITEMCOSTPVTDPPTXNLIN7_INV_();
90: aSqlItem.EXTEND(aPlsqlItem.COUNT);
85: RETURN DPPITEMCOSTPVTDPPTXNLIN7_INV_ IS
86: aSqlItem DPPITEMCOSTPVTDPPTXNLIN7_INV_;
87: BEGIN
88: -- initialize the table
89: aSqlItem := DPPITEMCOSTPVTDPPTXNLIN7_INV_();
90: aSqlItem.EXTEND(aPlsqlItem.COUNT);
91: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
92: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL10(aPlsqlItem(I));
93: END LOOP;
92: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL10(aPlsqlItem(I));
93: END LOOP;
94: RETURN aSqlItem;
95: END PL_TO_SQL11;
96: FUNCTION SQL_TO_PL12(aSqlItem DPPITEMCOSTPVTDPPTXNLIN7_INV_)
97: RETURN DPP_ITEMCOST_PVT.INV_ORG_DETAILS_TBL_TYPE IS
98: aPlsqlItem DPP_ITEMCOST_PVT.INV_ORG_DETAILS_TBL_TYPE;
99: BEGIN
100: FOR I IN 1..aSqlItem.COUNT LOOP