APPS.FEM_DIMENSIONS_PKG dependencies on FEM_DIMENSIONS_B

Line 17: cursor C is select ROWID from FEM_DIMENSIONS_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from FEM_DIMENSIONS_B
18: where DIMENSION_ID = X_DIMENSION_ID
19: ;
20: begin
21: insert into FEM_DIMENSIONS_B (

Line 21: insert into FEM_DIMENSIONS_B (

17: cursor C is select ROWID from FEM_DIMENSIONS_B
18: where DIMENSION_ID = X_DIMENSION_ID
19: ;
20: begin
21: insert into FEM_DIMENSIONS_B (
22: OBJECT_VERSION_NUMBER,
23: DIMENSION_ID,
24: DIMENSION_VARCHAR_LABEL,
25: DIM_OWNER_APPLICATION_ID,

Line 95: from FEM_DIMENSIONS_B

91: cursor c is select
92: OBJECT_VERSION_NUMBER,
93: DIMENSION_VARCHAR_LABEL,
94: DIM_OWNER_APPLICATION_ID
95: from FEM_DIMENSIONS_B
96: where DIMENSION_ID = X_DIMENSION_ID
97: for update of DIMENSION_ID nowait;
98: recinfo c%rowtype;
99:

Line 155: update FEM_DIMENSIONS_B set

151: X_LAST_UPDATED_BY in NUMBER,
152: X_LAST_UPDATE_LOGIN in NUMBER
153: ) is
154: begin
155: update FEM_DIMENSIONS_B set
156: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
157: DIMENSION_VARCHAR_LABEL = X_DIMENSION_VARCHAR_LABEL,
158: DIM_OWNER_APPLICATION_ID = X_DIM_OWNER_APPLICATION_ID,
159: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 194: delete from FEM_DIMENSIONS_B

190: if (sql%notfound) then
191: raise no_data_found;
192: end if;
193:
194: delete from FEM_DIMENSIONS_B
195: where DIMENSION_ID = X_DIMENSION_ID;
196:
197: if (sql%notfound) then
198: raise no_data_found;

Line 208: from FEM_DIMENSIONS_B B

204: begin
205: delete from FEM_DIMENSIONS_TL T
206: where not exists
207: (select NULL
208: from FEM_DIMENSIONS_B B
209: where B.DIMENSION_ID = T.DIMENSION_ID
210: );
211:
212: update FEM_DIMENSIONS_TL T set (