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