APPS.FEM_DATASETS_PKG dependencies on FEM_DATASETS_B

Line 19: cursor C is select ROWID from FEM_DATASETS_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from FEM_DATASETS_B
20: where DATASET_CODE = X_DATASET_CODE
21: ;
22: begin
23: insert into FEM_DATASETS_B (

Line 23: insert into FEM_DATASETS_B (

19: cursor C is select ROWID from FEM_DATASETS_B
20: where DATASET_CODE = X_DATASET_CODE
21: ;
22: begin
23: insert into FEM_DATASETS_B (
24: DATASET_CODE,
25: ENABLED_FLAG,
26: DATASET_DISPLAY_CODE,
27: READ_ONLY_FLAG,

Line 105: from FEM_DATASETS_B

101: DATASET_DISPLAY_CODE,
102: READ_ONLY_FLAG,
103: PERSONAL_FLAG,
104: OBJECT_VERSION_NUMBER
105: from FEM_DATASETS_B
106: where DATASET_CODE = X_DATASET_CODE
107: for update of DATASET_CODE nowait;
108: recinfo c%rowtype;
109:

Line 171: update FEM_DATASETS_B set

167: X_LAST_UPDATED_BY in NUMBER,
168: X_LAST_UPDATE_LOGIN in NUMBER
169: ) is
170: begin
171: update FEM_DATASETS_B set
172: ENABLED_FLAG = X_ENABLED_FLAG,
173: DATASET_DISPLAY_CODE = X_DATASET_DISPLAY_CODE,
174: READ_ONLY_FLAG = X_READ_ONLY_FLAG,
175: PERSONAL_FLAG = X_PERSONAL_FLAG,

Line 212: delete from FEM_DATASETS_B

208: if (sql%notfound) then
209: raise no_data_found;
210: end if;
211:
212: delete from FEM_DATASETS_B
213: where DATASET_CODE = X_DATASET_CODE;
214:
215: if (sql%notfound) then
216: raise no_data_found;

Line 226: from FEM_DATASETS_B B

222: begin
223: delete from FEM_DATASETS_TL T
224: where not exists
225: (select NULL
226: from FEM_DATASETS_B B
227: where B.DATASET_CODE = T.DATASET_CODE
228: );
229:
230: update FEM_DATASETS_TL T set (