eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SR_LOG_DATA_TEMP_PVT dependencies on CS_SR_LOG_DATA_TEMP_PVT

Line 1: PACKAGE BODY cs_sr_log_data_temp_pvt AS

1: PACKAGE BODY cs_sr_log_data_temp_pvt AS
2: /* $Header: csvlogb.pls 115.6 2002/11/30 11:50:51 pkesani noship $ */
3:
4: procedure delete_log( p_session_id number
5: , p_incident_id number)

Line 39: cs_sr_log_data_temp_pvt.display_seq);

35: display_seq)
36: VALUES ( p_session_id,
37: p_incident_id,
38: p_log_text,
39: cs_sr_log_data_temp_pvt.display_seq);
40: commit;
41:
42: end insert_log;
43:

Line 52: cs_sr_log_data_temp_pvt.get_log_details(p_incident_id);

48: begin
49:
50: select userenv('SESSIONID') into l_session_id from dual;
51:
52: cs_sr_log_data_temp_pvt.get_log_details(p_incident_id);
53:
54: i_return := cs_sr_log_data_temp_pvt.sort_log_data(1, cs_sr_log_data_temp_pvt.i_total_records);
55:
56: cs_sr_log_data_temp_pvt.insert_log_data(l_session_id, p_incident_id );

Line 54: i_return := cs_sr_log_data_temp_pvt.sort_log_data(1, cs_sr_log_data_temp_pvt.i_total_records);

50: select userenv('SESSIONID') into l_session_id from dual;
51:
52: cs_sr_log_data_temp_pvt.get_log_details(p_incident_id);
53:
54: i_return := cs_sr_log_data_temp_pvt.sort_log_data(1, cs_sr_log_data_temp_pvt.i_total_records);
55:
56: cs_sr_log_data_temp_pvt.insert_log_data(l_session_id, p_incident_id );
57:
58: x_session_id := l_session_id;

Line 56: cs_sr_log_data_temp_pvt.insert_log_data(l_session_id, p_incident_id );

52: cs_sr_log_data_temp_pvt.get_log_details(p_incident_id);
53:
54: i_return := cs_sr_log_data_temp_pvt.sort_log_data(1, cs_sr_log_data_temp_pvt.i_total_records);
55:
56: cs_sr_log_data_temp_pvt.insert_log_data(l_session_id, p_incident_id );
57:
58: x_session_id := l_session_id;
59:
60: exception

Line 217: cs_sr_log_data_temp_pvt.i_total_records := 0;

213:
214: /* This function executes each of the SQL and stores the data in
215: the Main array and Other Array */
216: l_formated_string := null;
217: cs_sr_log_data_temp_pvt.i_total_records := 0;
218: cs_sr_log_data_temp_pvt.i_other_records := 0;
219:
220: for i_ctn in log_cursor
221: loop

Line 218: cs_sr_log_data_temp_pvt.i_other_records := 0;

214: /* This function executes each of the SQL and stores the data in
215: the Main array and Other Array */
216: l_formated_string := null;
217: cs_sr_log_data_temp_pvt.i_total_records := 0;
218: cs_sr_log_data_temp_pvt.i_other_records := 0;
219:
220: for i_ctn in log_cursor
221: loop
222:

Line 226: length_of_string := cs_sr_log_data_temp_pvt.format_data('parameter.log_severity'||': ',

222:
223: length_of_string := 0;
224:
225: if i_ctn.incident_severity_flag = 'Y' then
226: length_of_string := cs_sr_log_data_temp_pvt.format_data('parameter.log_severity'||': ',
227: i_ctn.old_severity_name,
228: i_ctn.new_severity_name,
229: i_ctn.incident_severity_flag,
230: i_ctn.last_update_date,

Line 236: length_of_string := cs_sr_log_data_temp_pvt.format_data('parameter.log_type'||': ',

232: i_ctn.source_type);
233: end if;
234:
235: if i_ctn.incident_type_flag = 'Y' then
236: length_of_string := cs_sr_log_data_temp_pvt.format_data('parameter.log_type'||': ',
237: i_ctn.old_type_name,
238: i_ctn.new_type_name,
239: i_ctn.incident_type_flag,
240: i_ctn.last_update_date,

Line 246: length_of_string := cs_sr_log_data_temp_pvt.format_data('parameter.log_status'||': ',

242: i_ctn.source_type);
243: end if;
244:
245: if i_ctn.incident_status_flag = 'Y' then
246: length_of_string := cs_sr_log_data_temp_pvt.format_data('parameter.log_status'||': ',
247: i_ctn.old_status_name,
248: i_ctn.new_status_name,
249: i_ctn.incident_status_flag,
250: i_ctn.last_update_date,

Line 256: length_of_string := cs_sr_log_data_temp_pvt.format_data('parameter.log_urgency'||': ',

252: i_ctn.source_type);
253: end if;
254:
255: if i_ctn.incident_urgency_flag = 'Y' then
256: length_of_string := cs_sr_log_data_temp_pvt.format_data('parameter.log_urgency'||': ',
257: i_ctn.old_urgency_name,
258: i_ctn.new_urgency_name,
259: i_ctn.incident_urgency_flag,
260: i_ctn.last_update_date,

Line 266: length_of_string := cs_sr_log_data_temp_pvt.format_data('parameter.log_owner_type'||': ',

262: i_ctn.source_type);
263: end if;
264:
265: if i_ctn.change_resource_type_flag = 'Y' then
266: length_of_string := cs_sr_log_data_temp_pvt.format_data('parameter.log_owner_type'||': ',
267: i_ctn.old_resource_type,
268: i_ctn.resource_type,
269: i_ctn.change_resource_type_flag,
270: i_ctn.last_update_date,

Line 276: length_of_string := cs_sr_log_data_temp_pvt.format_data('parameter.log_owner'||': ',

272: i_ctn.source_type);
273: end if;
274:
275: if i_ctn.incident_owner_flag = 'Y' then
276: length_of_string := cs_sr_log_data_temp_pvt.format_data('parameter.log_owner'||': ',
277: i_ctn.old_owner,
278: i_ctn.new_owner,
279: i_ctn.incident_owner_flag,
280: i_ctn.last_update_date,

Line 286: length_of_string := cs_sr_log_data_temp_pvt.format_data('parameter.log_date'||': ',

282: i_ctn.source_type);
283: end if;
284:
285: if i_ctn.resolution_date_flag = 'Y' then
286: length_of_string := cs_sr_log_data_temp_pvt.format_data('parameter.log_date'||': ',
287: i_ctn.date_old,
288: i_ctn.date_new,
289: i_ctn.resolution_date_flag,
290: i_ctn.last_update_date,

Line 298: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;

294:
295: end loop; -- end of log_cursor loop
296:
297: -- Task Cursor. Collecting all Task data into the arrays.
298: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;
299: i_other_pointer := cs_sr_log_data_temp_pvt.i_other_records ;
300: for i_ctn in task_cursor
301: loop
302:

Line 299: i_other_pointer := cs_sr_log_data_temp_pvt.i_other_records ;

295: end loop; -- end of log_cursor loop
296:
297: -- Task Cursor. Collecting all Task data into the arrays.
298: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;
299: i_other_pointer := cs_sr_log_data_temp_pvt.i_other_records ;
300: for i_ctn in task_cursor
301: loop
302:
303: i_main_pointer := i_main_pointer + 1;

Line 304: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;

300: for i_ctn in task_cursor
301: loop
302:
303: i_main_pointer := i_main_pointer + 1;
304: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
305: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
306:
307: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
308: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := i_ctn.task_id;

Line 305: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;

301: loop
302:
303: i_main_pointer := i_main_pointer + 1;
304: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
305: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
306:
307: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
308: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := i_ctn.task_id;
309:

Line 307: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;

303: i_main_pointer := i_main_pointer + 1;
304: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
305: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
306:
307: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
308: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := i_ctn.task_id;
309:
310: i_other_pointer := i_other_pointer + 1;
311: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type;

Line 308: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := i_ctn.task_id;

304: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
305: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
306:
307: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
308: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := i_ctn.task_id;
309:
310: i_other_pointer := i_other_pointer + 1;
311: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type;
312: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.task_id;

Line 311: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type;

307: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
308: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := i_ctn.task_id;
309:
310: i_other_pointer := i_other_pointer + 1;
311: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type;
312: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.task_id;
313: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := '*** '||'parameter.log_tasks'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||gs_newline||i_ctn.description||gs_newline;
314: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
315:

Line 312: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.task_id;

308: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := i_ctn.task_id;
309:
310: i_other_pointer := i_other_pointer + 1;
311: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type;
312: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.task_id;
313: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := '*** '||'parameter.log_tasks'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||gs_newline||i_ctn.description||gs_newline;
314: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
315:
316: end loop; -- end of task_cursor loop

Line 313: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := '*** '||'parameter.log_tasks'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||gs_newline||i_ctn.description||gs_newline;

309:
310: i_other_pointer := i_other_pointer + 1;
311: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type;
312: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.task_id;
313: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := '*** '||'parameter.log_tasks'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||gs_newline||i_ctn.description||gs_newline;
314: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
315:
316: end loop; -- end of task_cursor loop
317:

Line 314: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));

310: i_other_pointer := i_other_pointer + 1;
311: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type;
312: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.task_id;
313: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := '*** '||'parameter.log_tasks'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||gs_newline||i_ctn.description||gs_newline;
314: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
315:
316: end loop; -- end of task_cursor loop
317:
318: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;

Line 318: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;

314: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
315:
316: end loop; -- end of task_cursor loop
317:
318: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;
319: cs_sr_log_data_temp_pvt.i_other_records := i_other_pointer ;
320:
321: -- Notes Cursor. Collecting all Notes data into the arrays.
322: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;

Line 319: cs_sr_log_data_temp_pvt.i_other_records := i_other_pointer ;

315:
316: end loop; -- end of task_cursor loop
317:
318: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;
319: cs_sr_log_data_temp_pvt.i_other_records := i_other_pointer ;
320:
321: -- Notes Cursor. Collecting all Notes data into the arrays.
322: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;
323: i_other_pointer := cs_sr_log_data_temp_pvt.i_other_records ;

Line 322: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;

318: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;
319: cs_sr_log_data_temp_pvt.i_other_records := i_other_pointer ;
320:
321: -- Notes Cursor. Collecting all Notes data into the arrays.
322: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;
323: i_other_pointer := cs_sr_log_data_temp_pvt.i_other_records ;
324:
325: for i_ctn in note_cursor
326: loop

Line 323: i_other_pointer := cs_sr_log_data_temp_pvt.i_other_records ;

319: cs_sr_log_data_temp_pvt.i_other_records := i_other_pointer ;
320:
321: -- Notes Cursor. Collecting all Notes data into the arrays.
322: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;
323: i_other_pointer := cs_sr_log_data_temp_pvt.i_other_records ;
324:
325: for i_ctn in note_cursor
326: loop
327:

Line 329: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;

325: for i_ctn in note_cursor
326: loop
327:
328: i_main_pointer := i_main_pointer + 1;
329: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
330: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
331:
332: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
333: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := i_ctn.jtf_note_id;

Line 330: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;

326: loop
327:
328: i_main_pointer := i_main_pointer + 1;
329: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
330: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
331:
332: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
333: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := i_ctn.jtf_note_id;
334:

Line 332: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;

328: i_main_pointer := i_main_pointer + 1;
329: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
330: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
331:
332: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
333: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := i_ctn.jtf_note_id;
334:
335: i_other_pointer := i_other_pointer + 1;
336: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type;

Line 333: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := i_ctn.jtf_note_id;

329: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
330: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
331:
332: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
333: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := i_ctn.jtf_note_id;
334:
335: i_other_pointer := i_other_pointer + 1;
336: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type;
337: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.jtf_note_id;

Line 336: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type;

332: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
333: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := i_ctn.jtf_note_id;
334:
335: i_other_pointer := i_other_pointer + 1;
336: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type;
337: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.jtf_note_id;
338: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := '*** '||'parameter.log_notes'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||gs_newline||i_ctn.notes||gs_newline;
339: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
340:

Line 337: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.jtf_note_id;

333: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := i_ctn.jtf_note_id;
334:
335: i_other_pointer := i_other_pointer + 1;
336: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type;
337: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.jtf_note_id;
338: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := '*** '||'parameter.log_notes'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||gs_newline||i_ctn.notes||gs_newline;
339: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
340:
341: end loop; -- end of note_cursor loop

Line 338: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := '*** '||'parameter.log_notes'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||gs_newline||i_ctn.notes||gs_newline;

334:
335: i_other_pointer := i_other_pointer + 1;
336: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type;
337: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.jtf_note_id;
338: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := '*** '||'parameter.log_notes'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||gs_newline||i_ctn.notes||gs_newline;
339: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
340:
341: end loop; -- end of note_cursor loop
342:

Line 339: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));

335: i_other_pointer := i_other_pointer + 1;
336: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type;
337: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.jtf_note_id;
338: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := '*** '||'parameter.log_notes'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||gs_newline||i_ctn.notes||gs_newline;
339: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
340:
341: end loop; -- end of note_cursor loop
342:
343: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;

Line 343: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;

339: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
340:
341: end loop; -- end of note_cursor loop
342:
343: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;
344: cs_sr_log_data_temp_pvt.i_other_records := i_other_pointer ;
345:
346: -- Activity Cursor. Collecting all Activity data into the arrays.
347: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;

Line 344: cs_sr_log_data_temp_pvt.i_other_records := i_other_pointer ;

340:
341: end loop; -- end of note_cursor loop
342:
343: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;
344: cs_sr_log_data_temp_pvt.i_other_records := i_other_pointer ;
345:
346: -- Activity Cursor. Collecting all Activity data into the arrays.
347: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;
348:

Line 347: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;

343: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;
344: cs_sr_log_data_temp_pvt.i_other_records := i_other_pointer ;
345:
346: -- Activity Cursor. Collecting all Activity data into the arrays.
347: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;
348:
349: for i_ctn in activity_cursor
350: loop
351:

Line 353: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;

349: for i_ctn in activity_cursor
350: loop
351:
352: i_main_pointer := i_main_pointer + 1;
353: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
354: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
355:
356: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
357: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := '*** '||'parameter.log_interaction'||': '||i_ctn.interaction_id||' '||i_ctn.user_name;

Line 354: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;

350: loop
351:
352: i_main_pointer := i_main_pointer + 1;
353: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
354: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
355:
356: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
357: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := '*** '||'parameter.log_interaction'||': '||i_ctn.interaction_id||' '||i_ctn.user_name;
358: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer):= cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer)||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||' '||i_ctn.short_description||gs_newline;

Line 356: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;

352: i_main_pointer := i_main_pointer + 1;
353: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
354: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
355:
356: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
357: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := '*** '||'parameter.log_interaction'||': '||i_ctn.interaction_id||' '||i_ctn.user_name;
358: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer):= cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer)||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||' '||i_ctn.short_description||gs_newline;
359: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer));
360:

Line 357: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := '*** '||'parameter.log_interaction'||': '||i_ctn.interaction_id||' '||i_ctn.user_name;

353: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
354: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
355:
356: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
357: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := '*** '||'parameter.log_interaction'||': '||i_ctn.interaction_id||' '||i_ctn.user_name;
358: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer):= cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer)||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||' '||i_ctn.short_description||gs_newline;
359: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer));
360:
361: end loop; -- end of note_cursor loop

Line 358: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer):= cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer)||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||' '||i_ctn.short_description||gs_newline;

354: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
355:
356: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
357: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := '*** '||'parameter.log_interaction'||': '||i_ctn.interaction_id||' '||i_ctn.user_name;
358: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer):= cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer)||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||' '||i_ctn.short_description||gs_newline;
359: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer));
360:
361: end loop; -- end of note_cursor loop
362:

Line 359: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer));

355:
356: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type;
357: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := '*** '||'parameter.log_interaction'||': '||i_ctn.interaction_id||' '||i_ctn.user_name;
358: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer):= cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer)||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||' '||i_ctn.short_description||gs_newline;
359: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer));
360:
361: end loop; -- end of note_cursor loop
362:
363: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;

Line 363: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;

359: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := length(cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer));
360:
361: end loop; -- end of note_cursor loop
362:
363: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;
364:
365: -- All Data from Knowledge base is fetched in this Cursor
366:
367: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;

Line 367: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;

363: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;
364:
365: -- All Data from Knowledge base is fetched in this Cursor
366:
367: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;
368: i_other_pointer := cs_sr_log_data_temp_pvt.i_other_records ;
369: old_set_id := 0;
370:
371: for i_ctn in soln_cursor

Line 368: i_other_pointer := cs_sr_log_data_temp_pvt.i_other_records ;

364:
365: -- All Data from Knowledge base is fetched in this Cursor
366:
367: i_main_pointer := cs_sr_log_data_temp_pvt.i_total_records;
368: i_other_pointer := cs_sr_log_data_temp_pvt.i_other_records ;
369: old_set_id := 0;
370:
371: for i_ctn in soln_cursor
372: loop

Line 377: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;

373:
374: if old_set_id <> i_ctn.set_id then
375: i_size_of_kb := 0;
376: i_main_pointer := i_main_pointer + 1;
377: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
378: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
379:
380: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type||'-'||i_ctn.set_id;
381: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := '*** '||'parameter.log_knowledge'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ');

Line 378: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;

374: if old_set_id <> i_ctn.set_id then
375: i_size_of_kb := 0;
376: i_main_pointer := i_main_pointer + 1;
377: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
378: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
379:
380: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type||'-'||i_ctn.set_id;
381: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := '*** '||'parameter.log_knowledge'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ');
382: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer):= cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer)||i_ctn.set_id||gs_newline||i_ctn.set_type_name||gs_newline||i_ctn.set_summary||gs_newline;

Line 380: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type||'-'||i_ctn.set_id;

376: i_main_pointer := i_main_pointer + 1;
377: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
378: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
379:
380: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type||'-'||i_ctn.set_id;
381: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := '*** '||'parameter.log_knowledge'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ');
382: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer):= cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer)||i_ctn.set_id||gs_newline||i_ctn.set_type_name||gs_newline||i_ctn.set_summary||gs_newline;
383: i_size_of_kb := i_size_of_kb + length(cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer));
384: old_set_id:=i_ctn.set_id;

Line 381: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := '*** '||'parameter.log_knowledge'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ');

377: cs_sr_log_data_temp_pvt.main_log_date(i_main_pointer) := i_ctn.last_update_date;
378: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
379:
380: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type||'-'||i_ctn.set_id;
381: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := '*** '||'parameter.log_knowledge'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ');
382: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer):= cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer)||i_ctn.set_id||gs_newline||i_ctn.set_type_name||gs_newline||i_ctn.set_summary||gs_newline;
383: i_size_of_kb := i_size_of_kb + length(cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer));
384: old_set_id:=i_ctn.set_id;
385: end if;

Line 382: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer):= cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer)||i_ctn.set_id||gs_newline||i_ctn.set_type_name||gs_newline||i_ctn.set_summary||gs_newline;

378: cs_sr_log_data_temp_pvt.main_log_pointer(i_main_pointer) := i_main_pointer;
379:
380: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type||'-'||i_ctn.set_id;
381: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := '*** '||'parameter.log_knowledge'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ');
382: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer):= cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer)||i_ctn.set_id||gs_newline||i_ctn.set_type_name||gs_newline||i_ctn.set_summary||gs_newline;
383: i_size_of_kb := i_size_of_kb + length(cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer));
384: old_set_id:=i_ctn.set_id;
385: end if;
386: i_other_pointer := i_other_pointer + 1;

Line 383: i_size_of_kb := i_size_of_kb + length(cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer));

379:
380: cs_sr_log_data_temp_pvt.main_log_source(i_main_pointer) := i_ctn.source_type||'-'||i_ctn.set_id;
381: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer) := '*** '||'parameter.log_knowledge'||': '||i_ctn.user_name||' '||rpad(to_char(i_ctn.last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ');
382: cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer):= cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer)||i_ctn.set_id||gs_newline||i_ctn.set_type_name||gs_newline||i_ctn.set_summary||gs_newline;
383: i_size_of_kb := i_size_of_kb + length(cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer));
384: old_set_id:=i_ctn.set_id;
385: end if;
386: i_other_pointer := i_other_pointer + 1;
387: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type||'-'||i_ctn.set_id;

Line 387: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type||'-'||i_ctn.set_id;

383: i_size_of_kb := i_size_of_kb + length(cs_sr_log_data_temp_pvt.main_log_text(i_main_pointer));
384: old_set_id:=i_ctn.set_id;
385: end if;
386: i_other_pointer := i_other_pointer + 1;
387: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type||'-'||i_ctn.set_id;
388: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.set_id;
389: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := ' '||i_ctn.element_type_name||' : '||i_ctn.element_summary||gs_newline;
390: i_size_of_kb := i_size_of_kb + length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
391: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := i_size_of_kb;

Line 388: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.set_id;

384: old_set_id:=i_ctn.set_id;
385: end if;
386: i_other_pointer := i_other_pointer + 1;
387: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type||'-'||i_ctn.set_id;
388: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.set_id;
389: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := ' '||i_ctn.element_type_name||' : '||i_ctn.element_summary||gs_newline;
390: i_size_of_kb := i_size_of_kb + length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
391: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := i_size_of_kb;
392:

Line 389: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := ' '||i_ctn.element_type_name||' : '||i_ctn.element_summary||gs_newline;

385: end if;
386: i_other_pointer := i_other_pointer + 1;
387: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type||'-'||i_ctn.set_id;
388: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.set_id;
389: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := ' '||i_ctn.element_type_name||' : '||i_ctn.element_summary||gs_newline;
390: i_size_of_kb := i_size_of_kb + length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
391: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := i_size_of_kb;
392:
393: end loop;

Line 390: i_size_of_kb := i_size_of_kb + length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));

386: i_other_pointer := i_other_pointer + 1;
387: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type||'-'||i_ctn.set_id;
388: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.set_id;
389: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := ' '||i_ctn.element_type_name||' : '||i_ctn.element_summary||gs_newline;
390: i_size_of_kb := i_size_of_kb + length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
391: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := i_size_of_kb;
392:
393: end loop;
394:

Line 391: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := i_size_of_kb;

387: cs_sr_log_data_temp_pvt.other_log_source(i_other_pointer):= i_ctn.source_type||'-'||i_ctn.set_id;
388: cs_sr_log_data_temp_pvt.other_log_id(i_other_pointer) := i_ctn.set_id;
389: cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer) := ' '||i_ctn.element_type_name||' : '||i_ctn.element_summary||gs_newline;
390: i_size_of_kb := i_size_of_kb + length(cs_sr_log_data_temp_pvt.other_log_text(i_other_pointer));
391: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := i_size_of_kb;
392:
393: end loop;
394:
395: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;

Line 395: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;

391: cs_sr_log_data_temp_pvt.main_log_page(i_main_pointer) := i_size_of_kb;
392:
393: end loop;
394:
395: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;
396: cs_sr_log_data_temp_pvt.i_other_records := i_other_pointer ;
397:
398: end get_log_details;
399:

Line 396: cs_sr_log_data_temp_pvt.i_other_records := i_other_pointer ;

