4779: NULL;
4780: END;
4781: RETURN aPlsqlItem;
4782: END SQL_TO_PL23;
4783: FUNCTION PL_TO_SQL47(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE)
4784: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_R IS
4785: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R;
4786: BEGIN
4787: aSqlItem := OE_ORDER_PUB_LOT_SERIAL_VAL_R(NULL, NULL);
4780: END;
4781: RETURN aPlsqlItem;
4782: END SQL_TO_PL23;
4783: FUNCTION PL_TO_SQL47(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE)
4784: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_R IS
4785: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R;
4786: BEGIN
4787: aSqlItem := OE_ORDER_PUB_LOT_SERIAL_VAL_R(NULL, NULL);
4788: aSqlItem.LINE := aPlsqlItem.LINE;
4781: RETURN aPlsqlItem;
4782: END SQL_TO_PL23;
4783: FUNCTION PL_TO_SQL47(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE)
4784: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_R IS
4785: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R;
4786: BEGIN
4787: aSqlItem := OE_ORDER_PUB_LOT_SERIAL_VAL_R(NULL, NULL);
4788: aSqlItem.LINE := aPlsqlItem.LINE;
4789: aSqlItem.LOT_SERIAL := aPlsqlItem.LOT_SERIAL;
4783: FUNCTION PL_TO_SQL47(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE)
4784: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_R IS
4785: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R;
4786: BEGIN
4787: aSqlItem := OE_ORDER_PUB_LOT_SERIAL_VAL_R(NULL, NULL);
4788: aSqlItem.LINE := aPlsqlItem.LINE;
4789: aSqlItem.LOT_SERIAL := aPlsqlItem.LOT_SERIAL;
4790: RETURN aSqlItem;
4791: END PL_TO_SQL47;
4788: aSqlItem.LINE := aPlsqlItem.LINE;
4789: aSqlItem.LOT_SERIAL := aPlsqlItem.LOT_SERIAL;
4790: RETURN aSqlItem;
4791: END PL_TO_SQL47;
4792: FUNCTION SQL_TO_PL47(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R)
4793: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE IS
4794: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE;
4795: BEGIN
4796: aPlsqlItem.LINE := aSqlItem.LINE;
4789: aSqlItem.LOT_SERIAL := aPlsqlItem.LOT_SERIAL;
4790: RETURN aSqlItem;
4791: END PL_TO_SQL47;
4792: FUNCTION SQL_TO_PL47(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R)
4793: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE IS
4794: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE;
4795: BEGIN
4796: aPlsqlItem.LINE := aSqlItem.LINE;
4797: aPlsqlItem.LOT_SERIAL := aSqlItem.LOT_SERIAL;
4790: RETURN aSqlItem;
4791: END PL_TO_SQL47;
4792: FUNCTION SQL_TO_PL47(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R)
4793: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE IS
4794: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE;
4795: BEGIN
4796: aPlsqlItem.LINE := aSqlItem.LINE;
4797: aPlsqlItem.LOT_SERIAL := aSqlItem.LOT_SERIAL;
4798: RETURN aPlsqlItem;