1: PACKAGE DPP_BPEL_UPDATECLAIM AUTHID CURRENT_USER AS
2: /* $Header: dppvbups.pls 120.1 2007/12/12 06:04:48 sdasan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE
4: FUNCTION PL_TO_SQL6(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE)
5: RETURN DPP_CLAIMS_PVT_DPP_TXN_HDR_R4;
6: FUNCTION SQL_TO_PL6(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_HDR_R4)
7: RETURN DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE;
1: PACKAGE DPP_BPEL_UPDATECLAIM AUTHID CURRENT_USER AS
2: /* $Header: dppvbups.pls 120.1 2007/12/12 06:04:48 sdasan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE
4: FUNCTION PL_TO_SQL6(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE)
5: RETURN DPP_CLAIMS_PVT_DPP_TXN_HDR_R4;
6: FUNCTION SQL_TO_PL6(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_HDR_R4)
7: RETURN DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE
1: PACKAGE DPP_BPEL_UPDATECLAIM AUTHID CURRENT_USER AS
2: /* $Header: dppvbups.pls 120.1 2007/12/12 06:04:48 sdasan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE
4: FUNCTION PL_TO_SQL6(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE)
5: RETURN DPP_CLAIMS_PVT_DPP_TXN_HDR_R4;
6: FUNCTION SQL_TO_PL6(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_HDR_R4)
7: RETURN DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE
9: FUNCTION PL_TO_SQL8(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE)
2: /* $Header: dppvbups.pls 120.1 2007/12/12 06:04:48 sdasan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE
4: FUNCTION PL_TO_SQL6(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE)
5: RETURN DPP_CLAIMS_PVT_DPP_TXN_HDR_R4;
6: FUNCTION SQL_TO_PL6(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_HDR_R4)
7: RETURN DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE
9: FUNCTION PL_TO_SQL8(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE)
10: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_6;
3: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE
4: FUNCTION PL_TO_SQL6(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE)
5: RETURN DPP_CLAIMS_PVT_DPP_TXN_HDR_R4;
6: FUNCTION SQL_TO_PL6(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_HDR_R4)
7: RETURN DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE
9: FUNCTION PL_TO_SQL8(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE)
10: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_6;
11: FUNCTION SQL_TO_PL8(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_6)
4: FUNCTION PL_TO_SQL6(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE)
5: RETURN DPP_CLAIMS_PVT_DPP_TXN_HDR_R4;
6: FUNCTION SQL_TO_PL6(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_HDR_R4)
7: RETURN DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE
9: FUNCTION PL_TO_SQL8(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE)
10: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_6;
11: FUNCTION SQL_TO_PL8(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_6)
12: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE;
5: RETURN DPP_CLAIMS_PVT_DPP_TXN_HDR_R4;
6: FUNCTION SQL_TO_PL6(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_HDR_R4)
7: RETURN DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE
9: FUNCTION PL_TO_SQL8(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE)
10: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_6;
11: FUNCTION SQL_TO_PL8(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_6)
12: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE
6: FUNCTION SQL_TO_PL6(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_HDR_R4)
7: RETURN DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE
9: FUNCTION PL_TO_SQL8(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE)
10: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_6;
11: FUNCTION SQL_TO_PL8(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_6)
12: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE
14: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE)
7: RETURN DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE
9: FUNCTION PL_TO_SQL8(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE)
10: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_6;
11: FUNCTION SQL_TO_PL8(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_6)
12: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE
14: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE)
15: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_5;
8: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE
9: FUNCTION PL_TO_SQL8(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE)
10: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_6;
11: FUNCTION SQL_TO_PL8(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_6)
12: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE
14: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE)
15: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_5;
16: FUNCTION SQL_TO_PL7(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5)
9: FUNCTION PL_TO_SQL8(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE)
10: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_6;
11: FUNCTION SQL_TO_PL8(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_6)
12: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE
14: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE)
15: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_5;
16: FUNCTION SQL_TO_PL7(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5)
17: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE;
10: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_6;
11: FUNCTION SQL_TO_PL8(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_6)
12: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE
14: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE)
15: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_5;
16: FUNCTION SQL_TO_PL7(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5)
17: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE;
18: PROCEDURE DPP_CLAIMS_PVT$UPDATE_CLAIMS (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,
11: FUNCTION SQL_TO_PL8(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_6)
12: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE
14: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE)
15: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_5;
16: FUNCTION SQL_TO_PL7(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5)
17: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE;
18: PROCEDURE DPP_CLAIMS_PVT$UPDATE_CLAIMS (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,
19: X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,P_TXN_HDR_REC IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_HDR_R4,
12: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE
14: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE)
15: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_5;
16: FUNCTION SQL_TO_PL7(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5)
17: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE;
18: PROCEDURE DPP_CLAIMS_PVT$UPDATE_CLAIMS (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,
19: X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,P_TXN_HDR_REC IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_HDR_R4,
20: P_TXN_LINE_TBL IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_LINE_5);
13: -- Declare the conversion functions the PL/SQL type DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE
14: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE)
15: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_5;
16: FUNCTION SQL_TO_PL7(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5)
17: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE;
18: PROCEDURE DPP_CLAIMS_PVT$UPDATE_CLAIMS (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,
19: X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,P_TXN_HDR_REC IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_HDR_R4,
20: P_TXN_LINE_TBL IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_LINE_5);
21: END DPP_BPEL_UPDATECLAIM;
14: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE)
15: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_5;
16: FUNCTION SQL_TO_PL7(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5)
17: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE;
18: PROCEDURE DPP_CLAIMS_PVT$UPDATE_CLAIMS (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,
19: X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,P_TXN_HDR_REC IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_HDR_R4,
20: P_TXN_LINE_TBL IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_LINE_5);
21: END DPP_BPEL_UPDATECLAIM;
15: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_5;
16: FUNCTION SQL_TO_PL7(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5)
17: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE;
18: PROCEDURE DPP_CLAIMS_PVT$UPDATE_CLAIMS (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,
19: X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,P_TXN_HDR_REC IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_HDR_R4,
20: P_TXN_LINE_TBL IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_LINE_5);
21: END DPP_BPEL_UPDATECLAIM;
16: FUNCTION SQL_TO_PL7(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5)
17: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE;
18: PROCEDURE DPP_CLAIMS_PVT$UPDATE_CLAIMS (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,
19: X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,P_TXN_HDR_REC IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_HDR_R4,
20: P_TXN_LINE_TBL IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_LINE_5);
21: END DPP_BPEL_UPDATECLAIM;