APPS.FEM_USER_DIM7_PKG dependencies on FEM_USER_DIM7_B

Line 21: cursor C is select ROWID from FEM_USER_DIM7_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_USER_DIM7_B
22: where USER_DIM7_ID = X_USER_DIM7_ID
23: and VALUE_SET_ID = X_VALUE_SET_ID
24: ;
25: begin

Line 26: insert into FEM_USER_DIM7_B (

22: where USER_DIM7_ID = X_USER_DIM7_ID
23: and VALUE_SET_ID = X_VALUE_SET_ID
24: ;
25: begin
26: insert into FEM_USER_DIM7_B (
27: USER_DIM7_DISPLAY_CODE,
28: ENABLED_FLAG,
29: PERSONAL_FLAG,
30: OBJECT_VERSION_NUMBER,

Line 118: from FEM_USER_DIM7_B

114: PERSONAL_FLAG,
115: OBJECT_VERSION_NUMBER,
116: READ_ONLY_FLAG,
117: DIMENSION_GROUP_ID
118: from FEM_USER_DIM7_B
119: where USER_DIM7_ID = X_USER_DIM7_ID
120: and VALUE_SET_ID = X_VALUE_SET_ID
121: for update of USER_DIM7_ID nowait;
122: recinfo c%rowtype;

Line 188: update FEM_USER_DIM7_B set

184: X_LAST_UPDATED_BY in NUMBER,
185: X_LAST_UPDATE_LOGIN in NUMBER
186: ) is
187: begin
188: update FEM_USER_DIM7_B set
189: USER_DIM7_DISPLAY_CODE = X_USER_DIM7_DISPLAY_CODE,
190: ENABLED_FLAG = X_ENABLED_FLAG,
191: PERSONAL_FLAG = X_PERSONAL_FLAG,
192: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 234: delete from FEM_USER_DIM7_B

230: if (sql%notfound) then
231: raise no_data_found;
232: end if;
233:
234: delete from FEM_USER_DIM7_B
235: where USER_DIM7_ID = X_USER_DIM7_ID
236: and VALUE_SET_ID = X_VALUE_SET_ID;
237:
238: if (sql%notfound) then

Line 249: from FEM_USER_DIM7_B B

245: begin
246: delete from FEM_USER_DIM7_TL T
247: where not exists
248: (select NULL
249: from FEM_USER_DIM7_B B
250: where B.USER_DIM7_ID = T.USER_DIM7_ID
251: and B.VALUE_SET_ID = T.VALUE_SET_ID
252: );
253: