DBA Data[Home] [Help]

APPS.DPP_BPEL_GETOUTBOUNDPL dependencies on DPP_BPEL_GETOUTBOUNDPL

Line 1: PACKAGE BODY DPP_BPEL_GETOUTBOUNDPL AS

1: PACKAGE BODY DPP_BPEL_GETOUTBOUNDPL AS
2: /* $Header: dppvbonb.pls 120.3 2011/07/14 09:50:13 rvkondur ship $ */
3: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE)
4: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF6 IS
5: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF6;

Line 108: P_PL_NOTIFY_HDR_REC_ := DPP_BPEL_GETOUTBOUNDPL.SQL_TO_PL7(P_PL_NOTIFY_HDR_REC);

104: P_PL_NOTIFY_HDR_REC IN OUT NOCOPY DPP_PRICING_PVT_DPP_PL_NOTIF6,P_PL_NOTIFY_LINE_TBL IN OUT NOCOPY DPP_PRICING_PVT_DPP_PL_NOTIF7) IS
105: P_PL_NOTIFY_HDR_REC_ DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
106: P_PL_NOTIFY_LINE_TBL_ DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE;
107: BEGIN
108: P_PL_NOTIFY_HDR_REC_ := DPP_BPEL_GETOUTBOUNDPL.SQL_TO_PL7(P_PL_NOTIFY_HDR_REC);
109: P_PL_NOTIFY_LINE_TBL_ := DPP_BPEL_GETOUTBOUNDPL.SQL_TO_PL8(P_PL_NOTIFY_LINE_TBL);
110: DPP_PRICING_PVT.NOTIFY_OUTBOUNDPRICELISTS(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_PL_NOTIFY_HDR_REC_,P_PL_NOTIFY_LINE_TBL_);
111: P_PL_NOTIFY_HDR_REC := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL7(P_PL_NOTIFY_HDR_REC_);
112: P_PL_NOTIFY_LINE_TBL := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL8(P_PL_NOTIFY_LINE_TBL_);

Line 109: P_PL_NOTIFY_LINE_TBL_ := DPP_BPEL_GETOUTBOUNDPL.SQL_TO_PL8(P_PL_NOTIFY_LINE_TBL);

105: P_PL_NOTIFY_HDR_REC_ DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
106: P_PL_NOTIFY_LINE_TBL_ DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE;
107: BEGIN
108: P_PL_NOTIFY_HDR_REC_ := DPP_BPEL_GETOUTBOUNDPL.SQL_TO_PL7(P_PL_NOTIFY_HDR_REC);
109: P_PL_NOTIFY_LINE_TBL_ := DPP_BPEL_GETOUTBOUNDPL.SQL_TO_PL8(P_PL_NOTIFY_LINE_TBL);
110: DPP_PRICING_PVT.NOTIFY_OUTBOUNDPRICELISTS(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_PL_NOTIFY_HDR_REC_,P_PL_NOTIFY_LINE_TBL_);
111: P_PL_NOTIFY_HDR_REC := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL7(P_PL_NOTIFY_HDR_REC_);
112: P_PL_NOTIFY_LINE_TBL := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL8(P_PL_NOTIFY_LINE_TBL_);
113: END DPP_PRICING_PVT$NOTIFY_OUTBOU;

Line 111: P_PL_NOTIFY_HDR_REC := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL7(P_PL_NOTIFY_HDR_REC_);

107: BEGIN
108: P_PL_NOTIFY_HDR_REC_ := DPP_BPEL_GETOUTBOUNDPL.SQL_TO_PL7(P_PL_NOTIFY_HDR_REC);
109: P_PL_NOTIFY_LINE_TBL_ := DPP_BPEL_GETOUTBOUNDPL.SQL_TO_PL8(P_PL_NOTIFY_LINE_TBL);
110: DPP_PRICING_PVT.NOTIFY_OUTBOUNDPRICELISTS(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_PL_NOTIFY_HDR_REC_,P_PL_NOTIFY_LINE_TBL_);
111: P_PL_NOTIFY_HDR_REC := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL7(P_PL_NOTIFY_HDR_REC_);
112: P_PL_NOTIFY_LINE_TBL := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL8(P_PL_NOTIFY_LINE_TBL_);
113: END DPP_PRICING_PVT$NOTIFY_OUTBOU;
114:
115: END DPP_BPEL_GETOUTBOUNDPL;

Line 112: P_PL_NOTIFY_LINE_TBL := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL8(P_PL_NOTIFY_LINE_TBL_);

108: P_PL_NOTIFY_HDR_REC_ := DPP_BPEL_GETOUTBOUNDPL.SQL_TO_PL7(P_PL_NOTIFY_HDR_REC);
109: P_PL_NOTIFY_LINE_TBL_ := DPP_BPEL_GETOUTBOUNDPL.SQL_TO_PL8(P_PL_NOTIFY_LINE_TBL);
110: DPP_PRICING_PVT.NOTIFY_OUTBOUNDPRICELISTS(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_PL_NOTIFY_HDR_REC_,P_PL_NOTIFY_LINE_TBL_);
111: P_PL_NOTIFY_HDR_REC := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL7(P_PL_NOTIFY_HDR_REC_);
112: P_PL_NOTIFY_LINE_TBL := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL8(P_PL_NOTIFY_LINE_TBL_);
113: END DPP_PRICING_PVT$NOTIFY_OUTBOU;
114:
115: END DPP_BPEL_GETOUTBOUNDPL;

Line 115: END DPP_BPEL_GETOUTBOUNDPL;

111: P_PL_NOTIFY_HDR_REC := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL7(P_PL_NOTIFY_HDR_REC_);
112: P_PL_NOTIFY_LINE_TBL := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL8(P_PL_NOTIFY_LINE_TBL_);
113: END DPP_PRICING_PVT$NOTIFY_OUTBOU;
114:
115: END DPP_BPEL_GETOUTBOUNDPL;