APPS.CS_KB_SOLUTION_PVT dependencies on DUAL

Line 837: SELECT CS_KB_SETS_S.NEXTVAL INTO x_set_id FROM DUAL;

833: p_data => X_MSG_DATA);
834: ELSE
835:
836: IF x_set_id IS NULL THEN
837: SELECT CS_KB_SETS_S.NEXTVAL INTO x_set_id FROM DUAL;
838: END IF;
839:
840: SELECT TO_CHAR(CS_KB_SET_NUMBER_S.NEXTVAL) INTO x_set_number FROM DUAL;
841: LOOP

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

836: IF x_set_id IS NULL THEN
837: SELECT CS_KB_SETS_S.NEXTVAL INTO x_set_id FROM DUAL;
838: END IF;
839:
840: SELECT TO_CHAR(CS_KB_SET_NUMBER_S.NEXTVAL) INTO x_set_number FROM DUAL;
841: LOOP
842: SELECT COUNT(set_number) INTO l_count
843: FROM CS_KB_SETS_B
844: WHERE set_number = x_set_number;

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

842: SELECT COUNT(set_number) INTO l_count
843: FROM CS_KB_SETS_B
844: WHERE set_number = x_set_number;
845: EXIT WHEN l_count = 0;
846: SELECT TO_CHAR(CS_KB_SET_NUMBER_S.NEXTVAL) INTO x_set_number FROM DUAL;
847: END LOOP;
848:
849: IF x_set_id is NULL OR x_set_number is null THEN
850: FND_MSG_PUB.initialize;