54: aPlsqlItem.INVOICE_CURRENCY_CODE := aSqlItem.INVOICE_CURRENCY_CODE;
55: RETURN aPlsqlItem;
56: END SQL_TO_PL12;
57: FUNCTION PL_TO_SQL12(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE)
58: RETURN DPPCUSTOMERCLAIMSPVTDPP12_DPP IS
59: aSqlItem DPPCUSTOMERCLAIMSPVTDPP12_DPP;
60: BEGIN
61: -- initialize the table
62: aSqlItem := DPPCUSTOMERCLAIMSPVTDPP12_DPP();
55: RETURN aPlsqlItem;
56: END SQL_TO_PL12;
57: FUNCTION PL_TO_SQL12(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE)
58: RETURN DPPCUSTOMERCLAIMSPVTDPP12_DPP IS
59: aSqlItem DPPCUSTOMERCLAIMSPVTDPP12_DPP;
60: BEGIN
61: -- initialize the table
62: aSqlItem := DPPCUSTOMERCLAIMSPVTDPP12_DPP();
63: aSqlItem.EXTEND(aPlsqlItem.COUNT);
58: RETURN DPPCUSTOMERCLAIMSPVTDPP12_DPP IS
59: aSqlItem DPPCUSTOMERCLAIMSPVTDPP12_DPP;
60: BEGIN
61: -- initialize the table
62: aSqlItem := DPPCUSTOMERCLAIMSPVTDPP12_DPP();
63: aSqlItem.EXTEND(aPlsqlItem.COUNT);
64: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
65: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL11(aPlsqlItem(I));
66: END LOOP;
65: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL11(aPlsqlItem(I));
66: END LOOP;
67: RETURN aSqlItem;
68: END PL_TO_SQL12;
69: FUNCTION SQL_TO_PL13(aSqlItem DPPCUSTOMERCLAIMSPVTDPP12_DPP)
70: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE IS
71: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE;
72: BEGIN
73: FOR I IN 1..aSqlItem.COUNT LOOP