APPS.FEM_TABLES_PKG dependencies on FEM_TABLES_B

Line 23: cursor C is select ROWID from FEM_TABLES_B

19: X_LAST_UPDATE_DATE in DATE,
20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23: cursor C is select ROWID from FEM_TABLES_B
24: where TABLE_NAME = X_TABLE_NAME
25: ;
26: begin
27: insert into FEM_TABLES_B (

Line 27: insert into FEM_TABLES_B (

23: cursor C is select ROWID from FEM_TABLES_B
24: where TABLE_NAME = X_TABLE_NAME
25: ;
26: begin
27: insert into FEM_TABLES_B (
28: PROC_KEY_INDEX_OWNER,
29: DI_VIEW_NAME,
30: REGISTRATION_STATUS_CODE,
31: INTERFACE_TABLE_NAME,

Line 125: from FEM_TABLES_B

121: TABLE_OWNER_APPLICATION_ID,
122: TABLE_ID,
123: ENABLED_FLAG,
124: OBJECT_VERSION_NUMBER
125: from FEM_TABLES_B
126: where TABLE_NAME = X_TABLE_NAME
127: for update of TABLE_NAME nowait;
128: recinfo c%rowtype;
129:

Line 202: update FEM_TABLES_B set

198: X_LAST_UPDATED_BY in NUMBER,
199: X_LAST_UPDATE_LOGIN in NUMBER
200: ) is
201: begin
202: update FEM_TABLES_B set
203: PROC_KEY_INDEX_OWNER = X_PROC_KEY_INDEX_OWNER,
204: DI_VIEW_NAME = X_DI_VIEW_NAME,
205: REGISTRATION_STATUS_CODE = X_REGISTRATION_STATUS_CODE,
206: INTERFACE_TABLE_NAME = X_INTERFACE_TABLE_NAME,

Line 247: delete from FEM_TABLES_B

243: if (sql%notfound) then
244: raise no_data_found;
245: end if;
246:
247: delete from FEM_TABLES_B
248: where TABLE_NAME = X_TABLE_NAME;
249:
250: if (sql%notfound) then
251: raise no_data_found;

Line 261: from FEM_TABLES_B B

257: begin
258: delete from FEM_TABLES_TL T
259: where not exists
260: (select NULL
261: from FEM_TABLES_B B
262: where B.TABLE_NAME = T.TABLE_NAME
263: );
264:
265: update FEM_TABLES_TL T set (