APPS.CE_FC_EXT_VIEWS_TABLE_PKG dependencies on CE_FORECAST_EXT_VIEWS

Line 27: FROM CE_FORECAST_EXT_VIEWS

23: X_last_updated_by NUMBER,
24: X_last_update_date DATE,
25: X_last_update_login NUMBER) IS
26: CURSOR C1 IS SELECT rowid
27: FROM CE_FORECAST_EXT_VIEWS
28: WHERE external_source_type = X_external_source_type;
29:
30: BEGIN
31: INSERT INTO CE_FORECAST_EXT_VIEWS (

Line 31: INSERT INTO CE_FORECAST_EXT_VIEWS (

27: FROM CE_FORECAST_EXT_VIEWS
28: WHERE external_source_type = X_external_source_type;
29:
30: BEGIN
31: INSERT INTO CE_FORECAST_EXT_VIEWS (
32: external_source_type,
33: external_source_view,
34: db_link_name,
35: created_by,

Line 70: UPDATE CE_FORECAST_EXT_VIEWS

66: X_last_updated_by NUMBER,
67: X_last_update_date DATE,
68: X_last_update_login NUMBER) IS
69: BEGIN
70: UPDATE CE_FORECAST_EXT_VIEWS
71: SET
72: external_source_type = X_external_source_type,
73: external_source_view = X_external_source_view,
74: db_link_name = X_db_link_name,

Line 91: DELETE FROM CE_FORECAST_EXT_VIEWS

87: PROCEDURE Delete_Row( X_rowid VARCHAR2) IS
88:
89: BEGIN
90:
91: DELETE FROM CE_FORECAST_EXT_VIEWS
92: WHERE rowid = X_rowid;
93:
94: IF (SQL%NOTFOUND) THEN
95: RAISE NO_DATA_FOUND;

Line 109: FROM CE_FORECAST_EXT_VIEWS

105: X_last_updated_by NUMBER,
106: X_last_update_date DATE,
107: X_last_update_login NUMBER) IS
108: CURSOR C IS SELECT *
109: FROM CE_FORECAST_EXT_VIEWS
110: WHERE rowid = X_rowid
111: FOR UPDATE OF external_source_type NOWAIT;
112:
113: Recinfo C%ROWTYPE;

Line 149: FROM ce_forecast_ext_views cesv

145: X_external_source_type VARCHAR2,
146: X_rowid VARCHAR2) IS
147: CURSOR chk_duplicates IS
148: SELECT 'founddup'
149: FROM ce_forecast_ext_views cesv
150: WHERE cesv.external_source_type = X_external_source_type
151: AND (X_rowid IS NULL
152: OR cesv.rowid <> chartorowid(X_rowid));
153: dummy VARCHAR2(100);