APPS.GMO_INSTR_DEFN_PKG dependencies on GMO_INSTR_DEFN_B

Line 22: cursor C is select ROWID from GMO_INSTR_DEFN_B

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from GMO_INSTR_DEFN_B
23: where INSTRUCTION_ID = X_INSTRUCTION_ID
24: ;
25: begin
26: insert into GMO_INSTR_DEFN_B (

Line 26: insert into GMO_INSTR_DEFN_B (

22: cursor C is select ROWID from GMO_INSTR_DEFN_B
23: where INSTRUCTION_ID = X_INSTRUCTION_ID
24: ;
25: begin
26: insert into GMO_INSTR_DEFN_B (
27: INSTRUCTION_ID,
28: INSTRUCTION_SET_ID,
29: INSTR_SEQ,
30: TASK_ID,

Line 116: from GMO_INSTR_DEFN_B

112: TASK_ATTRIBUTE_ID,
113: TASK_ATTRIBUTE,
114: INSTR_ACKN_TYPE,
115: INSTR_NUMBER
116: from GMO_INSTR_DEFN_B
117: where INSTRUCTION_ID = X_INSTRUCTION_ID
118: for update of INSTRUCTION_ID nowait;
119: recinfo c%rowtype;
120:

Line 190: update GMO_INSTR_DEFN_B set

186: X_LAST_UPDATED_BY in NUMBER,
187: X_LAST_UPDATE_LOGIN in NUMBER
188: ) is
189: begin
190: update GMO_INSTR_DEFN_B set
191: INSTRUCTION_SET_ID = X_INSTRUCTION_SET_ID,
192: INSTR_SEQ = X_INSTR_SEQ,
193: TASK_ID = X_TASK_ID,
194: TASK_ATTRIBUTE_ID = X_TASK_ATTRIBUTE_ID,

Line 233: delete from GMO_INSTR_DEFN_B

229: if (sql%notfound) then
230: raise no_data_found;
231: end if;
232:
233: delete from GMO_INSTR_DEFN_B
234: where INSTRUCTION_ID = X_INSTRUCTION_ID;
235:
236: if (sql%notfound) then
237: raise no_data_found;

Line 247: from GMO_INSTR_DEFN_B B

243: begin
244: delete from GMO_INSTR_DEFN_TL T
245: where not exists
246: (select NULL
247: from GMO_INSTR_DEFN_B B
248: where B.INSTRUCTION_ID = T.INSTRUCTION_ID
249: );
250:
251: update GMO_INSTR_DEFN_TL T set (