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 184: FROM cs_kb_set_ele_types se,

180:
181: IF p_set_number IS NOT NULL THEN
182: IF p_element_number IS NOT NULL THEN
183: SELECT count(*) INTO l_count
184: FROM cs_kb_set_ele_types se,
185: cs_kb_sets_b s,
186: cs_kb_elements_b e
187: WHERE se.set_type_id = s.set_type_id
188: AND se.element_type_id = e.element_type_id

Line 194: FROM CS_KB_SET_ELE_TYPES se,

190: AND e.element_number = p_element_number;
191:
192: ELSIF(p_ele_type_id > 0) THEN
193: SELECT count(*) INTO l_count
194: FROM CS_KB_SET_ELE_TYPES se,
195: CS_KB_SETS_B s
196: WHERE se.set_type_id = s.set_type_id
197: AND s.set_number = p_set_number
198: AND se.element_type_id = p_ele_type_id;

Line 204: FROM CS_KB_SET_ELE_TYPES se,

200:
201: ELSIF(p_set_type_id >0) THEN
202: IF p_element_number IS NOT NULL THEN
203: SELECT count(*) INTO l_count
204: FROM CS_KB_SET_ELE_TYPES se,
205: CS_KB_ELEMENTS_B e
206: WHERE se.set_type_id = p_set_type_id
207: AND e.element_number = p_element_number
208: AND se.element_type_id = e.element_type_id;

Line 212: FROM CS_KB_SET_ELE_TYPES se

208: AND se.element_type_id = e.element_type_id;
209:
210: ELSIF(p_ele_type_id >0) THEN
211: SELECT count(*) INTO l_count
212: FROM CS_KB_SET_ELE_TYPES se
213: WHERE se.set_type_id = p_set_type_id
214: AND se.element_type_id = p_ele_type_id;
215: END IF;
216: END IF;

Line 483: FROM CS_KB_SET_ELE_TYPES t, CS_KB_SETS_B s

479: RETURN NUMBER IS--RETURN OKAY_STATUS IF success, or ERROR_STATUS IF fail
480:
481: CURSOR cur_ele_types IS
482: SELECT t.element_type_id
483: FROM CS_KB_SET_ELE_TYPES t, CS_KB_SETS_B s
484: WHERE t.set_type_id = s.set_type_id
485: AND s.set_id = CS_KB_SOLUTION_PVT.Get_Latest_Version_Id(p_set_number)
486: ORDER BY t.element_type_order;
487:

Line 2811: select element_type_id from cs_kb_set_ele_types

2807: l_count NUMBER(15);
2808: l_exists boolean;
2809:
2810: cursor get_elem_type_ids(c_set_type_id IN NUMBER) IS
2811: select element_type_id from cs_kb_set_ele_types
2812: where set_type_id = c_set_type_id;
2813:
2814: BEGIN
2815: