DBA Data[Home] [Help]

APPS.OE_OUTBOUND_INT dependencies on OE_ACKNOWLEDGMENT_PUB_HEADER_

Line 4: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)

1: PACKAGE BODY Oe_Outbound_Int AS
2: /* $Header: OEXOEOBB.pls 120.4 2011/04/25 07:04:08 snimmaga ship $ */
3:
4: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
5: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS
6: aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;
7: BEGIN
8: -- initialize the object

Line 5: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS

1: PACKAGE BODY Oe_Outbound_Int AS
2: /* $Header: OEXOEOBB.pls 120.4 2011/04/25 07:04:08 snimmaga ship $ */
3:
4: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
5: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS
6: aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;
7: BEGIN
8: -- initialize the object
9: aSqlItem := OE_ACKNOWLEDGMENT_PUB_HEADER_(NULL, NULL, NULL, NULL, NULL,

Line 6: aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;

2: /* $Header: OEXOEOBB.pls 120.4 2011/04/25 07:04:08 snimmaga ship $ */
3:
4: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
5: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS
6: aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;
7: BEGIN
8: -- initialize the object
9: aSqlItem := OE_ACKNOWLEDGMENT_PUB_HEADER_(NULL, NULL, NULL, NULL, NULL,
10: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 9: aSqlItem := OE_ACKNOWLEDGMENT_PUB_HEADER_(NULL, NULL, NULL, NULL, NULL,

5: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS
6: aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;
7: BEGIN
8: -- initialize the object
9: aSqlItem := OE_ACKNOWLEDGMENT_PUB_HEADER_(NULL, NULL, NULL, NULL, NULL,
10: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
11: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
12: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
13: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 380: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)

376: aSqlItem.ACCOUNTING_RULE := aPlsqlItem.ACCOUNTING_RULE;
377: aSqlItem.ACKNOWLEDGMENT_FLAG := aPlsqlItem.ACKNOWLEDGMENT_FLAG;
378: RETURN aSqlItem;
379: END PL_TO_SQL2;
380: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
381: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE IS
382: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
383: BEGIN
384: aPlsqlItem.IB_OWNER_CODE := aSqlItem.IB_OWNER_CODE;

Line 381: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE IS

377: aSqlItem.ACKNOWLEDGMENT_FLAG := aPlsqlItem.ACKNOWLEDGMENT_FLAG;
378: RETURN aSqlItem;
379: END PL_TO_SQL2;
380: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
381: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE IS
382: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
383: BEGIN
384: aPlsqlItem.IB_OWNER_CODE := aSqlItem.IB_OWNER_CODE;
385: aPlsqlItem.IB_CURRENT_LOCATION_CODE := aSqlItem.IB_CURRENT_LOCATION_CODE;

Line 382: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;

378: RETURN aSqlItem;
379: END PL_TO_SQL2;
380: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
381: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE IS
382: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
383: BEGIN
384: aPlsqlItem.IB_OWNER_CODE := aSqlItem.IB_OWNER_CODE;
385: aPlsqlItem.IB_CURRENT_LOCATION_CODE := aSqlItem.IB_CURRENT_LOCATION_CODE;
386: aPlsqlItem.IB_INSTALLED_AT_LOCATION_CODE := aSqlItem.IB_INSTALLED_AT_LOCATION_CODE;

Line 727: FUNCTION PL_TO_SQL0(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE)

723: aPlsqlItem.ACCOUNTING_RULE := aSqlItem.ACCOUNTING_RULE;
724: aPlsqlItem.ACKNOWLEDGMENT_FLAG := aSqlItem.ACKNOWLEDGMENT_FLAG;
725: RETURN aPlsqlItem;
726: END SQL_TO_PL2;
727: FUNCTION PL_TO_SQL0(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE)
728: RETURN OE_SYNC_ORDER_PVT_HEADER_ACK_ IS
729: aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_;
730: BEGIN
731: -- initialize the table

Line 740: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE IS

736: END LOOP;
737: RETURN aSqlItem;
738: END PL_TO_SQL0;
739: FUNCTION SQL_TO_PL0(aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_)
740: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE IS
741: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
742: BEGIN
743: FOR I IN 1..aSqlItem.COUNT LOOP
744: aPlsqlItem(I) := SQL_TO_PL2(aSqlItem(I));

Line 741: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;

737: RETURN aSqlItem;
738: END PL_TO_SQL0;
739: FUNCTION SQL_TO_PL0(aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_)
740: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE IS
741: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
742: BEGIN
743: FOR I IN 1..aSqlItem.COUNT LOOP
744: aPlsqlItem(I) := SQL_TO_PL2(aSqlItem(I));
745: END LOOP;

Line 1861: P_HDR_ACK_TBL_ OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;

1857: X_MSG_COUNT OUT NOCOPY NUMBER,
1858: X_MSG_DATA OUT NOCOPY VARCHAR2)
1859: IS
1860:
1861: P_HDR_ACK_TBL_ OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
1862: P_LINE_ACK_TBL_ OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;
1863: BEGIN
1864:
1865: oe_debug_pub.add('Entering Procedure Sync_Order');