DBA Data[Home] [Help]

APPS.OE_INBOUND_INT dependencies on OE_ORDER_PUB_REQUEST_TBL_TYPE

Line 303: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)

299:
300: FUNCTION SQL_TO_PL48(aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE)
301: RETURN OE_ORDER_PUB.REQUEST_REC_TYPE;
302:
303: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
304: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE;
305:
306: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
307: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE;

Line 304: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE;

300: FUNCTION SQL_TO_PL48(aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE)
301: RETURN OE_ORDER_PUB.REQUEST_REC_TYPE;
302:
303: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
304: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE;
305:
306: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
307: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE;
308:

Line 306: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)

302:
303: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
304: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE;
305:
306: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
307: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE;
308:
309: --
310: -- Utility procedures

Line 307: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE;

303: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
304: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE;
305:
306: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
307: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE;
308:
309: --
310: -- Utility procedures
311: --

Line 474: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,

470: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
471: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
472: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
473: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
474: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
475: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
476: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
477: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
478: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,

Line 499: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,

495: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
496: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,
497: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T ,
498: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
499: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,
500: P_RTRIM_DATA VARCHAR2
501: );
502:
503: --

Line 567: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,

563: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
564: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
565: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
566: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
567: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
568: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
569: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
570: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
571: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,

Line 592: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,

588: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
589: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,
590: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T ,
591: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
592: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,
593: P_RTRIM_DATA VARCHAR2
594: );
595:
596: --

Line 658: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,

654: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
655: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
656: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
657: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
658: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
659: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HDR_REC25,
660: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
661: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
662: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,

Line 683: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,

679: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
680: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
681: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
682: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
683: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,
684: P_RTRIM_DATA VARCHAR2
685: );
686: ---------- O2C25
687: