26: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
27: ---------------------------------------------------------------------------
28: -- GLOBAL VARIABLES
29: ---------------------------------------------------------------------------
30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_PAV_PVT';
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
32: ---------------------------
33: --FUNCTIONs AND Procedures
34: ---------------------------
32: ---------------------------
33: --FUNCTIONs AND Procedures
34: ---------------------------
35: FUNCTION get_rec (
36: p_pav_rec IN OKC_PAV_PVT.pav_rec_type,
37: x_no_data_found OUT NOCOPY BOOLEAN
38: ) RETURN OKC_PAV_PVT.pav_rec_type ;
39:
40: FUNCTION get_rec (
34: ---------------------------
35: FUNCTION get_rec (
36: p_pav_rec IN OKC_PAV_PVT.pav_rec_type,
37: x_no_data_found OUT NOCOPY BOOLEAN
38: ) RETURN OKC_PAV_PVT.pav_rec_type ;
39:
40: FUNCTION get_rec (
41: p_pavv_rec IN OKC_PAV_PVT.pavv_rec_type,
42: x_no_data_found OUT NOCOPY BOOLEAN
37: x_no_data_found OUT NOCOPY BOOLEAN
38: ) RETURN OKC_PAV_PVT.pav_rec_type ;
39:
40: FUNCTION get_rec (
41: p_pavv_rec IN OKC_PAV_PVT.pavv_rec_type,
42: x_no_data_found OUT NOCOPY BOOLEAN
43: ) RETURN OKC_PAV_PVT.pavv_rec_type;
44:
45:
39:
40: FUNCTION get_rec (
41: p_pavv_rec IN OKC_PAV_PVT.pavv_rec_type,
42: x_no_data_found OUT NOCOPY BOOLEAN
43: ) RETURN OKC_PAV_PVT.pavv_rec_type;
44:
45:
46: FUNCTION null_out_defaults (
47: p_pavv_rec IN OKC_PAV_PVT.pavv_rec_type
43: ) RETURN OKC_PAV_PVT.pavv_rec_type;
44:
45:
46: FUNCTION null_out_defaults (
47: p_pavv_rec IN OKC_PAV_PVT.pavv_rec_type
48: ) RETURN OKC_PAV_PVT.pavv_rec_type ;
49:
50: END OKC_SPLIT1_PAV_PVT;
44:
45:
46: FUNCTION null_out_defaults (
47: p_pavv_rec IN OKC_PAV_PVT.pavv_rec_type
48: ) RETURN OKC_PAV_PVT.pavv_rec_type ;
49:
50: END OKC_SPLIT1_PAV_PVT;