APPS.DPP_BPEL_UPDATECOST dependencies on DPP_ITEMCOST_PVT_DPP_CST_HDR_

Line 3: FUNCTION PL_TO_SQL9(aPlsqlItem DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE)

1: PACKAGE BODY DPP_BPEL_UPDATECOST AS
2: /* $Header: dppvbucb.pls 120.1 2007/12/12 06:02:38 sdasan noship $ */
3: FUNCTION PL_TO_SQL9(aPlsqlItem DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE)
4: RETURN DPP_ITEMCOST_PVT_DPP_CST_HDR_ IS
5: aSqlItem DPP_ITEMCOST_PVT_DPP_CST_HDR_;
6: BEGIN
7: -- initialize the object

Line 4: RETURN DPP_ITEMCOST_PVT_DPP_CST_HDR_ IS

1: PACKAGE BODY DPP_BPEL_UPDATECOST AS
2: /* $Header: dppvbucb.pls 120.1 2007/12/12 06:02:38 sdasan noship $ */
3: FUNCTION PL_TO_SQL9(aPlsqlItem DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE)
4: RETURN DPP_ITEMCOST_PVT_DPP_CST_HDR_ IS
5: aSqlItem DPP_ITEMCOST_PVT_DPP_CST_HDR_;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_ITEMCOST_PVT_DPP_CST_HDR_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 5: aSqlItem DPP_ITEMCOST_PVT_DPP_CST_HDR_;

1: PACKAGE BODY DPP_BPEL_UPDATECOST AS
2: /* $Header: dppvbucb.pls 120.1 2007/12/12 06:02:38 sdasan noship $ */
3: FUNCTION PL_TO_SQL9(aPlsqlItem DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE)
4: RETURN DPP_ITEMCOST_PVT_DPP_CST_HDR_ IS
5: aSqlItem DPP_ITEMCOST_PVT_DPP_CST_HDR_;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_ITEMCOST_PVT_DPP_CST_HDR_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
9: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Line 8: aSqlItem := DPP_ITEMCOST_PVT_DPP_CST_HDR_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

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

Line 36: FUNCTION SQL_TO_PL9(aSqlItem DPP_ITEMCOST_PVT_DPP_CST_HDR_)

32: aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
33: aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
34: RETURN aSqlItem;
35: END PL_TO_SQL9;
36: FUNCTION SQL_TO_PL9(aSqlItem DPP_ITEMCOST_PVT_DPP_CST_HDR_)
37: RETURN DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE IS
38: aPlsqlItem DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE;
39: BEGIN
40: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;

Line 37: RETURN DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE IS

33: aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
34: RETURN aSqlItem;
35: END PL_TO_SQL9;
36: FUNCTION SQL_TO_PL9(aSqlItem DPP_ITEMCOST_PVT_DPP_CST_HDR_)
37: RETURN DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE IS
38: aPlsqlItem DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE;
39: BEGIN
40: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;
41: aPlsqlItem.TRANSACTION_NUMBER := aSqlItem.TRANSACTION_NUMBER;

Line 38: aPlsqlItem DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE;

34: RETURN aSqlItem;
35: END PL_TO_SQL9;
36: FUNCTION SQL_TO_PL9(aSqlItem DPP_ITEMCOST_PVT_DPP_CST_HDR_)
37: RETURN DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE IS
38: aPlsqlItem DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE;
39: BEGIN
40: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;
41: aPlsqlItem.TRANSACTION_NUMBER := aSqlItem.TRANSACTION_NUMBER;
42: aPlsqlItem.ORG_ID := aSqlItem.ORG_ID;

Line 195: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,P_TXN_HDR_REC DPP_ITEMCOST_PVT_DPP_CST_HDR_,

191: RETURN aPlsqlItem;
192: END SQL_TO_PL10;
193:
194: PROCEDURE DPP_ITEMCOST_PVT$UPDATE_ITEMC (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
195: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,P_TXN_HDR_REC DPP_ITEMCOST_PVT_DPP_CST_HDR_,
196: P_ITEM_COST_TBL DPP_ITEMCOST_PVT_DPP_TXN_LINE) IS
197: P_TXN_HDR_REC_ APPS.DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE;
198: P_ITEM_COST_TBL_ APPS.DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE;
199: BEGIN

Line 197: P_TXN_HDR_REC_ APPS.DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE;

193:
194: PROCEDURE DPP_ITEMCOST_PVT$UPDATE_ITEMC (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
195: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,P_TXN_HDR_REC DPP_ITEMCOST_PVT_DPP_CST_HDR_,
196: P_ITEM_COST_TBL DPP_ITEMCOST_PVT_DPP_TXN_LINE) IS
197: P_TXN_HDR_REC_ APPS.DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE;
198: P_ITEM_COST_TBL_ APPS.DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE;
199: BEGIN
200: P_TXN_HDR_REC_ := DPP_BPEL_UPDATECOST.SQL_TO_PL9(P_TXN_HDR_REC);
201: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATECOST.SQL_TO_PL10(P_ITEM_COST_TBL);