APPS.GMO_INSTR_TASK_DEFN_PKG dependencies on GMO_INSTR_TASK_DEFN_B

Line 23: cursor C is select ROWID from GMO_INSTR_TASK_DEFN_B

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 (

Line 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,

Line 122: from GMO_INSTR_TASK_DEFN_B

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:

Line 194: update GMO_INSTR_TASK_DEFN_B set

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,

Line 238: delete from GMO_INSTR_TASK_DEFN_B

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;

Line 252: from GMO_INSTR_TASK_DEFN_B B

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 (