APPS.CS_KB_ELEMENTS_AUDIT_PKG dependencies on DUAL

Line 669: SELECT CS_KB_ELEMENTS_S.NEXTVAL INTO l_element_id FROM DUAL;

665: p_data => x_msg_data);
666: ELSE
667:
668: IF x_element_id is null THEN
669: SELECT CS_KB_ELEMENTS_S.NEXTVAL INTO l_element_id FROM DUAL;
670: x_element_id := l_element_id;
671: END IF;
672:
673: SELECT TO_CHAR(CS_KB_ELEMENT_NUMBER_S.NEXTVAL) INTO l_element_number FROM DUAL;

Line 673: SELECT TO_CHAR(CS_KB_ELEMENT_NUMBER_S.NEXTVAL) INTO l_element_number FROM DUAL;

669: SELECT CS_KB_ELEMENTS_S.NEXTVAL INTO l_element_id FROM DUAL;
670: x_element_id := l_element_id;
671: END IF;
672:
673: SELECT TO_CHAR(CS_KB_ELEMENT_NUMBER_S.NEXTVAL) INTO l_element_number FROM DUAL;
674: LOOP
675: SELECT COUNT(element_number) INTO l_count
676: FROM CS_KB_ELEMENTS_B
677: WHERE element_number = l_element_number;

Line 679: SELECT TO_CHAR(CS_KB_ELEMENT_NUMBER_S.NEXTVAL) INTO l_element_number FROM DUAL;

675: SELECT COUNT(element_number) INTO l_count
676: FROM CS_KB_ELEMENTS_B
677: WHERE element_number = l_element_number;
678: EXIT WHEN l_count = 0;
679: SELECT TO_CHAR(CS_KB_ELEMENT_NUMBER_S.NEXTVAL) INTO l_element_number FROM DUAL;
680: END LOOP;
681:
682: IF x_element_id IS NULL OR l_element_number IS NULL THEN
683: FND_MSG_PUB.initialize;