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.

APPS.XTR_CASH_FCST dependencies on XTR_CASH_FCST

Line 1: PACKAGE BODY XTR_CASH_FCST AS

1: PACKAGE BODY XTR_CASH_FCST AS
2: /* $Header: xtrcshfb.pls 120.4 2005/10/05 20:19:09 eaggarwa ship $ */
3:
4: --
5: -- Get Header Information

Line 140: xtr_debug_pkg.debug('XTR_CASH_FCST.set_parameters-->NO_ORGS');

136: EXCEPTION
137: WHEN OTHERS THEN
138: -- G_rp_org_ids := NULL;
139: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
140: xtr_debug_pkg.debug('XTR_CASH_FCST.set_parameters-->NO_ORGS');
141: END IF;
142: Raise;
143: END;
144:

Line 166: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);

162: ELSE
163: G_parent_process := FALSE;
164: END IF;
165: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
166: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);

Line 167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);

163: G_parent_process := FALSE;
164: END IF;
165: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
166: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);

Line 168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);

164: END IF;
165: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
166: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);

Line 169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);

165: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
166: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);

Line 170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);

166: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);

Line 171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);

167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);

Line 172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);

168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);

Line 173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);

169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);

Line 174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);

170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
178: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);

Line 175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);

171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
178: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
179: xtr_debug_pkg.debug('XTR_CASH_FCST.G_forecast_id : '||G_forecast_id);

Line 176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);

172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
178: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
179: xtr_debug_pkg.debug('XTR_CASH_FCST.G_forecast_id : '||G_forecast_id);
180: END IF;

Line 177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);

173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
178: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
179: xtr_debug_pkg.debug('XTR_CASH_FCST.G_forecast_id : '||G_forecast_id);
180: END IF;
181: --

Line 178: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);

174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
178: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
179: xtr_debug_pkg.debug('XTR_CASH_FCST.G_forecast_id : '||G_forecast_id);
180: END IF;
181: --
182: -- Set View constants

Line 179: xtr_debug_pkg.debug('XTR_CASH_FCST.G_forecast_id : '||G_forecast_id);

175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
178: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
179: xtr_debug_pkg.debug('XTR_CASH_FCST.G_forecast_id : '||G_forecast_id);
180: END IF;
181: --
182: -- Set View constants
183: --

Line 342: xtr_debug_pkg.debug('>>XTR_CASH_FCST.valid_calendar_name');

338: or org.org_id IS NULL);
339:
340: BEGIN
341: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
342: xtr_debug_pkg.debug('>>XTR_CASH_FCST.valid_calendar_name');
343: END IF;
344:
345: IF(G_app_short_name = 'GL')THEN
346: SELECT period_set_name, set_of_books_id, name, currency_code

Line 382: xtr_debug_pkg.debug('<

378: END IF;
379: END LOOP;
380: END IF;
381: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
382: xtr_debug_pkg.debug('< 383: END IF;
384: return (valid_period);
385: EXCEPTION
386: WHEN OTHERS THEN

Line 453: xtr_debug_pkg.debug('>> XTR_CASH_FCST.submit_child_requests ');

449: AND trx_type <> 'GLC';
450:
451: BEGIN
452: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
453: xtr_debug_pkg.debug('>> XTR_CASH_FCST.submit_child_requests ');
454: END IF;
455: open CRowNumber(G_rp_forecast_header_id,G_rp_rownum_from, G_rp_rownum_to);
456: LOOP
457: FETCH CRowNumber INTO G_row_number;

Line 484: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.submit_child_requests');

480: EXCEPTION
481: WHEN OTHERS THEN
482: IF CRowNumber%ISOPEN THEN CLOSE CRowNumber; END IF;
483: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
484: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.submit_child_requests');
485: END IF;
486: RAISE;
487: END submit_child_requests;
488:

Line 564: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.create_forecast_header ');

560: commit;
561: EXCEPTION
562: WHEN OTHERS THEN
563: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
564: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.create_forecast_header ');
565: END IF;
566: RAISE;
567: END create_forecast_header;
568:

Line 594: xtr_debug_pkg.debug('>>XTR_CASH_FCST.create_xtr_forecast');

590: req_data VARCHAR2(30);
591: l_status VARCHAR2(1);
592: BEGIN
593: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
594: xtr_debug_pkg.debug('>>XTR_CASH_FCST.create_xtr_forecast');
595: END IF;
596: counter := 0;
597: --
598: -- Get forecast header info

Line 665: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.create_forecast-->delete');

661: END IF;
662: EXCEPTION
663: WHEN OTHERS THEN
664: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
665: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.create_forecast-->delete');
666: END IF;
667: RAISE;
668: END;
669:

Line 730: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.cash_xtr_forecast');

726: WHEN OTHERS THEN
727: IF f_row_cursor%ISOPEN THEN CLOSE f_row_cursor; END IF;
728: IF f_header_cursor%ISOPEN THEN CLOSE f_header_cursor; END IF;
729: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
730: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.cash_xtr_forecast');
731: END IF;
732: RAISE;
733: END create_forecast;
734:

Line 814: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.forecast-->delete');

810: END IF;
811: EXCEPTION
812: WHEN OTHERS THEN
813: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
814: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.forecast-->delete');
815: END IF;
816: RAISE;
817: END;
818: --

Line 840: END XTR_CASH_FCST;

836: CLOSE c_company;
837:
838: END Forecast;
839:
840: END XTR_CASH_FCST;