DBA Data[Home] [Help]

APPS.DPP_BPEL_UPDATELISTPRICE dependencies on DPP_LISTPRICE_PVT_DPP_TXN_H12

Line 4: RETURN DPP_LISTPRICE_PVT_DPP_TXN_H12 IS

1: PACKAGE BODY DPP_BPEL_UPDATELISTPRICE AS
2: /* $Header: dppvbulb.pls 120.1 2007/12/12 05:57:15 sdasan noship $ */
3: FUNCTION PL_TO_SQL22(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE)
4: RETURN DPP_LISTPRICE_PVT_DPP_TXN_H12 IS
5: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_H12(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 5: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12;

1: PACKAGE BODY DPP_BPEL_UPDATELISTPRICE AS
2: /* $Header: dppvbulb.pls 120.1 2007/12/12 05:57:15 sdasan noship $ */
3: FUNCTION PL_TO_SQL22(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE)
4: RETURN DPP_LISTPRICE_PVT_DPP_TXN_H12 IS
5: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_H12(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_LISTPRICE_PVT_DPP_TXN_H12(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

4: RETURN DPP_LISTPRICE_PVT_DPP_TXN_H12 IS
5: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_H12(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_PL22(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12)

32: aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
33: aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
34: RETURN aSqlItem;
35: END PL_TO_SQL22;
36: FUNCTION SQL_TO_PL22(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12)
37: RETURN DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE IS
38: aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
39: BEGIN
40: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;

Line 153: P_TXN_HDR_REC DPP_LISTPRICE_PVT_DPP_TXN_H12,P_ITEM_COST_TBL DPP_LISTPRICE_PVT_DPP_TXN_L13) IS

149: END SQL_TO_PL23;
150:
151: PROCEDURE DPP_LISTPRICE_PVT$UPDATE_LIST (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
152: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
153: P_TXN_HDR_REC DPP_LISTPRICE_PVT_DPP_TXN_H12,P_ITEM_COST_TBL DPP_LISTPRICE_PVT_DPP_TXN_L13) IS
154: P_TXN_HDR_REC_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
155: P_ITEM_COST_TBL_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE;
156: BEGIN
157: P_TXN_HDR_REC_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL22(P_TXN_HDR_REC);