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_COLUMNS_PKG dependencies on CE_FORECAST_COLUMNS

Line 1: PACKAGE BODY CE_FORECAST_COLUMNS_PKG AS

1: PACKAGE BODY CE_FORECAST_COLUMNS_PKG AS
2: /* $Header: cefcolb.pls 120.1 2002/11/12 21:19:39 bhchung ship $ */
3: --
4: -- Package
5: -- CE_FORECAST_COLUMNS_PKG

Line 5: -- CE_FORECAST_COLUMNS_PKG

1: PACKAGE BODY CE_FORECAST_COLUMNS_PKG AS
2: /* $Header: cefcolb.pls 120.1 2002/11/12 21:19:39 bhchung ship $ */
3: --
4: -- Package
5: -- CE_FORECAST_COLUMNS_PKG
6: -- Purpose
7: -- To group all the procedures/functions for table handling of the
8: -- ce_forecast_columns table.
9: -- History

Line 8: -- ce_forecast_columns table.

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

Line 34: -- CE_FORECAST_COLUMNS_PKG.Check_Unique(...)

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

Line 44: FROM ce_forecast_columns cfc

40: X_forecast_header_id NUMBER,
41: X_column_number NUMBER) IS
42: CURSOR chk_duplicates IS
43: SELECT 'Duplicate'
44: FROM ce_forecast_columns cfc
45: WHERE cfc.forecast_header_id = X_forecast_header_id
46: AND cfc.column_number = X_column_number
47: AND (X_rowid IS NULL
48: OR cfc.rowid <> chartorowid(X_rowid));

Line 77: -- CE_FORECAST_COLUMNS_PKG.Check_Unique_Aging(...)

73: -- Checks the uniqueness of the forecast agings inserted.
74: -- History
75: -- 07.10.96 C. Kawamoto Created
76: -- Example
77: -- CE_FORECAST_COLUMNS_PKG.Check_Unique_Aging(...)
78: -- Notes
79: --
80:
81: PROCEDURE Check_Unique_Aging(

Line 88: FROM ce_forecast_columns cfc

84: X_days_from NUMBER,
85: X_days_to NUMBER) IS
86: CURSOR chk_duplicate_agings IS
87: SELECT 'Duplicate'
88: FROM ce_forecast_columns cfc
89: WHERE cfc.forecast_header_id = X_forecast_header_id
90: AND cfc.days_from = X_days_from
91: AND cfc.days_to = X_days_to
92: AND (X_rowid IS NULL

Line 119: -- To insert new row to ce_forecast_columns.

115: --
116: -- Procedure
117: -- insert_row
118: -- Purpose
119: -- To insert new row to ce_forecast_columns.
120: -- History
121: -- 07.10.96 C. Kawamoto Created
122: -- Example
123: -- CE_FORECAST_COLUMNS_PKG.Insert_Row(...)

Line 123: -- CE_FORECAST_COLUMNS_PKG.Insert_Row(...)

119: -- To insert new row to ce_forecast_columns.
120: -- History
121: -- 07.10.96 C. Kawamoto Created
122: -- Example
123: -- CE_FORECAST_COLUMNS_PKG.Insert_Row(...)
124: -- Notes
125: --
126:
127: PROCEDURE Insert_Row(

Line 157: CURSOR C IS SELECT rowid FROM ce_forecast_columns

153: X_attribute13 VARCHAR2,
154: X_attribute14 VARCHAR2,
155: X_attribute15 VARCHAR2
156: ) IS
157: CURSOR C IS SELECT rowid FROM ce_forecast_columns
158: WHERE forecast_column_id = TO_NUMBER(X_forecast_column_id);
159: CURSOR C2 IS SELECT ce_forecast_columns_s.nextval FROM sys.dual;
160: BEGIN
161: OPEN C2;

Line 159: CURSOR C2 IS SELECT ce_forecast_columns_s.nextval FROM sys.dual;

155: X_attribute15 VARCHAR2
156: ) IS
157: CURSOR C IS SELECT rowid FROM ce_forecast_columns
158: WHERE forecast_column_id = TO_NUMBER(X_forecast_column_id);
159: CURSOR C2 IS SELECT ce_forecast_columns_s.nextval FROM sys.dual;
160: BEGIN
161: OPEN C2;
162: FETCH C2 INTO X_forecast_column_id;
163: CLOSE C2;

Line 165: INSERT INTO ce_forecast_columns(

161: OPEN C2;
162: FETCH C2 INTO X_forecast_column_id;
163: CLOSE C2;
164:
165: INSERT INTO ce_forecast_columns(
166: forecast_column_id,
167: forecast_header_id,
168: column_number,
169: days_from,

Line 234: -- To lock a row from ce_forecast_columns.

230: --
231: -- Procedure
232: -- lock_row
233: -- Purpose
234: -- To lock a row from ce_forecast_columns.
235: -- History
236: -- 07.10.96 C. Kawamoto Created
237: -- Example
238: -- CE_FORECAST_COLUMNS_PKG.Lock_Row(...)

Line 238: -- CE_FORECAST_COLUMNS_PKG.Lock_Row(...)

234: -- To lock a row from ce_forecast_columns.
235: -- History
236: -- 07.10.96 C. Kawamoto Created
237: -- Example
238: -- CE_FORECAST_COLUMNS_PKG.Lock_Row(...)
239: -- Notes
240: --
241:
242: PROCEDURE Lock_Row(

Line 274: FROM ce_forecast_columns

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

Line 356: -- To update ce_forecast_columns with changes made.

352: --
353: -- Procedure
354: -- Update_Row
355: -- Purpose
356: -- To update ce_forecast_columns with changes made.
357: -- History
358: -- 07.10.96 C. Kawamoto Created
359: -- Example
360: -- CE_FORECAST_COLUMNS_PKG.Update_Row(...);

Line 360: -- CE_FORECAST_COLUMNS_PKG.Update_Row(...);

356: -- To update ce_forecast_columns with changes made.
357: -- History
358: -- 07.10.96 C. Kawamoto Created
359: -- Example
360: -- CE_FORECAST_COLUMNS_PKG.Update_Row(...);
361: -- Notes
362: --
363: PROCEDURE Update_Row(
364: X_rowid VARCHAR2,

Line 394: UPDATE ce_forecast_columns

390: X_attribute14 VARCHAR2,
391: X_attribute15 VARCHAR2
392: ) IS
393: BEGIN
394: UPDATE ce_forecast_columns
395: SET
396: forecast_column_id = X_forecast_column_id,
397: forecast_header_id = X_forecast_header_id,
398: column_number = X_column_number,

Line 428: -- To delete a row from ce_forecast_columns.

424: --
425: -- Procedure
426: -- Delete_Row
427: -- Purpose
428: -- To delete a row from ce_forecast_columns.
429: -- History
430: -- 07.10.96 C. Kawamoto Created
431: -- Example
432: -- CE_FORECAST_COLUMNS_PKG.Delete_Row(...);

Line 432: -- CE_FORECAST_COLUMNS_PKG.Delete_Row(...);

428: -- To delete a row from ce_forecast_columns.
429: -- History
430: -- 07.10.96 C. Kawamoto Created
431: -- Example
432: -- CE_FORECAST_COLUMNS_PKG.Delete_Row(...);
433: -- Notes
434: --
435: PROCEDURE Delete_Row(X_rowid VARCHAR2) IS
436: BEGIN

Line 437: DELETE FROM ce_forecast_columns

433: -- Notes
434: --
435: PROCEDURE Delete_Row(X_rowid VARCHAR2) IS
436: BEGIN
437: DELETE FROM ce_forecast_columns
438: WHERE rowid = X_rowid;
439: if (SQL%NOTFOUND) then
440: Raise NO_DATA_FOUND;
441: end if;

Line 453: FROM CE_FORECAST_COLUMNS

449: -- delete all forecast cells that belong to the template column
450: --
451: SELECT forecast_header_id, forecast_column_id
452: INTO p_forecast_header_id, p_forecast_column_id
453: FROM CE_FORECAST_COLUMNS
454: WHERE rowid = X_rowid;
455:
456: DELETE FROM CE_FORECAST_CELLS
457: WHERE forecast_header_id = p_forecast_header_id AND

Line 463: END CE_FORECAST_COLUMNS_PKG;

459:
460: END Delete_Forecast_Cells;
461:
462:
463: END CE_FORECAST_COLUMNS_PKG;