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_FORECAST_PERIODS_PKG dependencies on XTR_FORECAST_PERIODS

Line 1: PACKAGE BODY XTR_FORECAST_PERIODS_PKG AS

1: PACKAGE BODY XTR_FORECAST_PERIODS_PKG AS
2: /* $Header: xtrfprdb.pls 115.1 99/07/17 00:30:48 porting ship $ */
3: --
4: -- Package
5: -- XTR_FORECAST_PERIODS_PKG

Line 5: -- XTR_FORECAST_PERIODS_PKG

1: PACKAGE BODY XTR_FORECAST_PERIODS_PKG AS
2: /* $Header: xtrfprdb.pls 115.1 99/07/17 00:30:48 porting ship $ */
3: --
4: -- Package
5: -- XTR_FORECAST_PERIODS_PKG
6: -- Purpose
7: -- To group all the procedures/functions for table handling of the
8: -- xtr_forecast_periods table.
9: -- History

Line 8: -- xtr_forecast_periods table.

4: -- Package
5: -- XTR_FORECAST_PERIODS_PKG
6: -- Purpose
7: -- To group all the procedures/functions for table handling of the
8: -- xtr_forecast_periods table.
9: -- History
10: -- 12/24/98 BHCHUNG Created
11: --
12:

Line 22: -- XTR_FORECAST_PERIODS_PKG.Check_Unique(...)

18: -- Checks the uniqueness of the forecast period inserted.
19: -- History
20: -- 12/24/98 BHCHUNG Created
21: -- Example
22: -- XTR_FORECAST_PERIODS_PKG.Check_Unique(...)
23: -- Notes
24: --
25:
26: PROCEDURE Check_Unique(

Line 32: FROM xtr_forecast_periods cfc

28: X_forecast_header_id NUMBER,
29: X_period_number NUMBER) IS
30: CURSOR chk_duplicates IS
31: SELECT 'Duplicate'
32: FROM xtr_forecast_periods cfc
33: WHERE cfc.forecast_header_id = X_forecast_header_id
34: AND cfc.period_number = X_period_number
35: AND (X_rowid IS NULL
36: OR cfc.rowid <> chartorowid(X_rowid));

Line 61: -- To insert new row to xtr_forecast_periods.

57: --
58: -- Procedure
59: -- insert_row
60: -- Purpose
61: -- To insert new row to xtr_forecast_periods.
62: -- History
63: -- 12/24/98 BHCHUNG Created
64: -- Example
65: -- XTR_FORECAST_PERIODS_PKG.Insert_Row(...)

Line 65: -- XTR_FORECAST_PERIODS_PKG.Insert_Row(...)

61: -- To insert new row to xtr_forecast_periods.
62: -- History
63: -- 12/24/98 BHCHUNG Created
64: -- Example
65: -- XTR_FORECAST_PERIODS_PKG.Insert_Row(...)
66: -- Notes
67: --
68:
69: PROCEDURE Insert_Row(

Line 83: CURSOR C IS SELECT rowid FROM xtr_forecast_periods

79: X_last_updated_by NUMBER,
80: X_last_update_date DATE,
81: X_last_update_login NUMBER
82: ) IS
83: CURSOR C IS SELECT rowid FROM xtr_forecast_periods
84: WHERE forecast_period_id = TO_NUMBER(X_forecast_period_id);
85: CURSOR C2 IS SELECT ce_forecast_columns_s.nextval FROM sys.dual;
86:
87:

Line 93: INSERT INTO xtr_forecast_periods(

89: OPEN C2;
90: FETCH C2 INTO X_forecast_period_id;
91: CLOSE C2;
92:
93: INSERT INTO xtr_forecast_periods(
94: forecast_period_id,
95: forecast_header_id,
96: period_number,
97: level_of_summary,

Line 130: -- To lock a row from xtr_forecast_periods.

126: --
127: -- Procedure
128: -- lock_row
129: -- Purpose
130: -- To lock a row from xtr_forecast_periods.
131: -- History
132: -- 12/24/98 BHCHUNG Created
133: -- Example
134: -- XTR_FORECAST_PERIODS_PKG.Lock_Row(...)

Line 134: -- XTR_FORECAST_PERIODS_PKG.Lock_Row(...)

130: -- To lock a row from xtr_forecast_periods.
131: -- History
132: -- 12/24/98 BHCHUNG Created
133: -- Example
134: -- XTR_FORECAST_PERIODS_PKG.Lock_Row(...)
135: -- Notes
136: --
137:
138: PROCEDURE Lock_Row(

Line 154: FROM xtr_forecast_periods

150: X_last_update_login NUMBER
151: ) IS
152: CURSOR C IS
153: SELECT *
154: FROM xtr_forecast_periods
155: WHERE rowid = X_rowid
156: FOR UPDATE of forecast_period_id NOWAIT;
157: Recinfo C%ROWTYPE;
158: BEGIN

Line 186: -- To update xtr_forecast_periods with changes made.

182: --
183: -- Procedure
184: -- Update_Row
185: -- Purpose
186: -- To update xtr_forecast_periods with changes made.
187: -- History
188: -- 12/24/98 BHCHUNG Created
189: -- Example
190: -- XTR_FORECAST_PERIODS_PKG.Update_Row(...);

Line 190: -- XTR_FORECAST_PERIODS_PKG.Update_Row(...);

186: -- To update xtr_forecast_periods with changes made.
187: -- History
188: -- 12/24/98 BHCHUNG Created
189: -- Example
190: -- XTR_FORECAST_PERIODS_PKG.Update_Row(...);
191: -- Notes
192: --
193: PROCEDURE Update_Row(
194: X_rowid VARCHAR2,

Line 208: UPDATE xtr_forecast_periods

204: X_last_update_date DATE,
205: X_last_update_login NUMBER
206: ) IS
207: BEGIN
208: UPDATE xtr_forecast_periods
209: SET
210: forecast_period_id = X_forecast_period_id,
211: forecast_header_id = X_forecast_header_id,
212: period_number = X_period_number,

Line 226: -- To delete a row from xtr_forecast_periods.

222: --
223: -- Procedure
224: -- Delete_Row
225: -- Purpose
226: -- To delete a row from xtr_forecast_periods.
227: -- History
228: -- 12/24/98 BHCHUNG Created
229: -- Example
230: -- XTR_FORECAST_PERIODS_PKG.Delete_Row(...);

Line 230: -- XTR_FORECAST_PERIODS_PKG.Delete_Row(...);

226: -- To delete a row from xtr_forecast_periods.
227: -- History
228: -- 12/24/98 BHCHUNG Created
229: -- Example
230: -- XTR_FORECAST_PERIODS_PKG.Delete_Row(...);
231: -- Notes
232: --
233: PROCEDURE Delete_Row(X_rowid VARCHAR2) IS
234: BEGIN

Line 235: DELETE FROM xtr_forecast_periods

231: -- Notes
232: --
233: PROCEDURE Delete_Row(X_rowid VARCHAR2) IS
234: BEGIN
235: DELETE FROM xtr_forecast_periods
236: WHERE rowid = X_rowid;
237: if (SQL%NOTFOUND) then
238: Raise NO_DATA_FOUND;
239: end if;

Line 242: END XTR_FORECAST_PERIODS_PKG;

238: Raise NO_DATA_FOUND;
239: end if;
240: END Delete_Row;
241:
242: END XTR_FORECAST_PERIODS_PKG;
243: