1: package okc_outcome_pub as
2: /* $Header: OKCPOCES.pls 120.0 2005/05/26 09:56:15 appldev noship $ */
3:
4: subtype ocev_rec_type is okc_outcome_pvt.ocev_rec_type;
5: subtype ocev_tbl_type is okc_outcome_pvt.ocev_tbl_type;
6: subtype oatv_rec_type is okc_outcome_pvt.oatv_rec_type;
7: subtype oatv_tbl_type is okc_outcome_pvt.oatv_tbl_type;
8:
1: package okc_outcome_pub as
2: /* $Header: OKCPOCES.pls 120.0 2005/05/26 09:56:15 appldev noship $ */
3:
4: subtype ocev_rec_type is okc_outcome_pvt.ocev_rec_type;
5: subtype ocev_tbl_type is okc_outcome_pvt.ocev_tbl_type;
6: subtype oatv_rec_type is okc_outcome_pvt.oatv_rec_type;
7: subtype oatv_tbl_type is okc_outcome_pvt.oatv_tbl_type;
8:
9: ----------------------------------------------------------------------------------
2: /* $Header: OKCPOCES.pls 120.0 2005/05/26 09:56:15 appldev noship $ */
3:
4: subtype ocev_rec_type is okc_outcome_pvt.ocev_rec_type;
5: subtype ocev_tbl_type is okc_outcome_pvt.ocev_tbl_type;
6: subtype oatv_rec_type is okc_outcome_pvt.oatv_rec_type;
7: subtype oatv_tbl_type is okc_outcome_pvt.oatv_tbl_type;
8:
9: ----------------------------------------------------------------------------------
10: -- Global Variables
3:
4: subtype ocev_rec_type is okc_outcome_pvt.ocev_rec_type;
5: subtype ocev_tbl_type is okc_outcome_pvt.ocev_tbl_type;
6: subtype oatv_rec_type is okc_outcome_pvt.oatv_rec_type;
7: subtype oatv_tbl_type is okc_outcome_pvt.oatv_tbl_type;
8:
9: ----------------------------------------------------------------------------------
10: -- Global Variables
11: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OUTCOME_PUB';
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16:
17: g_ocev_rec okc_outcome_pvt.ocev_rec_type;
18: g_ocev_tbl okc_outcome_pvt.ocev_tbl_type;
19: g_oatv_rec okc_outcome_pvt.oatv_rec_type;
20: g_oatv_tbl okc_outcome_pvt.oatv_tbl_type;
21: ----------------------------------------------------------------------------------
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16:
17: g_ocev_rec okc_outcome_pvt.ocev_rec_type;
18: g_ocev_tbl okc_outcome_pvt.ocev_tbl_type;
19: g_oatv_rec okc_outcome_pvt.oatv_rec_type;
20: g_oatv_tbl okc_outcome_pvt.oatv_tbl_type;
21: ----------------------------------------------------------------------------------
22: --Global Exception
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16:
17: g_ocev_rec okc_outcome_pvt.ocev_rec_type;
18: g_ocev_tbl okc_outcome_pvt.ocev_tbl_type;
19: g_oatv_rec okc_outcome_pvt.oatv_rec_type;
20: g_oatv_tbl okc_outcome_pvt.oatv_tbl_type;
21: ----------------------------------------------------------------------------------
22: --Global Exception
23: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
16:
17: g_ocev_rec okc_outcome_pvt.ocev_rec_type;
18: g_ocev_tbl okc_outcome_pvt.ocev_tbl_type;
19: g_oatv_rec okc_outcome_pvt.oatv_rec_type;
20: g_oatv_tbl okc_outcome_pvt.oatv_tbl_type;
21: ----------------------------------------------------------------------------------
22: --Global Exception
23: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
24: ----------------------------------------------------------------------------------