34: aPlsqlItem := oe_outbound_int.SQL_TO_PL0(aSqlItem);
35: RETURN aPlsqlItem;
36: END SQL_TO_PL0;
37:
38: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
39: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC IS
40: aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC;
41: BEGIN
42: aSqlItem := oe_outbound_int.PL_TO_SQL3(aPlsqlItem);
35: RETURN aPlsqlItem;
36: END SQL_TO_PL0;
37:
38: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
39: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC IS
40: aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC;
41: BEGIN
42: aSqlItem := oe_outbound_int.PL_TO_SQL3(aPlsqlItem);
43: RETURN aSqlItem;
36: END SQL_TO_PL0;
37:
38: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
39: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC IS
40: aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC;
41: BEGIN
42: aSqlItem := oe_outbound_int.PL_TO_SQL3(aPlsqlItem);
43: RETURN aSqlItem;
44: END PL_TO_SQL3;
42: aSqlItem := oe_outbound_int.PL_TO_SQL3(aPlsqlItem);
43: RETURN aSqlItem;
44: END PL_TO_SQL3;
45:
46: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
47: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE IS
48: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
49: BEGIN
50: aPlsqlItem := oe_outbound_int.SQL_TO_PL3(aSqlItem);
43: RETURN aSqlItem;
44: END PL_TO_SQL3;
45:
46: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
47: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE IS
48: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
49: BEGIN
50: aPlsqlItem := oe_outbound_int.SQL_TO_PL3(aSqlItem);
51: RETURN aPlsqlItem;
44: END PL_TO_SQL3;
45:
46: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
47: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE IS
48: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
49: BEGIN
50: aPlsqlItem := oe_outbound_int.SQL_TO_PL3(aSqlItem);
51: RETURN aPlsqlItem;
52: END SQL_TO_PL3;
50: aPlsqlItem := oe_outbound_int.SQL_TO_PL3(aSqlItem);
51: RETURN aPlsqlItem;
52: END SQL_TO_PL3;
53:
54: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE)
55: RETURN OE_SYNC_ORDER_PVT_LINE_ACK_TB IS
56: aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB;
57: BEGIN
58: aSqlItem := oe_outbound_int.PL_TO_SQL1(aPlsqlItem);
59: RETURN aSqlItem;
60: END PL_TO_SQL1;
61:
62: FUNCTION SQL_TO_PL1(aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB)
63: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE IS
64: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;
65: BEGIN
66: aPlsqlItem := oe_outbound_int.SQL_TO_PL1(aSqlItem);
67: RETURN aPlsqlItem;
60: END PL_TO_SQL1;
61:
62: FUNCTION SQL_TO_PL1(aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB)
63: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE IS
64: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;
65: BEGIN
66: aPlsqlItem := oe_outbound_int.SQL_TO_PL1(aSqlItem);
67: RETURN aPlsqlItem;
68: END SQL_TO_PL1;