1 PACKAGE oki_but_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKIRBUTS.pls 115.8 2002/12/01 17:51:51 rpotnuru noship $ */
3
4 --------------------------------------------------------------------------------
5 -- Start of comments
6 --
7 -- API Name : OKI_BUT_PVT
8 -- Type : Process
9 -- Purpose : This package contains procedure and functions that are common
10 -- to other bins
11 -- Modification History
12 -- 04-Jan-2002 mezra Created
13 -- 20-Mar-2002 mezra Added logic to retrieve title at contract level.
14 -- 27-Mar-2002 mezra Added new procedure and functions to support
15 -- scaling factor
16 -- 04-Apr-2002 mezra Moved dbdrv to top of file.
17 -- Synched branch with mainline.
18 -- 26-NOV-2002 rpotnuru NOCOPY Changes
19 --
20 --
21 -- Notes :
22 --
23 -- End of comments
24 --------------------------------------------------------------------------------
25
26
27 --------------------------------------------------------------------------------
28 -- Package Global to hold scaling factor
29 --------------------------------------------------------------------------------
30 g_scaling_factor VARCHAR2(30);
31
32 --------------------------------------------------------------------------------
33 -- Function that returns the refresh date
34
35 --------------------------------------------------------------------------------
36 FUNCTION get_rfh_date
37 ( p_name IN VARCHAR2
38 ) RETURN VARCHAR2 ;
39
40 --------------------------------------------------------------------------------
41 -- Function to get the period set name based on the user's profile.
42
43 --------------------------------------------------------------------------------
44 FUNCTION get_period_set
45 ( p_profile_value IN VARCHAR2
46 ) RETURN VARCHAR2 ;
47
48
49 --------------------------------------------------------------------------------
50 -- Function to get the period type based on the user's profile.
51
52 --------------------------------------------------------------------------------
53 FUNCTION get_period_type
54 ( p_profile_value IN VARCHAR2
55 ) RETURN VARCHAR2 ;
56
57
58
59 --------------------------------------------------------------------------------
60 -- Function to get the default the period name based on the user's profile:
61 -- period set and period type
62
63 --------------------------------------------------------------------------------
64 FUNCTION get_period_name
65 ( p_profile_value IN VARCHAR2
66 ) RETURN VARCHAR2 ;
67
68
69 --------------------------------------------------------------------------------
70 -- Function to get the column label for the renewal aging report
71
72 --------------------------------------------------------------------------------
73 FUNCTION get_aging_label1( p_col_pos IN VARCHAR2 ) return varchar2 ;
74 FUNCTION get_aging_label2( p_col_pos IN VARCHAR2 ) return varchar2 ;
75 FUNCTION get_aging_label3( p_col_pos IN VARCHAR2 ) return varchar2 ;
76 FUNCTION get_aging_label4( p_col_pos IN VARCHAR2 ) return varchar2 ;
77
78 --------------------------------------------------------------------------------
79 -- Function that returns the either the start age age value or the end age
80 -- value of the age group.
81 --------------------------------------------------------------------------------
82 FUNCTION get_start_end_age_val
83 ( p_start_end_pos IN VARCHAR2
84 , p_col_pos IN VARCHAR2
85 ) RETURN VARCHAR2 ;
86
87 --------------------------------------------------------------------------------
88 -- Function that returns the title for a bin.
89 --------------------------------------------------------------------------------
90 FUNCTION get_bin_title
91 ( p_grouping IN VARCHAR2
92 , p_bin_name IN VARCHAR2
93 , p_code IN VARCHAR2
94 ) RETURN VARCHAR2 ;
95
96 --------------------------------------------------------------------------------
97 -- Function that returns the title for a bin at the org level.
98 --------------------------------------------------------------------------------
99 FUNCTION get_bin_title2
100 ( p_param IN VARCHAR2
101 ) RETURN VARCHAR2 ;
102
103 --------------------------------------------------------------------------------
104 -- Function that returns the title for a bin at the contract level.
105 --------------------------------------------------------------------------------
106 FUNCTION get_top_n_k_title
107 ( p_param IN VARCHAR2
108 ) RETURN VARCHAR2 ;
109
110 --------------------------------------------------------------------------------
111 -- Function to return the title for the bin
112 --------------------------------------------------------------------------------
113 FUNCTION get_title_for_bin
114 ( p_param IN VARCHAR2
115 ) RETURN VARCHAR2 ;
116
117 --------------------------------------------------------------------------------
118 -- Function to return the scaling factor
119 --------------------------------------------------------------------------------
120 FUNCTION get_scaling_factor RETURN VARCHAR2;
121
122 --------------------------------------------------------------------------------
123 -- Procedure to set the scaling factor from the bin parameter
124 --------------------------------------------------------------------------------
125 PROCEDURE set_scaling_factor(p_param IN VARCHAR2) ;
126
127 --------------------------------------------------------------------------------
128 -- Function that returns the default value for the summary build date.
129 --------------------------------------------------------------------------------
130 FUNCTION dflt_summary_build_date
131 ( p_name IN VARCHAR2
132 ) RETURN VARCHAR2 ;
133
134 END oki_but_pvt ;