APPS.CS_KB_SESSION_PKG dependencies on CS_KB_SESSIONS

Line 18: select cs_kb_sessions_s.nextval

14: P_LAST_UPDATE_LOGIN in NUMBER
15: )
16: is
17: cursor getNewSessionIdCsr is
18: select cs_kb_sessions_s.nextval
19: from dual;
20:
21: cursor verifyRowCursor is
22: select ROWID

Line 23: from CS_KB_SESSIONS

19: from dual;
20:
21: cursor verifyRowCursor is
22: select ROWID
23: from CS_KB_SESSIONS
24: where SESSION_ID = X_SESSION_ID;
25: begin
26:
27: /* Get a new data id */

Line 32: insert into cs_kb_sessions

28: OPEN getNewSessionIdCsr;
29: FETCH getNewSessionIdCsr INTO X_SESSION_ID;
30: CLOSE getNewSessionIdCsr;
31:
32: insert into cs_kb_sessions
33: (
34: session_id,
35: source_object_id,
36: source_object_code,

Line 78: update cs_kb_sessions

74: P_LAST_UPDATE_LOGIN in NUMBER
75: )
76: is
77: begin
78: update cs_kb_sessions
79: set
80: source_object_id = p_source_object_id,
81: source_object_code = p_source_object_code,
82: last_update_date = p_last_update_date,

Line 99: delete from cs_kb_sessions

95: P_SESSION_ID in NUMBER
96: )
97: is
98: begin
99: delete from cs_kb_sessions
100: where session_id = P_SESSION_ID;
101: if(sql%notfound) then
102: raise no_data_found;
103: end if;