APPS.FEM_BAL_SHEET_MODELS_PKG dependencies on FEM_BAL_SHEET_MODELS_B

Line 19: cursor C is select ROWID from FEM_BAL_SHEET_MODELS_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_BAL_SHEET_MODELS_B
20: where BAL_SHEET_MODEL_CODE = X_BAL_SHEET_MODEL_CODE
21: ;
22: begin
23: insert into FEM_BAL_SHEET_MODELS_B (

Line 23: insert into FEM_BAL_SHEET_MODELS_B (

19: cursor C is select ROWID from FEM_BAL_SHEET_MODELS_B
20: where BAL_SHEET_MODEL_CODE = X_BAL_SHEET_MODEL_CODE
21: ;
22: begin
23: insert into FEM_BAL_SHEET_MODELS_B (
24: BAL_SHEET_MODEL_CODE,
25: BAL_SHEET_CALC_TYPE_CODE,
26: BAL_SHEET_DEF_TYPE_CODE,
27: ENABLED_FLAG,

Line 105: from FEM_BAL_SHEET_MODELS_B

101: BAL_SHEET_DEF_TYPE_CODE,
102: ENABLED_FLAG,
103: READ_ONLY_FLAG,
104: PERSONAL_FLAG
105: from FEM_BAL_SHEET_MODELS_B
106: where BAL_SHEET_MODEL_CODE = X_BAL_SHEET_MODEL_CODE
107: for update of BAL_SHEET_MODEL_CODE nowait;
108: recinfo c%rowtype;
109:

Line 169: update FEM_BAL_SHEET_MODELS_B set

165: X_LAST_UPDATED_BY in NUMBER,
166: X_LAST_UPDATE_LOGIN in NUMBER
167: ) is
168: begin
169: update FEM_BAL_SHEET_MODELS_B set
170: BAL_SHEET_CALC_TYPE_CODE = X_BAL_SHEET_CALC_TYPE_CODE,
171: BAL_SHEET_DEF_TYPE_CODE = X_BAL_SHEET_DEF_TYPE_CODE,
172: ENABLED_FLAG = X_ENABLED_FLAG,
173: READ_ONLY_FLAG = X_READ_ONLY_FLAG,

Line 210: delete from FEM_BAL_SHEET_MODELS_B

206: if (sql%notfound) then
207: raise no_data_found;
208: end if;
209:
210: delete from FEM_BAL_SHEET_MODELS_B
211: where BAL_SHEET_MODEL_CODE = X_BAL_SHEET_MODEL_CODE;
212:
213: if (sql%notfound) then
214: raise no_data_found;

Line 224: from FEM_BAL_SHEET_MODELS_B B

220: begin
221: delete from FEM_BAL_SHEET_MODELS_TL T
222: where not exists
223: (select NULL
224: from FEM_BAL_SHEET_MODELS_B B
225: where B.BAL_SHEET_MODEL_CODE = T.BAL_SHEET_MODEL_CODE
226: );
227:
228: update FEM_BAL_SHEET_MODELS_TL T set (