APPS.FEM_TAB_COLUMNS_PKG dependencies on FEM_TAB_COLUMNS_B

Line 21: cursor C is select ROWID from FEM_TAB_COLUMNS_B

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from FEM_TAB_COLUMNS_B
22: where TABLE_NAME = X_TABLE_NAME
23: and COLUMN_NAME = X_COLUMN_NAME
24: ;
25: begin

Line 26: insert into FEM_TAB_COLUMNS_B (

22: where TABLE_NAME = X_TABLE_NAME
23: and COLUMN_NAME = X_COLUMN_NAME
24: ;
25: begin
26: insert into FEM_TAB_COLUMNS_B (
27: ENABLED_FLAG,
28: INTERFACE_COLUMN_NAME,
29: TABLE_NAME,
30: COLUMN_NAME,

Line 118: from FEM_TAB_COLUMNS_B

114: FEM_DATA_TYPE_CODE,
115: DIMENSION_ID,
116: UOM_COLUMN_NAME,
117: OBJECT_VERSION_NUMBER
118: from FEM_TAB_COLUMNS_B
119: where TABLE_NAME = X_TABLE_NAME
120: and COLUMN_NAME = X_COLUMN_NAME
121: for update of TABLE_NAME nowait;
122: recinfo c%rowtype;

Line 189: update FEM_TAB_COLUMNS_B set

185: X_LAST_UPDATED_BY in NUMBER,
186: X_LAST_UPDATE_LOGIN in NUMBER
187: ) is
188: begin
189: update FEM_TAB_COLUMNS_B set
190: ENABLED_FLAG = X_ENABLED_FLAG,
191: INTERFACE_COLUMN_NAME = X_INTERFACE_COLUMN_NAME,
192: FEM_DATA_TYPE_CODE = X_FEM_DATA_TYPE_CODE,
193: DIMENSION_ID = X_DIMENSION_ID,

Line 235: delete from FEM_TAB_COLUMNS_B

231: if (sql%notfound) then
232: raise no_data_found;
233: end if;
234:
235: delete from FEM_TAB_COLUMNS_B
236: where TABLE_NAME = X_TABLE_NAME
237: and COLUMN_NAME = X_COLUMN_NAME;
238:
239: if (sql%notfound) then

Line 250: from FEM_TAB_COLUMNS_B B

246: begin
247: delete from FEM_TAB_COLUMNS_TL T
248: where not exists
249: (select NULL
250: from FEM_TAB_COLUMNS_B B
251: where B.TABLE_NAME = T.TABLE_NAME
252: and B.COLUMN_NAME = T.COLUMN_NAME
253: );
254: