71: END LOOP;
72: RETURN aPlsqlItem;
73: END SQL_TO_PL3;
74: FUNCTION PL_TO_SQL4(aPlsqlItem DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_WH_REC_TYPE)
75: RETURN DPP_COVEREDINVENTORY_PVT_DPP4 IS
76: aSqlItem DPP_COVEREDINVENTORY_PVT_DPP4;
77: BEGIN
78: -- initialize the object
79: aSqlItem := DPP_COVEREDINVENTORY_PVT_DPP4(NULL, NULL, NULL, NULL);
72: RETURN aPlsqlItem;
73: END SQL_TO_PL3;
74: FUNCTION PL_TO_SQL4(aPlsqlItem DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_WH_REC_TYPE)
75: RETURN DPP_COVEREDINVENTORY_PVT_DPP4 IS
76: aSqlItem DPP_COVEREDINVENTORY_PVT_DPP4;
77: BEGIN
78: -- initialize the object
79: aSqlItem := DPP_COVEREDINVENTORY_PVT_DPP4(NULL, NULL, NULL, NULL);
80: aSqlItem.WAREHOUSE_ID := aPlsqlItem.WAREHOUSE_ID;
75: RETURN DPP_COVEREDINVENTORY_PVT_DPP4 IS
76: aSqlItem DPP_COVEREDINVENTORY_PVT_DPP4;
77: BEGIN
78: -- initialize the object
79: aSqlItem := DPP_COVEREDINVENTORY_PVT_DPP4(NULL, NULL, NULL, NULL);
80: aSqlItem.WAREHOUSE_ID := aPlsqlItem.WAREHOUSE_ID;
81: aSqlItem.WAREHOUSE_NAME := aPlsqlItem.WAREHOUSE_NAME;
82: aSqlItem.COVERED_QUANTITY := aPlsqlItem.COVERED_QUANTITY;
83: aSqlItem.RCT_LINE_TBL := PL_TO_SQL3(aPlsqlItem.RCT_LINE_TBL);
82: aSqlItem.COVERED_QUANTITY := aPlsqlItem.COVERED_QUANTITY;
83: aSqlItem.RCT_LINE_TBL := PL_TO_SQL3(aPlsqlItem.RCT_LINE_TBL);
84: RETURN aSqlItem;
85: END PL_TO_SQL4;
86: FUNCTION SQL_TO_PL4(aSqlItem DPP_COVEREDINVENTORY_PVT_DPP4)
87: RETURN DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_WH_REC_TYPE IS
88: aPlsqlItem DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_WH_REC_TYPE;
89: BEGIN
90: aPlsqlItem.WAREHOUSE_ID := aSqlItem.WAREHOUSE_ID;