175: CURSOR filtered_category_cur IS
176: SELECT DISTINCT
177: jcfc.category_code,
178: jcfc.category_name
179: FROM ja_cn_fa_category_gt jcfc
180: ORDER BY jcfc.category_code;
181:
182: BEGIN
183: --logging for debug
299: CLOSE category_code_name_cur;
300: lv_combined_category_code := lv_combined_category_code || lv_category_value;
301:
302: -- insert into the temporary table in order to filter the same
303: INSERT INTO ja_cn_fa_category_gt
304: (category_code
305: ,category_name
306: ,created_by
307: ,creation_date
326: THEN
327: lv_combined_category_code := lv_combined_category_code || lv_category_value;
328:
329: -- insert into the temporary table in order to filter the same
330: INSERT INTO ja_cn_fa_category_gt
331: (category_code
332: ,category_name
333: ,created_by
334: ,creation_date