DBA Data[Home] [Help]

APPS.XX_BPEL_CALLPROCESSORDEREBS11I dependencies on OE_ORDER_PUB_LOT_SERIAL_VAL_T

Line 726: FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)

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);

Line 727: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T IS

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;

Line 728: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T;

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;

Line 734: FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)

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);

Line 735: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE IS

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;

Line 736: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;

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;

Line 827: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

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,

Line 828: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_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,

Line 853: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_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