DBA Data[Home] [Help]

APPS.DPP_BPEL_SELCOVINV dependencies on DPP_BPEL_SELCOVINV

Line 1: PACKAGE BODY DPP_BPEL_SELCOVINV AS

1: PACKAGE BODY DPP_BPEL_SELCOVINV AS
2: /* $Header: dppvbsib.pls 120.2 2007/12/12 06:28:17 sdasan noship $ */
3: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_COVEREDINVENTORY_PVT.DPP_INV_HDR_REC_TYPE)
4: RETURN DPP_COVEREDINVENTORY_PVT_DPP_ IS
5: aSqlItem DPP_COVEREDINVENTORY_PVT_DPP_;

Line 171: P_INV_HDR_REC_ := DPP_BPEL_SELCOVINV.SQL_TO_PL0(P_INV_HDR_REC);

167: P_INV_HDR_REC DPP_COVEREDINVENTORY_PVT_DPP_,P_COVERED_INV_TBL IN OUT NOCOPY DPP_COVEREDINVENTORY_PVT_DPP1) IS
168: P_INV_HDR_REC_ APPS.DPP_COVEREDINVENTORY_PVT.DPP_INV_HDR_REC_TYPE;
169: P_COVERED_INV_TBL_ APPS.DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_TBL_TYPE;
170: BEGIN
171: P_INV_HDR_REC_ := DPP_BPEL_SELCOVINV.SQL_TO_PL0(P_INV_HDR_REC);
172: P_COVERED_INV_TBL_ := DPP_BPEL_SELCOVINV.SQL_TO_PL1(P_COVERED_INV_TBL);
173: APPS.DPP_COVEREDINVENTORY_PVT.SELECT_COVEREDINVENTORY(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_INV_HDR_REC_,P_COVERED_INV_TBL_);
174: P_COVERED_INV_TBL := DPP_BPEL_SELCOVINV.PL_TO_SQL0(P_COVERED_INV_TBL_);
175: END DPP_COVEREDINVENTORY_PVT$SELE;

Line 172: P_COVERED_INV_TBL_ := DPP_BPEL_SELCOVINV.SQL_TO_PL1(P_COVERED_INV_TBL);

168: P_INV_HDR_REC_ APPS.DPP_COVEREDINVENTORY_PVT.DPP_INV_HDR_REC_TYPE;
169: P_COVERED_INV_TBL_ APPS.DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_TBL_TYPE;
170: BEGIN
171: P_INV_HDR_REC_ := DPP_BPEL_SELCOVINV.SQL_TO_PL0(P_INV_HDR_REC);
172: P_COVERED_INV_TBL_ := DPP_BPEL_SELCOVINV.SQL_TO_PL1(P_COVERED_INV_TBL);
173: APPS.DPP_COVEREDINVENTORY_PVT.SELECT_COVEREDINVENTORY(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_INV_HDR_REC_,P_COVERED_INV_TBL_);
174: P_COVERED_INV_TBL := DPP_BPEL_SELCOVINV.PL_TO_SQL0(P_COVERED_INV_TBL_);
175: END DPP_COVEREDINVENTORY_PVT$SELE;
176:

Line 174: P_COVERED_INV_TBL := DPP_BPEL_SELCOVINV.PL_TO_SQL0(P_COVERED_INV_TBL_);

170: BEGIN
171: P_INV_HDR_REC_ := DPP_BPEL_SELCOVINV.SQL_TO_PL0(P_INV_HDR_REC);
172: P_COVERED_INV_TBL_ := DPP_BPEL_SELCOVINV.SQL_TO_PL1(P_COVERED_INV_TBL);
173: APPS.DPP_COVEREDINVENTORY_PVT.SELECT_COVEREDINVENTORY(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_INV_HDR_REC_,P_COVERED_INV_TBL_);
174: P_COVERED_INV_TBL := DPP_BPEL_SELCOVINV.PL_TO_SQL0(P_COVERED_INV_TBL_);
175: END DPP_COVEREDINVENTORY_PVT$SELE;
176:
177: END DPP_BPEL_SELCOVINV;

Line 177: END DPP_BPEL_SELCOVINV;

173: APPS.DPP_COVEREDINVENTORY_PVT.SELECT_COVEREDINVENTORY(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_INV_HDR_REC_,P_COVERED_INV_TBL_);
174: P_COVERED_INV_TBL := DPP_BPEL_SELCOVINV.PL_TO_SQL0(P_COVERED_INV_TBL_);
175: END DPP_COVEREDINVENTORY_PVT$SELE;
176:
177: END DPP_BPEL_SELCOVINV;