1: package okc_process_pub as
2: /* $Header: OKCPPDFS.pls 120.0 2005/05/26 09:28:34 appldev noship $ */
3:
4: -- complex entity object subtype definitions
5: subtype pdfv_rec_type is okc_process_pvt.pdfv_rec_type;
6: subtype pdfv_tbl_type is okc_process_pvt.pdfv_tbl_type;
7: subtype pdpv_rec_type is okc_process_pvt.pdpv_rec_type;
8: subtype pdpv_tbl_type is okc_process_pvt.pdpv_tbl_type;
9:
2: /* $Header: OKCPPDFS.pls 120.0 2005/05/26 09:28:34 appldev noship $ */
3:
4: -- complex entity object subtype definitions
5: subtype pdfv_rec_type is okc_process_pvt.pdfv_rec_type;
6: subtype pdfv_tbl_type is okc_process_pvt.pdfv_tbl_type;
7: subtype pdpv_rec_type is okc_process_pvt.pdpv_rec_type;
8: subtype pdpv_tbl_type is okc_process_pvt.pdpv_tbl_type;
9:
10: ---------------------------------------------------------------------------------------
3:
4: -- complex entity object subtype definitions
5: subtype pdfv_rec_type is okc_process_pvt.pdfv_rec_type;
6: subtype pdfv_tbl_type is okc_process_pvt.pdfv_tbl_type;
7: subtype pdpv_rec_type is okc_process_pvt.pdpv_rec_type;
8: subtype pdpv_tbl_type is okc_process_pvt.pdpv_tbl_type;
9:
10: ---------------------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
4: -- complex entity object subtype definitions
5: subtype pdfv_rec_type is okc_process_pvt.pdfv_rec_type;
6: subtype pdfv_tbl_type is okc_process_pvt.pdfv_tbl_type;
7: subtype pdpv_rec_type is okc_process_pvt.pdpv_rec_type;
8: subtype pdpv_tbl_type is okc_process_pvt.pdpv_tbl_type;
9:
10: ---------------------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------------------
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
16: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
17: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
18:
19: g_pdfv_rec okc_process_pvt.pdfv_rec_type;
20: g_pdfv_tbl okc_process_pvt.pdfv_tbl_type;
21: g_pdpv_rec okc_process_pvt.pdpv_rec_type;
22: g_pdpv_tbl okc_process_pvt.pdpv_tbl_type;
23: ---------------------------------------------------------------------------------------
16: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
17: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
18:
19: g_pdfv_rec okc_process_pvt.pdfv_rec_type;
20: g_pdfv_tbl okc_process_pvt.pdfv_tbl_type;
21: g_pdpv_rec okc_process_pvt.pdpv_rec_type;
22: g_pdpv_tbl okc_process_pvt.pdpv_tbl_type;
23: ---------------------------------------------------------------------------------------
24: --Global Exception
17: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
18:
19: g_pdfv_rec okc_process_pvt.pdfv_rec_type;
20: g_pdfv_tbl okc_process_pvt.pdfv_tbl_type;
21: g_pdpv_rec okc_process_pvt.pdpv_rec_type;
22: g_pdpv_tbl okc_process_pvt.pdpv_tbl_type;
23: ---------------------------------------------------------------------------------------
24: --Global Exception
25: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18:
19: g_pdfv_rec okc_process_pvt.pdfv_rec_type;
20: g_pdfv_tbl okc_process_pvt.pdfv_tbl_type;
21: g_pdpv_rec okc_process_pvt.pdpv_rec_type;
22: g_pdpv_tbl okc_process_pvt.pdpv_tbl_type;
23: ---------------------------------------------------------------------------------------
24: --Global Exception
25: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
26: