APPS.FEM_FIN_ELEMS_PKG dependencies on FEM_FIN_ELEMS_B

Line 20: cursor C is select ROWID from FEM_FIN_ELEMS_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_FIN_ELEMS_B
21: where FINANCIAL_ELEM_ID = X_FINANCIAL_ELEM_ID
22: and VALUE_SET_ID = X_VALUE_SET_ID
23: ;
24: begin

Line 25: insert into FEM_FIN_ELEMS_B (

21: where FINANCIAL_ELEM_ID = X_FINANCIAL_ELEM_ID
22: and VALUE_SET_ID = X_VALUE_SET_ID
23: ;
24: begin
25: insert into FEM_FIN_ELEMS_B (
26: VALUE_SET_ID,
27: FINANCIAL_ELEM_DISPLAY_CODE,
28: ENABLED_FLAG,
29: READ_ONLY_FLAG,

Line 113: from FEM_FIN_ELEMS_B

109: ENABLED_FLAG,
110: READ_ONLY_FLAG,
111: OBJECT_VERSION_NUMBER,
112: PERSONAL_FLAG
113: from FEM_FIN_ELEMS_B
114: where FINANCIAL_ELEM_ID = X_FINANCIAL_ELEM_ID
115: and VALUE_SET_ID = X_VALUE_SET_ID
116: for update of FINANCIAL_ELEM_ID nowait;
117: recinfo c%rowtype;

Line 180: update FEM_FIN_ELEMS_B set

176: X_LAST_UPDATED_BY in NUMBER,
177: X_LAST_UPDATE_LOGIN in NUMBER
178: ) is
179: begin
180: update FEM_FIN_ELEMS_B set
181: FINANCIAL_ELEM_DISPLAY_CODE = X_FINANCIAL_ELEM_DISPLAY_CODE,
182: ENABLED_FLAG = X_ENABLED_FLAG,
183: READ_ONLY_FLAG = X_READ_ONLY_FLAG,
184: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 225: delete from FEM_FIN_ELEMS_B

221: if (sql%notfound) then
222: raise no_data_found;
223: end if;
224:
225: delete from FEM_FIN_ELEMS_B
226: where FINANCIAL_ELEM_ID = X_FINANCIAL_ELEM_ID
227: and VALUE_SET_ID = X_VALUE_SET_ID;
228:
229: if (sql%notfound) then

Line 240: from FEM_FIN_ELEMS_B B

236: begin
237: delete from FEM_FIN_ELEMS_TL T
238: where not exists
239: (select NULL
240: from FEM_FIN_ELEMS_B B
241: where B.FINANCIAL_ELEM_ID = T.FINANCIAL_ELEM_ID
242: and B.VALUE_SET_ID = T.VALUE_SET_ID
243: );
244: