DBA Data[Home] [Help]

APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_SETS_S

Line 430: CS_KB_SETS_S.NEXTVAL,

426: visibility_id,
427: USAGE_SCORE,
428: NORM_USAGE_SCORE
429: ) VALUES (
430: CS_KB_SETS_S.NEXTVAL,
431: b_rec.set_number,
432: b_rec.set_type_id,
433: p_status,
434: l_SYSDATE,

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