APPS.CS_KB_SESSION_ATTR_PKG dependencies on CS_KB_SESSION_ATTRS

Line 109: from cs_kb_session_attrs

105: ) return number
106: is
107: cursor getSessionAttrIds( c_session_id number ) is
108: select session_attr_id
109: from cs_kb_session_attrs
110: where session_id = c_session_id;
111: begin
112: for rec in getSessionAttrIds( p_session_id ) loop
113: delete_row

Line 144: select cs_kb_session_attrs_s.nextval

140: P_LAST_UPDATE_LOGIN in NUMBER
141: )
142: is
143: cursor getNewSessionAttrIdCsr is
144: select cs_kb_session_attrs_s.nextval
145: from dual;
146:
147: cursor verifyRowCursor is
148: select ROWID

Line 149: from CS_KB_SESSION_ATTRS

145: from dual;
146:
147: cursor verifyRowCursor is
148: select ROWID
149: from CS_KB_SESSION_ATTRS
150: where SESSION_ATTR_ID = X_SESSION_ATTR_ID;
151: begin
152:
153: /* Get a new data id */

Line 158: insert into cs_kb_session_attrs

154: OPEN getNewSessionAttrIdCsr;
155: FETCH getNewSessionAttrIdCsr INTO X_SESSION_ATTR_ID;
156: CLOSE getNewSessionAttrIdCsr;
157:
158: insert into cs_kb_session_attrs
159: (
160: session_attr_id,
161: session_id,
162: attribute_type,

Line 213: update cs_kb_session_attrs

209: P_LAST_UPDATE_LOGIN in NUMBER
210: )
211: is
212: begin
213: update cs_kb_session_attrs
214: set
215: session_id = p_session_id,
216: attribute_type = p_attribute_type,
217: attribute_name = p_attribute_name,

Line 237: delete from cs_kb_session_attrs

233: P_SESSION_ATTR_ID in NUMBER
234: )
235: is
236: begin
237: delete from cs_kb_session_attrs
238: where session_attr_id = P_SESSION_ATTR_ID;
239: if(sql%notfound) then
240: raise no_data_found;
241: end if;