APPS.CE_FORECAST_ROWS1_PKG dependencies on CE_FORECAST_ROWS

Line 1: PACKAGE BODY CE_FORECAST_ROWS1_PKG AS

1: PACKAGE BODY CE_FORECAST_ROWS1_PKG AS
2: /* $Header: cefrow1b.pls 120.1 2002/11/12 21:25:37 bhchung ship $ */
3: --
4: -- Package
5: -- CE_FORECAST_ROWS1_PKG

Line 5: -- CE_FORECAST_ROWS1_PKG

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

Line 8: -- ce_forecast_rows table.

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

Line 35: -- CE_FORECAST_ROWS1_PKG.Check_Unique(...)

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

Line 44: FROM ce_forecast_rows cfr

40: X_forecast_header_id NUMBER,
41: X_row_number NUMBER) IS
42: CURSOR chk_duplicates IS
43: SELECT 'Duplidate'
44: FROM ce_forecast_rows cfr
45: WHERE cfr.forecast_header_id = X_forecast_header_id
46: AND cfr.row_number = X_row_number
47: AND (X_rowid IS NULL
48: OR cfr.rowid <> chartorowid(X_rowid));

Line 72: -- To insert new row to ce_forecast_rows.

68: --
69: -- Procedure
70: -- insert_row
71: -- Purpose
72: -- To insert new row to ce_forecast_rows.
73: -- History
74: -- 07.10.96 C. Kawamoto Created
75: -- Example
76: -- CE_FORECAST_ROWS1_PKG.Insert_Row(...)

Line 76: -- CE_FORECAST_ROWS1_PKG.Insert_Row(...)

72: -- To insert new row to ce_forecast_rows.
73: -- History
74: -- 07.10.96 C. Kawamoto Created
75: -- Example
76: -- CE_FORECAST_ROWS1_PKG.Insert_Row(...)
77: -- Notes
78: --
79:
80: PROCEDURE Insert_Row(

Line 167: CURSOR C IS SELECT rowid FROM ce_forecast_rows

163: X_period NUMBER,
164: X_order_type_id NUMBER,
165: X_use_payment_terms VARCHAR2
166: ) IS
167: CURSOR C IS SELECT rowid FROM ce_forecast_rows
168: WHERE forecast_row_id = X_forecast_row_id;
169: CURSOR C2 IS SELECT ce_forecast_rows_s.nextval FROM sys.dual;
170:
171: BEGIN

Line 169: CURSOR C2 IS SELECT ce_forecast_rows_s.nextval FROM sys.dual;

165: X_use_payment_terms VARCHAR2
166: ) IS
167: CURSOR C IS SELECT rowid FROM ce_forecast_rows
168: WHERE forecast_row_id = X_forecast_row_id;
169: CURSOR C2 IS SELECT ce_forecast_rows_s.nextval FROM sys.dual;
170:
171: BEGIN
172: OPEN C2;
173: FETCH C2 INTO X_forecast_row_id;

Line 176: INSERT INTO ce_forecast_rows(

172: OPEN C2;
173: FETCH C2 INTO X_forecast_row_id;
174: CLOSE C2;
175:
176: INSERT INTO ce_forecast_rows(
177: forecast_row_id,
178: forecast_header_id,
179: row_number,
180: trx_type,

Line 359: -- To lock a row from ce_forecast_rows.

355: --
356: -- Procedure
357: -- lock_row
358: -- Purpose
359: -- To lock a row from ce_forecast_rows.
360: -- History
361: -- 07.10.96 C. Kawamoto Created
362: -- Example
363: -- CE_FORECAST_ROWS1_PKG.Lock_Row(...)

Line 363: -- CE_FORECAST_ROWS1_PKG.Lock_Row(...)

359: -- To lock a row from ce_forecast_rows.
360: -- History
361: -- 07.10.96 C. Kawamoto Created
362: -- Example
363: -- CE_FORECAST_ROWS1_PKG.Lock_Row(...)
364: -- Notes
365: --
366:
367: PROCEDURE Lock_Row(

Line 456: FROM ce_forecast_rows

452: X_use_payment_terms VARCHAR2
453: ) IS
454: CURSOR C IS
455: SELECT *
456: FROM ce_forecast_rows
457: WHERE rowid = X_rowid
458: FOR UPDATE of forecast_row_id NOWAIT;
459: Recinfo C%ROWTYPE;
460: BEGIN

Line 705: END CE_FORECAST_ROWS1_PKG;

701: end if;
702: END Lock_Row;
703:
704:
705: END CE_FORECAST_ROWS1_PKG;