DBA Data[Home] [Help]

APPS.OE_INBOUND_INT dependencies on OE_ORDER_PUB_HEADER_VAL_REC_T

Line 687: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)

683:
684: RETURN aPlsqlItem;
685: END SQL_TO_PL1;
686:
687: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
688: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS
689: aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;
690: BEGIN
691: aSqlItem := OE_ORDER_PUB_HEADER_VAL_REC_T(NULL, NULL, NULL, NULL, NULL, NULL

Line 688: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS

684: RETURN aPlsqlItem;
685: END SQL_TO_PL1;
686:
687: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
688: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS
689: aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;
690: BEGIN
691: aSqlItem := OE_ORDER_PUB_HEADER_VAL_REC_T(NULL, NULL, NULL, NULL, NULL, NULL
692: , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL

Line 689: aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;

685: END SQL_TO_PL1;
686:
687: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
688: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS
689: aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;
690: BEGIN
691: aSqlItem := OE_ORDER_PUB_HEADER_VAL_REC_T(NULL, NULL, NULL, NULL, NULL, NULL
692: , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
693: , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL

Line 691: aSqlItem := OE_ORDER_PUB_HEADER_VAL_REC_T(NULL, NULL, NULL, NULL, NULL, NULL

687: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
688: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS
689: aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;
690: BEGIN
691: aSqlItem := OE_ORDER_PUB_HEADER_VAL_REC_T(NULL, NULL, NULL, NULL, NULL, NULL
692: , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
693: , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
694: , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
695: , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL

Line 854: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)

850: aSqlItem.AUTHORING_PARTY := aPlsqlItem.AUTHORING_PARTY;
851: RETURN aSqlItem;
852: END PL_TO_SQL2;
853:
854: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
855: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE IS
856: aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
857: BEGIN
858: aPlsqlItem.ACCOUNTING_RULE := aSqlItem.ACCOUNTING_RULE;

Line 855: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE IS

851: RETURN aSqlItem;
852: END PL_TO_SQL2;
853:
854: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
855: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE IS
856: aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
857: BEGIN
858: aPlsqlItem.ACCOUNTING_RULE := aSqlItem.ACCOUNTING_RULE;
859: aPlsqlItem.AGREEMENT := aSqlItem.AGREEMENT;

Line 856: aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE;

852: END PL_TO_SQL2;
853:
854: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
855: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE IS
856: aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
857: BEGIN
858: aPlsqlItem.ACCOUNTING_RULE := aSqlItem.ACCOUNTING_RULE;
859: aPlsqlItem.AGREEMENT := aSqlItem.AGREEMENT;
860: aPlsqlItem.CONVERSION_TYPE := aSqlItem.CONVERSION_TYPE;

Line 4991: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,

4987: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
4988: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
4989: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4990: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4991: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4992: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4993: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
4994: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
4995: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

Line 4992: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,

4988: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
4989: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4990: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4991: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4992: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4993: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
4994: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
4995: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
4996: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

Line 5039: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,

5035: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5036: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5037: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
5038: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HDR_REC25,
5039: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
5040: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5041: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
5042: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
5043: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,

Line 5777: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,

5773: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
5774: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
5775: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5776: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5777: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5778: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5779: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5780: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5781: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

Line 5778: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,

5774: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
5775: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5776: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5777: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5778: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5779: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5780: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5781: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
5782: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

Line 5825: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,

5821: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5822: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5823: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
5824: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
5825: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
5826: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
5827: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
5828: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,
5829: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T ,

Line 5854: P_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;

5850: )
5851: IS
5852: P_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;
5853: P_OLD_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;
5854: P_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5855: P_OLD_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5856: P_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
5857: P_OLD_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
5858: P_HEADER_ADJ_VAL_TBL_ OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;

Line 5855: P_OLD_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;

5851: IS
5852: P_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;
5853: P_OLD_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;
5854: P_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5855: P_OLD_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5856: P_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
5857: P_OLD_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
5858: P_HEADER_ADJ_VAL_TBL_ OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
5859: P_OLD_HEADER_ADJ_VAL_TBL_ OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;

Line 5902: X_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;

5898: P_LOT_SERIAL_VAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
5899: P_OLD_LOT_SERIAL_VAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
5900: P_ACTION_REQUEST_TBL_ OE_ORDER_PUB.REQUEST_TBL_TYPE;
5901: X_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;
5902: X_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5903: X_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
5904: X_HEADER_ADJ_VAL_TBL_ OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
5905: X_HEADER_PRICE_ATT_TBL_ OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
5906: X_HEADER_ADJ_ATT_TBL_ OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;

Line 6397: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,

6393: X_MSG_COUNT OUT NOCOPY NUMBER ,
6394: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
6395: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
6396: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
6397: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
6398: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
6399: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
6400: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
6401: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

Line 6398: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,

6394: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
6395: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
6396: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
6397: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
6398: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
6399: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
6400: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
6401: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
6402: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

Line 6445: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,

6441: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
6442: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
6443: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
6444: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
6445: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
6446: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
6447: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
6448: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,
6449: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T ,