224: aPlsqlItem := oe_inbound_int.SQL_TO_PL8(aSqlItem);
225: RETURN aPlsqlItem;
226: END SQL_TO_PL8;
227:
228: FUNCTION PL_TO_SQL32(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE)
229: RETURN OE_ORDER_PUB_HEADER_SCREDIT11 IS
230: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11;
231: BEGIN
232: aSqlItem := oe_inbound_int.PL_TO_SQL32(aPlsqlItem);
233: RETURN aSqlItem;
234: END PL_TO_SQL32;
235:
236: FUNCTION SQL_TO_PL32(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11)
237: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE IS
238: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE;
239: BEGIN
240: aPlsqlItem := oe_inbound_int.SQL_TO_PL32(aSqlItem);
241: RETURN aPlsqlItem;
234: END PL_TO_SQL32;
235:
236: FUNCTION SQL_TO_PL32(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11)
237: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE IS
238: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE;
239: BEGIN
240: aPlsqlItem := oe_inbound_int.SQL_TO_PL32(aSqlItem);
241: RETURN aPlsqlItem;
242: END SQL_TO_PL32;
240: aPlsqlItem := oe_inbound_int.SQL_TO_PL32(aSqlItem);
241: RETURN aPlsqlItem;
242: END SQL_TO_PL32;
243:
244: FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)
245: RETURN OE_ORDER_PUB_HEADER_SCREDIT_V IS
246: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V;
247: BEGIN
248: aSqlItem := oe_inbound_int.PL_TO_SQL9(aPlsqlItem);
241: RETURN aPlsqlItem;
242: END SQL_TO_PL32;
243:
244: FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)
245: RETURN OE_ORDER_PUB_HEADER_SCREDIT_V IS
246: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V;
247: BEGIN
248: aSqlItem := oe_inbound_int.PL_TO_SQL9(aPlsqlItem);
249: RETURN aSqlItem;
242: END SQL_TO_PL32;
243:
244: FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)
245: RETURN OE_ORDER_PUB_HEADER_SCREDIT_V IS
246: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V;
247: BEGIN
248: aSqlItem := oe_inbound_int.PL_TO_SQL9(aPlsqlItem);
249: RETURN aSqlItem;
250: END PL_TO_SQL9;
248: aSqlItem := oe_inbound_int.PL_TO_SQL9(aPlsqlItem);
249: RETURN aSqlItem;
250: END PL_TO_SQL9;
251:
252: FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)
253: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE IS
254: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
255: BEGIN
256: aPlsqlItem := oe_inbound_int.SQL_TO_PL9(aSqlItem);
249: RETURN aSqlItem;
250: END PL_TO_SQL9;
251:
252: FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)
253: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE IS
254: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
255: BEGIN
256: aPlsqlItem := oe_inbound_int.SQL_TO_PL9(aSqlItem);
257: RETURN aPlsqlItem;
250: END PL_TO_SQL9;
251:
252: FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)
253: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE IS
254: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
255: BEGIN
256: aPlsqlItem := oe_inbound_int.SQL_TO_PL9(aSqlItem);
257: RETURN aPlsqlItem;
258: END SQL_TO_PL9;
793: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
794: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
795: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
796: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
797: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
798: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
799: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
800: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
801: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
794: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
795: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
796: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
797: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
798: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
799: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
800: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
801: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
802: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
834: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
835: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
836: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,
837: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,
838: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
839: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
840: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
841: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,
842: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,