DBA Data[Home] [Help]

APPS.OE_INBOUND_INT dependencies on OE_ORDER_PUB_HEADER_REC_TYPE

Line 13: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)

9: -- Functions that convert traditional PL/SQL complex types
10: -- (Record, Table, etc.,) to PL/SQL object types (these are the ones
11: -- understood by the web service adapter); and vice-versa.
12: --
13: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
14: RETURN OE_ORDER_PUB_HEADER_REC_TYPE;
15:
16: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
17: RETURN OE_ORDER_PUB.HEADER_REC_TYPE;

Line 14: RETURN OE_ORDER_PUB_HEADER_REC_TYPE;

10: -- (Record, Table, etc.,) to PL/SQL object types (these are the ones
11: -- understood by the web service adapter); and vice-versa.
12: --
13: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
14: RETURN OE_ORDER_PUB_HEADER_REC_TYPE;
15:
16: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
17: RETURN OE_ORDER_PUB.HEADER_REC_TYPE;
18:

Line 16: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)

12: --
13: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
14: RETURN OE_ORDER_PUB_HEADER_REC_TYPE;
15:
16: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
17: RETURN OE_ORDER_PUB.HEADER_REC_TYPE;
18:
19: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
20: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T;

Line 17: RETURN OE_ORDER_PUB.HEADER_REC_TYPE;

13: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
14: RETURN OE_ORDER_PUB_HEADER_REC_TYPE;
15:
16: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
17: RETURN OE_ORDER_PUB.HEADER_REC_TYPE;
18:
19: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
20: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T;
21:

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

301: --
302: -- Utility procedures
303: --
304: PROCEDURE Convert_Line_null_to_miss(p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type);
305: PROCEDURE Convert_hdr_null_to_miss (p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type);
306:
307: --
308: -- Webservice Adapter wrapper for Oe_Order_Pub.Process_Order(...) API
309: -- with the newer signature.

Line 318: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

314: P_RETURN_VALUES VARCHAR2,
315: P_ACTION_COMMIT VARCHAR2,
316: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
317: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
318: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
319: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
320: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
321: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
322: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 319: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

315: P_ACTION_COMMIT VARCHAR2,
316: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
317: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
318: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
319: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
320: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
321: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
322: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
323: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 367: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,

363: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
364: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
365: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
366: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
367: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
368: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
369: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
370: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
371: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,

Line 411: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

407: P_ACTION_COMMIT VARCHAR2,
408: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
409: X_MSG_COUNT OUT NOCOPY NUMBER,
410: X_MSG_DATA OUT NOCOPY VARCHAR2,
411: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
412: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
413: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
414: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
415: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 412: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

408: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
409: X_MSG_COUNT OUT NOCOPY NUMBER,
410: X_MSG_DATA OUT NOCOPY VARCHAR2,
411: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
412: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
413: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
414: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
415: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
416: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 460: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,

456: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
457: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
458: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
459: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
460: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
461: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
462: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
463: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
464: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,