392:
393: end loop;
394:
395: cs_sr_log_data_temp_pvt.i_total_records := i_main_pointer ;
396: cs_sr_log_data_temp_pvt.i_other_records := i_other_pointer ;
397:
398: end get_log_details;
399:
400: function format_data(column_name in varchar2,

Line 420: i_sort_pointer := cs_sr_log_data_temp_pvt.i_total_records;

416: begin
417:
418: /* This function formats all Audit data */
419:
420: i_sort_pointer := cs_sr_log_data_temp_pvt.i_total_records;
421: if changed_flag = 'Y' then
422: l_formated_string := '*** '||'parameter.log_audit'||': '||last_updated_by||' '||rpad(to_char(last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||' '||rpad(column_name,20,' ')||' '||old_field_name||' --> '||new_field_name;
423:
424: l_formated_string := l_formated_string||gs_newline;

Line 426: cs_sr_log_data_temp_pvt.main_log_date(i_sort_pointer) := last_update_date;

422: l_formated_string := '*** '||'parameter.log_audit'||': '||last_updated_by||' '||rpad(to_char(last_update_date,'DD-MON-YYYY HH24:MI:SS'),20,' ')||' '||rpad(column_name,20,' ')||' '||old_field_name||' --> '||new_field_name;
423:
424: l_formated_string := l_formated_string||gs_newline;
425: i_sort_pointer := i_sort_pointer + 1;
426: cs_sr_log_data_temp_pvt.main_log_date(i_sort_pointer) := last_update_date;
427: cs_sr_log_data_temp_pvt.main_log_pointer(i_sort_pointer) := i_sort_pointer;
428:
429: cs_sr_log_data_temp_pvt.main_log_source(i_sort_pointer) := source_type;
430: cs_sr_log_data_temp_pvt.main_log_text(i_sort_pointer) := l_formated_string;

Line 427: cs_sr_log_data_temp_pvt.main_log_pointer(i_sort_pointer) := i_sort_pointer;

423:
424: l_formated_string := l_formated_string||gs_newline;
425: i_sort_pointer := i_sort_pointer + 1;
426: cs_sr_log_data_temp_pvt.main_log_date(i_sort_pointer) := last_update_date;
427: cs_sr_log_data_temp_pvt.main_log_pointer(i_sort_pointer) := i_sort_pointer;
428:
429: cs_sr_log_data_temp_pvt.main_log_source(i_sort_pointer) := source_type;
430: cs_sr_log_data_temp_pvt.main_log_text(i_sort_pointer) := l_formated_string;
431: cs_sr_log_data_temp_pvt.main_log_page(i_sort_pointer) := length(l_formated_string);

Line 429: cs_sr_log_data_temp_pvt.main_log_source(i_sort_pointer) := source_type;

425: i_sort_pointer := i_sort_pointer + 1;
426: cs_sr_log_data_temp_pvt.main_log_date(i_sort_pointer) := last_update_date;
427: cs_sr_log_data_temp_pvt.main_log_pointer(i_sort_pointer) := i_sort_pointer;
428:
429: cs_sr_log_data_temp_pvt.main_log_source(i_sort_pointer) := source_type;
430: cs_sr_log_data_temp_pvt.main_log_text(i_sort_pointer) := l_formated_string;
431: cs_sr_log_data_temp_pvt.main_log_page(i_sort_pointer) := length(l_formated_string);
432: else
433: l_formated_string := null;

Line 430: cs_sr_log_data_temp_pvt.main_log_text(i_sort_pointer) := l_formated_string;

426: cs_sr_log_data_temp_pvt.main_log_date(i_sort_pointer) := last_update_date;
427: cs_sr_log_data_temp_pvt.main_log_pointer(i_sort_pointer) := i_sort_pointer;
428:
429: cs_sr_log_data_temp_pvt.main_log_source(i_sort_pointer) := source_type;
430: cs_sr_log_data_temp_pvt.main_log_text(i_sort_pointer) := l_formated_string;
431: cs_sr_log_data_temp_pvt.main_log_page(i_sort_pointer) := length(l_formated_string);
432: else
433: l_formated_string := null;
434: end if;

Line 431: cs_sr_log_data_temp_pvt.main_log_page(i_sort_pointer) := length(l_formated_string);

427: cs_sr_log_data_temp_pvt.main_log_pointer(i_sort_pointer) := i_sort_pointer;
428:
429: cs_sr_log_data_temp_pvt.main_log_source(i_sort_pointer) := source_type;
430: cs_sr_log_data_temp_pvt.main_log_text(i_sort_pointer) := l_formated_string;
431: cs_sr_log_data_temp_pvt.main_log_page(i_sort_pointer) := length(l_formated_string);
432: else
433: l_formated_string := null;
434: end if;
435:

Line 436: cs_sr_log_data_temp_pvt.i_total_records := i_sort_pointer ;

432: else
433: l_formated_string := null;
434: end if;
435:
436: cs_sr_log_data_temp_pvt.i_total_records := i_sort_pointer ;
437: return length(l_formated_string);
438:
439: end format_data;
440:

Line 472: l_mid_date := cs_sr_log_data_temp_pvt.main_log_date(i_mid);

468: i_start := p_low-1;
469: i_end := p_high;
470:
471: i_mid := i_end; -- Selecting an arbitary mid point
472: l_mid_date := cs_sr_log_data_temp_pvt.main_log_date(i_mid);
473:
474: while i_start < i_end -- Main while loop
475: loop
476: loop

Line 482: if (cs_sr_log_data_temp_pvt.main_log_date(i_start) < l_mid_date) then

478: if (i_start > i_end) then
479: i_start := i_end;
480: exit;
481: end if;
482: if (cs_sr_log_data_temp_pvt.main_log_date(i_start) < l_mid_date) then
483: exit;
484: end if;
485: end loop;
486:

Line 490: (cs_sr_log_data_temp_pvt.main_log_date(i_end) > l_mid_date)) then

486:
487: loop
488: i_end := i_end - 1;
489: if ((i_end < i_start) or
490: (cs_sr_log_data_temp_pvt.main_log_date(i_end) > l_mid_date)) then
491: exit;
492: end if;
493: end loop;
494:

Line 497: l_swap_date := cs_sr_log_data_temp_pvt.main_log_date(i_start);

493: end loop;
494:
495: if (i_start < i_end) then
496: --Swap data in i_start i_end
497: l_swap_date := cs_sr_log_data_temp_pvt.main_log_date(i_start);
498: l_swap_pointer := cs_sr_log_data_temp_pvt.main_log_pointer(i_start);
499:
500: cs_sr_log_data_temp_pvt.main_log_date(i_start):= cs_sr_log_data_temp_pvt.main_log_date(i_end);
501: cs_sr_log_data_temp_pvt.main_log_pointer(i_start):= cs_sr_log_data_temp_pvt.main_log_pointer(i_end);

Line 498: l_swap_pointer := cs_sr_log_data_temp_pvt.main_log_pointer(i_start);

494:
495: if (i_start < i_end) then
496: --Swap data in i_start i_end
497: l_swap_date := cs_sr_log_data_temp_pvt.main_log_date(i_start);
498: l_swap_pointer := cs_sr_log_data_temp_pvt.main_log_pointer(i_start);
499:
500: cs_sr_log_data_temp_pvt.main_log_date(i_start):= cs_sr_log_data_temp_pvt.main_log_date(i_end);
501: cs_sr_log_data_temp_pvt.main_log_pointer(i_start):= cs_sr_log_data_temp_pvt.main_log_pointer(i_end);
502:

Line 500: cs_sr_log_data_temp_pvt.main_log_date(i_start):= cs_sr_log_data_temp_pvt.main_log_date(i_end);

496: --Swap data in i_start i_end
497: l_swap_date := cs_sr_log_data_temp_pvt.main_log_date(i_start);
498: l_swap_pointer := cs_sr_log_data_temp_pvt.main_log_pointer(i_start);
499:
500: cs_sr_log_data_temp_pvt.main_log_date(i_start):= cs_sr_log_data_temp_pvt.main_log_date(i_end);
501: cs_sr_log_data_temp_pvt.main_log_pointer(i_start):= cs_sr_log_data_temp_pvt.main_log_pointer(i_end);
502:
503: cs_sr_log_data_temp_pvt.main_log_date(i_end):= l_swap_date;
504: cs_sr_log_data_temp_pvt.main_log_pointer(i_end):= l_swap_pointer;

Line 501: cs_sr_log_data_temp_pvt.main_log_pointer(i_start):= cs_sr_log_data_temp_pvt.main_log_pointer(i_end);

497: l_swap_date := cs_sr_log_data_temp_pvt.main_log_date(i_start);
498: l_swap_pointer := cs_sr_log_data_temp_pvt.main_log_pointer(i_start);
499:
500: cs_sr_log_data_temp_pvt.main_log_date(i_start):= cs_sr_log_data_temp_pvt.main_log_date(i_end);
501: cs_sr_log_data_temp_pvt.main_log_pointer(i_start):= cs_sr_log_data_temp_pvt.main_log_pointer(i_end);
502:
503: cs_sr_log_data_temp_pvt.main_log_date(i_end):= l_swap_date;
504: cs_sr_log_data_temp_pvt.main_log_pointer(i_end):= l_swap_pointer;
505:

Line 503: cs_sr_log_data_temp_pvt.main_log_date(i_end):= l_swap_date;

499:
500: cs_sr_log_data_temp_pvt.main_log_date(i_start):= cs_sr_log_data_temp_pvt.main_log_date(i_end);
501: cs_sr_log_data_temp_pvt.main_log_pointer(i_start):= cs_sr_log_data_temp_pvt.main_log_pointer(i_end);
502:
503: cs_sr_log_data_temp_pvt.main_log_date(i_end):= l_swap_date;
504: cs_sr_log_data_temp_pvt.main_log_pointer(i_end):= l_swap_pointer;
505:
506: end if;
507: end loop; -- End of main while loop

Line 504: cs_sr_log_data_temp_pvt.main_log_pointer(i_end):= l_swap_pointer;

500: cs_sr_log_data_temp_pvt.main_log_date(i_start):= cs_sr_log_data_temp_pvt.main_log_date(i_end);
501: cs_sr_log_data_temp_pvt.main_log_pointer(i_start):= cs_sr_log_data_temp_pvt.main_log_pointer(i_end);
502:
503: cs_sr_log_data_temp_pvt.main_log_date(i_end):= l_swap_date;
504: cs_sr_log_data_temp_pvt.main_log_pointer(i_end):= l_swap_pointer;
505:
506: end if;
507: end loop; -- End of main while loop
508:

Line 509: l_swap_date := cs_sr_log_data_temp_pvt.main_log_date(i_start);

505:
506: end if;
507: end loop; -- End of main while loop
508:
509: l_swap_date := cs_sr_log_data_temp_pvt.main_log_date(i_start);
510: l_swap_pointer := cs_sr_log_data_temp_pvt.main_log_pointer(i_start);
511:
512: cs_sr_log_data_temp_pvt.main_log_date(i_start):= cs_sr_log_data_temp_pvt.main_log_date(p_high);
513: cs_sr_log_data_temp_pvt.main_log_pointer(i_start):= cs_sr_log_data_temp_pvt.main_log_pointer(p_high);

Line 510: l_swap_pointer := cs_sr_log_data_temp_pvt.main_log_pointer(i_start);

506: end if;
507: end loop; -- End of main while loop
508:
509: l_swap_date := cs_sr_log_data_temp_pvt.main_log_date(i_start);
510: l_swap_pointer := cs_sr_log_data_temp_pvt.main_log_pointer(i_start);
511:
512: cs_sr_log_data_temp_pvt.main_log_date(i_start):= cs_sr_log_data_temp_pvt.main_log_date(p_high);
513: cs_sr_log_data_temp_pvt.main_log_pointer(i_start):= cs_sr_log_data_temp_pvt.main_log_pointer(p_high);
514:

Line 512: cs_sr_log_data_temp_pvt.main_log_date(i_start):= cs_sr_log_data_temp_pvt.main_log_date(p_high);

508:
509: l_swap_date := cs_sr_log_data_temp_pvt.main_log_date(i_start);
510: l_swap_pointer := cs_sr_log_data_temp_pvt.main_log_pointer(i_start);
511:
512: cs_sr_log_data_temp_pvt.main_log_date(i_start):= cs_sr_log_data_temp_pvt.main_log_date(p_high);
513: cs_sr_log_data_temp_pvt.main_log_pointer(i_start):= cs_sr_log_data_temp_pvt.main_log_pointer(p_high);
514:
515: cs_sr_log_data_temp_pvt.main_log_date(p_high):= l_swap_date;
516: cs_sr_log_data_temp_pvt.main_log_pointer(p_high):= l_swap_pointer;

Line 513: cs_sr_log_data_temp_pvt.main_log_pointer(i_start):= cs_sr_log_data_temp_pvt.main_log_pointer(p_high);

509: l_swap_date := cs_sr_log_data_temp_pvt.main_log_date(i_start);
510: l_swap_pointer := cs_sr_log_data_temp_pvt.main_log_pointer(i_start);
511:
512: cs_sr_log_data_temp_pvt.main_log_date(i_start):= cs_sr_log_data_temp_pvt.main_log_date(p_high);
513: cs_sr_log_data_temp_pvt.main_log_pointer(i_start):= cs_sr_log_data_temp_pvt.main_log_pointer(p_high);
514:
515: cs_sr_log_data_temp_pvt.main_log_date(p_high):= l_swap_date;
516: cs_sr_log_data_temp_pvt.main_log_pointer(p_high):= l_swap_pointer;
517:

Line 515: cs_sr_log_data_temp_pvt.main_log_date(p_high):= l_swap_date;

511:
512: cs_sr_log_data_temp_pvt.main_log_date(i_start):= cs_sr_log_data_temp_pvt.main_log_date(p_high);
513: cs_sr_log_data_temp_pvt.main_log_pointer(i_start):= cs_sr_log_data_temp_pvt.main_log_pointer(p_high);
514:
515: cs_sr_log_data_temp_pvt.main_log_date(p_high):= l_swap_date;
516: cs_sr_log_data_temp_pvt.main_log_pointer(p_high):= l_swap_pointer;
517:
518: i_return := cs_sr_log_data_temp_pvt.sort_log_data(p_low, i_start - 1);
519: i_return := cs_sr_log_data_temp_pvt.sort_log_data(i_start + 1, p_high);

Line 516: cs_sr_log_data_temp_pvt.main_log_pointer(p_high):= l_swap_pointer;

512: cs_sr_log_data_temp_pvt.main_log_date(i_start):= cs_sr_log_data_temp_pvt.main_log_date(p_high);
513: cs_sr_log_data_temp_pvt.main_log_pointer(i_start):= cs_sr_log_data_temp_pvt.main_log_pointer(p_high);
514:
515: cs_sr_log_data_temp_pvt.main_log_date(p_high):= l_swap_date;
516: cs_sr_log_data_temp_pvt.main_log_pointer(p_high):= l_swap_pointer;
517:
518: i_return := cs_sr_log_data_temp_pvt.sort_log_data(p_low, i_start - 1);
519: i_return := cs_sr_log_data_temp_pvt.sort_log_data(i_start + 1, p_high);
520: return p_return;

Line 518: i_return := cs_sr_log_data_temp_pvt.sort_log_data(p_low, i_start - 1);

514:
515: cs_sr_log_data_temp_pvt.main_log_date(p_high):= l_swap_date;
516: cs_sr_log_data_temp_pvt.main_log_pointer(p_high):= l_swap_pointer;
517:
518: i_return := cs_sr_log_data_temp_pvt.sort_log_data(p_low, i_start - 1);
519: i_return := cs_sr_log_data_temp_pvt.sort_log_data(i_start + 1, p_high);
520: return p_return;
521:
522: end sort_log_data;

Line 519: i_return := cs_sr_log_data_temp_pvt.sort_log_data(i_start + 1, p_high);

515: cs_sr_log_data_temp_pvt.main_log_date(p_high):= l_swap_date;
516: cs_sr_log_data_temp_pvt.main_log_pointer(p_high):= l_swap_pointer;
517:
518: i_return := cs_sr_log_data_temp_pvt.sort_log_data(p_low, i_start - 1);
519: i_return := cs_sr_log_data_temp_pvt.sort_log_data(i_start + 1, p_high);
520: return p_return;
521:
522: end sort_log_data;
523:

Line 543: cs_sr_log_data_temp_pvt.delete_log( p_session_id, p_incident_id);

539: the field LOG_NOTES.LOG_DETAILS.
540: */
541: -- Delete the records first
542: --
543: cs_sr_log_data_temp_pvt.delete_log( p_session_id, p_incident_id);
544:
545: cs_sr_log_data_temp_pvt.display_seq := 0;
546: total_log_size := 0;
547: for i_location in start_location..cs_sr_log_data_temp_pvt.i_total_records

Line 545: cs_sr_log_data_temp_pvt.display_seq := 0;

541: -- Delete the records first
542: --
543: cs_sr_log_data_temp_pvt.delete_log( p_session_id, p_incident_id);
544:
545: cs_sr_log_data_temp_pvt.display_seq := 0;
546: total_log_size := 0;
547: for i_location in start_location..cs_sr_log_data_temp_pvt.i_total_records
548: loop
549: i_counter := cs_sr_log_data_temp_pvt.main_log_pointer(i_location);

Line 547: for i_location in start_location..cs_sr_log_data_temp_pvt.i_total_records

543: cs_sr_log_data_temp_pvt.delete_log( p_session_id, p_incident_id);
544:
545: cs_sr_log_data_temp_pvt.display_seq := 0;
546: total_log_size := 0;
547: for i_location in start_location..cs_sr_log_data_temp_pvt.i_total_records
548: loop
549: i_counter := cs_sr_log_data_temp_pvt.main_log_pointer(i_location);
550: cs_sr_log_data_temp_pvt.display_seq := cs_sr_log_data_temp_pvt.display_seq+1;
551:

Line 549: i_counter := cs_sr_log_data_temp_pvt.main_log_pointer(i_location);

545: cs_sr_log_data_temp_pvt.display_seq := 0;
546: total_log_size := 0;
547: for i_location in start_location..cs_sr_log_data_temp_pvt.i_total_records
548: loop
549: i_counter := cs_sr_log_data_temp_pvt.main_log_pointer(i_location);
550: cs_sr_log_data_temp_pvt.display_seq := cs_sr_log_data_temp_pvt.display_seq+1;
551:
552: if cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='AUDIT' then
553:

Line 550: cs_sr_log_data_temp_pvt.display_seq := cs_sr_log_data_temp_pvt.display_seq+1;

546: total_log_size := 0;
547: for i_location in start_location..cs_sr_log_data_temp_pvt.i_total_records
548: loop
549: i_counter := cs_sr_log_data_temp_pvt.main_log_pointer(i_location);
550: cs_sr_log_data_temp_pvt.display_seq := cs_sr_log_data_temp_pvt.display_seq+1;
551:
552: if cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='AUDIT' then
553:
554: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,

Line 552: if cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='AUDIT' then

548: loop
549: i_counter := cs_sr_log_data_temp_pvt.main_log_pointer(i_location);
550: cs_sr_log_data_temp_pvt.display_seq := cs_sr_log_data_temp_pvt.display_seq+1;
551:
552: if cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='AUDIT' then
553:
554: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
555: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
556:

Line 554: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,

550: cs_sr_log_data_temp_pvt.display_seq := cs_sr_log_data_temp_pvt.display_seq+1;
551:
552: if cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='AUDIT' then
553:
554: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
555: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
556:
557: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='ACTIVITY' then
558:

Line 555: cs_sr_log_data_temp_pvt.main_log_text(i_counter));

551:
552: if cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='AUDIT' then
553:
554: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
555: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
556:
557: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='ACTIVITY' then
558:
559: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,

Line 557: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='ACTIVITY' then

553:
554: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
555: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
556:
557: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='ACTIVITY' then
558:
559: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
560: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
561:

Line 559: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,

555: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
556:
557: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='ACTIVITY' then
558:
559: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
560: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
561:
562: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='TASK' then
563: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));

