APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_SET_NUMBER_S

Line 854: SELECT TO_CHAR(CS_KB_SET_NUMBER_S.NEXTVAL) INTO x_set_number FROM DUAL;

850: IF x_set_id IS NULL THEN
851: SELECT CS_KB_SETS_S.NEXTVAL INTO x_set_id FROM DUAL;
852: END IF;
853:
854: SELECT TO_CHAR(CS_KB_SET_NUMBER_S.NEXTVAL) INTO x_set_number FROM DUAL;
855: LOOP
856: SELECT COUNT(set_number) INTO l_count
857: FROM CS_KB_SETS_B
858: WHERE set_number = x_set_number;

Line 860: SELECT TO_CHAR(CS_KB_SET_NUMBER_S.NEXTVAL) INTO x_set_number FROM DUAL;

856: SELECT COUNT(set_number) INTO l_count
857: FROM CS_KB_SETS_B
858: WHERE set_number = x_set_number;
859: EXIT WHEN l_count = 0;
860: SELECT TO_CHAR(CS_KB_SET_NUMBER_S.NEXTVAL) INTO x_set_number FROM DUAL;
861: END LOOP;
862:
863: IF x_set_id is NULL OR x_set_number is null THEN
864: FND_MSG_PUB.initialize;