[Home] [Help]
PACKAGE: APPS.CE_CASH_FCST
Source
1 PACKAGE CE_CASH_FCST 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;