Line 560: cs_sr_log_data_temp_pvt.main_log_text(i_counter));

556:
557: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='ACTIVITY' then
558:
559: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
560: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
561:
562: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='TASK' then
563: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));
564: cs_sr_log_data_temp_pvt.get_data_location('TASK', l_source_id, i_position);

Line 562: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='TASK' then

558:
559: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
560: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
561:
562: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='TASK' then
563: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));
564: cs_sr_log_data_temp_pvt.get_data_location('TASK', l_source_id, i_position);
565:
566: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,

Line 563: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));

559: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
560: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
561:
562: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='TASK' then
563: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));
564: cs_sr_log_data_temp_pvt.get_data_location('TASK', l_source_id, i_position);
565:
566: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
567: cs_sr_log_data_temp_pvt.other_log_text(i_position));

Line 564: cs_sr_log_data_temp_pvt.get_data_location('TASK', l_source_id, i_position);

560: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
561:
562: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='TASK' then
563: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));
564: cs_sr_log_data_temp_pvt.get_data_location('TASK', l_source_id, i_position);
565:
566: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
567: cs_sr_log_data_temp_pvt.other_log_text(i_position));
568:

Line 566: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,

562: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='TASK' then
563: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));
564: cs_sr_log_data_temp_pvt.get_data_location('TASK', l_source_id, i_position);
565:
566: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
567: cs_sr_log_data_temp_pvt.other_log_text(i_position));
568:
569: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='NOTE' then
570: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));

