APPS.GMO_INSTR_SET_DEFN_PKG dependencies on GMO_INSTR_SET_DEFN_B

Line 20: cursor C is select ROWID from GMO_INSTR_SET_DEFN_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from GMO_INSTR_SET_DEFN_B
21: where INSTRUCTION_SET_ID = X_INSTRUCTION_SET_ID
22: ;
23: begin
24: insert into GMO_INSTR_SET_DEFN_B (

Line 24: insert into GMO_INSTR_SET_DEFN_B (

20: cursor C is select ROWID from GMO_INSTR_SET_DEFN_B
21: where INSTRUCTION_SET_ID = X_INSTRUCTION_SET_ID
22: ;
23: begin
24: insert into GMO_INSTR_SET_DEFN_B (
25: INSTRUCTION_SET_ID,
26: INSTRUCTION_TYPE,
27: INSTR_SET_NAME,
28: ENTITY_NAME,

Line 111: from GMO_INSTR_SET_DEFN_B

107: ENTITY_KEY,
108: ACKN_STATUS,
109: ORIG_SOURCE,
110: ORIG_SOURCE_ID
111: from GMO_INSTR_SET_DEFN_B
112: where INSTRUCTION_SET_ID = X_INSTRUCTION_SET_ID
113: for update of INSTRUCTION_SET_ID nowait;
114: recinfo c%rowtype;
115:

Line 183: update GMO_INSTR_SET_DEFN_B set

179: X_LAST_UPDATED_BY in NUMBER,
180: X_LAST_UPDATE_LOGIN in NUMBER
181: ) is
182: begin
183: update GMO_INSTR_SET_DEFN_B set
184: INSTRUCTION_TYPE = X_INSTRUCTION_TYPE,
185: INSTR_SET_NAME = X_INSTR_SET_NAME,
186: ENTITY_NAME = X_ENTITY_NAME,
187: ENTITY_KEY = X_ENTITY_KEY,

Line 225: delete from GMO_INSTR_SET_DEFN_B

221: if (sql%notfound) then
222: raise no_data_found;
223: end if;
224:
225: delete from GMO_INSTR_SET_DEFN_B
226: where INSTRUCTION_SET_ID = X_INSTRUCTION_SET_ID;
227:
228: if (sql%notfound) then
229: raise no_data_found;

Line 239: from GMO_INSTR_SET_DEFN_B B

235: begin
236: delete from GMO_INSTR_SET_DEFN_TL T
237: where not exists
238: (select NULL
239: from GMO_INSTR_SET_DEFN_B B
240: where B.INSTRUCTION_SET_ID = T.INSTRUCTION_SET_ID
241: );
242:
243: update GMO_INSTR_SET_DEFN_TL T set (