APPS.FEM_VALUE_SETS_PKG dependencies on FEM_VALUE_SETS_B

Line 21: cursor C is select ROWID from FEM_VALUE_SETS_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_VALUE_SETS_B
22: where VALUE_SET_ID = X_VALUE_SET_ID
23: ;
24: begin
25: insert into FEM_VALUE_SETS_B (

Line 25: insert into FEM_VALUE_SETS_B (

21: cursor C is select ROWID from FEM_VALUE_SETS_B
22: where VALUE_SET_ID = X_VALUE_SET_ID
23: ;
24: begin
25: insert into FEM_VALUE_SETS_B (
26: DEFAULT_LOAD_MEMBER_ID,
27: VALUE_SET_ID,
28: DEFAULT_MEMBER_ID,
29: OBJECT_VERSION_NUMBER,

Line 115: from FEM_VALUE_SETS_B

111: DEFAULT_HIERARCHY_OBJ_ID,
112: READ_ONLY_FLAG,
113: VALUE_SET_DISPLAY_CODE,
114: DIMENSION_ID
115: from FEM_VALUE_SETS_B
116: where VALUE_SET_ID = X_VALUE_SET_ID
117: for update of VALUE_SET_ID nowait;
118: recinfo c%rowtype;
119:

Line 186: update FEM_VALUE_SETS_B set

182: X_LAST_UPDATED_BY in NUMBER,
183: X_LAST_UPDATE_LOGIN in NUMBER
184: ) is
185: begin
186: update FEM_VALUE_SETS_B set
187: DEFAULT_LOAD_MEMBER_ID = X_DEFAULT_LOAD_MEMBER_ID,
188: DEFAULT_MEMBER_ID = X_DEFAULT_MEMBER_ID,
189: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
190: DEFAULT_HIERARCHY_OBJ_ID = X_DEFAULT_HIERARCHY_OBJ_ID,

Line 229: delete from FEM_VALUE_SETS_B

225: if (sql%notfound) then
226: raise no_data_found;
227: end if;
228:
229: delete from FEM_VALUE_SETS_B
230: where VALUE_SET_ID = X_VALUE_SET_ID;
231:
232: if (sql%notfound) then
233: raise no_data_found;

Line 243: from FEM_VALUE_SETS_B B

239: begin
240: delete from FEM_VALUE_SETS_TL T
241: where not exists
242: (select NULL
243: from FEM_VALUE_SETS_B B
244: where B.VALUE_SET_ID = T.VALUE_SET_ID
245: );
246:
247: update FEM_VALUE_SETS_TL T set (