690: aPlsqlItem := oe_inbound_int.SQL_TO_PL46(aSqlItem);
691: RETURN aPlsqlItem;
692: END SQL_TO_PL46;
693:
694: FUNCTION PL_TO_SQL23(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE)
695: RETURN OE_ORDER_PUB_LOT_SERIAL_TBL_T IS
696: aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T;
697: BEGIN
698: aSqlItem := oe_inbound_int.PL_TO_SQL23(aPlsqlItem);
691: RETURN aPlsqlItem;
692: END SQL_TO_PL46;
693:
694: FUNCTION PL_TO_SQL23(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE)
695: RETURN OE_ORDER_PUB_LOT_SERIAL_TBL_T IS
696: aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T;
697: BEGIN
698: aSqlItem := oe_inbound_int.PL_TO_SQL23(aPlsqlItem);
699: RETURN aSqlItem;
692: END SQL_TO_PL46;
693:
694: FUNCTION PL_TO_SQL23(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE)
695: RETURN OE_ORDER_PUB_LOT_SERIAL_TBL_T IS
696: aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T;
697: BEGIN
698: aSqlItem := oe_inbound_int.PL_TO_SQL23(aPlsqlItem);
699: RETURN aSqlItem;
700: END PL_TO_SQL23;
698: aSqlItem := oe_inbound_int.PL_TO_SQL23(aPlsqlItem);
699: RETURN aSqlItem;
700: END PL_TO_SQL23;
701:
702: FUNCTION SQL_TO_PL23(aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T)
703: RETURN OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE IS
704: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
705: BEGIN
706: aPlsqlItem := oe_inbound_int.SQL_TO_PL23(aSqlItem);
699: RETURN aSqlItem;
700: END PL_TO_SQL23;
701:
702: FUNCTION SQL_TO_PL23(aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T)
703: RETURN OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE IS
704: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
705: BEGIN
706: aPlsqlItem := oe_inbound_int.SQL_TO_PL23(aSqlItem);
707: RETURN aPlsqlItem;
700: END PL_TO_SQL23;
701:
702: FUNCTION SQL_TO_PL23(aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T)
703: RETURN OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE IS
704: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
705: BEGIN
706: aPlsqlItem := oe_inbound_int.SQL_TO_PL23(aSqlItem);
707: RETURN aPlsqlItem;
708: END SQL_TO_PL23;
821: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
822: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
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,
822: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
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,
848: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
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: )