19: X_LAST_UPDATE_DATE in DATE,
20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23: cursor C is select ROWID from GMO_INSTR_TASK_DEFN_B
24: where TASK_ID = X_TASK_ID
25: ;
26: begin
27: insert into GMO_INSTR_TASK_DEFN_B (
23: cursor C is select ROWID from GMO_INSTR_TASK_DEFN_B
24: where TASK_ID = X_TASK_ID
25: ;
26: begin
27: insert into GMO_INSTR_TASK_DEFN_B (
28: TASK_ID,
29: ENTITY_NAME,
30: INSTRUCTION_TYPE,
31: TASK_NAME,
118: ATTRIBUTE_SQL,
119: ATTRIBUTE_DISPLAY_COL_COUNT,
120: MAX_ALLOWED_TASK,
121: ENTITY_KEY_PATTERN
122: from GMO_INSTR_TASK_DEFN_B
123: where TASK_ID = X_TASK_ID
124: for update of TASK_ID nowait;
125: recinfo c%rowtype;
126:
190: X_LAST_UPDATED_BY in NUMBER,
191: X_LAST_UPDATE_LOGIN in NUMBER
192: ) is
193: begin
194: update GMO_INSTR_TASK_DEFN_B set
195: ENTITY_NAME = X_ENTITY_NAME,
196: INSTRUCTION_TYPE = X_INSTRUCTION_TYPE,
197: TASK_NAME = X_TASK_NAME,
198: TASK_TYPE = X_TASK_TYPE,
234: if (sql%notfound) then
235: raise no_data_found;
236: end if;
237:
238: delete from GMO_INSTR_TASK_DEFN_B
239: where TASK_ID = X_TASK_ID;
240:
241: if (sql%notfound) then
242: raise no_data_found;
248: begin
249: delete from GMO_INSTR_TASK_DEFN_TL T
250: where not exists
251: (select NULL
252: from GMO_INSTR_TASK_DEFN_B B
253: where B.TASK_ID = T.TASK_ID
254: );
255:
256: update GMO_INSTR_TASK_DEFN_TL T set (