1 PACKAGE oki_utl_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKIRUTLS.pls 115.17 2002/12/01 17:51:10 rpotnuru noship $ */
3
4 --------------------------------------------------------------------------------
5 -- Start of comments
6 --
7 -- API Name : OKI_UTL_PVT
8 -- Type : Process
9 -- Purpose : This package contains procedure and functions that are common
10 -- to other packages
11 -- Modification History
12 -- 16-Jul-2001 mezra Created
13 -- 20-Sep-2001 mezra Added get_aging_label function.
14 -- 27-Sep-2001 mezra Change get_period_set, get_period_type,
15 -- get_period_name to take a parameter value
16 -- that is defaulted to to null.
17 -- 01-Oct-2001 mezra Added function to determine the start and
18 -- end value of the age grouping.
19 -- Added function to get the bin title for the
20 -- aging detail bin.
21 -- 19-Dec-2001 mezra Added function get_aging_label1,
22 -- get_aging_label2, get_aging_label3,
23 -- get_aging_label4 to get the aging label for
24 -- column.
25 -- 26-Dec-2001 mezra Added cursors that are used across packages:
26 -- g_tactk_all_csr, g_tactk_by_org_csr,
27 -- g_rnwl_oppty_all_csr, g_rnwl_oppty_by_org_csr,
28 -- g_k_exp_in_qtr_all_csr, g_k_exp_in_qtr_by_org_csr,
29 -- g_org_csr.
30 -- Added get_bin_title2 to retrieve the title for the
31 -- drilldown bins.
32 -- 26-Dec-2001 mezra Added function to default the build summary date.
33 -- 04-Jan-2002 mezra Remove all functions and procedures for the bin.
34 -- 08-Apr-2002 mezra Added g_bin_disp_lkup_csr cursor to retrieve bin
35 -- display lookup details.
36 -- 26-NOV-2002 rpotnuru NOCOPY Changes
37 --
38 -- Notes :
39 --
40 -- End of comments
41 --------------------------------------------------------------------------------
42
43
44 --------------------------------------------------------------------------------
45 -- Global cursor to get gl_periods data
46
47 --------------------------------------------------------------------------------
48 CURSOR g_glpr_csr
49 ( p_period_set_name IN VARCHAR2
50 , p_period_type IN VARCHAR2
51 , p_summary_build_date IN DATE ) RETURN gl_periods%ROWTYPE ;
52
53 --------------------------------------------------------------------------------
54 --
55 --------------------------------------------------------------------------------
56 TYPE g_tactk_all_csr_row IS RECORD
57 (
58 value oki_sales_k_hdrs.base_contract_amount%TYPE
59 , contract_count oki_sales_k_hdrs.chr_id%TYPE
60 ) ;
61
62 CURSOR g_tactk_all_csr
63 (
64 p_start_date IN DATE
65 ) RETURN g_tactk_all_csr_row ;
66
67
68 TYPE g_tactk_by_org_csr_row IS RECORD
69 (
70 value oki_sales_k_hdrs.base_contract_amount%TYPE
71 , contract_count oki_sales_k_hdrs.chr_id%TYPE
72 , authoring_org_id oki_sales_k_hdrs.authoring_org_id%TYPE
73 ) ;
74
75 CURSOR g_tactk_by_org_csr
76 (
77 p_start_date IN DATE
78 , p_authoring_org_id IN NUMBER
79 ) RETURN g_tactk_by_org_csr_row ;
80
81
82 TYPE g_rnwl_oppty_all_csr_row IS RECORD
83 (
84 value oki_sales_k_hdrs.base_contract_amount%TYPE
85 , contract_count oki_sales_k_hdrs.chr_id%TYPE
86 ) ;
87
88 CURSOR g_rnwl_oppty_all_csr
89 (
90 p_qtr_end_date IN DATE
91 ) RETURN g_rnwl_oppty_all_csr_row ;
92
93 TYPE g_rnwl_oppty_by_org_csr_row IS RECORD
94 (
95 value oki_sales_k_hdrs.base_contract_amount%TYPE
96 , contract_count oki_sales_k_hdrs.chr_id%TYPE
97 ) ;
98
99 CURSOR g_rnwl_oppty_by_org_csr
100 (
101 p_qtr_end_date IN DATE
102 , p_authoring_org_id IN NUMBER
103 ) RETURN g_rnwl_oppty_by_org_csr_row ;
104
105
106 TYPE g_k_exp_in_qtr_all_csr_row IS RECORD
107 (
108 value oki_sales_k_hdrs.base_contract_amount%TYPE
109 , contract_count oki_sales_k_hdrs.chr_id%TYPE
110 ) ;
111
112 CURSOR g_k_exp_in_qtr_all_csr
113 (
114 p_qtr_start_date IN DATE
115 , p_qtr_end_date IN DATE
116 ) RETURN g_k_exp_in_qtr_all_csr_row ;
117
118
119 TYPE g_k_exp_in_qtr_by_org_csr_row IS RECORD
120 (
121 value oki_sales_k_hdrs.base_contract_amount%TYPE
122 , contract_count oki_sales_k_hdrs.chr_id%TYPE
123 ) ;
124
125 CURSOR g_k_exp_in_qtr_by_org_csr
126 (
127 p_qtr_start_date IN DATE
128 , p_qtr_end_date IN DATE
129 , p_authoring_org_id IN NUMBER
130 ) RETURN g_k_exp_in_qtr_by_org_csr_row ;
131
132
133 --
134 -- Cursor to return the distinct authoring_org_id and
135 -- organization_name from the oki_sales_k_hdrs table
136 --
137 TYPE g_org_csr_row IS RECORD
138 (
139 authoring_org_id oki_sales_k_hdrs.authoring_org_id%TYPE
140 , organization_name oki_sales_k_hdrs.organization_name%TYPE
141 ) ;
142
143 CURSOR g_org_csr RETURN g_org_csr_row ;
144
145 --
146 -- Cursor to return the bin metadata
147 --
148 TYPE g_bin_disp_lkup_csr_row IS RECORD
149 (
150 bin_code_meaning oki_bin_disp_lkup.bin_code_meaning%TYPE
151 , bin_code_seq oki_bin_disp_lkup.bin_code_seq%TYPE
152 ) ;
153
154 CURSOR g_bin_disp_lkup_csr
155 ( p_bin_id IN VARCHAR2
156 , p_bin_code IN VARCHAR2
157 ) RETURN g_bin_disp_lkup_csr_row ;
158
159 --------------------------------------------------------------------------------
160 -- Function that gl period dates
161
162 --------------------------------------------------------------------------------
163 PROCEDURE get_gl_period_date
164 (
165 x_retcode OUT NOCOPY VARCHAR2
166 );
167
168
169 END oki_utl_pvt ;