APPS.CS_KB_SOLN_CATEGORIES_PVT dependencies on CS_KB_SET_CATEGORIES

Line 140: from cs_kb_set_categories sl, cs_kb_sets_b b

136: */
137: begin
138:
139: select /*+ index(sl) */ count( * ) into n_child_solutions
140: from cs_kb_set_categories sl, cs_kb_sets_b b
141: where sl.category_id = p_category_id
142: and b.set_id = sl.set_id
143: --and b.status = 'PUB';
144: and (b.status = 'PUB' or (b.status <> 'OBS' and b.latest_version_flag = 'Y'));

Line 164: delete /*+ index(sl) */ from cs_kb_set_categories sl

160: p_data => X_MSG_DATA);
161:
162: ELSE
163: -- Delete all set category links (which should not be PUBlished versions)
164: delete /*+ index(sl) */ from cs_kb_set_categories sl
165: where sl.category_id = p_category_id;
166: /* for linkIdRec in removeLinksCsr
167: ( p_category_id, soln_category_link_obj_code )
168: loop

Line 496: -- 11510 - This procedure has been changed to use cs_kb_set_categories

492: p_data => X_MSG_DATA);
493:
494: end updateCategory;
495:
496: -- 11510 - This procedure has been changed to use cs_kb_set_categories
497: -- The x_soln_category_link_id out parameter is no longer
498: -- used, so it will always return 0.
499: procedure addSolutionToCategory
500: (

Line 523: -- There is no PL/SQL table handler for the cs_kb_set_categories

519: -- Validation is done here
520:
521: SAVEPOINT linkSolutionToCategoryTran;
522:
523: -- There is no PL/SQL table handler for the cs_kb_set_categories
524: -- linking table yet. This code will directly perform insert.
525: insert into CS_KB_SET_CATEGORIES (
526: SET_ID,
527: CATEGORY_ID,

Line 525: insert into CS_KB_SET_CATEGORIES (

521: SAVEPOINT linkSolutionToCategoryTran;
522:
523: -- There is no PL/SQL table handler for the cs_kb_set_categories
524: -- linking table yet. This code will directly perform insert.
525: insert into CS_KB_SET_CATEGORIES (
526: SET_ID,
527: CATEGORY_ID,
528: CREATION_DATE,
529: CREATED_BY,

Line 597: -- 11.5.10 dev - This procedure has been changed to use cs_kb_set_categories.

593: x_msg_count := 0;
594: x_msg_data := null;
595: end addSolutionToCategory;
596:
597: -- 11.5.10 dev - This procedure has been changed to use cs_kb_set_categories.
598: -- Need to handle error better.
599: procedure removeSolutionFromCategory
600: (
601: p_api_version in number,

Line 616: delete from cs_kb_set_categories

612: begin
613: -- Validation here
614:
615: -- Remove the links
616: delete from cs_kb_set_categories
617: where set_id = p_solution_id
618: and category_id = p_category_id;
619:
620: x_return_status := fnd_api.g_ret_sts_success;

Line 754: from cs_kb_set_categories sl, cs_kb_sets_b b

750:
751: cursor get_pub_inprog(cp_category_id number)
752: is
753: select /*+ index(sl) */ b.set_id
754: from cs_kb_set_categories sl, cs_kb_sets_b b
755: where sl.category_id = cp_category_id
756: and b.set_id = sl.set_id
757: and (b.status = 'PUB' or (b.status <> 'OBS' and b.latest_version_flag = 'Y'));
758: