7:
8:
9: cursor get_session_attr_count is
10: select count(*)
11: from cs_kb_session_attrs b
12: where b.session_id in (
13: select a.session_id
14: from cs_kb_sessions a
15: where a.source_object_code like 'KMT%'
62: fnd_message.get_string('CS', 'CS_KB_NUM_SES_DEL') || l_session_count);
63:
64: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Purging data...');
65:
66: delete cs_kb_session_attrs b
67: where b.session_id in (
68: select a.session_id
69: from cs_kb_sessions a
70: where a.source_object_code like 'KMT%'