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.
PACKAGE: APPS.CE_CASH_FCST

Source


1 PACKAGE CE_CASH_FCST AUTHID CURRENT_USER AS
2 /* $Header: cefcshfs.pls 120.13 2005/06/17 18:34:53 jikumar ship $ 	*/
3 
4 --
5 -- GLOBAL VARIABLES
6 --
7 TYPE RowInfoRec is record ( forecast_row_id		CE_FORECAST_ROWS.forecast_row_id%TYPE,
8 			    set_of_books_id		CE_FORECAST_ROWS.set_of_books_id%TYPE,
9 			    chart_of_accounts_id	CE_FORECAST_ROWS.chart_of_accounts_id%TYPE,
10 			    code_combination_id		CE_FORECAST_ROWS.code_combination_id%TYPE);
11 TYPE RowInfoTab is table of RowInfoRec index by BINARY_INTEGER;
12 G_glc_rowinfo		RowInfoTab;
13 --
14 --Run-Time Parameters
15 --
16 G_rp_forecast_header_id		CE_FORECAST_HEADERS.forecast_header_id%TYPE;
17 G_rp_forecast_runname		CE_FORECASTS.name%TYPE;
18 G_rp_forecast_start_period	CE_FORECASTS.start_period%TYPE;
19 G_rp_forecast_start_date	CE_FORECASTS.start_date%TYPE;
20 G_rp_forecast_currency		FND_CURRENCIES.currency_code%TYPE;
21 G_rp_src_curr_type		VARCHAR2(30);
22 G_rp_src_currency		FND_CURRENCIES.currency_code%TYPE;
23 G_rp_exchange_type		GL_DAILY_RATES.conversion_type%TYPE;
24 G_rp_exchange_date		GL_DAILY_RATES.conversion_date%TYPE;
25 G_rp_exchange_rate		GL_DAILY_RATES.conversion_rate%TYPE;
26 G_rp_rownum_from		CE_FORECAST_ROWS.row_number%TYPE;
27 G_rp_rownum_to			CE_FORECAST_ROWS.row_number%TYPE;
28 G_rp_calendar_name		GL_PERIOD_SETS.period_set_name%TYPE;
29 G_rp_amount_threshold		NUMBER;
30 G_rp_project_id			NUMBER;
31 G_rp_sub_request		VARCHAR2(30);
32 
33 G_rp_bank_balance_type		VARCHAR2(3);
34 G_rp_float_type			VARCHAR2(4);
35 G_rp_view_by			VARCHAR2(4);
36 G_rp_include_sub_account	VARCHAR2(1);
37 G_rp_factor			NUMBER;
38 
39 --
40 --Header Info
41 --
42 G_aging_type			CE_FORECAST_HEADERS.aging_type%TYPE;
43 G_forecast_id			CE_FORECASTS.forecast_id%TYPE;
44 G_forecast_name			CE_FORECAST_HEADERS.name%TYPE;
45 G_forecast_history_date		DATE;
46 G_forecast_history_period	VARCHAR2(30);
47 G_period_set_name		GL_PERIODS.period_set_name%TYPE;
48 G_overdue_transactions		CE_FORECAST_HEADERS.overdue_transactions%TYPE;
49 G_cutoff_period			CE_FORECAST_HEADERS.cutoff_period%TYPE;
50 G_transaction_calendar_id	CE_FORECAST_HEADERS.transaction_calendar_id%TYPE;
51 G_start_project_id		CE_FORECAST_HEADERS.start_project_id%TYPE;
52 G_start_project_no		PA_PROJECTS_ALL.segment1%TYPE;
53 G_end_project_id		CE_FORECAST_HEADERS.end_project_id%TYPE;
54 G_end_project_no		PA_PROJECTS_ALL.segment1%TYPE;
55 G_display_debug			VARCHAR2(1);
56 G_debug_path			VARCHAR2(100);
57 G_debug_file			VARCHAR2(100);
58 
59 --row info
60 G_rowid				VARCHAR2(30);
61 G_forecast_row_id		CE_FORECAST_ROWS.forecast_row_id%TYPE;
62 G_row_number			CE_FORECAST_ROWS.row_number%TYPE;
63 G_trx_type			CE_FORECAST_ROWS.trx_type%TYPE;
64 G_lead_time			CE_FORECAST_ROWS.lead_time%TYPE;
65 G_forecast_method		CE_FORECAST_ROWS.forecast_method%TYPE;
66 G_discount_option		CE_FORECAST_ROWS.discount_option%TYPE;
67 G_include_float_flag		CE_FORECAST_ROWS.include_float_flag%TYPE;
68 G_order_status			CE_FORECAST_ROWS.order_status%TYPE;
69 G_order_date_type		CE_FORECAST_ROWS.order_date_type%TYPE;
70 G_code_combination_id  		CE_FORECAST_ROWS.code_combination_id%TYPE;
71 G_set_of_books_id		CE_FORECAST_ROWS.set_of_books_id%TYPE;
72 G_org_id			CE_FORECAST_ROWS.org_id%TYPE;
73 G_legal_entity_id		CE_FORECAST_ROWS.legal_entity_id%TYPE;
74 G_chart_of_accounts_id 	 	CE_FORECAST_ROWS.chart_of_accounts_id%TYPE;
75 G_budget_name			CE_FORECAST_ROWS.budget_name%TYPE;
76 G_encumbrance_type_id		CE_FORECAST_ROWS.encumbrance_type_id%TYPE;
77 G_roll_forward_type		CE_FORECAST_ROWS.roll_forward_type%TYPE;
78 G_roll_forward_period		CE_FORECAST_ROWS.roll_forward_period%TYPE;
79 G_include_dispute_flag		CE_FORECAST_ROWS.include_dispute_flag%TYPE;
80 G_sales_stage_id		CE_FORECAST_ROWS.sales_stage_id%TYPE;
81 G_channel_code			CE_FORECAST_ROWS.channel_code%TYPE;
82 G_win_probability		CE_FORECAST_ROWS.win_probability%TYPE;
83 G_sales_forecast_status		CE_FORECAST_ROWS.sales_forecast_status%TYPE;
84 G_functional_currency		FND_CURRENCIES.currency_code%TYPE;
85 G_customer_profile_class_id 	CE_FORECAST_ROWS.customer_profile_class_id%TYPE;
86 G_bank_account_id		CE_FORECAST_ROWS.bank_account_id%TYPE;
87 G_receipt_method_id		CE_FORECAST_ROWS.receipt_method_id%TYPE;
88 G_payment_method		CE_FORECAST_ROWS.payment_method%TYPE;
89 G_pay_group			CE_FORECAST_ROWS.pay_group%TYPE;
90 G_payment_priority		CE_FORECAST_ROWS.payment_priority%TYPE;
91 G_vendor_type			CE_FORECAST_ROWS.vendor_type%TYPE;
92 G_app_short_name		CE_FORECAST_ROWS.trx_type%TYPE;
93 G_authorization_status 		CE_FORECAST_ROWS.authorization_status%TYPE;
94 G_type				CE_FORECAST_ROWS.type%TYPE;
95 G_budget_type			CE_FORECAST_ROWS.budget_type%TYPE;
96 G_budget_version		CE_FORECAST_ROWS.budget_version%TYPE;
97 G_include_hold_flag		CE_FORECAST_ROWS.include_hold_flag%TYPE;
98 G_include_net_cash_flag		CE_FORECAST_ROWS.include_net_cash_flag%TYPE;
99 G_budget_version_id		CE_FORECAST_ROWS.budget_version_id%TYPE;
100 G_payroll_id			CE_FORECAST_ROWS.payroll_id%TYPE;
101 G_company_code			CE_FORECAST_ROWS.company_code%TYPE;
102 G_exclude_indic_exp		CE_FORECAST_ROWS.exclude_indic_exp%TYPE;
103 G_xtr_bank_account		CE_FORECAST_ROWS.xtr_bank_account%TYPE;
104 G_org_payment_method_id		CE_FORECAST_ROWS.org_payment_method_id%TYPE;
105 G_external_source_type		CE_FORECAST_ROWS.external_source_type%TYPE;
106 G_criteria_category		CE_FORECAST_ROWS.criteria_category%TYPE;
107 G_criteria1			CE_FORECAST_ROWS.criteria1%TYPE;
108 G_criteria2			CE_FORECAST_ROWS.criteria2%TYPE;
109 G_criteria3			CE_FORECAST_ROWS.criteria3%TYPE;
110 G_criteria4			CE_FORECAST_ROWS.criteria4%TYPE;
111 G_criteria5			CE_FORECAST_ROWS.criteria5%TYPE;
112 G_criteria6			CE_FORECAST_ROWS.criteria6%TYPE;
113 G_criteria7			CE_FORECAST_ROWS.criteria7%TYPE;
114 G_criteria8			CE_FORECAST_ROWS.criteria8%TYPE;
115 G_criteria9			CE_FORECAST_ROWS.criteria9%TYPE;
116 G_criteria10			CE_FORECAST_ROWS.criteria10%TYPE;
117 G_criteria11			CE_FORECAST_ROWS.criteria11%TYPE;
118 G_criteria12			CE_FORECAST_ROWS.criteria12%TYPE;
119 G_criteria13			CE_FORECAST_ROWS.criteria13%TYPE;
120 G_criteria14			CE_FORECAST_ROWS.criteria14%TYPE;
121 G_criteria15			CE_FORECAST_ROWS.criteria15%TYPE;
122 G_use_average_payment_days	CE_FORECAST_ROWS.use_average_payment_days%TYPE;
123 G_apd_period			CE_FORECAST_ROWS.period%TYPE;
124 G_order_type_id                 CE_FORECAST_ROWS.order_type_id%TYPE;
125 G_use_payment_terms             CE_FORECAST_ROWS.use_payment_terms%TYPE;
126 G_include_temp_labor_flag       CE_FORECAST_ROWS.include_temp_labor_flag%TYPE;
127 --
128 G_sob_currency_code		GL_SETS_OF_BOOKS.currency_code%TYPE;
129 G_parent_process		BOOLEAN;
130 G_overdue_column_id		NUMBER;
131 --
132 -- Forecast Currency Info
133 --
134 G_precision			NUMBER;
135 G_ext_precision			NUMBER;
136 G_min_acct_unit			NUMBER;
137 --
138 G_max_col			NUMBER;
139 G_min_col			NUMBER;
140 G_invalid_overdue		BOOLEAN;
141 G_invalid_overdue_row		BOOLEAN;
142 G_gl_cash_only			BOOLEAN;
143 --
144 G_spec_revision 	VARCHAR2(1000) := '$Revision: 120.13 $';
145 
146 FUNCTION spec_revision RETURN VARCHAR2;
147 
148 FUNCTION body_revision RETURN VARCHAR2;
149 
150 PROCEDURE set_parameters (p_forecast_header_id	IN NUMBER,
151 			p_forecast_runname	IN VARCHAR2,
152 			p_forecast_start_date	IN VARCHAR2,
153 			p_calendar_name		IN VARCHAR2,
154 			p_forecast_start_period	IN VARCHAR2,
155 			p_forecast_currency	IN VARCHAR2,
156 			p_exchange_type		IN VARCHAR2,
157 			p_exchange_date		IN VARCHAR2,
158 			p_exchange_rate		IN NUMBER,
159 			p_src_curr_type		IN VARCHAR2,
160 			p_src_currency		IN VARCHAR2,
161 			p_amount_threshold	IN NUMBER,
162 			p_project_id		IN NUMBER,
163 			p_rownum_from		IN NUMBER,
164 			p_rownum_to		IN NUMBER,
165 			p_sub_request		IN VARCHAR2,
166 			p_factor		IN NUMBER,
167 			p_include_sub_account	IN VARCHAR2,
168 			p_view_by		IN VARCHAR2,
169 			p_bank_balance_type	IN VARCHAR2,
170 			p_float_type		IN VARCHAR2,
171 			p_forecast_id		IN NUMBER,
172 			p_display_debug		IN VARCHAR2,
173 			p_debug_path		IN VARCHAR2,
174 			p_debug_file		IN VARCHAR2);
175 
176 PROCEDURE Print_Report;
177 
178 PROCEDURE Print_Forecast_Report;
179 
180 PROCEDURE Forecast(	errbuf			OUT NOCOPY VARCHAR2,
181 			retcode			OUT NOCOPY NUMBER,
182 			p_forecast_header_id	IN NUMBER,
183 			p_forecast_runname	IN VARCHAR2,
184 			p_factor		IN NUMBER,
185 			p_start_project_num	IN VARCHAR2,
186 			p_end_project_num	IN VARCHAR2,
187 			p_calendar_name		IN VARCHAR2,
188 			p_forecast_start_period	IN VARCHAR2,
189 			p_forecast_currency	IN VARCHAR2,
190 			p_src_curr_type		IN VARCHAR2,
191 			p_src_curr_dummy	in varchar2,
192 			p_src_currency		IN VARCHAR2,
193 			p_exchange_date		IN VARCHAR2,
194 			p_exchange_type		IN VARCHAR2,
195 			p_exchange_rate		IN NUMBER,
196 			p_rownum_from		IN NUMBER,
197 			p_rownum_to		IN NUMBER,
198 			p_amount_threshold_x	IN VARCHAR2,
199 			p_sub_request		IN VARCHAR2,
200 			p_view_by		IN VARCHAR2,
201 			p_view_dummy		IN VARCHAR2,
202 			p_bank_balance_type	IN VARCHAR2,
203 			p_float_type		IN VARCHAR2,
204 			p_include_sub_account	IN VARCHAR2,
205 			p_forecast_id		IN NUMBER,
206 			p_dummy			IN VARCHAR2,
207 			p_display_debug		IN VARCHAR2,
208 			p_debug_path		IN VARCHAR2,
209 			p_debug_file		IN VARCHAR2,
210 			p_fc_name_exists	IN VARCHAR2);
211 
212 PROCEDURE Forecast(	errbuf			OUT NOCOPY VARCHAR2,
213 			retcode			OUT NOCOPY NUMBER,
214 			p_forecast_header_id	IN NUMBER,
215 			p_forecast_runname	IN VARCHAR2,
216 			p_factor		IN NUMBER,
217 			p_start_project_num	IN VARCHAR2,
218 			p_end_project_num	IN VARCHAR2,
219 			p_calendar_name		IN VARCHAR2,
220 			p_forecast_start_date	IN VARCHAR2,
221 			p_forecast_currency	IN VARCHAR2,
222 			p_src_curr_type		IN VARCHAR2,
223 			p_src_curr_dummy	IN VARCHAR2,
224 			p_src_currency		IN VARCHAR2,
225 			p_exchange_date		IN VARCHAR2,
226 			p_exchange_type		IN VARCHAR2,
227 			p_exchange_rate		IN NUMBER,
228 			p_rownum_from		IN NUMBER,
229 			p_rownum_to		IN NUMBER,
230 			p_amount_threshold_x	IN VARCHAR2,
231 			p_sub_request		IN VARCHAR2,
232 			p_view_by		IN VARCHAR2,
233 			p_view_dummy		IN VARCHAR2,
234 			p_bank_balance_type	IN VARCHAR2,
235 			p_float_type		IN VARCHAR2,
236 			p_include_sub_account	IN VARCHAR2,
237 			p_forecast_id		IN NUMBER,
238 			p_display_debug		IN VARCHAR2,
239 			p_debug_path		IN VARCHAR2,
240 			p_debug_file		IN VARCHAR2,
241 			p_fc_name_exists	IN VARCHAR2);
242 
243 PROCEDURE Create_Forecast;
244 
245 END CE_CASH_FCST;