DBA Data[Home] [Help]

APPS.XX_BPEL_CALLPROCESSORDEREBS11I dependencies on OE_ORDER_PUB_REQUEST_TBL_TYPE

Line 758: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)

754: aPlsqlItem := oe_inbound_int.SQL_TO_PL48(aSqlItem);
755: RETURN aPlsqlItem;
756: END SQL_TO_PL48;
757:
758: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
759: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE IS
760: aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE;
761: BEGIN
762: aSqlItem := oe_inbound_int.PL_TO_SQL25(aPlsqlItem);

Line 759: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE IS

755: RETURN aPlsqlItem;
756: END SQL_TO_PL48;
757:
758: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
759: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE IS
760: aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE;
761: BEGIN
762: aSqlItem := oe_inbound_int.PL_TO_SQL25(aPlsqlItem);
763: RETURN aSqlItem;

Line 760: aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE;

756: END SQL_TO_PL48;
757:
758: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
759: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE IS
760: aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE;
761: BEGIN
762: aSqlItem := oe_inbound_int.PL_TO_SQL25(aPlsqlItem);
763: RETURN aSqlItem;
764: END PL_TO_SQL25;

Line 766: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)

762: aSqlItem := oe_inbound_int.PL_TO_SQL25(aPlsqlItem);
763: RETURN aSqlItem;
764: END PL_TO_SQL25;
765:
766: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
767: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE IS
768: aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE;
769: BEGIN
770: aPlsqlItem := oe_inbound_int.SQL_TO_PL25(aSqlItem);

Line 767: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE IS

763: RETURN aSqlItem;
764: END PL_TO_SQL25;
765:
766: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
767: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE IS
768: aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE;
769: BEGIN
770: aPlsqlItem := oe_inbound_int.SQL_TO_PL25(aSqlItem);
771: RETURN aPlsqlItem;

Line 768: aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE;

764: END PL_TO_SQL25;
765:
766: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
767: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE IS
768: aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE;
769: BEGIN
770: aPlsqlItem := oe_inbound_int.SQL_TO_PL25(aSqlItem);
771: RETURN aPlsqlItem;
772: END SQL_TO_PL25;

Line 829: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,

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,
833: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,

Line 854: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,

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
858: BEGIN