[Home] [Help]
PACKAGE: APPS.OKC_TAV_PVT
Source
1 Package OKC_TAV_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSTAVS.pls 120.0 2005/05/25 19:42:45 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
8 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
9 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
10 G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
11 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
12 TYPE tve_rec_type IS RECORD (
13 id NUMBER := OKC_API.G_MISS_NUM,
14 spn_id NUMBER := OKC_API.G_MISS_NUM,
15 tve_id_offset NUMBER := OKC_API.G_MISS_NUM,
16 uom_code OKC_TIMEVALUES.uom_code%TYPE := OKC_API.G_MISS_CHAR,
17 cnh_id NUMBER := OKC_API.G_MISS_NUM,
18 tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
20 tze_id NUMBER := OKC_API.G_MISS_NUM,
21 tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22 tve_id_started NUMBER := OKC_API.G_MISS_NUM,
23 tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
24 tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25 object_version_number NUMBER := OKC_API.G_MISS_NUM,
26 created_by NUMBER := OKC_API.G_MISS_NUM,
27 creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29 last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30 duration NUMBER := OKC_API.G_MISS_NUM,
31 operator OKC_TIMEVALUES.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
32 before_after OKC_TIMEVALUES.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
33 datetime OKC_TIMEVALUES.DATETIME%TYPE := OKC_API.G_MISS_DATE,
34 month NUMBER := OKC_API.G_MISS_NUM,
35 day NUMBER := OKC_API.G_MISS_NUM,
36 hour NUMBER := OKC_API.G_MISS_NUM,
37 minute NUMBER := OKC_API.G_MISS_NUM,
38 second NUMBER := OKC_API.G_MISS_NUM,
39 interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
40 nth NUMBER := OKC_API.G_MISS_NUM,
41 day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
42 last_update_login NUMBER := OKC_API.G_MISS_NUM,
43 attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44 --Bug 3122962
45 name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
46 description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
47 short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
48 comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
49 attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
50 attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
51 attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
52 attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
53 attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
54 attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
55 attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
56 attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
57 attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
58 attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
59 attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
60 attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
61 attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
62 attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
63 attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
64 g_miss_tve_rec tve_rec_type;
65 TYPE tve_tbl_type IS TABLE OF tve_rec_type
66 INDEX BY BINARY_INTEGER;
67 /* TYPE okc_timevalues_tl_rec_type IS RECORD (
68 id NUMBER := OKC_API.G_MISS_NUM,
69 language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
70 source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
71 sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72 description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73 short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
74 comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
75 name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
76 created_by NUMBER := OKC_API.G_MISS_NUM,
77 creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79 last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80 last_update_login NUMBER := OKC_API.G_MISS_NUM);
81 g_miss_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
82 TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type
83 INDEX BY BINARY_INTEGER;
84 */
85 TYPE tavv_rec_type IS RECORD (
86 id NUMBER := OKC_API.G_MISS_NUM,
87 object_version_number NUMBER := OKC_API.G_MISS_NUM,
88 --Bug 3122962
89 sfwt_flag OKC_TIME_TPA_VALUE_V.SFWT_FLAG%TYPE := 'N',
90 spn_id NUMBER := OKC_API.G_MISS_NUM,
91 tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
92 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
93 tze_id NUMBER := OKC_API.G_MISS_NUM,
94 tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95 description OKC_TIME_TPA_VALUE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
96 short_description OKC_TIME_TPA_VALUE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97 comments OKC_TIME_TPA_VALUE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
98 datetime OKC_TIME_TPA_VALUE_V.DATETIME%TYPE := OKC_API.G_MISS_DATE,
99 attribute_category OKC_TIME_TPA_VALUE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
100 attribute1 OKC_TIME_TPA_VALUE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
101 attribute2 OKC_TIME_TPA_VALUE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
102 attribute3 OKC_TIME_TPA_VALUE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
103 attribute4 OKC_TIME_TPA_VALUE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
104 attribute5 OKC_TIME_TPA_VALUE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
105 attribute6 OKC_TIME_TPA_VALUE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
106 attribute7 OKC_TIME_TPA_VALUE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
107 attribute8 OKC_TIME_TPA_VALUE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
108 attribute9 OKC_TIME_TPA_VALUE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
109 attribute10 OKC_TIME_TPA_VALUE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
110 attribute11 OKC_TIME_TPA_VALUE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
111 attribute12 OKC_TIME_TPA_VALUE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
112 attribute13 OKC_TIME_TPA_VALUE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
113 attribute14 OKC_TIME_TPA_VALUE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
114 attribute15 OKC_TIME_TPA_VALUE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
115 created_by NUMBER := OKC_API.G_MISS_NUM,
116 creation_date OKC_TIME_TPA_VALUE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
117 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
118 last_update_date OKC_TIME_TPA_VALUE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
119 last_update_login NUMBER := OKC_API.G_MISS_NUM);
120 g_miss_tavv_rec tavv_rec_type;
121 TYPE tavv_tbl_type IS TABLE OF tavv_rec_type
122 INDEX BY BINARY_INTEGER;
123 ---------------------------------------------------------------------------
124 -- GLOBAL MESSAGE CONSTANTS
125 ---------------------------------------------------------------------------
126 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
127 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
128 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
129 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
130 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
131 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
132 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
133 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
134 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
135 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
136 ---------------------------------------------------------------------------
137 -- GLOBAL VARIABLES
138 ---------------------------------------------------------------------------
139 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TAV_PVT';
140 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
141 ---------------------------------------------------------------------------
142 -- Procedures and Functions
143 ---------------------------------------------------------------------------
144
145 PROCEDURE qc;
146 PROCEDURE change_version;
147 PROCEDURE api_copy;
148 PROCEDURE insert_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_tavv_rec IN tavv_rec_type,
155 x_tavv_rec OUT NOCOPY tavv_rec_type);
156
157 PROCEDURE insert_row(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_tavv_tbl IN tavv_tbl_type,
164 x_tavv_tbl OUT NOCOPY tavv_tbl_type);
165
166 PROCEDURE lock_row(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_tavv_rec IN tavv_rec_type);
173
174 PROCEDURE lock_row(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_tavv_tbl IN tavv_tbl_type);
181
182 PROCEDURE update_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_tavv_rec IN tavv_rec_type,
189 x_tavv_rec OUT NOCOPY tavv_rec_type);
190
191 PROCEDURE update_row(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_tavv_tbl IN tavv_tbl_type,
198 x_tavv_tbl OUT NOCOPY tavv_tbl_type);
199
200 PROCEDURE delete_row(
201 p_api_version IN NUMBER,
202 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2,
206 p_tavv_rec IN tavv_rec_type);
207
208 PROCEDURE delete_row(
209 p_api_version IN NUMBER,
210 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214 p_tavv_tbl IN tavv_tbl_type);
215
216 PROCEDURE validate_row(
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2,
222 p_tavv_rec IN tavv_rec_type);
223
224 PROCEDURE validate_row(
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_tavv_tbl IN tavv_tbl_type);
231
232 FUNCTION create_version(
233 p_chr_id IN NUMBER,
234 p_major_version IN NUMBER) RETURN VARCHAR2;
235
236 FUNCTION restore_version(
237 p_chr_id IN NUMBER,
238 p_major_version IN NUMBER) RETURN VARCHAR2;
239
240 END OKC_TAV_PVT;