APPS.FEM_OBJECT_DEFINITION_PKG dependencies on FEM_OBJECT_DEFINITION_B

Line 24: cursor C is select ROWID from FEM_OBJECT_DEFINITION_B

20: X_LAST_UPDATE_DATE in DATE,
21: X_LAST_UPDATED_BY in NUMBER,
22: X_LAST_UPDATE_LOGIN in NUMBER
23: ) is
24: cursor C is select ROWID from FEM_OBJECT_DEFINITION_B
25: where OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
26: ;
27: begin
28: insert into FEM_OBJECT_DEFINITION_B (

Line 28: insert into FEM_OBJECT_DEFINITION_B (

24: cursor C is select ROWID from FEM_OBJECT_DEFINITION_B
25: where OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
26: ;
27: begin
28: insert into FEM_OBJECT_DEFINITION_B (
29: OBJECT_VERSION_NUMBER,
30: OBJECT_DEFINITION_ID,
31: OBJECT_ID,
32: EFFECTIVE_START_DATE,

Line 134: from FEM_OBJECT_DEFINITION_B

130: OLD_APPROVED_COPY_FLAG,
131: OLD_APPROVED_COPY_OBJ_DEF_ID,
132: APPROVED_BY,
133: APPROVAL_DATE
134: from FEM_OBJECT_DEFINITION_B
135: where OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
136: for update of OBJECT_DEFINITION_ID nowait;
137: recinfo c%rowtype;
138:

Line 211: update FEM_OBJECT_DEFINITION_B set

207: X_LAST_UPDATED_BY in NUMBER,
208: X_LAST_UPDATE_LOGIN in NUMBER
209: ) is
210: begin
211: update FEM_OBJECT_DEFINITION_B set
212: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
213: OBJECT_ID = X_OBJECT_ID,
214: EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE,
215: EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE,

Line 257: delete from FEM_OBJECT_DEFINITION_B

253: if (sql%notfound) then
254: raise no_data_found;
255: end if;
256:
257: delete from FEM_OBJECT_DEFINITION_B
258: where OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID;
259:
260: if (sql%notfound) then
261: raise no_data_found;

Line 271: from FEM_OBJECT_DEFINITION_B B

267: begin
268: delete from FEM_OBJECT_DEFINITION_TL T
269: where not exists
270: (select NULL
271: from FEM_OBJECT_DEFINITION_B B
272: where B.OBJECT_DEFINITION_ID = T.OBJECT_DEFINITION_ID
273: );
274:
275: update FEM_OBJECT_DEFINITION_TL T set (