Line 567: cs_sr_log_data_temp_pvt.other_log_text(i_position));

563: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));
564: cs_sr_log_data_temp_pvt.get_data_location('TASK', l_source_id, i_position);
565:
566: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
567: cs_sr_log_data_temp_pvt.other_log_text(i_position));
568:
569: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='NOTE' then
570: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));
571: cs_sr_log_data_temp_pvt.get_data_location('NOTE', l_source_id, i_position);

Line 569: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='NOTE' then

565:
566: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
567: cs_sr_log_data_temp_pvt.other_log_text(i_position));
568:
569: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='NOTE' then
570: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));
571: cs_sr_log_data_temp_pvt.get_data_location('NOTE', l_source_id, i_position);
572:
573: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,

Line 570: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));

566: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
567: cs_sr_log_data_temp_pvt.other_log_text(i_position));
568:
569: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='NOTE' then
570: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));
571: cs_sr_log_data_temp_pvt.get_data_location('NOTE', l_source_id, i_position);
572:
573: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
574: cs_sr_log_data_temp_pvt.other_log_text(i_position));

Line 571: cs_sr_log_data_temp_pvt.get_data_location('NOTE', l_source_id, i_position);

567: cs_sr_log_data_temp_pvt.other_log_text(i_position));
568:
569: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='NOTE' then
570: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));
571: cs_sr_log_data_temp_pvt.get_data_location('NOTE', l_source_id, i_position);
572:
573: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
574: cs_sr_log_data_temp_pvt.other_log_text(i_position));
575:

Line 573: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,

569: elsif cs_sr_log_data_temp_pvt.main_log_source(i_counter) ='NOTE' then
570: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));
571: cs_sr_log_data_temp_pvt.get_data_location('NOTE', l_source_id, i_position);
572:
573: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
574: cs_sr_log_data_temp_pvt.other_log_text(i_position));
575:
576: elsif substr(cs_sr_log_data_temp_pvt.main_log_source(i_counter),1,4) ='SOLN'
577: and cs_sr_log_data_temp_pvt.i_other_records > 0 then

Line 574: cs_sr_log_data_temp_pvt.other_log_text(i_position));

570: l_source_id := to_number(rtrim(cs_sr_log_data_temp_pvt.main_log_text(i_counter)));
571: cs_sr_log_data_temp_pvt.get_data_location('NOTE', l_source_id, i_position);
572:
573: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
574: cs_sr_log_data_temp_pvt.other_log_text(i_position));
575:
576: elsif substr(cs_sr_log_data_temp_pvt.main_log_source(i_counter),1,4) ='SOLN'
577: and cs_sr_log_data_temp_pvt.i_other_records > 0 then
578:

Line 576: elsif substr(cs_sr_log_data_temp_pvt.main_log_source(i_counter),1,4) ='SOLN'

572:
573: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
574: cs_sr_log_data_temp_pvt.other_log_text(i_position));
575:
576: elsif substr(cs_sr_log_data_temp_pvt.main_log_source(i_counter),1,4) ='SOLN'
577: and cs_sr_log_data_temp_pvt.i_other_records > 0 then
578:
579: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
580: cs_sr_log_data_temp_pvt.main_log_text(i_counter));

Line 577: and cs_sr_log_data_temp_pvt.i_other_records > 0 then

573: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
574: cs_sr_log_data_temp_pvt.other_log_text(i_position));
575:
576: elsif substr(cs_sr_log_data_temp_pvt.main_log_source(i_counter),1,4) ='SOLN'
577: and cs_sr_log_data_temp_pvt.i_other_records > 0 then
578:
579: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
580: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
581: l_set_id := substr(cs_sr_log_data_temp_pvt.main_log_source(i_counter),6,length(cs_sr_log_data_temp_pvt.main_log_source(i_counter)));

Line 579: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,

575:
576: elsif substr(cs_sr_log_data_temp_pvt.main_log_source(i_counter),1,4) ='SOLN'
577: and cs_sr_log_data_temp_pvt.i_other_records > 0 then
578:
579: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
580: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
581: l_set_id := substr(cs_sr_log_data_temp_pvt.main_log_source(i_counter),6,length(cs_sr_log_data_temp_pvt.main_log_source(i_counter)));
582: l_source_id := to_number(rtrim(l_set_id));
583: cs_sr_log_data_temp_pvt.get_data_location(cs_sr_log_data_temp_pvt.main_log_source(i_counter), l_source_id, i_position);

Line 580: cs_sr_log_data_temp_pvt.main_log_text(i_counter));

576: elsif substr(cs_sr_log_data_temp_pvt.main_log_source(i_counter),1,4) ='SOLN'
577: and cs_sr_log_data_temp_pvt.i_other_records > 0 then
578:
579: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
580: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
581: l_set_id := substr(cs_sr_log_data_temp_pvt.main_log_source(i_counter),6,length(cs_sr_log_data_temp_pvt.main_log_source(i_counter)));
582: l_source_id := to_number(rtrim(l_set_id));
583: cs_sr_log_data_temp_pvt.get_data_location(cs_sr_log_data_temp_pvt.main_log_source(i_counter), l_source_id, i_position);
584:

