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_FORECAST_HEADERS_PKG dependencies on CE_FORECAST_HEADERS

Line 1: PACKAGE BODY CE_FORECAST_HEADERS_PKG AS

1: PACKAGE BODY CE_FORECAST_HEADERS_PKG AS
2: /* $Header: cefhdrb.pls 120.1 2002/11/12 21:23:33 bhchung ship $ */
3: --
4: -- Package
5: -- CE_FORECASTT_HEADERS_PKG

Line 8: -- ce_forecast_headers table.

4: -- Package
5: -- CE_FORECASTT_HEADERS_PKG
6: -- Purpose
7: -- To group all the procedures/functions for table handling of the
8: -- ce_forecast_headers table.
9: -- History
10: -- 07.10.96 C. Kawamoto Created
11: --
12:

Line 34: -- CE_FORECAST_HEADERS_PKG.Check_Unique(...);

30: -- Checks the uniqueness of the forecast inserted.
31: -- History
32: -- 07.10.96 C. Kawamoto Created
33: -- Example
34: -- CE_FORECAST_HEADERS_PKG.Check_Unique(...);
35: -- Notes
36: --
37: PROCEDURE Check_Unique(
38: X_rowid VARCHAR2,

Line 42: FROM ce_forecast_headers cfh

38: X_rowid VARCHAR2,
39: X_name VARCHAR2) IS
40: CURSOR chk_duplicates IS
41: SELECT 'Duplidate'
42: FROM ce_forecast_headers cfh
43: WHERE cfh.name = X_name
44: AND (X_rowid IS NULL
45: OR cfh.rowid <> chartorowid(X_rowid));
46: dummy VARCHAR2(100);

Line 69: -- To insert new row to ce_forecast_headers.

65: --
66: -- Procedure
67: -- insert_row
68: -- Purpose
69: -- To insert new row to ce_forecast_headers.
70: -- History
71: -- 07.10.96 C. Kawamoto Created
72: -- Example
73: -- CE_FORECAST_HEADERS_PKG.Insert_Row(...)

Line 73: -- CE_FORECAST_HEADERS_PKG.Insert_Row(...)

69: -- To insert new row to ce_forecast_headers.
70: -- History
71: -- 07.10.96 C. Kawamoto Created
72: -- Example
73: -- CE_FORECAST_HEADERS_PKG.Insert_Row(...)
74: -- Notes
75: --
76:
77: PROCEDURE Insert_Row(

Line 111: CURSOR C IS SELECT rowid FROM ce_forecast_headers

107: X_attribute13 VARCHAR2,
108: X_attribute14 VARCHAR2,
109: X_attribute15 VARCHAR2
110: ) IS
111: CURSOR C IS SELECT rowid FROM ce_forecast_headers
112: WHERE forecast_header_id = X_forecast_header_id;
113: CURSOR C2 IS SELECT ce_forecast_headers_s.nextval FROM sys.dual;
114: p_row_id VARCHAR2(100);
115: p_forecast_column_id NUMBER;

Line 113: CURSOR C2 IS SELECT ce_forecast_headers_s.nextval FROM sys.dual;

109: X_attribute15 VARCHAR2
110: ) IS
111: CURSOR C IS SELECT rowid FROM ce_forecast_headers
112: WHERE forecast_header_id = X_forecast_header_id;
113: CURSOR C2 IS SELECT ce_forecast_headers_s.nextval FROM sys.dual;
114: p_row_id VARCHAR2(100);
115: p_forecast_column_id NUMBER;
116:
117: BEGIN

