1: PACKAGE DPP_BPEL_SELCUSTCLAIM AS
2: /* $Header: dppvbscs.pls 120.4 2008/02/12 09:48:10 vdewan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE
4: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE)
5: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_CU;
6: FUNCTION SQL_TO_PL0(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU)
7: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
1: PACKAGE DPP_BPEL_SELCUSTCLAIM AS
2: /* $Header: dppvbscs.pls 120.4 2008/02/12 09:48:10 vdewan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE
4: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE)
5: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_CU;
6: FUNCTION SQL_TO_PL0(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU)
7: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE
1: PACKAGE DPP_BPEL_SELCUSTCLAIM AS
2: /* $Header: dppvbscs.pls 120.4 2008/02/12 09:48:10 vdewan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE
4: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE)
5: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_CU;
6: FUNCTION SQL_TO_PL0(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU)
7: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE
9: FUNCTION PL_TO_SQL2(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE)
2: /* $Header: dppvbscs.pls 120.4 2008/02/12 09:48:10 vdewan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE
4: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE)
5: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_CU;
6: FUNCTION SQL_TO_PL0(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU)
7: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE
9: FUNCTION PL_TO_SQL2(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE)
10: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C4;
3: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE
4: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE)
5: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_CU;
6: FUNCTION SQL_TO_PL0(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU)
7: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE
9: FUNCTION PL_TO_SQL2(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE)
10: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C4;
11: FUNCTION SQL_TO_PL2(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C4)
4: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE)
5: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_CU;
6: FUNCTION SQL_TO_PL0(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU)
7: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE
9: FUNCTION PL_TO_SQL2(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE)
10: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C4;
11: FUNCTION SQL_TO_PL2(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C4)
12: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE;
5: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_CU;
6: FUNCTION SQL_TO_PL0(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU)
7: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE
9: FUNCTION PL_TO_SQL2(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE)
10: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C4;
11: FUNCTION SQL_TO_PL2(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C4)
12: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE
6: FUNCTION SQL_TO_PL0(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU)
7: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE
9: FUNCTION PL_TO_SQL2(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE)
10: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C4;
11: FUNCTION SQL_TO_PL2(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C4)
12: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE
14: FUNCTION PL_TO_SQL3(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE)
7: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE
9: FUNCTION PL_TO_SQL2(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE)
10: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C4;
11: FUNCTION SQL_TO_PL2(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C4)
12: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE
14: FUNCTION PL_TO_SQL3(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE)
15: RETURN DPPCUSTOMERCLAIMSPVTDPPC2_DPP;
8: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE
9: FUNCTION PL_TO_SQL2(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE)
10: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C4;
11: FUNCTION SQL_TO_PL2(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C4)
12: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE
14: FUNCTION PL_TO_SQL3(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE)
15: RETURN DPPCUSTOMERCLAIMSPVTDPPC2_DPP;
16: FUNCTION SQL_TO_PL3(aSqlItem DPPCUSTOMERCLAIMSPVTDPPC2_DPP)
9: FUNCTION PL_TO_SQL2(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE)
10: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C4;
11: FUNCTION SQL_TO_PL2(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C4)
12: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE
14: FUNCTION PL_TO_SQL3(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE)
15: RETURN DPPCUSTOMERCLAIMSPVTDPPC2_DPP;
16: FUNCTION SQL_TO_PL3(aSqlItem DPPCUSTOMERCLAIMSPVTDPPC2_DPP)
17: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE;
10: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C4;
11: FUNCTION SQL_TO_PL2(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C4)
12: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE
14: FUNCTION PL_TO_SQL3(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE)
15: RETURN DPPCUSTOMERCLAIMSPVTDPPC2_DPP;
16: FUNCTION SQL_TO_PL3(aSqlItem DPPCUSTOMERCLAIMSPVTDPPC2_DPP)
17: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE
13: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE
14: FUNCTION PL_TO_SQL3(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE)
15: RETURN DPPCUSTOMERCLAIMSPVTDPPC2_DPP;
16: FUNCTION SQL_TO_PL3(aSqlItem DPPCUSTOMERCLAIMSPVTDPPC2_DPP)
17: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE
19: FUNCTION PL_TO_SQL4(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE)
20: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C2;
21: FUNCTION SQL_TO_PL4(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C2)
14: FUNCTION PL_TO_SQL3(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE)
15: RETURN DPPCUSTOMERCLAIMSPVTDPPC2_DPP;
16: FUNCTION SQL_TO_PL3(aSqlItem DPPCUSTOMERCLAIMSPVTDPPC2_DPP)
17: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE
19: FUNCTION PL_TO_SQL4(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE)
20: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C2;
21: FUNCTION SQL_TO_PL4(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C2)
22: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE;
15: RETURN DPPCUSTOMERCLAIMSPVTDPPC2_DPP;
16: FUNCTION SQL_TO_PL3(aSqlItem DPPCUSTOMERCLAIMSPVTDPPC2_DPP)
17: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE
19: FUNCTION PL_TO_SQL4(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE)
20: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C2;
21: FUNCTION SQL_TO_PL4(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C2)
22: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE;
23: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE
16: FUNCTION SQL_TO_PL3(aSqlItem DPPCUSTOMERCLAIMSPVTDPPC2_DPP)
17: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE
19: FUNCTION PL_TO_SQL4(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE)
20: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C2;
21: FUNCTION SQL_TO_PL4(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C2)
22: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE;
23: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE
24: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE)
17: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE
19: FUNCTION PL_TO_SQL4(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE)
20: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C2;
21: FUNCTION SQL_TO_PL4(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C2)
22: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE;
23: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE
24: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE)
25: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C1;
18: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE
19: FUNCTION PL_TO_SQL4(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE)
20: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C2;
21: FUNCTION SQL_TO_PL4(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C2)
22: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE;
23: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE
24: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE)
25: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C1;
26: FUNCTION SQL_TO_PL1(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C1)
19: FUNCTION PL_TO_SQL4(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE)
20: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C2;
21: FUNCTION SQL_TO_PL4(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C2)
22: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE;
23: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE
24: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE)
25: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C1;
26: FUNCTION SQL_TO_PL1(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C1)
27: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE;
20: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C2;
21: FUNCTION SQL_TO_PL4(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C2)
22: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE;
23: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE
24: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE)
25: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C1;
26: FUNCTION SQL_TO_PL1(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C1)
27: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE;
28: PROCEDURE DPP_CUSTOMERCLAIMS_PVT$SELECT (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
21: FUNCTION SQL_TO_PL4(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C2)
22: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE;
23: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE
24: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE)
25: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C1;
26: FUNCTION SQL_TO_PL1(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C1)
27: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE;
28: PROCEDURE DPP_CUSTOMERCLAIMS_PVT$SELECT (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
29: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
22: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE;
23: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE
24: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE)
25: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C1;
26: FUNCTION SQL_TO_PL1(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C1)
27: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE;
28: PROCEDURE DPP_CUSTOMERCLAIMS_PVT$SELECT (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
29: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2,P_CUST_HDR_REC DPP_CUSTOMERCLAIMS_PVT_DPP_CU,
23: -- Declare the conversion functions the PL/SQL type DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE
24: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE)
25: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C1;
26: FUNCTION SQL_TO_PL1(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C1)
27: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE;
28: PROCEDURE DPP_CUSTOMERCLAIMS_PVT$SELECT (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
29: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2,P_CUST_HDR_REC DPP_CUSTOMERCLAIMS_PVT_DPP_CU,
31: P_CUSTOMER_TBL IN OUT NOCOPY DPP_CUSTOMERCLAIMS_PVT_DPP_C1);
24: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE)
25: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C1;
26: FUNCTION SQL_TO_PL1(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C1)
27: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE;
28: PROCEDURE DPP_CUSTOMERCLAIMS_PVT$SELECT (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
29: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2,P_CUST_HDR_REC DPP_CUSTOMERCLAIMS_PVT_DPP_CU,
31: P_CUSTOMER_TBL IN OUT NOCOPY DPP_CUSTOMERCLAIMS_PVT_DPP_C1);
32: END DPP_BPEL_SELCUSTCLAIM;
26: FUNCTION SQL_TO_PL1(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C1)
27: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE;
28: PROCEDURE DPP_CUSTOMERCLAIMS_PVT$SELECT (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
29: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2,P_CUST_HDR_REC DPP_CUSTOMERCLAIMS_PVT_DPP_CU,
31: P_CUSTOMER_TBL IN OUT NOCOPY DPP_CUSTOMERCLAIMS_PVT_DPP_C1);
32: END DPP_BPEL_SELCUSTCLAIM;
27: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE;
28: PROCEDURE DPP_CUSTOMERCLAIMS_PVT$SELECT (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
29: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2,P_CUST_HDR_REC DPP_CUSTOMERCLAIMS_PVT_DPP_CU,
31: P_CUSTOMER_TBL IN OUT NOCOPY DPP_CUSTOMERCLAIMS_PVT_DPP_C1);
32: END DPP_BPEL_SELCUSTCLAIM;