APPS.CS_KB_ELEMENTS_AUDIT_PKG dependencies on CS_KB_ELEMENTS_TL

Line 55: CS_KB_ELEMENTS_TL tl

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

Line 86: FROM CS_KB_ELEMENTS_TL tl,

82: c_access_level IN NUMBER ) IS
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

Line 1424: UPDATE CS_KB_ELEMENTS_TL

1420: Last_Updated_By = l_user,
1421: Last_Update_Login = l_login
1422: WHERE Element_Id = Statements.Element_id;
1423:
1424: UPDATE CS_KB_ELEMENTS_TL
1425: SET Composite_Text_Index = 'x',
1426: Last_Update_Date = sysdate,
1427: Last_Updated_By = l_user,
1428: Last_Update_Login = l_login