1 PACKAGE cs_sr_log_data_temp_pvt AUTHID CURRENT_USER AS
2 /* $Header: csvlogs.pls 115.6 2002/11/30 11:50:31 pkesani noship $ */
3
4 PROCEDURE delete_log(p_session_id NUMBER
5 , p_incident_id NUMBER);
6
7 PROCEDURE insert_log(p_session_id NUMBER
8 , p_incident_id NUMBER
9 , p_log_text VARCHAR2);
10
11
12 procedure get_log_report(p_incident_id in number,
13 x_session_id out NOCOPY number);
14
15 -- The Main arrays. This array will hold all data for Audit
16 -- and activities. It will also hold pointers to the other array.
17 -- This array will be sorted by Date.
18 -------------------Sorted Array has pointer to main array ---------------
19 type table_pointer is table of integer
20 index by binary_integer;
21 main_log_pointer table_pointer;
22
23 type table_date is table of date
24 index by binary_integer;
25 main_log_date table_date;
26
27 -------------------Un-sorted Array i.e The Main array ---------------
28 type table_source is table of varchar2(30)
29 index by binary_integer;
30 main_log_source table_source;
31
32 type table_text is table of varchar2(700)
33 index by binary_integer;
34 main_log_text table_text;
35
36 main_log_page table_pointer; -- Type Integer
37
38 -------------------Un-sorted Array i.e The Other array ---------------
39 -- The Other arrays. This array will hold all data for Notes, Tasks
40 -- and Knowledge. This is an Un-sorted array.
41
42 other_log_source table_source;
43
44 type table_id is table of number
45 index by binary_integer;
46 other_log_id table_id;
47
48 type long_table_text is table of varchar2(4000)
49 index by binary_integer;
50 other_log_text long_table_text;
51
52 i_total_records integer; -- Total Number of records in Main array
53 i_other_records integer; -- Total Number of records in Other array
54 i_current_record_pointer integer; -- Current position of the pointer
55
56 total_log_pages integer ;
57 current_log_page integer;
58
59 display_seq number := 0;
60
61 procedure get_log_details(p_incident_id in number);
62
63 function format_data(column_name in varchar2,
64 old_field_name in varchar2,
65 new_field_name in varchar2,
66 changed_flag in varchar2,
67 last_update_date in date,
68 last_updated_by in varchar2,
69 source_type in varchar2) return number;
70
71 function sort_log_data(p_low in integer, p_high in integer) RETURN INTEGER;
72
73 procedure insert_log_data(p_session_id NUMBER,
74 p_incident_id NUMBER);
75
76 procedure get_data_location(source_type in varchar2, source_id in number, position out NOCOPY integer);
77
78 procedure inc_display_seq;
79
80 END;