1 PACKAGE BIX_UTIL_PKG AUTHID CURRENT_USER AS
2 /*$Header: bixxutls.pls 115.24 2002/11/27 00:27:06 djambula ship $*/
3
4 FUNCTION get_null_lookup RETURN VARCHAR2;
5 FUNCTION get_icx_session_id RETURN NUMBER;
6 FUNCTION get_hrmiss_frmt(seconds IN NUMBER) RETURN VARCHAR2;
7 FUNCTION get_hrmi_frmt(seconds IN NUMBER) RETURN VARCHAR2;
8 FUNCTION get_uwq_refresh_date(p_context in varchar2 default null ) RETURN VARCHAR2;
9 FUNCTION get_calls_refresh_date(p_context in varchar2 default null ) RETURN VARCHAR2;
10 FUNCTION get_start_date(p_end_date IN varchar2,
11 p_period IN VARCHAR2,
12 p_date_format IN VARCHAR2,
13 p_numperiods IN NUMBER)
14 RETURN VARCHAR2;
15 FUNCTION get_group_by (p_end_date IN varchar2,
16 p_period IN VARCHAR2,
17 p_date_format IN VARCHAR2
18 )
19 RETURN VARCHAR2;
20 PROCEDURE get_time_range(p_time_id in number, p_from_date out nocopy date, p_to_date out nocopy date);
21 FUNCTION bix_dm_get_footer(p_context IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
22 FUNCTION bix_dm_get_agent_footer(p_context IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
23 FUNCTION bix_dm_get_call_footer(p_context IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
24 FUNCTION bix_dm_get_agent_refresh_date(p_context IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
25 FUNCTION bix_dm_get_call_refresh_date(p_context IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
26 FUNCTION bix_real_get_footer(p_context IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
27 FUNCTION get_uwq_footer(p_context IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
28 FUNCTION get_uwq_duration_footer(p_context IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
29 FUNCTION get_realtime_footer(p_context IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
30 PROCEDURE get_prev_period(p_period_set_name IN VARCHAR2,
31 p_period_type IN VARCHAR2,
32 p_date IN DATE,
33 p_period_start_date OUT nocopy DATE,
34 p_period_end_date OUT nocopy DATE);
35 PROCEDURE get_curr_period(p_period_set_name IN VARCHAR2,
36 p_period_type IN VARCHAR2,
37 p_date IN DATE,
38 p_period_start_date OUT nocopy DATE,
39 p_period_end_date OUT nocopy DATE);
40 PROCEDURE get_time_period(p_period_ind IN VARCHAR2,
41 p_start_date IN VARCHAR2,
42 p_start_time IN VARCHAR2,
43 p_end_date IN VARCHAR2,
44 p_end_time IN VARCHAR2,
45 p_start_period OUT nocopy VARCHAR2,
46 p_end_period OUT nocopy VARCHAR2);
47 PROCEDURE get_conversion_rate ( p_from_currency IN VARCHAR2,
48 p_to_currency IN VARCHAR2,
49 p_conversion_type IN VARCHAR2,
50 p_denom_rate OUT nocopy NUMBER,
51 p_num_rate OUT nocopy NUMBER,
52 p_status OUT nocopy NUMBER );
53 PROCEDURE get_conversion_rate ( p_from_currency IN VARCHAR2,
54 p_to_currency IN VARCHAR2,
55 p_conversion_date IN DATE,
56 p_conversion_type IN VARCHAR2,
57 p_denom_rate OUT nocopy NUMBER,
58 p_num_rate OUT nocopy NUMBER,
59 p_status OUT nocopy NUMBER );
60 FUNCTION GET_PARAMETER_VALUE(p_param_str IN varchar2,
61 p_param_name IN varchar2,
62 p_param_sep IN varchar2 default '&',
63 p_value_sep IN varchar2 default '=') RETURN VARCHAR2;
64 END BIX_UTIL_PKG;