APPS.FEM_DIM_ATTR_VERSIONS_PKG dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 20: cursor C is select ROWID from FEM_DIM_ATTR_VERSIONS_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from FEM_DIM_ATTR_VERSIONS_B
21: where VERSION_ID = X_VERSION_ID
22: ;
23: begin
24: insert into FEM_DIM_ATTR_VERSIONS_B (

Line 24: insert into FEM_DIM_ATTR_VERSIONS_B (

20: cursor C is select ROWID from FEM_DIM_ATTR_VERSIONS_B
21: where VERSION_ID = X_VERSION_ID
22: ;
23: begin
24: insert into FEM_DIM_ATTR_VERSIONS_B (
25: VERSION_ID,
26: ATTRIBUTE_ID,
27: AW_SNAPSHOT_FLAG,
28: VERSION_DISPLAY_CODE,

Line 110: from FEM_DIM_ATTR_VERSIONS_B

106: VERSION_DISPLAY_CODE,
107: OBJECT_VERSION_NUMBER,
108: DEFAULT_VERSION_FLAG,
109: PERSONAL_FLAG
110: from FEM_DIM_ATTR_VERSIONS_B
111: where VERSION_ID = X_VERSION_ID
112: for update of VERSION_ID nowait;
113: recinfo c%rowtype;
114:

Line 176: update FEM_DIM_ATTR_VERSIONS_B set

172: X_LAST_UPDATED_BY in NUMBER,
173: X_LAST_UPDATE_LOGIN in NUMBER
174: ) is
175: begin
176: update FEM_DIM_ATTR_VERSIONS_B set
177: ATTRIBUTE_ID = X_ATTRIBUTE_ID,
178: AW_SNAPSHOT_FLAG = X_AW_SNAPSHOT_FLAG,
179: VERSION_DISPLAY_CODE = X_VERSION_DISPLAY_CODE,
180: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 218: delete from FEM_DIM_ATTR_VERSIONS_B

214: if (sql%notfound) then
215: raise no_data_found;
216: end if;
217:
218: delete from FEM_DIM_ATTR_VERSIONS_B
219: where VERSION_ID = X_VERSION_ID;
220:
221: if (sql%notfound) then
222: raise no_data_found;

Line 232: from FEM_DIM_ATTR_VERSIONS_B B

228: begin
229: delete from FEM_DIM_ATTR_VERSIONS_TL T
230: where not exists
231: (select NULL
232: from FEM_DIM_ATTR_VERSIONS_B B
233: where B.VERSION_ID = T.VERSION_ID
234: );
235:
236: update FEM_DIM_ATTR_VERSIONS_TL T set (