Line 122: INSERT INTO ce_forecast_headers(

118: OPEN C2;
119: FETCH C2 INTO X_forecast_header_id;
120: CLOSE C2;
121:
122: INSERT INTO ce_forecast_headers(
123: forecast_header_id,
124: name,
125: description,
126: aging_type,

Line 232: -- To lock a row from ce_forecast_headers.

228: --
229: -- Procedure
230: -- lock_row
231: -- Purpose
232: -- To lock a row from ce_forecast_headers.
233: -- History
234: -- 07.10.96 C. Kawamoto Created
235: -- Example
236: -- CE_FORECAST_HEADERS_PKG.Lock_Row(...)

Line 236: -- CE_FORECAST_HEADERS_PKG.Lock_Row(...)

232: -- To lock a row from ce_forecast_headers.
233: -- History
234: -- 07.10.96 C. Kawamoto Created
235: -- Example
236: -- CE_FORECAST_HEADERS_PKG.Lock_Row(...)
237: -- Notes
238: --
239:
240: PROCEDURE Lock_Row(

Line 275: FROM ce_forecast_headers

271: X_attribute15 VARCHAR2
272: ) IS
273: CURSOR C IS
274: SELECT *
275: FROM ce_forecast_headers
276: WHERE rowid = X_rowid
277: FOR UPDATE of forecast_header_id NOWAIT;
278: Recinfo C%ROWTYPE;
279: BEGIN

Line 370: -- To update ce_forecast_headers with changes made.

366: --
367: -- Procedure
368: -- Update_Row
369: -- Purpose
370: -- To update ce_forecast_headers with changes made.
371: -- History
372: -- 07.10.96 C. Kawamoto Created
373: -- 07.22.97 W. Chan Add logic for overdue_transaction and
374: -- cutoff_period update

Line 376: -- CE_FORECAST_HEADERS_PKG.Update_Row(...);

372: -- 07.10.96 C. Kawamoto Created
373: -- 07.22.97 W. Chan Add logic for overdue_transaction and
374: -- cutoff_period update
375: -- Example
376: -- CE_FORECAST_HEADERS_PKG.Update_Row(...);
377: -- Notes
378: --
379: PROCEDURE Update_Row(
380: X_rowid VARCHAR2,

Line 420: FROM CE_FORECAST_HEADERS

416: BEGIN
417:
418: SELECT overdue_transactions, cutoff_period
419: INTO p_overdue_transactions, p_cutoff_period
420: FROM CE_FORECAST_HEADERS
421: WHERE rowid = X_rowid;
422:
423: UPDATE ce_forecast_headers
424: SET

Line 423: UPDATE ce_forecast_headers

419: INTO p_overdue_transactions, p_cutoff_period
420: FROM CE_FORECAST_HEADERS
421: WHERE rowid = X_rowid;
422:
423: UPDATE ce_forecast_headers
424: SET
425: forecast_header_id = X_forecast_header_id,
426: name = X_name,
427: description = X_description,

Line 526: -- To delete a row from ce_forecast_headers.

522: --
523: -- Procedure
524: -- Delete_Row
525: -- Purpose
526: -- To delete a row from ce_forecast_headers.
527: -- History
528: -- 07.10.96 C. Kawamoto Created
529: -- Example
530: -- CE_FORECAST_HEADERS_PKG.Delete_Row(...);

Line 530: -- CE_FORECAST_HEADERS_PKG.Delete_Row(...);

526: -- To delete a row from ce_forecast_headers.
527: -- History
528: -- 07.10.96 C. Kawamoto Created
529: -- Example
530: -- CE_FORECAST_HEADERS_PKG.Delete_Row(...);
531: -- Notes
532: --
533: PROCEDURE Delete_Row(X_rowid VARCHAR2) IS
534: p_forecast_header_id NUMBER;

Line 541: FROM CE_FORECAST_HEADERS

537: -- delete all rows, columns, and headers for template
538: --
539: SELECT forecast_header_id
540: INTO p_forecast_header_id
541: FROM CE_FORECAST_HEADERS
542: WHERE rowid = X_rowid;
543:
544: DELETE FROM CE_FORECAST_ROWS
545: WHERE forecast_header_id = p_forecast_header_id;

Line 550: DELETE FROM ce_forecast_headers

546:
547: DELETE FROM CE_FORECAST_COLUMNS
548: WHERE forecast_header_id = p_forecast_header_id;
549:
550: DELETE FROM ce_forecast_headers
551: WHERE rowid = X_rowid;
552: if (SQL%NOTFOUND) then
553: Raise NO_DATA_FOUND;
554: end if;

Line 565: FROM CE_FORECAST_HEADERS

561: -- delete all forecasts and cells that belong to the template
562: --
563: SELECT forecast_header_id
564: INTO p_forecast_header_id
565: FROM CE_FORECAST_HEADERS
566: WHERE rowid = X_rowid;
567:
568: DELETE FROM CE_FORECAST_CELLS
569: WHERE forecast_header_id = p_forecast_header_id;

Line 576: END CE_FORECAST_HEADERS_PKG;

572: WHERE forecast_header_id = p_forecast_header_id;
573:
574: END Delete_Forecasts;
575:
576: END CE_FORECAST_HEADERS_PKG;