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_PKG

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 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 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 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 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;