Line 581: l_set_id := substr(cs_sr_log_data_temp_pvt.main_log_source(i_counter),6,length(cs_sr_log_data_temp_pvt.main_log_source(i_counter)));

577: and cs_sr_log_data_temp_pvt.i_other_records > 0 then
578:
579: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
580: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
581: l_set_id := substr(cs_sr_log_data_temp_pvt.main_log_source(i_counter),6,length(cs_sr_log_data_temp_pvt.main_log_source(i_counter)));
582: l_source_id := to_number(rtrim(l_set_id));
583: cs_sr_log_data_temp_pvt.get_data_location(cs_sr_log_data_temp_pvt.main_log_source(i_counter), l_source_id, i_position);
584:
585: i_position := 1;

Line 583: cs_sr_log_data_temp_pvt.get_data_location(cs_sr_log_data_temp_pvt.main_log_source(i_counter), l_source_id, i_position);

579: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id,
580: cs_sr_log_data_temp_pvt.main_log_text(i_counter));
581: l_set_id := substr(cs_sr_log_data_temp_pvt.main_log_source(i_counter),6,length(cs_sr_log_data_temp_pvt.main_log_source(i_counter)));
582: l_source_id := to_number(rtrim(l_set_id));
583: cs_sr_log_data_temp_pvt.get_data_location(cs_sr_log_data_temp_pvt.main_log_source(i_counter), l_source_id, i_position);
584:
585: i_position := 1;
586: while (i_position <= cs_sr_log_data_temp_pvt.i_other_records)
587: loop

Line 586: while (i_position <= cs_sr_log_data_temp_pvt.i_other_records)

582: l_source_id := to_number(rtrim(l_set_id));
583: cs_sr_log_data_temp_pvt.get_data_location(cs_sr_log_data_temp_pvt.main_log_source(i_counter), l_source_id, i_position);
584:
585: i_position := 1;
586: while (i_position <= cs_sr_log_data_temp_pvt.i_other_records)
587: loop
588: if (cs_sr_log_data_temp_pvt.other_log_source(i_position) = cs_sr_log_data_temp_pvt.main_log_source(i_counter)
589: and cs_sr_log_data_temp_pvt.other_log_id(i_position)=l_source_id) then
590:

Line 588: if (cs_sr_log_data_temp_pvt.other_log_source(i_position) = cs_sr_log_data_temp_pvt.main_log_source(i_counter)

584:
585: i_position := 1;
586: while (i_position <= cs_sr_log_data_temp_pvt.i_other_records)
587: loop
588: if (cs_sr_log_data_temp_pvt.other_log_source(i_position) = cs_sr_log_data_temp_pvt.main_log_source(i_counter)
589: and cs_sr_log_data_temp_pvt.other_log_id(i_position)=l_source_id) then
590:
591: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id, cs_sr_log_data_temp_pvt.other_log_text(i_position));
592: end if;

Line 589: and cs_sr_log_data_temp_pvt.other_log_id(i_position)=l_source_id) then

585: i_position := 1;
586: while (i_position <= cs_sr_log_data_temp_pvt.i_other_records)
587: loop
588: if (cs_sr_log_data_temp_pvt.other_log_source(i_position) = cs_sr_log_data_temp_pvt.main_log_source(i_counter)
589: and cs_sr_log_data_temp_pvt.other_log_id(i_position)=l_source_id) then
590:
591: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id, cs_sr_log_data_temp_pvt.other_log_text(i_position));
592: end if;
593: i_position := i_position + 1;

Line 591: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id, cs_sr_log_data_temp_pvt.other_log_text(i_position));

587: loop
588: if (cs_sr_log_data_temp_pvt.other_log_source(i_position) = cs_sr_log_data_temp_pvt.main_log_source(i_counter)
589: and cs_sr_log_data_temp_pvt.other_log_id(i_position)=l_source_id) then
590:
591: cs_sr_log_data_temp_pvt.insert_log( p_session_id, p_incident_id, cs_sr_log_data_temp_pvt.other_log_text(i_position));
592: end if;
593: i_position := i_position + 1;
594: end loop;
595:

Line 613: if cs_sr_log_data_temp_pvt.i_other_records = 1 then

609: This function will not be used later as the pointer will be directly
610: stored */
611:
612: if source_id is not null and source_type is not null then
613: if cs_sr_log_data_temp_pvt.i_other_records = 1 then
614: if cs_sr_log_data_temp_pvt.other_log_id(1)=source_id
615: and cs_sr_log_data_temp_pvt.other_log_source(1)=source_type then
616: position := 1;
617: end if;

Line 614: if cs_sr_log_data_temp_pvt.other_log_id(1)=source_id

610: stored */
611:
612: if source_id is not null and source_type is not null then
613: if cs_sr_log_data_temp_pvt.i_other_records = 1 then
614: if cs_sr_log_data_temp_pvt.other_log_id(1)=source_id
615: and cs_sr_log_data_temp_pvt.other_log_source(1)=source_type then
616: position := 1;
617: end if;
618:

Line 615: and cs_sr_log_data_temp_pvt.other_log_source(1)=source_type then

611:
612: if source_id is not null and source_type is not null then
613: if cs_sr_log_data_temp_pvt.i_other_records = 1 then
614: if cs_sr_log_data_temp_pvt.other_log_id(1)=source_id
615: and cs_sr_log_data_temp_pvt.other_log_source(1)=source_type then
616: position := 1;
617: end if;
618:
619: else

Line 620: for i_position in 1..cs_sr_log_data_temp_pvt.i_other_records

616: position := 1;
617: end if;
618:
619: else
620: for i_position in 1..cs_sr_log_data_temp_pvt.i_other_records
621: loop
622: if cs_sr_log_data_temp_pvt.other_log_id(i_position)=source_id
623: and cs_sr_log_data_temp_pvt.other_log_source(i_position)=source_type then
624: position := i_position;

Line 622: if cs_sr_log_data_temp_pvt.other_log_id(i_position)=source_id

618:
619: else
620: for i_position in 1..cs_sr_log_data_temp_pvt.i_other_records
621: loop
622: if cs_sr_log_data_temp_pvt.other_log_id(i_position)=source_id
623: and cs_sr_log_data_temp_pvt.other_log_source(i_position)=source_type then
624: position := i_position;
625: exit;
626: end if;

Line 623: and cs_sr_log_data_temp_pvt.other_log_source(i_position)=source_type then

619: else
620: for i_position in 1..cs_sr_log_data_temp_pvt.i_other_records
621: loop
622: if cs_sr_log_data_temp_pvt.other_log_id(i_position)=source_id
623: and cs_sr_log_data_temp_pvt.other_log_source(i_position)=source_type then
624: position := i_position;
625: exit;
626: end if;
627: end loop;

Line 637: cs_sr_log_data_temp_pvt.display_seq := cs_sr_log_data_temp_pvt.display_seq+1;

633: procedure inc_display_seq is
634: ctn number;
635:
636: begin
637: cs_sr_log_data_temp_pvt.display_seq := cs_sr_log_data_temp_pvt.display_seq+1;
638:
639: end inc_display_seq;
640:
641: END;