APPS.DPP_BPEL_SELCUSTCLAIM dependencies on DPP_BPEL_SELCUSTCLAIM

Line 1: PACKAGE BODY DPP_BPEL_SELCUSTCLAIM AS

1: PACKAGE BODY DPP_BPEL_SELCUSTCLAIM AS
2: /* $Header: dppvbscb.pls 120.5 2011/07/14 09:57:23 rvkondur ship $ */
3: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE)
4: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_CU IS
5: aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU;

Line 128: P_CUST_HDR_REC_ := DPP_BPEL_SELCUSTCLAIM.SQL_TO_PL0(P_CUST_HDR_REC);

124: P_CUSTOMER_TBL IN OUT NOCOPY DPP_CUSTOMERCLAIMS_PVT_DPP_C1) IS
125: P_CUST_HDR_REC_ DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
126: P_CUSTOMER_TBL_ DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE;
127: BEGIN
128: P_CUST_HDR_REC_ := DPP_BPEL_SELCUSTCLAIM.SQL_TO_PL0(P_CUST_HDR_REC);
129: P_CUSTOMER_TBL_ := DPP_BPEL_SELCUSTCLAIM.SQL_TO_PL1(P_CUSTOMER_TBL);
130: DPP_CUSTOMERCLAIMS_PVT.SELECT_CUSTOMERPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,
131: X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_CUST_HDR_REC_,P_CUSTOMER_TBL_);
132: P_CUSTOMER_TBL := DPP_BPEL_SELCUSTCLAIM.PL_TO_SQL0(P_CUSTOMER_TBL_);

Line 129: P_CUSTOMER_TBL_ := DPP_BPEL_SELCUSTCLAIM.SQL_TO_PL1(P_CUSTOMER_TBL);

125: P_CUST_HDR_REC_ DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
126: P_CUSTOMER_TBL_ DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE;
127: BEGIN
128: P_CUST_HDR_REC_ := DPP_BPEL_SELCUSTCLAIM.SQL_TO_PL0(P_CUST_HDR_REC);
129: P_CUSTOMER_TBL_ := DPP_BPEL_SELCUSTCLAIM.SQL_TO_PL1(P_CUSTOMER_TBL);
130: DPP_CUSTOMERCLAIMS_PVT.SELECT_CUSTOMERPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,
131: X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_CUST_HDR_REC_,P_CUSTOMER_TBL_);
132: P_CUSTOMER_TBL := DPP_BPEL_SELCUSTCLAIM.PL_TO_SQL0(P_CUSTOMER_TBL_);
133: END DPP_CUSTOMERCLAIMS_PVT$SELECT;

Line 132: P_CUSTOMER_TBL := DPP_BPEL_SELCUSTCLAIM.PL_TO_SQL0(P_CUSTOMER_TBL_);

128: P_CUST_HDR_REC_ := DPP_BPEL_SELCUSTCLAIM.SQL_TO_PL0(P_CUST_HDR_REC);
129: P_CUSTOMER_TBL_ := DPP_BPEL_SELCUSTCLAIM.SQL_TO_PL1(P_CUSTOMER_TBL);
130: DPP_CUSTOMERCLAIMS_PVT.SELECT_CUSTOMERPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,
131: X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_CUST_HDR_REC_,P_CUSTOMER_TBL_);
132: P_CUSTOMER_TBL := DPP_BPEL_SELCUSTCLAIM.PL_TO_SQL0(P_CUSTOMER_TBL_);
133: END DPP_CUSTOMERCLAIMS_PVT$SELECT;
134:
135: END DPP_BPEL_SELCUSTCLAIM;

Line 135: END DPP_BPEL_SELCUSTCLAIM;

131: X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_CUST_HDR_REC_,P_CUSTOMER_TBL_);
132: P_CUSTOMER_TBL := DPP_BPEL_SELCUSTCLAIM.PL_TO_SQL0(P_CUSTOMER_TBL_);
133: END DPP_CUSTOMERCLAIMS_PVT$SELECT;
134:
135: END DPP_BPEL_SELCUSTCLAIM;