DBA Data[Home] [Help]

APPS.DPP_BPEL_UPDATEPO dependencies on DPP_PURCHASEPRICE_PVT_DPP_TXN

Line 3: FUNCTION PL_TO_SQL14(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE)

1: PACKAGE BODY DPP_BPEL_UPDATEPO AS
2: /* $Header: dppvbudb.pls 120.3 2007/12/18 13:18:00 assoni noship $ */
3: FUNCTION PL_TO_SQL14(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE)
4: RETURN DPP_PURCHASEPRICE_PVT_DPP_TXN IS
5: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN;
6: BEGIN
7: -- initialize the object

Line 4: RETURN DPP_PURCHASEPRICE_PVT_DPP_TXN IS

1: PACKAGE BODY DPP_BPEL_UPDATEPO AS
2: /* $Header: dppvbudb.pls 120.3 2007/12/18 13:18:00 assoni noship $ */
3: FUNCTION PL_TO_SQL14(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE)
4: RETURN DPP_PURCHASEPRICE_PVT_DPP_TXN IS
5: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_TXN(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Line 5: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN;

1: PACKAGE BODY DPP_BPEL_UPDATEPO AS
2: /* $Header: dppvbudb.pls 120.3 2007/12/18 13:18:00 assoni noship $ */
3: FUNCTION PL_TO_SQL14(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE)
4: RETURN DPP_PURCHASEPRICE_PVT_DPP_TXN IS
5: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_TXN(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
9: aSqlItem.TRANSACTION_HEADER_ID := aPlsqlItem.TRANSACTION_HEADER_ID;

Line 8: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_TXN(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

4: RETURN DPP_PURCHASEPRICE_PVT_DPP_TXN IS
5: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_TXN(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
9: aSqlItem.TRANSACTION_HEADER_ID := aPlsqlItem.TRANSACTION_HEADER_ID;
10: aSqlItem.TRANSACTION_NUMBER := aPlsqlItem.TRANSACTION_NUMBER;
11: aSqlItem.ORG_ID := aPlsqlItem.ORG_ID;
12: aSqlItem.VENDOR_ID := aPlsqlItem.VENDOR_ID;

Line 35: FUNCTION SQL_TO_PL14(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN)

31: aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
32: aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
33: RETURN aSqlItem;
34: END PL_TO_SQL14;
35: FUNCTION SQL_TO_PL14(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN)
36: RETURN DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE IS
37: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
38: BEGIN
39: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;

Line 36: RETURN DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE IS

32: aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
33: RETURN aSqlItem;
34: END PL_TO_SQL14;
35: FUNCTION SQL_TO_PL14(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN)
36: RETURN DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE IS
37: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
38: BEGIN
39: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;
40: aPlsqlItem.TRANSACTION_NUMBER := aSqlItem.TRANSACTION_NUMBER;

Line 37: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;

33: RETURN aSqlItem;
34: END PL_TO_SQL14;
35: FUNCTION SQL_TO_PL14(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN)
36: RETURN DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE IS
37: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
38: BEGIN
39: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;
40: aPlsqlItem.TRANSACTION_NUMBER := aSqlItem.TRANSACTION_NUMBER;
41: aPlsqlItem.ORG_ID := aSqlItem.ORG_ID;

Line 194: X_MSG_DATA OUT NOCOPY VARCHAR2,P_ITEM_PRICE_REC DPP_PURCHASEPRICE_PVT_DPP_TXN,P_ITEM_COST_TBL DPP_PURCHASEPRICE_PVT_DPP_ITE) IS

190: END SQL_TO_PL15;
191:
192: PROCEDURE DPP_PURCHASEPRICE_PVT$UPDATE_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
193: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
194: X_MSG_DATA OUT NOCOPY VARCHAR2,P_ITEM_PRICE_REC DPP_PURCHASEPRICE_PVT_DPP_TXN,P_ITEM_COST_TBL DPP_PURCHASEPRICE_PVT_DPP_ITE) IS
195: P_ITEM_PRICE_REC_ DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
196: P_ITEM_COST_TBL_ DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE;
197: BEGIN
198: P_ITEM_PRICE_REC_ := DPP_BPEL_UPDATEPO.SQL_TO_PL14(P_ITEM_PRICE_REC);

Line 195: P_ITEM_PRICE_REC_ DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;

191:
192: PROCEDURE DPP_PURCHASEPRICE_PVT$UPDATE_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
193: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
194: X_MSG_DATA OUT NOCOPY VARCHAR2,P_ITEM_PRICE_REC DPP_PURCHASEPRICE_PVT_DPP_TXN,P_ITEM_COST_TBL DPP_PURCHASEPRICE_PVT_DPP_ITE) IS
195: P_ITEM_PRICE_REC_ DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
196: P_ITEM_COST_TBL_ DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE;
197: BEGIN
198: P_ITEM_PRICE_REC_ := DPP_BPEL_UPDATEPO.SQL_TO_PL14(P_ITEM_PRICE_REC);
199: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATEPO.SQL_TO_PL15(P_ITEM_COST_TBL);