[Home] [Help]
PACKAGE: APPS.OKL_POT_PVT
Source
1 PACKAGE OKL_POT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSPOTS.pls 115.1 2002/12/12 01:42:10 mvasudev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_POOL_TYPES_V Record Spec
7 TYPE potv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10 ,code OKL_POOL_TYPES_V.CODE%TYPE := OKC_API.G_MISS_CHAR
11 ,description OKL_POOL_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12 ,short_description OKL_POOL_TYPES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13 ,from_date OKL_POOL_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
14 ,to_date OKL_POOL_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
15 ,attribute_category OKL_POOL_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
16 ,attribute1 OKL_POOL_TYPES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
17 ,attribute2 OKL_POOL_TYPES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
18 ,attribute3 OKL_POOL_TYPES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
19 ,attribute4 OKL_POOL_TYPES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
20 ,attribute5 OKL_POOL_TYPES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
21 ,attribute6 OKL_POOL_TYPES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
22 ,attribute7 OKL_POOL_TYPES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
23 ,attribute8 OKL_POOL_TYPES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
24 ,attribute9 OKL_POOL_TYPES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
25 ,attribute10 OKL_POOL_TYPES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
26 ,attribute11 OKL_POOL_TYPES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
27 ,attribute12 OKL_POOL_TYPES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
28 ,attribute13 OKL_POOL_TYPES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
29 ,attribute14 OKL_POOL_TYPES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
30 ,attribute15 OKL_POOL_TYPES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
31 ,created_by NUMBER := OKC_API.G_MISS_NUM
32 ,creation_date OKL_POOL_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
33 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
34 ,last_update_date OKL_POOL_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
35 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
36 G_MISS_potv_rec potv_rec_type;
37 TYPE potv_tbl_type IS TABLE OF potv_rec_type
38 INDEX BY BINARY_INTEGER;
39 -- OKL_POOL_TYPES Record Spec
40 TYPE pot_rec_type IS RECORD (
41 id NUMBER := OKC_API.G_MISS_NUM
42 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43 ,code OKL_POOL_TYPES.CODE%TYPE := OKC_API.G_MISS_CHAR
44 ,description OKL_POOL_TYPES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
45 ,short_description OKL_POOL_TYPES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
46 ,from_date OKL_POOL_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
47 ,to_date OKL_POOL_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
48 ,attribute_category OKL_POOL_TYPES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49 ,attribute1 OKL_POOL_TYPES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50 ,attribute2 OKL_POOL_TYPES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51 ,attribute3 OKL_POOL_TYPES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52 ,attribute4 OKL_POOL_TYPES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53 ,attribute5 OKL_POOL_TYPES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54 ,attribute6 OKL_POOL_TYPES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55 ,attribute7 OKL_POOL_TYPES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56 ,attribute8 OKL_POOL_TYPES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57 ,attribute9 OKL_POOL_TYPES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58 ,attribute10 OKL_POOL_TYPES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59 ,attribute11 OKL_POOL_TYPES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60 ,attribute12 OKL_POOL_TYPES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61 ,attribute13 OKL_POOL_TYPES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62 ,attribute14 OKL_POOL_TYPES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63 ,attribute15 OKL_POOL_TYPES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64 ,created_by NUMBER := OKC_API.G_MISS_NUM
65 ,creation_date OKL_POOL_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67 ,last_update_date OKL_POOL_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
69 G_MISS_pot_rec pot_rec_type;
70 TYPE pot_tbl_type IS TABLE OF pot_rec_type
71 INDEX BY BINARY_INTEGER;
72 ---------------------------------------------------------------------------
73 -- GLOBAL MESSAGE CONSTANTS
74 ---------------------------------------------------------------------------
75 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
76 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
77 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
83 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
84 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
85 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
86 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
87 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
88 -- mvasudev, 11/08/2002
89 G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
90
91 ---------------------------------------------------------------------------
92 -- GLOBAL EXCEPTIONS
93 ---------------------------------------------------------------------------
94 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
95
96 ---------------------------------------------------------------------------
97 -- GLOBAL VARIABLES
98 ---------------------------------------------------------------------------
99 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_POT_PVT';
100 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
101 ---------------------------------------------------------------------------
102 -- Procedures and Functions
103 ---------------------------------------------------------------------------
104
105 PROCEDURE qc;
106 PROCEDURE change_version;
107 PROCEDURE api_copy;
108 PROCEDURE insert_row(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_potv_rec IN potv_rec_type,
115 x_potv_rec OUT NOCOPY potv_rec_type);
116 PROCEDURE insert_row(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_potv_tbl IN potv_tbl_type,
123 x_potv_tbl OUT NOCOPY potv_tbl_type,
124 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
125 PROCEDURE insert_row(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_potv_tbl IN potv_tbl_type,
132 x_potv_tbl OUT NOCOPY potv_tbl_type);
133 PROCEDURE lock_row(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 p_potv_rec IN potv_rec_type);
140 PROCEDURE lock_row(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_potv_tbl IN potv_tbl_type,
147 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
148 PROCEDURE lock_row(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_potv_tbl IN potv_tbl_type);
155 PROCEDURE update_row(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_potv_rec IN potv_rec_type,
162 x_potv_rec OUT NOCOPY potv_rec_type);
163 PROCEDURE update_row(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_potv_tbl IN potv_tbl_type,
170 x_potv_tbl OUT NOCOPY potv_tbl_type,
171 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
172 PROCEDURE update_row(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_potv_tbl IN potv_tbl_type,
179 x_potv_tbl OUT NOCOPY potv_tbl_type);
180 PROCEDURE delete_row(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_potv_rec IN potv_rec_type);
187 PROCEDURE delete_row(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_potv_tbl IN potv_tbl_type,
194 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
195 PROCEDURE delete_row(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_potv_tbl IN potv_tbl_type);
202 PROCEDURE validate_row(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_potv_rec IN potv_rec_type);
209 PROCEDURE validate_row(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_potv_tbl IN potv_tbl_type,
216 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
217 PROCEDURE validate_row(
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 p_potv_tbl IN potv_tbl_type);
224 END OKL_POT_PVT;