[Home] [Help]
PACKAGE: APPS.OKS_SRVAVLEXC_PVT
Source
1 Package OKS_SRVAVLEXC_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSRSVES.pls 120.0 2005/05/25 18:21:04 appldev noship $ */
3
4 SUBTYPE saxv_rec_type IS OKS_AVLEXC_PVT.saxv_rec_type;
5 SUBTYPE saxv_tbl_type IS OKS_AVLEXC_PVT.saxv_tbl_type;
6
7 -- GLOBAL VARIABLES
8 ---------------------------------------------------------------------------
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_SERVAVAILEXC_PVT';
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11 ---------------------------------------------------------------------------
12
13
14 PROCEDURE insert_serv_avail_exc(
15 p_api_version IN NUMBER,
16 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
17 x_return_status OUT NOCOPY VARCHAR2,
18 x_msg_count OUT NOCOPY NUMBER,
19 x_msg_data OUT NOCOPY VARCHAR2,
20 p_saxv_rec IN saxv_rec_type,
21 x_saxv_rec OUT NOCOPY saxv_rec_type);
22
23
24 PROCEDURE lock_serv_avail_exc(
25 p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 p_saxv_rec IN saxv_rec_type);
31
32
33 PROCEDURE update_serv_avail_exc(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_saxv_rec IN saxv_rec_type,
40 x_saxv_rec OUT NOCOPY saxv_rec_type);
41
42
43 PROCEDURE delete_serv_avail_exc(
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_saxv_rec IN saxv_rec_type);
50
51
52 PROCEDURE validate_serv_avail_exc(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_saxv_rec IN saxv_rec_type);
59
60 End OKS_SRVAVLEXC_PVT;