APPS.FEM_FOLDERS_PKG dependencies on FEM_FOLDERS_B

Line 15: cursor C is select ROWID from FEM_FOLDERS_B

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from FEM_FOLDERS_B
16: where FOLDER_ID = X_FOLDER_ID
17: ;
18: begin
19: insert into FEM_FOLDERS_B (

Line 19: insert into FEM_FOLDERS_B (

15: cursor C is select ROWID from FEM_FOLDERS_B
16: where FOLDER_ID = X_FOLDER_ID
17: ;
18: begin
19: insert into FEM_FOLDERS_B (
20: OBJECT_VERSION_NUMBER,
21: FOLDER_ID,
22: CREATION_DATE,
23: CREATED_BY,

Line 85: from FEM_FOLDERS_B

81: X_DESCRIPTION in VARCHAR2
82: ) is
83: cursor c is select
84: OBJECT_VERSION_NUMBER
85: from FEM_FOLDERS_B
86: where FOLDER_ID = X_FOLDER_ID
87: for update of FOLDER_ID nowait;
88: recinfo c%rowtype;
89:

Line 141: update FEM_FOLDERS_B set

137: X_LAST_UPDATED_BY in NUMBER,
138: X_LAST_UPDATE_LOGIN in NUMBER
139: ) is
140: begin
141: update FEM_FOLDERS_B set
142: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
143: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
144: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
145: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 178: delete from FEM_FOLDERS_B

174: if (sql%notfound) then
175: raise no_data_found;
176: end if;
177:
178: delete from FEM_FOLDERS_B
179: where FOLDER_ID = X_FOLDER_ID;
180:
181: if (sql%notfound) then
182: raise no_data_found;

Line 192: from FEM_FOLDERS_B B

188: begin
189: delete from FEM_FOLDERS_TL T
190: where not exists
191: (select NULL
192: from FEM_FOLDERS_B B
193: where B.FOLDER_ID = T.FOLDER_ID
194: );
195:
196: update FEM_FOLDERS_TL T set (