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 IEC_G_REP_CONF_PARAMS_B
16: where PARAM_ID = X_PARAM_ID
17: ;
18: begin
19: x_rowid := NULL;
17: ;
18: begin
19: x_rowid := NULL;
20:
21: insert into IEC_G_REP_CONF_PARAMS_B (
22: PARAM_ID,
23: OBJECT_VERSION_NUMBER,
24: CREATION_DATE,
25: CREATED_BY,
82: X_PARAM_NAME in VARCHAR2
83: ) is
84: cursor c is select
85: OBJECT_VERSION_NUMBER
86: from IEC_G_REP_CONF_PARAMS_B
87: where PARAM_ID = X_PARAM_ID
88: for update of PARAM_ID nowait;
89: recinfo c%rowtype;
90:
134: X_LAST_UPDATED_BY in NUMBER,
135: X_LAST_UPDATE_LOGIN in NUMBER
136: ) is
137: begin
138: update IEC_G_REP_CONF_PARAMS_B set
139: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
140: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
141: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
142: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
170: if (sql%notfound) then
171: raise no_data_found;
172: end if;
173:
174: delete from IEC_G_REP_CONF_PARAMS_B
175: where PARAM_ID = X_PARAM_ID;
176:
177: if (sql%notfound) then
178: raise no_data_found;
184: begin
185: delete from IEC_G_REP_CONF_PARAMS_TL T
186: where not exists
187: (select NULL
188: from IEC_G_REP_CONF_PARAMS_B B
189: where B.PARAM_ID = T.PARAM_ID
190: );
191:
192: update IEC_G_REP_CONF_PARAMS_TL T set (