DBA Data[Home] [Help]

APPS.OE_INBOUND_INT dependencies on OE_ORDER_PUB_HEADER_REC_TYPE

Line 21: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)

17: -- Functions that convert traditional PL/SQL complex types
18: -- (Record, Table, etc.,) to PL/SQL object types (these are the ones
19: -- understood by the web service adapter); and vice-versa.
20: --
21: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
22: RETURN OE_ORDER_PUB_HEADER_REC_TYPE;
23:
24: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
25: RETURN OE_ORDER_PUB.HEADER_REC_TYPE;

Line 22: RETURN OE_ORDER_PUB_HEADER_REC_TYPE;

18: -- (Record, Table, etc.,) to PL/SQL object types (these are the ones
19: -- understood by the web service adapter); and vice-versa.
20: --
21: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
22: RETURN OE_ORDER_PUB_HEADER_REC_TYPE;
23:
24: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
25: RETURN OE_ORDER_PUB.HEADER_REC_TYPE;
26:

Line 24: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)

20: --
21: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
22: RETURN OE_ORDER_PUB_HEADER_REC_TYPE;
23:
24: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
25: RETURN OE_ORDER_PUB.HEADER_REC_TYPE;
26:
27: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
28: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T;

Line 25: RETURN OE_ORDER_PUB.HEADER_REC_TYPE;

21: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
22: RETURN OE_ORDER_PUB_HEADER_REC_TYPE;
23:
24: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
25: RETURN OE_ORDER_PUB.HEADER_REC_TYPE;
26:
27: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
28: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T;
29:

Line 313: PROCEDURE Convert_hdr_null_to_miss (p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type);

309: --
310: -- Utility procedures
311: --
312: PROCEDURE Convert_Line_null_to_miss(p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type);
313: PROCEDURE Convert_hdr_null_to_miss (p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type);
314:
315: --
316: -- Webservice Adapter wrapper for Oe_Order_Pub.Process_Order(...) API
317: -- with the newer signature.

Line 426: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

422: P_RETURN_VALUES VARCHAR2,
423: P_ACTION_COMMIT VARCHAR2,
424: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
425: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
426: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
427: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
428: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
429: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
430: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 427: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

423: P_ACTION_COMMIT VARCHAR2,
424: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
425: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
426: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
427: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
428: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
429: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
430: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
431: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 475: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,

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 ,
479: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,

Line 519: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

515: P_ACTION_COMMIT VARCHAR2,
516: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
517: X_MSG_COUNT OUT NOCOPY NUMBER,
518: X_MSG_DATA OUT NOCOPY VARCHAR2,
519: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
520: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
521: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
522: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
523: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 520: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

516: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
517: X_MSG_COUNT OUT NOCOPY NUMBER,
518: X_MSG_DATA OUT NOCOPY VARCHAR2,
519: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
520: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
521: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
522: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
523: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
524: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 568: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,

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 ,
572: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,

Line 610: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

606: P_RETURN_VALUES VARCHAR2,
607: P_ACTION_COMMIT VARCHAR2,
608: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
609: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
610: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
611: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
612: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
613: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
614: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 611: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

607: P_ACTION_COMMIT VARCHAR2,
608: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
609: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
610: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
611: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
612: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
613: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
614: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
615: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,