DBA Data[Home] [Help]

APPS.XX_BPEL_CALLPROCESSORDEREBS11I dependencies on OE_ORDER_PUB_LOT_SERIAL_TBL_T

Line 694: FUNCTION PL_TO_SQL23(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE)

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

Line 695: RETURN OE_ORDER_PUB_LOT_SERIAL_TBL_T IS

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;

Line 696: aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T;

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;

Line 702: FUNCTION SQL_TO_PL23(aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T)

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

Line 703: RETURN OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE IS

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;

Line 704: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;

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;

Line 825: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,

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,

Line 826: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,

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,

Line 852: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,

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