722: aPlsqlItem := oe_inbound_int.SQL_TO_PL47(aSqlItem);
723: RETURN aPlsqlItem;
724: END SQL_TO_PL47;
725:
726: FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)
727: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T IS
728: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T;
729: BEGIN
730: aSqlItem := oe_inbound_int.PL_TO_SQL24(aPlsqlItem);
723: RETURN aPlsqlItem;
724: END SQL_TO_PL47;
725:
726: FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)
727: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T IS
728: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T;
729: BEGIN
730: aSqlItem := oe_inbound_int.PL_TO_SQL24(aPlsqlItem);
731: RETURN aSqlItem;
724: END SQL_TO_PL47;
725:
726: FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)
727: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T IS
728: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T;
729: BEGIN
730: aSqlItem := oe_inbound_int.PL_TO_SQL24(aPlsqlItem);
731: RETURN aSqlItem;
732: END PL_TO_SQL24;
730: aSqlItem := oe_inbound_int.PL_TO_SQL24(aPlsqlItem);
731: RETURN aSqlItem;
732: END PL_TO_SQL24;
733:
734: FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)
735: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE IS
736: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
737: BEGIN
738: aPlsqlItem := oe_inbound_int.SQL_TO_PL24(aSqlItem);
731: RETURN aSqlItem;
732: END PL_TO_SQL24;
733:
734: FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)
735: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE IS
736: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
737: BEGIN
738: aPlsqlItem := oe_inbound_int.SQL_TO_PL24(aSqlItem);
739: RETURN aPlsqlItem;
732: END PL_TO_SQL24;
733:
734: FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)
735: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE IS
736: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
737: BEGIN
738: aPlsqlItem := oe_inbound_int.SQL_TO_PL24(aSqlItem);
739: RETURN aPlsqlItem;
740: END SQL_TO_PL24;
823: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
824: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
825: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
826: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
827: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
828: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
829: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
830: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,
831: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
824: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
825: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
826: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
827: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
828: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
829: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
830: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,
831: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
832: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
849: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
850: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
851: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
852: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
853: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T,
854: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,
855: P_RTRIM_DATA VARCHAR2
856: )
857: IS