[Home] [Help]
PACKAGE: APPS.OKL_VP_CAT_PVT
Source
1 Package OKL_VP_CAT_PVT AS
2 /* $Header: OKLSCARS.pls 120.1 2005/10/30 04:40:29 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE cat_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
9 sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10 cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11 chr_id NUMBER := OKC_API.G_MISS_NUM,
12 cle_id NUMBER := OKC_API.G_MISS_NUM,
13 cat_id NUMBER := OKC_API.G_MISS_NUM,
14 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
15 object_version_number NUMBER := OKC_API.G_MISS_NUM,
16 created_by NUMBER := OKC_API.G_MISS_NUM,
17 creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19 last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20 fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
21 last_update_login NUMBER := OKC_API.G_MISS_NUM,
22 attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23 attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24 attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25 attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26 attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27 attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28 attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29 attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30 attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31 attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32 attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33 attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34 attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35 attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36 attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37 attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
38 security_group_id NUMBER := OKC_API.G_MISS_NUM);
39 g_miss_cat_rec cat_rec_type;
40 TYPE cat_tbl_type IS TABLE OF cat_rec_type
41 INDEX BY BINARY_INTEGER;
42 TYPE okc_k_articles_tl_rec_type IS RECORD (
43 id NUMBER := OKC_API.G_MISS_NUM,
44 language OKC_K_ARTICLES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
45 source_lang OKC_K_ARTICLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
46 sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47 object_version_number NUMBER := OKC_API.G_MISS_NUM,
48 comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
49 variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50 name OKC_K_ARTICLES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
51 -- text ... commented out to treat empty CLOB as an of empty content:
52 -- if need to nullify it then nullify contents, not the pointer
53 -- text OKC_K_ARTICLES_TL.TEXT%TYPE := OKC_API.G_MISS_CHAR,
54 --+Hand code start
55 -- text OKC_K_ARTICLES_TL.TEXT%TYPE,
56 --+Hand code end
57 created_by NUMBER := OKC_API.G_MISS_NUM,
58 creation_date OKC_K_ARTICLES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
59 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
60 last_update_date OKC_K_ARTICLES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
61 last_update_login NUMBER := OKC_API.G_MISS_NUM,
62 security_group_id NUMBER := OKC_API.G_MISS_NUM,
63 sav_sav_release OKC_K_ARTICLES_TL.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR);
64 g_miss_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
65 TYPE okc_k_articles_tl_tbl_type IS TABLE OF okc_k_articles_tl_rec_type
66 INDEX BY BINARY_INTEGER;
67 TYPE catv_rec_type IS RECORD (
68 id NUMBER := OKC_API.G_MISS_NUM,
69 chr_id NUMBER := OKC_API.G_MISS_NUM,
70 cle_id NUMBER := OKC_API.G_MISS_NUM,
71 cat_id NUMBER := OKC_API.G_MISS_NUM,
72 object_version_number NUMBER := OKC_API.G_MISS_NUM,
73 sfwt_flag OKC_K_ARTICLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74 sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
75 sav_sav_release OKC_K_ARTICLES_V.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
76 sbt_code OKC_K_ARTICLES_V.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
77 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78 comments OKC_K_ARTICLES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
79 fulltext_yn OKC_K_ARTICLES_V.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
80 variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81 name OKC_K_ARTICLES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
82 -- text ... commented out to treat empty CLOB as an of empty content:
83 -- if need to nullify it then nullify contents, not the pointer
84 -- text OKC_K_ARTICLES_V.TEXT%TYPE := OKC_API.G_MISS_CHAR,
85 --+Hand code start
86 -- text OKC_K_ARTICLES_V.TEXT%TYPE,
87 --+Hand code end
88 attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
89 attribute1 OKC_K_ARTICLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
90 attribute2 OKC_K_ARTICLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
91 attribute3 OKC_K_ARTICLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
92 attribute4 OKC_K_ARTICLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
93 attribute5 OKC_K_ARTICLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
94 attribute6 OKC_K_ARTICLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
95 attribute7 OKC_K_ARTICLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
96 attribute8 OKC_K_ARTICLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
97 attribute9 OKC_K_ARTICLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
98 attribute10 OKC_K_ARTICLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
99 attribute11 OKC_K_ARTICLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
100 attribute12 OKC_K_ARTICLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
101 attribute13 OKC_K_ARTICLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
102 attribute14 OKC_K_ARTICLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
103 attribute15 OKC_K_ARTICLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
104 cat_type OKC_K_ARTICLES_V.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
105 created_by NUMBER := OKC_API.G_MISS_NUM,
106 creation_date OKC_K_ARTICLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
108 last_update_date OKC_K_ARTICLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
109 last_update_login NUMBER := OKC_API.G_MISS_NUM);
110 g_miss_catv_rec catv_rec_type;
111 TYPE catv_tbl_type IS TABLE OF catv_rec_type
112 INDEX BY BINARY_INTEGER;
113 ---------------------------------------------------------------------------
114 -- GLOBAL MESSAGE CONSTANTS
115 ---------------------------------------------------------------------------
116 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
117 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
118 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
119 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
120 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
121 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
122 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
123 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
124 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
125 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
126 ---------------------------------------------------------------------------
127 -- GLOBAL VARIABLES
128 ---------------------------------------------------------------------------
129 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CAT_PVT';
130 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
131 ---------------------------------------------------------------------------
132 -- Procedures and Functions
133 ---------------------------------------------------------------------------
134
135 PROCEDURE qc;
136 PROCEDURE change_version;
137 PROCEDURE api_copy;
138 PROCEDURE add_language;
139 PROCEDURE insert_row(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_catv_rec IN catv_rec_type,
146 x_catv_rec OUT NOCOPY catv_rec_type);
147
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_catv_tbl IN catv_tbl_type,
155 x_catv_tbl OUT NOCOPY catv_tbl_type);
156
157 PROCEDURE lock_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_catv_rec IN catv_rec_type);
164
165 PROCEDURE lock_row(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_catv_tbl IN catv_tbl_type);
172
173 PROCEDURE update_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_catv_rec IN catv_rec_type,
180 x_catv_rec OUT NOCOPY catv_rec_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_catv_tbl IN catv_tbl_type,
189 x_catv_tbl OUT NOCOPY catv_tbl_type);
190
191 PROCEDURE delete_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_catv_rec IN catv_rec_type);
198
199 PROCEDURE delete_row(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_catv_tbl IN catv_tbl_type);
206
207 PROCEDURE validate_row(
208 p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 p_catv_rec IN catv_rec_type);
214
215 PROCEDURE validate_row(
216 p_api_version IN NUMBER,
217 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2,
221 p_catv_tbl IN catv_tbl_type);
222
223 PROCEDURE INSERT_ROW_UPG(p_catv_tbl catv_tbl_type);
224
225 FUNCTION create_version(
226 p_chr_id IN NUMBER,
227 p_major_version IN NUMBER) RETURN VARCHAR2;
228
229 FUNCTION restore_version(
230 p_chr_id IN NUMBER,
231 p_major_version IN NUMBER) RETURN VARCHAR2;
232
233 END; -- Package Specification OKL_VP_CAT_PVT