1: PACKAGE DPP_BPEL_GETTRANSLATEDMESSAGE AS
2: /* $Header: dppvbgts.pls 120.0 2008/03/25 06:25:43 vdewan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE
4: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE)
5: RETURN DPP_NOTIFICATION_PVT_MESSAGE1;
6: FUNCTION SQL_TO_PL1(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE1)
7: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE;
1: PACKAGE DPP_BPEL_GETTRANSLATEDMESSAGE AS
2: /* $Header: dppvbgts.pls 120.0 2008/03/25 06:25:43 vdewan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE
4: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE)
5: RETURN DPP_NOTIFICATION_PVT_MESSAGE1;
6: FUNCTION SQL_TO_PL1(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE1)
7: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE
1: PACKAGE DPP_BPEL_GETTRANSLATEDMESSAGE AS
2: /* $Header: dppvbgts.pls 120.0 2008/03/25 06:25:43 vdewan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE
4: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE)
5: RETURN DPP_NOTIFICATION_PVT_MESSAGE1;
6: FUNCTION SQL_TO_PL1(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE1)
7: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE
9: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE)
2: /* $Header: dppvbgts.pls 120.0 2008/03/25 06:25:43 vdewan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE
4: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE)
5: RETURN DPP_NOTIFICATION_PVT_MESSAGE1;
6: FUNCTION SQL_TO_PL1(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE1)
7: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE
9: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE)
10: RETURN DPP_NOTIFICATION_PVT_MESSAGE_;
3: -- Declare the conversion functions the PL/SQL type DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE
4: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE)
5: RETURN DPP_NOTIFICATION_PVT_MESSAGE1;
6: FUNCTION SQL_TO_PL1(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE1)
7: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE
9: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE)
10: RETURN DPP_NOTIFICATION_PVT_MESSAGE_;
11: FUNCTION SQL_TO_PL0(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE_)
4: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE)
5: RETURN DPP_NOTIFICATION_PVT_MESSAGE1;
6: FUNCTION SQL_TO_PL1(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE1)
7: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE
9: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE)
10: RETURN DPP_NOTIFICATION_PVT_MESSAGE_;
11: FUNCTION SQL_TO_PL0(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE_)
12: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE;
5: RETURN DPP_NOTIFICATION_PVT_MESSAGE1;
6: FUNCTION SQL_TO_PL1(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE1)
7: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE
9: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE)
10: RETURN DPP_NOTIFICATION_PVT_MESSAGE_;
11: FUNCTION SQL_TO_PL0(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE_)
12: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE;
13: PROCEDURE DPP_NOTIFICATION_PVT$SELECT_M (X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
6: FUNCTION SQL_TO_PL1(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE1)
7: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE
9: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE)
10: RETURN DPP_NOTIFICATION_PVT_MESSAGE_;
11: FUNCTION SQL_TO_PL0(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE_)
12: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE;
13: PROCEDURE DPP_NOTIFICATION_PVT$SELECT_M (X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
14: X_MSG_DATA OUT NOCOPY VARCHAR2,P_MESSAGE_NAME VARCHAR2,P_APPLICATION_SHORT_NAME VARCHAR2,P_LANGUAGE_CODE VARCHAR2,
7: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE
9: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE)
10: RETURN DPP_NOTIFICATION_PVT_MESSAGE_;
11: FUNCTION SQL_TO_PL0(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE_)
12: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE;
13: PROCEDURE DPP_NOTIFICATION_PVT$SELECT_M (X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
14: X_MSG_DATA OUT NOCOPY VARCHAR2,P_MESSAGE_NAME VARCHAR2,P_APPLICATION_SHORT_NAME VARCHAR2,P_LANGUAGE_CODE VARCHAR2,
15: P_MESSAGE_TOKEN DPP_NOTIFICATION_PVT_MESSAGE_,X_MESSAGE_TYPE OUT NOCOPY VARCHAR2,X_MESSAGE_CATEGORY OUT NOCOPY VARCHAR2,
8: -- Declare the conversion functions the PL/SQL type DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE
9: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE)
10: RETURN DPP_NOTIFICATION_PVT_MESSAGE_;
11: FUNCTION SQL_TO_PL0(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE_)
12: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE;
13: PROCEDURE DPP_NOTIFICATION_PVT$SELECT_M (X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
14: X_MSG_DATA OUT NOCOPY VARCHAR2,P_MESSAGE_NAME VARCHAR2,P_APPLICATION_SHORT_NAME VARCHAR2,P_LANGUAGE_CODE VARCHAR2,
15: P_MESSAGE_TOKEN DPP_NOTIFICATION_PVT_MESSAGE_,X_MESSAGE_TYPE OUT NOCOPY VARCHAR2,X_MESSAGE_CATEGORY OUT NOCOPY VARCHAR2,
16: X_MESSAGE_TEXT OUT NOCOPY VARCHAR2,X_MESSAGE_SEVERITY OUT NOCOPY VARCHAR2);
11: FUNCTION SQL_TO_PL0(aSqlItem DPP_NOTIFICATION_PVT_MESSAGE_)
12: RETURN DPP_NOTIFICATION_PVT.MESSAGE_TOKENS_TBL_TYPE;
13: PROCEDURE DPP_NOTIFICATION_PVT$SELECT_M (X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
14: X_MSG_DATA OUT NOCOPY VARCHAR2,P_MESSAGE_NAME VARCHAR2,P_APPLICATION_SHORT_NAME VARCHAR2,P_LANGUAGE_CODE VARCHAR2,
15: P_MESSAGE_TOKEN DPP_NOTIFICATION_PVT_MESSAGE_,X_MESSAGE_TYPE OUT NOCOPY VARCHAR2,X_MESSAGE_CATEGORY OUT NOCOPY VARCHAR2,
16: X_MESSAGE_TEXT OUT NOCOPY VARCHAR2,X_MESSAGE_SEVERITY OUT NOCOPY VARCHAR2);
17: END DPP_BPEL_GETTRANSLATEDMESSAGE;