8:
9: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
10: RETURN OE_ORDER_PUB.HEADER_REC_TYPE;
11:
12: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
13: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T;
14:
15: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
16: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
9: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
10: RETURN OE_ORDER_PUB.HEADER_REC_TYPE;
11:
12: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
13: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T;
14:
15: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
16: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
17:
11:
12: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
13: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T;
14:
15: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
16: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
17:
18: FUNCTION PL_TO_SQL26(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE)
19: RETURN OE_ORDER_PUB_HEADER_ADJ_REC_T;
12: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
13: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T;
14:
15: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
16: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
17:
18: FUNCTION PL_TO_SQL26(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE)
19: RETURN OE_ORDER_PUB_HEADER_ADJ_REC_T;
20:
303: X_MSG_COUNT OUT NOCOPY NUMBER,
304: X_MSG_DATA OUT NOCOPY VARCHAR2,
305: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
306: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
307: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
308: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
309: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
310: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
311: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
304: X_MSG_DATA OUT NOCOPY VARCHAR2,
305: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
306: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
307: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
308: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
309: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
310: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
311: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
312: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
351: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
352: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
353: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
354: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,
355: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
356: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
357: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
358: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
359: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,