DBA Data[Home] [Help]

APPS.DPP_BPEL_GETPODATA dependencies on DPP_BPEL_GETPODATA

Line 1: PACKAGE BODY DPP_BPEL_GETPODATA AS

1: PACKAGE BODY DPP_BPEL_GETPODATA AS
2: /* $Header: dppvbufb.pls 120.4 2011/07/14 10:57:02 rvkondur ship $ */
3: FUNCTION PL_TO_SQL11(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE)
4: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO_ IS
5: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO_;

Line 127: P_PO_NOTIFY_HDR_REC_ := DPP_BPEL_GETPODATA.SQL_TO_PL11(P_PO_NOTIFY_HDR_REC);

123: P_PO_NOTIFY_ITEM_TBL IN OUT NOCOPY DPP_PURCHASEPRICE_PVT_DPP_PO10) IS
124: P_PO_NOTIFY_HDR_REC_ DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE;
125: P_PO_NOTIFY_ITEM_TBL_ DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE;
126: BEGIN
127: P_PO_NOTIFY_HDR_REC_ := DPP_BPEL_GETPODATA.SQL_TO_PL11(P_PO_NOTIFY_HDR_REC);
128: P_PO_NOTIFY_ITEM_TBL_ := DPP_BPEL_GETPODATA.SQL_TO_PL12(P_PO_NOTIFY_ITEM_TBL);
129: DPP_PURCHASEPRICE_PVT.NOTIFY_PO(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,
130: X_MSG_COUNT,X_MSG_DATA,P_PO_NOTIFY_HDR_REC_,P_PO_NOTIFY_ITEM_TBL_);
131: P_PO_NOTIFY_HDR_REC := DPP_BPEL_GETPODATA.PL_TO_SQL11(P_PO_NOTIFY_HDR_REC_);

Line 128: P_PO_NOTIFY_ITEM_TBL_ := DPP_BPEL_GETPODATA.SQL_TO_PL12(P_PO_NOTIFY_ITEM_TBL);

124: P_PO_NOTIFY_HDR_REC_ DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE;
125: P_PO_NOTIFY_ITEM_TBL_ DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE;
126: BEGIN
127: P_PO_NOTIFY_HDR_REC_ := DPP_BPEL_GETPODATA.SQL_TO_PL11(P_PO_NOTIFY_HDR_REC);
128: P_PO_NOTIFY_ITEM_TBL_ := DPP_BPEL_GETPODATA.SQL_TO_PL12(P_PO_NOTIFY_ITEM_TBL);
129: DPP_PURCHASEPRICE_PVT.NOTIFY_PO(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,
130: X_MSG_COUNT,X_MSG_DATA,P_PO_NOTIFY_HDR_REC_,P_PO_NOTIFY_ITEM_TBL_);
131: P_PO_NOTIFY_HDR_REC := DPP_BPEL_GETPODATA.PL_TO_SQL11(P_PO_NOTIFY_HDR_REC_);
132: P_PO_NOTIFY_ITEM_TBL := DPP_BPEL_GETPODATA.PL_TO_SQL12(P_PO_NOTIFY_ITEM_TBL_);

Line 131: P_PO_NOTIFY_HDR_REC := DPP_BPEL_GETPODATA.PL_TO_SQL11(P_PO_NOTIFY_HDR_REC_);

127: P_PO_NOTIFY_HDR_REC_ := DPP_BPEL_GETPODATA.SQL_TO_PL11(P_PO_NOTIFY_HDR_REC);
128: P_PO_NOTIFY_ITEM_TBL_ := DPP_BPEL_GETPODATA.SQL_TO_PL12(P_PO_NOTIFY_ITEM_TBL);
129: DPP_PURCHASEPRICE_PVT.NOTIFY_PO(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,
130: X_MSG_COUNT,X_MSG_DATA,P_PO_NOTIFY_HDR_REC_,P_PO_NOTIFY_ITEM_TBL_);
131: P_PO_NOTIFY_HDR_REC := DPP_BPEL_GETPODATA.PL_TO_SQL11(P_PO_NOTIFY_HDR_REC_);
132: P_PO_NOTIFY_ITEM_TBL := DPP_BPEL_GETPODATA.PL_TO_SQL12(P_PO_NOTIFY_ITEM_TBL_);
133: END DPP_PURCHASEPRICE_PVT$NOTIFY_;
134:
135: END DPP_BPEL_GETPODATA;

Line 132: P_PO_NOTIFY_ITEM_TBL := DPP_BPEL_GETPODATA.PL_TO_SQL12(P_PO_NOTIFY_ITEM_TBL_);

128: P_PO_NOTIFY_ITEM_TBL_ := DPP_BPEL_GETPODATA.SQL_TO_PL12(P_PO_NOTIFY_ITEM_TBL);
129: DPP_PURCHASEPRICE_PVT.NOTIFY_PO(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,
130: X_MSG_COUNT,X_MSG_DATA,P_PO_NOTIFY_HDR_REC_,P_PO_NOTIFY_ITEM_TBL_);
131: P_PO_NOTIFY_HDR_REC := DPP_BPEL_GETPODATA.PL_TO_SQL11(P_PO_NOTIFY_HDR_REC_);
132: P_PO_NOTIFY_ITEM_TBL := DPP_BPEL_GETPODATA.PL_TO_SQL12(P_PO_NOTIFY_ITEM_TBL_);
133: END DPP_PURCHASEPRICE_PVT$NOTIFY_;
134:
135: END DPP_BPEL_GETPODATA;

Line 135: END DPP_BPEL_GETPODATA;

131: P_PO_NOTIFY_HDR_REC := DPP_BPEL_GETPODATA.PL_TO_SQL11(P_PO_NOTIFY_HDR_REC_);
132: P_PO_NOTIFY_ITEM_TBL := DPP_BPEL_GETPODATA.PL_TO_SQL12(P_PO_NOTIFY_ITEM_TBL_);
133: END DPP_PURCHASEPRICE_PVT$NOTIFY_;
134:
135: END DPP_BPEL_GETPODATA;