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.XTR_CASH_FCST

Source


1 PACKAGE XTR_CASH_FCST AUTHID CURRENT_USER AS
2 /*$Header: xtrcshfs.pls 120.1 2005/06/29 06:15:26 badiredd ship $ 	*/
3 
4 -- CONTEXT: CALL = XTR_CASH_FCST.Forecast
5 
6 -- GLOBAL VARIABLES
7 --
8 TYPE RowInfoRec is record ( forecast_row_id		CE_FORECAST_ROWS.forecast_row_id%TYPE,
9 			    set_of_books_id		CE_FORECAST_ROWS.set_of_books_id%TYPE,
10 			    chart_of_accounts_id	CE_FORECAST_ROWS.chart_of_accounts_id%TYPE,
11 			    code_combination_id		CE_FORECAST_ROWS.code_combination_id%TYPE);
12 TYPE RowInfoTab is table of RowInfoRec index by BINARY_INTEGER;
13 
14 --G_glc_rowinfo		RowInfoTab;
15 --
16 --Run-Time Parameters
17 --
18 G_rp_forecast_header_id		CE_FORECAST_HEADERS.forecast_header_id%TYPE;
19 G_rp_forecast_runname		CE_FORECASTS.name%TYPE;
20 G_rp_forecast_start_period	CE_FORECASTS.start_period%TYPE;
21 G_rp_forecast_start_date	CE_FORECASTS.start_date%TYPE;
22 G_rp_forecast_currency		FND_CURRENCIES.currency_code%TYPE;
23 G_rp_src_curr_type		VARCHAR2(30);
24 G_rp_src_currency		FND_CURRENCIES.currency_code%TYPE;
25 G_rp_exchange_type		GL_DAILY_RATES.conversion_type%TYPE;
26 --G_rp_exchange_date		GL_DAILY_RATES.conversion_date%TYPE;
27 --G_rp_exchange_rate		GL_DAILY_RATES.conversion_rate%TYPE;
28 G_rp_rownum_from		CE_FORECAST_ROWS.row_number%TYPE;
29 G_rp_rownum_to			CE_FORECAST_ROWS.row_number%TYPE;
30 G_rp_calendar_name		GL_PERIOD_SETS.period_set_name%TYPE;
31 --G_rp_amount_threshold		NUMBER;
32 --G_rp_project_id			NUMBER;
33 G_rp_legal_entity_id		NUMBER;
34 G_rp_sub_request		VARCHAR2(30);
35 G_rp_org_ids                    VARCHAR2(500);
36 
37 --
38 --Header Info
39 --
40 G_aging_type			CE_FORECAST_HEADERS.aging_type%TYPE;
41 G_forecast_id			CE_FORECASTS.forecast_id%TYPE;
42 G_forecast_name			CE_FORECAST_HEADERS.name%TYPE;
43 --G_forecast_history_date		DATE;
44 --G_forecast_history_period	VARCHAR2(30);
45 G_period_set_name		GL_PERIODS.period_set_name%TYPE;
46 G_overdue_transactions		CE_FORECAST_HEADERS.overdue_transactions%TYPE;
47 --G_cutoff_period			CE_FORECAST_HEADERS.cutoff_period%TYPE;
48 G_transaction_calendar_id	CE_FORECAST_HEADERS.transaction_calendar_id%TYPE;
49 G_start_project_id		CE_FORECAST_HEADERS.start_project_id%TYPE;
50 G_end_project_id		CE_FORECAST_HEADERS.end_project_id%TYPE;
51 G_treasury_template		CE_FORECAST_HEADERS.treasury_template%TYPE;
52 G_party_code			XTR_PARTY_INFO.party_code%TYPE;
53 
54 --row info
55 G_rowid				VARCHAR2(30);
56 G_forecast_row_id		CE_FORECAST_ROWS.forecast_row_id%TYPE;
57 G_row_number			CE_FORECAST_ROWS.row_number%TYPE;
58 G_trx_type			CE_FORECAST_ROWS.trx_type%TYPE;
59 G_lead_time			CE_FORECAST_ROWS.lead_time%TYPE;
60 G_forecast_method		CE_FORECAST_ROWS.forecast_method%TYPE;
61 G_discount_option		CE_FORECAST_ROWS.discount_option%TYPE;
62 G_include_float_flag		CE_FORECAST_ROWS.include_float_flag%TYPE;
63 G_order_status			CE_FORECAST_ROWS.order_status%TYPE;
64 G_order_date_type		CE_FORECAST_ROWS.order_date_type%TYPE;
65 G_code_combination_id  		CE_FORECAST_ROWS.code_combination_id%TYPE;
66 G_set_of_books_id		CE_FORECAST_ROWS.set_of_books_id%TYPE;
67 G_org_id			CE_FORECAST_ROWS.org_id%TYPE;
68 G_chart_of_accounts_id 	 	CE_FORECAST_ROWS.chart_of_accounts_id%TYPE;
69 G_budget_name			CE_FORECAST_ROWS.budget_name%TYPE;
70 G_encumbrance_type_id		CE_FORECAST_ROWS.encumbrance_type_id%TYPE;
71 G_roll_forward_type		CE_FORECAST_ROWS.roll_forward_type%TYPE;
72 G_roll_forward_period		CE_FORECAST_ROWS.roll_forward_period%TYPE;
73 G_include_dispute_flag		CE_FORECAST_ROWS.include_dispute_flag%TYPE;
74 G_sales_stage_id		CE_FORECAST_ROWS.sales_stage_id%TYPE;
75 G_channel_code			CE_FORECAST_ROWS.channel_code%TYPE;
76 G_win_probability		CE_FORECAST_ROWS.win_probability%TYPE;
77 G_sales_forecast_status		CE_FORECAST_ROWS.sales_forecast_status%TYPE;
78 --G_functional_currency		FND_CURRENCIES.currency_code%TYPE;
79 G_customer_profile_class_id 	CE_FORECAST_ROWS.customer_profile_class_id%TYPE;
80 G_bank_account_id		CE_FORECAST_ROWS.bank_account_id%TYPE;
81 G_receipt_method_id		CE_FORECAST_ROWS.receipt_method_id%TYPE;
82 G_payment_method		CE_FORECAST_ROWS.payment_method%TYPE;
83 G_pay_group			CE_FORECAST_ROWS.pay_group%TYPE;
84 G_payment_priority		CE_FORECAST_ROWS.payment_priority%TYPE;
85 G_vendor_type			CE_FORECAST_ROWS.vendor_type%TYPE;
86 G_app_short_name		CE_FORECAST_ROWS.trx_type%TYPE;
87 G_authorization_status 		CE_FORECAST_ROWS.authorization_status%TYPE;
88 G_type				CE_FORECAST_ROWS.type%TYPE;
89 G_budget_type			CE_FORECAST_ROWS.budget_type%TYPE;
90 G_budget_version		CE_FORECAST_ROWS.budget_version%TYPE;
91 G_include_hold_flag		CE_FORECAST_ROWS.include_hold_flag%TYPE;
92 G_include_net_cash_flag		CE_FORECAST_ROWS.include_net_cash_flag%TYPE;
93 G_budget_version_id		CE_FORECAST_ROWS.budget_version_id%TYPE;
94 G_payroll_id			CE_FORECAST_ROWS.payroll_id%TYPE;
95 G_org_payment_method_id		CE_FORECAST_ROWS.org_payment_method_id%TYPE;
96 G_external_source_type		CE_FORECAST_ROWS.external_source_type%TYPE;
97 G_criteria_category		CE_FORECAST_ROWS.criteria_category%TYPE;
98 G_criteria1			CE_FORECAST_ROWS.criteria1%TYPE;
99 G_criteria2			CE_FORECAST_ROWS.criteria2%TYPE;
100 G_criteria3			CE_FORECAST_ROWS.criteria3%TYPE;
101 G_criteria4			CE_FORECAST_ROWS.criteria4%TYPE;
102 G_criteria5			CE_FORECAST_ROWS.criteria5%TYPE;
103 G_criteria6			CE_FORECAST_ROWS.criteria6%TYPE;
104 G_criteria7			CE_FORECAST_ROWS.criteria7%TYPE;
105 G_criteria8			CE_FORECAST_ROWS.criteria8%TYPE;
106 G_criteria9			CE_FORECAST_ROWS.criteria9%TYPE;
107 G_criteria10			CE_FORECAST_ROWS.criteria10%TYPE;
108 G_criteria11			CE_FORECAST_ROWS.criteria11%TYPE;
109 G_criteria12			CE_FORECAST_ROWS.criteria12%TYPE;
110 G_criteria13			CE_FORECAST_ROWS.criteria13%TYPE;
111 G_criteria14			CE_FORECAST_ROWS.criteria14%TYPE;
112 G_criteria15			CE_FORECAST_ROWS.criteria15%TYPE;
113 --
114 G_sob_currency_code		GL_SETS_OF_BOOKS.currency_code%TYPE;
115 G_parent_process		BOOLEAN;
116 G_overdue_period_id		NUMBER;
117 
118 --
119 -- Forecast Currency Info
120 --
121 G_precision			NUMBER;
122 G_ext_precision			NUMBER;
123 G_min_acct_unit			NUMBER;
124 --
125 G_max_col			NUMBER;
126 G_min_col			NUMBER;
127 G_invalid_overdue		BOOLEAN;
128 G_invalid_overdue_row		BOOLEAN;
129 --G_gl_cash_only			BOOLEAN;
130 --
131 FUNCTION set_parameters (p_forecast_header_id	IN NUMBER,
132 			p_forecast_runname	IN VARCHAR2,
133 			p_forecast_start_date	IN VARCHAR2,
134 			p_forecast_currency	IN VARCHAR2,
135 			p_src_curr_type		IN VARCHAR2,
136 			p_company_code		IN VARCHAR2,
137 			p_rownum_from		IN NUMBER,
138 			p_rownum_to		IN NUMBER,
139 			p_sub_request		IN VARCHAR2) RETURN NUMBER;
140 
141 PROCEDURE Print_Report;
142 
143 
144 PROCEDURE Forecast(	errbuf			OUT NOCOPY VARCHAR2,
145 			retcode			OUT NOCOPY NUMBER,
146 			p_forecast_header_id	IN NUMBER,
147 			p_forecast_runname	IN VARCHAR2,
148 			p_company_code		IN VARCHAR2,
149 			p_forecast_start_date	IN VARCHAR2,
150 			p_rownum_from		IN NUMBER,
151 			p_rownum_to		IN NUMBER,
152 			p_sub_request		IN VARCHAR2);
153 
154 PROCEDURE Create_Forecast;
155 
156 END XTR_CASH_FCST;
157