DBA Data[Home] [Help]

APPS.DPP_BPEL_UPDATELISTPRICE dependencies on DPP_BPEL_UPDATELISTPRICE

Line 1: PACKAGE BODY DPP_BPEL_UPDATELISTPRICE AS

1: PACKAGE BODY DPP_BPEL_UPDATELISTPRICE AS
2: /* $Header: dppvbulb.pls 120.2 2011/07/14 10:07:31 rvkondur ship $ */
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;

Line 157: P_TXN_HDR_REC_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL22(P_TXN_HDR_REC);

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_ DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
155: P_ITEM_COST_TBL_ 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);
158: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL23(P_ITEM_COST_TBL);
159: DPP_LISTPRICE_PVT.UPDATE_LISTPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_TXN_HDR_REC_,P_ITEM_COST_TBL_);
160: END DPP_LISTPRICE_PVT$UPDATE_LIST;
161:

Line 158: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL23(P_ITEM_COST_TBL);

154: P_TXN_HDR_REC_ DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
155: P_ITEM_COST_TBL_ 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);
158: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL23(P_ITEM_COST_TBL);
159: DPP_LISTPRICE_PVT.UPDATE_LISTPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_TXN_HDR_REC_,P_ITEM_COST_TBL_);
160: END DPP_LISTPRICE_PVT$UPDATE_LIST;
161:
162: END DPP_BPEL_UPDATELISTPRICE;

Line 162: END DPP_BPEL_UPDATELISTPRICE;

158: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL23(P_ITEM_COST_TBL);
159: DPP_LISTPRICE_PVT.UPDATE_LISTPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_TXN_HDR_REC_,P_ITEM_COST_TBL_);
160: END DPP_LISTPRICE_PVT$UPDATE_LIST;
161:
162: END DPP_BPEL_UPDATELISTPRICE;