1: package okc_conditions_pub as
2: /* $Header: OKCPCNHS.pls 120.0 2005/05/25 18:58:27 appldev noship $ */
3:
4: -- complex entity object subtype definitions
5: subtype cnhv_rec_type is okc_conditions_pvt.cnhv_rec_type;
6: subtype cnhv_tbl_type is okc_conditions_pvt.cnhv_tbl_type;
7: subtype cnlv_rec_type is okc_conditions_pvt.cnlv_rec_type;
8: subtype cnlv_tbl_type is okc_conditions_pvt.cnlv_tbl_type;
9: subtype coev_rec_type is okc_conditions_pvt.coev_rec_type;
2: /* $Header: OKCPCNHS.pls 120.0 2005/05/25 18:58:27 appldev noship $ */
3:
4: -- complex entity object subtype definitions
5: subtype cnhv_rec_type is okc_conditions_pvt.cnhv_rec_type;
6: subtype cnhv_tbl_type is okc_conditions_pvt.cnhv_tbl_type;
7: subtype cnlv_rec_type is okc_conditions_pvt.cnlv_rec_type;
8: subtype cnlv_tbl_type is okc_conditions_pvt.cnlv_tbl_type;
9: subtype coev_rec_type is okc_conditions_pvt.coev_rec_type;
10: subtype coev_tbl_type is okc_conditions_pvt.coev_tbl_type;
3:
4: -- complex entity object subtype definitions
5: subtype cnhv_rec_type is okc_conditions_pvt.cnhv_rec_type;
6: subtype cnhv_tbl_type is okc_conditions_pvt.cnhv_tbl_type;
7: subtype cnlv_rec_type is okc_conditions_pvt.cnlv_rec_type;
8: subtype cnlv_tbl_type is okc_conditions_pvt.cnlv_tbl_type;
9: subtype coev_rec_type is okc_conditions_pvt.coev_rec_type;
10: subtype coev_tbl_type is okc_conditions_pvt.coev_tbl_type;
11: subtype aavv_rec_type is okc_conditions_pvt.aavv_rec_type;
4: -- complex entity object subtype definitions
5: subtype cnhv_rec_type is okc_conditions_pvt.cnhv_rec_type;
6: subtype cnhv_tbl_type is okc_conditions_pvt.cnhv_tbl_type;
7: subtype cnlv_rec_type is okc_conditions_pvt.cnlv_rec_type;
8: subtype cnlv_tbl_type is okc_conditions_pvt.cnlv_tbl_type;
9: subtype coev_rec_type is okc_conditions_pvt.coev_rec_type;
10: subtype coev_tbl_type is okc_conditions_pvt.coev_tbl_type;
11: subtype aavv_rec_type is okc_conditions_pvt.aavv_rec_type;
12: subtype aavv_tbl_type is okc_conditions_pvt.aavv_tbl_type;
5: subtype cnhv_rec_type is okc_conditions_pvt.cnhv_rec_type;
6: subtype cnhv_tbl_type is okc_conditions_pvt.cnhv_tbl_type;
7: subtype cnlv_rec_type is okc_conditions_pvt.cnlv_rec_type;
8: subtype cnlv_tbl_type is okc_conditions_pvt.cnlv_tbl_type;
9: subtype coev_rec_type is okc_conditions_pvt.coev_rec_type;
10: subtype coev_tbl_type is okc_conditions_pvt.coev_tbl_type;
11: subtype aavv_rec_type is okc_conditions_pvt.aavv_rec_type;
12: subtype aavv_tbl_type is okc_conditions_pvt.aavv_tbl_type;
13: subtype aalv_rec_type is okc_conditions_pvt.aalv_rec_type;
6: subtype cnhv_tbl_type is okc_conditions_pvt.cnhv_tbl_type;
7: subtype cnlv_rec_type is okc_conditions_pvt.cnlv_rec_type;
8: subtype cnlv_tbl_type is okc_conditions_pvt.cnlv_tbl_type;
9: subtype coev_rec_type is okc_conditions_pvt.coev_rec_type;
10: subtype coev_tbl_type is okc_conditions_pvt.coev_tbl_type;
11: subtype aavv_rec_type is okc_conditions_pvt.aavv_rec_type;
12: subtype aavv_tbl_type is okc_conditions_pvt.aavv_tbl_type;
13: subtype aalv_rec_type is okc_conditions_pvt.aalv_rec_type;
14: subtype aalv_tbl_type is okc_conditions_pvt.aalv_tbl_type;
7: subtype cnlv_rec_type is okc_conditions_pvt.cnlv_rec_type;
8: subtype cnlv_tbl_type is okc_conditions_pvt.cnlv_tbl_type;
9: subtype coev_rec_type is okc_conditions_pvt.coev_rec_type;
10: subtype coev_tbl_type is okc_conditions_pvt.coev_tbl_type;
11: subtype aavv_rec_type is okc_conditions_pvt.aavv_rec_type;
12: subtype aavv_tbl_type is okc_conditions_pvt.aavv_tbl_type;
13: subtype aalv_rec_type is okc_conditions_pvt.aalv_rec_type;
14: subtype aalv_tbl_type is okc_conditions_pvt.aalv_tbl_type;
15: subtype fepv_rec_type is okc_conditions_pvt.fepv_rec_type;
8: subtype cnlv_tbl_type is okc_conditions_pvt.cnlv_tbl_type;
9: subtype coev_rec_type is okc_conditions_pvt.coev_rec_type;
10: subtype coev_tbl_type is okc_conditions_pvt.coev_tbl_type;
11: subtype aavv_rec_type is okc_conditions_pvt.aavv_rec_type;
12: subtype aavv_tbl_type is okc_conditions_pvt.aavv_tbl_type;
13: subtype aalv_rec_type is okc_conditions_pvt.aalv_rec_type;
14: subtype aalv_tbl_type is okc_conditions_pvt.aalv_tbl_type;
15: subtype fepv_rec_type is okc_conditions_pvt.fepv_rec_type;
16: subtype fepv_tbl_type is okc_conditions_pvt.fepv_tbl_type;
9: subtype coev_rec_type is okc_conditions_pvt.coev_rec_type;
10: subtype coev_tbl_type is okc_conditions_pvt.coev_tbl_type;
11: subtype aavv_rec_type is okc_conditions_pvt.aavv_rec_type;
12: subtype aavv_tbl_type is okc_conditions_pvt.aavv_tbl_type;
13: subtype aalv_rec_type is okc_conditions_pvt.aalv_rec_type;
14: subtype aalv_tbl_type is okc_conditions_pvt.aalv_tbl_type;
15: subtype fepv_rec_type is okc_conditions_pvt.fepv_rec_type;
16: subtype fepv_tbl_type is okc_conditions_pvt.fepv_tbl_type;
17:
10: subtype coev_tbl_type is okc_conditions_pvt.coev_tbl_type;
11: subtype aavv_rec_type is okc_conditions_pvt.aavv_rec_type;
12: subtype aavv_tbl_type is okc_conditions_pvt.aavv_tbl_type;
13: subtype aalv_rec_type is okc_conditions_pvt.aalv_rec_type;
14: subtype aalv_tbl_type is okc_conditions_pvt.aalv_tbl_type;
15: subtype fepv_rec_type is okc_conditions_pvt.fepv_rec_type;
16: subtype fepv_tbl_type is okc_conditions_pvt.fepv_tbl_type;
17:
18: ---------------------------------------------------------------------------------------
11: subtype aavv_rec_type is okc_conditions_pvt.aavv_rec_type;
12: subtype aavv_tbl_type is okc_conditions_pvt.aavv_tbl_type;
13: subtype aalv_rec_type is okc_conditions_pvt.aalv_rec_type;
14: subtype aalv_tbl_type is okc_conditions_pvt.aalv_tbl_type;
15: subtype fepv_rec_type is okc_conditions_pvt.fepv_rec_type;
16: subtype fepv_tbl_type is okc_conditions_pvt.fepv_tbl_type;
17:
18: ---------------------------------------------------------------------------------------
19: -- GLOBAL VARIABLES
12: subtype aavv_tbl_type is okc_conditions_pvt.aavv_tbl_type;
13: subtype aalv_rec_type is okc_conditions_pvt.aalv_rec_type;
14: subtype aalv_tbl_type is okc_conditions_pvt.aalv_tbl_type;
15: subtype fepv_rec_type is okc_conditions_pvt.fepv_rec_type;
16: subtype fepv_tbl_type is okc_conditions_pvt.fepv_tbl_type;
17:
18: ---------------------------------------------------------------------------------------
19: -- GLOBAL VARIABLES
20: ---------------------------------------------------------------------------------------
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
24: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
26:
27: g_cnhv_rec okc_conditions_pvt.cnhv_rec_type;
28: g_cnhv_tbl okc_conditions_pvt.cnhv_tbl_type;
29: g_cnlv_rec okc_conditions_pvt.cnlv_rec_type;
30: g_cnlv_tbl okc_conditions_pvt.cnlv_tbl_type;
31: g_coev_rec okc_conditions_pvt.coev_rec_type;
24: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
26:
27: g_cnhv_rec okc_conditions_pvt.cnhv_rec_type;
28: g_cnhv_tbl okc_conditions_pvt.cnhv_tbl_type;
29: g_cnlv_rec okc_conditions_pvt.cnlv_rec_type;
30: g_cnlv_tbl okc_conditions_pvt.cnlv_tbl_type;
31: g_coev_rec okc_conditions_pvt.coev_rec_type;
32: g_coev_tbl okc_conditions_pvt.coev_tbl_type;
25: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
26:
27: g_cnhv_rec okc_conditions_pvt.cnhv_rec_type;
28: g_cnhv_tbl okc_conditions_pvt.cnhv_tbl_type;
29: g_cnlv_rec okc_conditions_pvt.cnlv_rec_type;
30: g_cnlv_tbl okc_conditions_pvt.cnlv_tbl_type;
31: g_coev_rec okc_conditions_pvt.coev_rec_type;
32: g_coev_tbl okc_conditions_pvt.coev_tbl_type;
33: g_aavv_rec okc_conditions_pvt.aavv_rec_type;
26:
27: g_cnhv_rec okc_conditions_pvt.cnhv_rec_type;
28: g_cnhv_tbl okc_conditions_pvt.cnhv_tbl_type;
29: g_cnlv_rec okc_conditions_pvt.cnlv_rec_type;
30: g_cnlv_tbl okc_conditions_pvt.cnlv_tbl_type;
31: g_coev_rec okc_conditions_pvt.coev_rec_type;
32: g_coev_tbl okc_conditions_pvt.coev_tbl_type;
33: g_aavv_rec okc_conditions_pvt.aavv_rec_type;
34: g_aavv_tbl okc_conditions_pvt.aavv_tbl_type;
27: g_cnhv_rec okc_conditions_pvt.cnhv_rec_type;
28: g_cnhv_tbl okc_conditions_pvt.cnhv_tbl_type;
29: g_cnlv_rec okc_conditions_pvt.cnlv_rec_type;
30: g_cnlv_tbl okc_conditions_pvt.cnlv_tbl_type;
31: g_coev_rec okc_conditions_pvt.coev_rec_type;
32: g_coev_tbl okc_conditions_pvt.coev_tbl_type;
33: g_aavv_rec okc_conditions_pvt.aavv_rec_type;
34: g_aavv_tbl okc_conditions_pvt.aavv_tbl_type;
35: g_aalv_rec okc_conditions_pvt.aalv_rec_type;
28: g_cnhv_tbl okc_conditions_pvt.cnhv_tbl_type;
29: g_cnlv_rec okc_conditions_pvt.cnlv_rec_type;
30: g_cnlv_tbl okc_conditions_pvt.cnlv_tbl_type;
31: g_coev_rec okc_conditions_pvt.coev_rec_type;
32: g_coev_tbl okc_conditions_pvt.coev_tbl_type;
33: g_aavv_rec okc_conditions_pvt.aavv_rec_type;
34: g_aavv_tbl okc_conditions_pvt.aavv_tbl_type;
35: g_aalv_rec okc_conditions_pvt.aalv_rec_type;
36: g_aalv_tbl okc_conditions_pvt.aalv_tbl_type;
29: g_cnlv_rec okc_conditions_pvt.cnlv_rec_type;
30: g_cnlv_tbl okc_conditions_pvt.cnlv_tbl_type;
31: g_coev_rec okc_conditions_pvt.coev_rec_type;
32: g_coev_tbl okc_conditions_pvt.coev_tbl_type;
33: g_aavv_rec okc_conditions_pvt.aavv_rec_type;
34: g_aavv_tbl okc_conditions_pvt.aavv_tbl_type;
35: g_aalv_rec okc_conditions_pvt.aalv_rec_type;
36: g_aalv_tbl okc_conditions_pvt.aalv_tbl_type;
37: g_fepv_rec okc_conditions_pvt.fepv_rec_type;
30: g_cnlv_tbl okc_conditions_pvt.cnlv_tbl_type;
31: g_coev_rec okc_conditions_pvt.coev_rec_type;
32: g_coev_tbl okc_conditions_pvt.coev_tbl_type;
33: g_aavv_rec okc_conditions_pvt.aavv_rec_type;
34: g_aavv_tbl okc_conditions_pvt.aavv_tbl_type;
35: g_aalv_rec okc_conditions_pvt.aalv_rec_type;
36: g_aalv_tbl okc_conditions_pvt.aalv_tbl_type;
37: g_fepv_rec okc_conditions_pvt.fepv_rec_type;
38: g_fepv_tbl okc_conditions_pvt.fepv_tbl_type;
31: g_coev_rec okc_conditions_pvt.coev_rec_type;
32: g_coev_tbl okc_conditions_pvt.coev_tbl_type;
33: g_aavv_rec okc_conditions_pvt.aavv_rec_type;
34: g_aavv_tbl okc_conditions_pvt.aavv_tbl_type;
35: g_aalv_rec okc_conditions_pvt.aalv_rec_type;
36: g_aalv_tbl okc_conditions_pvt.aalv_tbl_type;
37: g_fepv_rec okc_conditions_pvt.fepv_rec_type;
38: g_fepv_tbl okc_conditions_pvt.fepv_tbl_type;
39: ---------------------------------------------------------------------------------------
32: g_coev_tbl okc_conditions_pvt.coev_tbl_type;
33: g_aavv_rec okc_conditions_pvt.aavv_rec_type;
34: g_aavv_tbl okc_conditions_pvt.aavv_tbl_type;
35: g_aalv_rec okc_conditions_pvt.aalv_rec_type;
36: g_aalv_tbl okc_conditions_pvt.aalv_tbl_type;
37: g_fepv_rec okc_conditions_pvt.fepv_rec_type;
38: g_fepv_tbl okc_conditions_pvt.fepv_tbl_type;
39: ---------------------------------------------------------------------------------------
40: --Global Exception
33: g_aavv_rec okc_conditions_pvt.aavv_rec_type;
34: g_aavv_tbl okc_conditions_pvt.aavv_tbl_type;
35: g_aalv_rec okc_conditions_pvt.aalv_rec_type;
36: g_aalv_tbl okc_conditions_pvt.aalv_tbl_type;
37: g_fepv_rec okc_conditions_pvt.fepv_rec_type;
38: g_fepv_tbl okc_conditions_pvt.fepv_tbl_type;
39: ---------------------------------------------------------------------------------------
40: --Global Exception
41: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
34: g_aavv_tbl okc_conditions_pvt.aavv_tbl_type;
35: g_aalv_rec okc_conditions_pvt.aalv_rec_type;
36: g_aalv_tbl okc_conditions_pvt.aalv_tbl_type;
37: g_fepv_rec okc_conditions_pvt.fepv_rec_type;
38: g_fepv_tbl okc_conditions_pvt.fepv_tbl_type;
39: ---------------------------------------------------------------------------------------
40: --Global Exception
41: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
42: