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.CE_FORECASTS_PKG dependencies on CE_FORECASTS

Line 1: PACKAGE BODY CE_FORECASTS_PKG AS

1: PACKAGE BODY CE_FORECASTS_PKG AS
2: /* $Header: cefcastb.pls 120.4 2003/07/31 23:44:32 sspoonen ship $ */
3:
4: FUNCTION body_revision RETURN VARCHAR2 IS
5: BEGIN

Line 20: CE_FORECASTS_PKG.G_factor := X_factor;

16: END spec_revision;
17:
18: PROCEDURE set_factor(X_factor NUMBER) IS
19: BEGIN
20: CE_FORECASTS_PKG.G_factor := X_factor;
21: END;
22:
23: FUNCTION get_factor RETURN NUMBER IS
24: BEGIN

Line 25: return (CE_FORECASTS_PKG.G_factor);

21: END;
22:
23: FUNCTION get_factor RETURN NUMBER IS
24: BEGIN
25: return (CE_FORECASTS_PKG.G_factor);
26: END;
27:
28: PROCEDURE create_empty_forecast(X_rowid IN OUT NOCOPY VARCHAR2,
29: X_forecast_id IN OUT NOCOPY NUMBER,

Line 72: CE_FORECASTS_TABLE_PKG.insert_row(

68: BEGIN
69: --
70: -- Insert new forecast into forecast table
71: --
72: CE_FORECASTS_TABLE_PKG.insert_row(
73: X_rowid => X_rowid,
74: X_forecast_id => X_forecast_id,
75: X_forecast_header_id => X_forecast_header_id,
76: X_name => X_forecast_name,

Line 190: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.create_empty_forecast');

186: EXCEPTION
187: WHEN OTHERS THEN
188: if (cc%ISOPEN) then close cc; end if;
189: if (cr%ISOPEN) then close cr; end if;
190: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.create_empty_forecast');
191: RAISE;
192: END;
193:
194: PROCEDURE add_column( X_new_forecast VARCHAR2,

Line 219: cep_standard.debug('>> CE_FORECASTS_PKG.add_column');

215: p_forecast_cell_id NUMBER;
216: p_last_column_id NUMBER;
217: p_developer_column_num NUMBER;
218: BEGIN
219: cep_standard.debug('>> CE_FORECASTS_PKG.add_column');
220: IF(X_new_forecast = 'Y')THEN
221: CE_FORECASTS_PKG.duplicate_template_header(
222: X_forecast_header_id => X_forecast_header_id,
223: X_created_by => X_created_by,

Line 221: CE_FORECASTS_PKG.duplicate_template_header(

217: p_developer_column_num NUMBER;
218: BEGIN
219: cep_standard.debug('>> CE_FORECASTS_PKG.add_column');
220: IF(X_new_forecast = 'Y')THEN
221: CE_FORECASTS_PKG.duplicate_template_header(
222: X_forecast_header_id => X_forecast_header_id,
223: X_created_by => X_created_by,
224: X_creation_date => X_creation_date,
225: X_last_updated_by => X_last_updated_by,

Line 267: CE_FORECASTS_PKG.fill_cells( X_forecast_header_id,

263: X_attribute14 => null,
264: X_attribute15 => null);
265:
266: cep_standard.debug(' - insert new cells');
267: CE_FORECASTS_PKG.fill_cells( X_forecast_header_id,
268: 'COLUMN',
269: X_forecast_column_id,
270: X_created_by,
271: X_creation_date,

Line 277: CE_FORECASTS_PKG.rearrange_column_number( X_forecast_header_id );

273: X_last_update_date,
274: X_last_update_login );
275:
276: cep_standard.debug(' - rearrange column number');
277: CE_FORECASTS_PKG.rearrange_column_number( X_forecast_header_id );
278:
279: cep_standard.debug(' - arrange GLC line');
280: --
281: -- If template contains GLC line, copy the GLC amount from the last

Line 332: cep_standard.debug('<< CE_FORECASTS_PKG.add_column');

328: --
329: -- Commit work
330: --
331: COMMIT;
332: cep_standard.debug('<< CE_FORECASTS_PKG.add_column');
333:
334: EXCEPTION
335: WHEN NO_DATA_FOUND THEN
336: null;

Line 339: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.add_column');

335: WHEN NO_DATA_FOUND THEN
336: null;
337: WHEN OTHERS THEN
338: IF SQLCODE <> -1422 THEN
339: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.add_column');
340: RAISE;
341: END IF;
342: END;
343:

Line 360: CE_FORECASTS_PKG.duplicate_template_header(

356: X_description VARCHAR2) IS
357: p_rowid varchar2(100);
358: BEGIN
359: IF(X_new_forecast = 'Y')THEN
360: CE_FORECASTS_PKG.duplicate_template_header(
361: X_forecast_header_id => X_forecast_header_id,
362: X_created_by => X_created_by,
363: X_creation_date => X_creation_date,
364: X_last_updated_by => X_last_updated_by,

Line 369: CE_FORECASTS_PKG.rearrange_column_number(X_forecast_header_id);

365: X_last_update_date => X_last_update_date,
366: X_last_update_login => X_last_update_login,
367: X_forecast_id => X_forecast_id,
368: X_name => X_name);
369: CE_FORECASTS_PKG.rearrange_column_number(X_forecast_header_id);
370: END IF;
371:
372: CE_FORECAST_ROWS1_PKG.Insert_Row(
373: X_rowid => p_rowid,

Line 460: CE_FORECASTS_PKG.fill_cells( X_forecast_header_id,

456: X_period => to_number(null),
457: X_order_type_id => to_number(null),
458: X_use_payment_terms => null);
459:
460: CE_FORECASTS_PKG.fill_cells( X_forecast_header_id,
461: 'ROW',
462: X_forecast_row_id,
463: X_created_by,
464: X_creation_date,

Line 475: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.add_row');

471: COMMIT;
472:
473: EXCEPTION
474: WHEN OTHERS THEN
475: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.add_row');
476: RAISE;
477: END;
478:
479: PROCEDURE fill_cells( X_header_id NUMBER,

Line 488: from ce_forecasts

484: X_last_updated_by NUMBER,
485: X_last_update_date DATE,
486: X_last_update_login NUMBER) IS
487: cursor cf is select forecast_id
488: from ce_forecasts
489: where forecast_header_id = X_header_id;
490: cursor cr(ffid number) is
491: select distinct(forecast_row_id)
492: from ce_forecast_cells

Line 556: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.add_row');

552: WHEN OTHERS THEN
553: if (cc%ISOPEN) then close cc; end if;
554: if (cr%ISOPEN) then close cr; end if;
555: if (cf%ISOPEN) then close cf; end if;
556: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.add_row');
557: RAISE;
558: END;
559:
560: PROCEDURE rearrange_column_number( X_forecast_header_id NUMBER ) IS

Line 589: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.rearrage_column_number');

585:
586: EXCEPTION
587: WHEN OTHERS THEN
588: if (cc%ISOPEN) then close cc; end if;
589: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.rearrage_column_number');
590: RAISE;
591: END;
592:
593: PROCEDURE duplicate_template_header(

Line 621: cep_standard.debug('>> CE_FORECASTS_PKG.duplicate_forecast_header');

617: WHERE forecast_header_id = X_forecast_header_id;
618: RowInfo CR%ROWTYPE;
619:
620: BEGIN
621: cep_standard.debug('>> CE_FORECASTS_PKG.duplicate_forecast_header');
622: --
623: -- Create duplicate header
624: --
625: open CH;

Line 676: UPDATE CE_FORECASTS

672: UPDATE CE_FORECAST_CELLS
673: SET forecast_header_id = p_forecast_header_id
674: WHERE forecast_id = X_forecast_id;
675:
676: UPDATE CE_FORECASTS
677: SET forecast_header_id = p_forecast_header_id
678: WHERE forecast_id = X_forecast_id;
679:
680: --

Line 833: cep_standard.debug('<< CE_FORECASTS_PKG.duplicate_forecast_header');

829: fetch CR into RowInfo;
830: END LOOP;
831:
832: x_forecast_header_id := p_forecast_header_id;
833: cep_standard.debug('<< CE_FORECASTS_PKG.duplicate_forecast_header');
834:
835: EXCEPTION
836: WHEN OTHERS THEN
837: if (ch%ISOPEN) then close ch; end if;

Line 840: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.duplicate_template_header');

836: WHEN OTHERS THEN
837: if (ch%ISOPEN) then close ch; end if;
838: if (cc%ISOPEN) then close cc; end if;
839: if (cr%ISOPEN) then close cr; end if;
840: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.duplicate_template_header');
841: RAISE;
842: END;
843:
844: PROCEDURE recalc_glc(X_hid IN NUMBER) IS

Line 847: FROM ce_forecasts

843:
844: PROCEDURE recalc_glc(X_hid IN NUMBER) IS
845: CURSOR C_fid (p_hid NUMBER) IS
846: SELECT forecast_id
847: FROM ce_forecasts
848: WHERE forecast_header_id = p_hid;
849:
850: l_start_date CE_FORECASTS.start_date%TYPE;
851: l_calendar_name CE_FORECASTS.period_set_name%TYPE;

Line 850: l_start_date CE_FORECASTS.start_date%TYPE;

846: SELECT forecast_id
847: FROM ce_forecasts
848: WHERE forecast_header_id = p_hid;
849:
850: l_start_date CE_FORECASTS.start_date%TYPE;
851: l_calendar_name CE_FORECASTS.period_set_name%TYPE;
852: l_start_period CE_FORECASTS.start_period%TYPE;
853: l_forecast_currency CE_FORECASTS.forecast_currency%TYPE;
854: l_exchange_type CE_FORECASTS.exchange_rate_type%TYPE;

Line 851: l_calendar_name CE_FORECASTS.period_set_name%TYPE;

847: FROM ce_forecasts
848: WHERE forecast_header_id = p_hid;
849:
850: l_start_date CE_FORECASTS.start_date%TYPE;
851: l_calendar_name CE_FORECASTS.period_set_name%TYPE;
852: l_start_period CE_FORECASTS.start_period%TYPE;
853: l_forecast_currency CE_FORECASTS.forecast_currency%TYPE;
854: l_exchange_type CE_FORECASTS.exchange_rate_type%TYPE;
855: l_exchange_date CE_FORECASTS.exchange_date%TYPE;

Line 852: l_start_period CE_FORECASTS.start_period%TYPE;

848: WHERE forecast_header_id = p_hid;
849:
850: l_start_date CE_FORECASTS.start_date%TYPE;
851: l_calendar_name CE_FORECASTS.period_set_name%TYPE;
852: l_start_period CE_FORECASTS.start_period%TYPE;
853: l_forecast_currency CE_FORECASTS.forecast_currency%TYPE;
854: l_exchange_type CE_FORECASTS.exchange_rate_type%TYPE;
855: l_exchange_date CE_FORECASTS.exchange_date%TYPE;
856: l_exchange_rate CE_FORECASTS.exchange_rate%TYPE;

Line 853: l_forecast_currency CE_FORECASTS.forecast_currency%TYPE;

849:
850: l_start_date CE_FORECASTS.start_date%TYPE;
851: l_calendar_name CE_FORECASTS.period_set_name%TYPE;
852: l_start_period CE_FORECASTS.start_period%TYPE;
853: l_forecast_currency CE_FORECASTS.forecast_currency%TYPE;
854: l_exchange_type CE_FORECASTS.exchange_rate_type%TYPE;
855: l_exchange_date CE_FORECASTS.exchange_date%TYPE;
856: l_exchange_rate CE_FORECASTS.exchange_rate%TYPE;
857: l_src_curr_type CE_FORECASTS.currency_type%TYPE;

Line 854: l_exchange_type CE_FORECASTS.exchange_rate_type%TYPE;

850: l_start_date CE_FORECASTS.start_date%TYPE;
851: l_calendar_name CE_FORECASTS.period_set_name%TYPE;
852: l_start_period CE_FORECASTS.start_period%TYPE;
853: l_forecast_currency CE_FORECASTS.forecast_currency%TYPE;
854: l_exchange_type CE_FORECASTS.exchange_rate_type%TYPE;
855: l_exchange_date CE_FORECASTS.exchange_date%TYPE;
856: l_exchange_rate CE_FORECASTS.exchange_rate%TYPE;
857: l_src_curr_type CE_FORECASTS.currency_type%TYPE;
858: l_source_currency CE_FORECASTS.source_currency%TYPE;

Line 855: l_exchange_date CE_FORECASTS.exchange_date%TYPE;

851: l_calendar_name CE_FORECASTS.period_set_name%TYPE;
852: l_start_period CE_FORECASTS.start_period%TYPE;
853: l_forecast_currency CE_FORECASTS.forecast_currency%TYPE;
854: l_exchange_type CE_FORECASTS.exchange_rate_type%TYPE;
855: l_exchange_date CE_FORECASTS.exchange_date%TYPE;
856: l_exchange_rate CE_FORECASTS.exchange_rate%TYPE;
857: l_src_curr_type CE_FORECASTS.currency_type%TYPE;
858: l_source_currency CE_FORECASTS.source_currency%TYPE;
859: l_rownum_from CE_FORECAST_ROWS.row_number%TYPE;

Line 856: l_exchange_rate CE_FORECASTS.exchange_rate%TYPE;

852: l_start_period CE_FORECASTS.start_period%TYPE;
853: l_forecast_currency CE_FORECASTS.forecast_currency%TYPE;
854: l_exchange_type CE_FORECASTS.exchange_rate_type%TYPE;
855: l_exchange_date CE_FORECASTS.exchange_date%TYPE;
856: l_exchange_rate CE_FORECASTS.exchange_rate%TYPE;
857: l_src_curr_type CE_FORECASTS.currency_type%TYPE;
858: l_source_currency CE_FORECASTS.source_currency%TYPE;
859: l_rownum_from CE_FORECAST_ROWS.row_number%TYPE;
860: l_rownum_to CE_FORECAST_ROWS.row_number%TYPE;

Line 857: l_src_curr_type CE_FORECASTS.currency_type%TYPE;

853: l_forecast_currency CE_FORECASTS.forecast_currency%TYPE;
854: l_exchange_type CE_FORECASTS.exchange_rate_type%TYPE;
855: l_exchange_date CE_FORECASTS.exchange_date%TYPE;
856: l_exchange_rate CE_FORECASTS.exchange_rate%TYPE;
857: l_src_curr_type CE_FORECASTS.currency_type%TYPE;
858: l_source_currency CE_FORECASTS.source_currency%TYPE;
859: l_rownum_from CE_FORECAST_ROWS.row_number%TYPE;
860: l_rownum_to CE_FORECAST_ROWS.row_number%TYPE;
861: l_amount_threshold CE_FORECASTS.amount_threshold%TYPE;

Line 858: l_source_currency CE_FORECASTS.source_currency%TYPE;

854: l_exchange_type CE_FORECASTS.exchange_rate_type%TYPE;
855: l_exchange_date CE_FORECASTS.exchange_date%TYPE;
856: l_exchange_rate CE_FORECASTS.exchange_rate%TYPE;
857: l_src_curr_type CE_FORECASTS.currency_type%TYPE;
858: l_source_currency CE_FORECASTS.source_currency%TYPE;
859: l_rownum_from CE_FORECAST_ROWS.row_number%TYPE;
860: l_rownum_to CE_FORECAST_ROWS.row_number%TYPE;
861: l_amount_threshold CE_FORECASTS.amount_threshold%TYPE;
862: l_project_id CE_FORECASTS.project_id%TYPE;

Line 861: l_amount_threshold CE_FORECASTS.amount_threshold%TYPE;

857: l_src_curr_type CE_FORECASTS.currency_type%TYPE;
858: l_source_currency CE_FORECASTS.source_currency%TYPE;
859: l_rownum_from CE_FORECAST_ROWS.row_number%TYPE;
860: l_rownum_to CE_FORECAST_ROWS.row_number%TYPE;
861: l_amount_threshold CE_FORECASTS.amount_threshold%TYPE;
862: l_project_id CE_FORECASTS.project_id%TYPE;
863:
864: cnt_fc NUMBER;
865: fcount NUMBER;

Line 862: l_project_id CE_FORECASTS.project_id%TYPE;

858: l_source_currency CE_FORECASTS.source_currency%TYPE;
859: l_rownum_from CE_FORECAST_ROWS.row_number%TYPE;
860: l_rownum_to CE_FORECAST_ROWS.row_number%TYPE;
861: l_amount_threshold CE_FORECASTS.amount_threshold%TYPE;
862: l_project_id CE_FORECASTS.project_id%TYPE;
863:
864: cnt_fc NUMBER;
865: fcount NUMBER;
866: fid_rec C_fid%ROWTYPE;

Line 870: FROM ce_forecasts

866: fid_rec C_fid%ROWTYPE;
867: BEGIN
868: SELECT count(*)
869: INTO cnt_fc
870: FROM ce_forecasts
871: WHERE forecast_header_id = X_hid;
872:
873: FOR fid_rec IN C_fid(X_hid) LOOP
874:

Line 902: FROM ce_forecasts

898: l_src_curr_type,
899: l_source_currency,
900: l_amount_threshold,
901: l_project_id
902: FROM ce_forecasts
903: WHERE forecast_id = fid_rec.forecast_id;
904:
905: SELECT min(row_number),
906: max(row_number)

Line 952: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.recalc_glc');

948:
949: EXCEPTION
950: WHEN OTHERS THEN
951: IF (C_fid%ISOPEN) THEN CLOSE C_fid; END IF;
952: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.recalc_glc');
953: RAISE;
954: END recalc_glc;
955:
956:

Line 957: END CE_FORECASTS_PKG;

953: RAISE;
954: END recalc_glc;
955:
956:
957: END CE_FORECASTS_PKG;