APPS.CS_KB_ELEMENTS_AUDIT_PKG dependencies on CS_KB_ELEMENTS_B

Line 54: FROM CS_KB_ELEMENTS_B b,

50:
51: BEGIN
52: SELECT b.element_number, b.element_type_id, b.access_level, tl.name, tl.description
53: INTO l_element_number, l_element_type_id, l_access_level, l_name, l_desc
54: FROM CS_KB_ELEMENTS_B b,
55: CS_KB_ELEMENTS_TL tl
56: WHERE b.element_id = tl.element_id
57: AND tl.language = USERENV('LANG')
58: AND b.element_id = p_element_id;

Line 87: CS_KB_ELEMENTS_B b

83: SELECT tl.element_id,
84: tl.description,
85: b.status
86: FROM CS_KB_ELEMENTS_TL tl,
87: CS_KB_ELEMENTS_B b
88: WHERE tl.name = c_name
89: AND tl.language = USERENV('LANG')
90: AND tl.element_id = b.element_id
91: AND b.element_number <> c_element_number

Line 145: FROM CS_KB_ELEMENTS_B

141: BEGIN
142:
143: SELECT element_number
144: INTO l_element_number
145: FROM CS_KB_ELEMENTS_B
146: WHERE element_id = p_element_id;
147:
148: RETURN l_element_number;
149:

Line 162: FROM CS_KB_ELEMENTS_B

158:
159: BEGIN
160: SELECT MAX(element_id)
161: INTO l_latest_version_id
162: FROM CS_KB_ELEMENTS_B
163: WHERE element_number = p_element_number;
164: IF (SQL%NOTFOUND) THEN
165: RAISE NO_DATA_FOUND;
166: END IF;

Line 676: FROM CS_KB_ELEMENTS_B

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;
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;

Line 824: FROM CS_KB_ELEMENTS_B

820:
821: CURSOR validate_old_type_used_csr(p_element_type_id IN NUMBER,
822: p_element_id IN NUMBER) IS
823: SELECT 'x'
824: FROM CS_KB_ELEMENTS_B
825: WHERE element_id = p_element_id
826: AND element_type_id = p_element_type_id;
827:
828: BEGIN

Line 984: FROM CS_KB_ELEMENTS_B

980: attribute12,
981: attribute13,
982: attribute14,
983: attribute15
984: FROM CS_KB_ELEMENTS_B
985: WHERE Element_id = P_ELEMENT_ID;
986:
987: CURSOR Get_Current_Cat_Group_Solns IS
988: SELECT distinct s.Set_id, s.Set_Number

Line 1036: FROM CS_KB_ELEMENTS_B

1032: AND se.element_id = v_dup_id);
1033:
1034: CURSOR Get_Element_Number IS
1035: SELECT Element_Number
1036: FROM CS_KB_ELEMENTS_B
1037: WHERE Element_id = P_ELEMENT_ID;
1038:
1039:
1040: CURSOR Stmt_In_Soln_Outside_Cur_CG IS

Line 1399: FROM CS_KB_ELEMENTS_B E

1395: IS
1396:
1397: CURSOR GET_ORPHANS IS
1398: SELECT E.element_id
1399: FROM CS_KB_ELEMENTS_B E
1400: WHERE E.status <> 'OBS'
1401: AND NOT EXISTS (SELECT 'x'
1402: FROM CS_KB_SETS_B S,
1403: CS_KB_SET_ELES SE

Line 1417: UPDATE CS_KB_ELEMENTS_B

1413: BEGIN
1414:
1415: FOR Statements IN GET_ORPHANS LOOP
1416:
1417: UPDATE CS_KB_ELEMENTS_B
1418: SET Status = 'OBS',
1419: Last_Update_Date = sysdate,
1420: Last_Updated_By = l_user,
1421: Last_Update_Login = l_login