[Home] [Help]
PACKAGE: APPS.OKS_SRVAVLEXC_PUB
Source
1 Package OKS_SRVAVLEXC_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSPSVES.pls 120.0 2005/05/25 18:34:27 appldev noship $ */
3
4 SUBTYPE saxv_rec_type IS OKS_SRVAVLEXC_PVT.saxv_rec_type;
5 SUBTYPE saxv_tbl_type IS OKS_SRVAVLEXC_PVT.saxv_tbl_type;
6
7 -- GLOBAL VARIABLES
8 ---------------------------------------------------------------------------
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_SERVAVAILEXC_PUB';
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11 G_SAXV_REC saxv_rec_type;
12 ---------------------------------------------------------------------------
13
14 -- GLOBAL_MESSAGE_CONSTANTS
15 ---------------------------------------------------------------------------
16 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
17 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
18 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
19 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
20 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
21 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
22 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
23 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
24 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
25 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
26 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
27 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
28 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
29 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
30 ---------------------------------------------------------------------------
31
32 -- GLOBAL EXCEPTION
33 ---------------------------------------------------------------------------
34 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
35 ---------------------------------------------------------------------------
36
37
38 PROCEDURE insert_serv_avail_exc(
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_saxv_rec IN saxv_rec_type,
45 x_saxv_rec OUT NOCOPY saxv_rec_type);
46
47 PROCEDURE insert_serv_avail_exc(
48 p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 p_saxv_tbl IN saxv_tbl_type,
54 x_saxv_tbl OUT NOCOPY saxv_tbl_type);
55
56 PROCEDURE lock_serv_avail_exc(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_saxv_rec IN saxv_rec_type);
63
64 PROCEDURE lock_serv_avail_exc(
65 p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_saxv_tbl IN saxv_tbl_type);
71
72 PROCEDURE update_serv_avail_exc(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 p_saxv_rec IN saxv_rec_type,
79 x_saxv_rec OUT NOCOPY saxv_rec_type);
80
81 PROCEDURE update_serv_avail_exc(
82 p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 p_saxv_tbl IN saxv_tbl_type,
88 x_saxv_tbl OUT NOCOPY saxv_tbl_type);
89
90 PROCEDURE delete_serv_avail_exc(
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 p_saxv_rec IN saxv_rec_type);
97
98 PROCEDURE delete_serv_avail_exc(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_saxv_tbl IN saxv_tbl_type);
105
106 PROCEDURE validate_serv_avail_exc(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_saxv_rec IN saxv_rec_type);
113
114 PROCEDURE validate_serv_avail_exc(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_saxv_tbl IN saxv_tbl_type);
121
122 END OKS_SRVAVLEXC_PUB;