APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SET_ELE_TYPES

Line 66: -- (which IS defined IN cs_kb_set_ele_types) exists

62: END Is_Element_Updatable;
63:
64:
65: -- check IF at least one statement FOR each mandatory element-type
66: -- (which IS defined IN cs_kb_set_ele_types) exists
67: -- FOR this particular version of solution
68: -- RETURN 'N' IF complete, 'Y' IF there IS any missing ele-types
69: FUNCTION Get_Missing_Ele_Type
70: ( p_set_id IN NUMBER--,

Line 89: FROM CS_KB_SET_ELE_TYPES A, CS_KB_ELEMENT_TYPES_VL B

85:
86: -- list of required element types
87: CURSOR cur_ele_type(p_set_type_id IN NUMBER) IS
88: SELECT B.element_type_id
89: FROM CS_KB_SET_ELE_TYPES A, CS_KB_ELEMENT_TYPES_VL B
90: WHERE A.set_type_id = p_set_type_id
91: AND A.optional_flag = 'N'
92: AND A.element_type_id = B.element_type_id
93: AND trunc(sysdate) between trunc(nvl(B.start_date_active, sysdate)) and trunc(nvl(B.end_date_active, sysdate))

Line 175: FROM cs_kb_set_ele_types se,

171:
172: IF p_set_number IS NOT NULL THEN
173: IF p_element_number IS NOT NULL THEN
174: SELECT count(*) INTO l_count
175: FROM cs_kb_set_ele_types se,
176: cs_kb_sets_b s,
177: cs_kb_elements_b e
178: WHERE se.set_type_id = s.set_type_id
179: AND se.element_type_id = e.element_type_id

Line 185: FROM CS_KB_SET_ELE_TYPES se,

181: AND e.element_number = p_element_number;
182:
183: ELSIF(p_ele_type_id > 0) THEN
184: SELECT count(*) INTO l_count
185: FROM CS_KB_SET_ELE_TYPES se,
186: CS_KB_SETS_B s
187: WHERE se.set_type_id = s.set_type_id
188: AND s.set_number = p_set_number
189: AND se.element_type_id = p_ele_type_id;

Line 195: FROM CS_KB_SET_ELE_TYPES se,

191:
192: ELSIF(p_set_type_id >0) THEN
193: IF p_element_number IS NOT NULL THEN
194: SELECT count(*) INTO l_count
195: FROM CS_KB_SET_ELE_TYPES se,
196: CS_KB_ELEMENTS_B e
197: WHERE se.set_type_id = p_set_type_id
198: AND e.element_number = p_element_number
199: AND se.element_type_id = e.element_type_id;

Line 203: FROM CS_KB_SET_ELE_TYPES se

199: AND se.element_type_id = e.element_type_id;
200:
201: ELSIF(p_ele_type_id >0) THEN
202: SELECT count(*) INTO l_count
203: FROM CS_KB_SET_ELE_TYPES se
204: WHERE se.set_type_id = p_set_type_id
205: AND se.element_type_id = p_ele_type_id;
206: END IF;
207: END IF;

Line 474: FROM CS_KB_SET_ELE_TYPES t, CS_KB_SETS_B s

470: RETURN NUMBER IS--RETURN OKAY_STATUS IF success, or ERROR_STATUS IF fail
471:
472: CURSOR cur_ele_types IS
473: SELECT t.element_type_id
474: FROM CS_KB_SET_ELE_TYPES t, CS_KB_SETS_B s
475: WHERE t.set_type_id = s.set_type_id
476: AND s.set_id = CS_KB_SOLUTION_PVT.Get_Latest_Version_Id(p_set_number)
477: ORDER BY t.element_type_order;
478:

Line 2801: select element_type_id from cs_kb_set_ele_types

2797: l_count NUMBER(15);
2798: l_exists boolean;
2799:
2800: cursor get_elem_type_ids(c_set_type_id IN NUMBER) IS
2801: select element_type_id from cs_kb_set_ele_types
2802: where set_type_id = c_set_type_id;
2803:
2804: BEGIN
2805: