APPS.GMO_INSTR_SET_INSTANCE_PKG dependencies on GMO_INSTR_SET_INSTANCE_B

Line 22: cursor C is select ROWID from GMO_INSTR_SET_INSTANCE_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_SET_INSTANCE_B
23: where INSTRUCTION_SET_ID = X_INSTRUCTION_SET_ID
24: ;
25: begin
26: insert into GMO_INSTR_SET_INSTANCE_B (

Line 26: insert into GMO_INSTR_SET_INSTANCE_B (

22: cursor C is select ROWID from GMO_INSTR_SET_INSTANCE_B
23: where INSTRUCTION_SET_ID = X_INSTRUCTION_SET_ID
24: ;
25: begin
26: insert into GMO_INSTR_SET_INSTANCE_B (
27: INSTR_SET_STATUS,
28: INSTRUCTION_SET_ID,
29: INSTRUCTION_TYPE,
30: INSTR_SET_NAME,

Line 117: from GMO_INSTR_SET_INSTANCE_B

113: ENTITY_KEY,
114: ACKN_STATUS,
115: ORIG_SOURCE,
116: ORIG_SOURCE_ID
117: from GMO_INSTR_SET_INSTANCE_B
118: where INSTRUCTION_SET_ID = X_INSTRUCTION_SET_ID
119: for update of INSTRUCTION_SET_ID nowait;
120: recinfo c%rowtype;
121:

Line 192: update GMO_INSTR_SET_INSTANCE_B set

188: X_LAST_UPDATED_BY in NUMBER,
189: X_LAST_UPDATE_LOGIN in NUMBER
190: ) is
191: begin
192: update GMO_INSTR_SET_INSTANCE_B set
193: INSTR_SET_STATUS = X_INSTR_SET_STATUS,
194: INSTRUCTION_TYPE = X_INSTRUCTION_TYPE,
195: INSTR_SET_NAME = X_INSTR_SET_NAME,
196: ENTITY_NAME = X_ENTITY_NAME,

Line 235: delete from GMO_INSTR_SET_INSTANCE_B

231: if (sql%notfound) then
232: raise no_data_found;
233: end if;
234:
235: delete from GMO_INSTR_SET_INSTANCE_B
236: where INSTRUCTION_SET_ID = X_INSTRUCTION_SET_ID;
237:
238: if (sql%notfound) then
239: raise no_data_found;

Line 249: from GMO_INSTR_SET_INSTANCE_B B

245: begin
246: delete from GMO_INSTR_SET_INSTANCE_TL T
247: where not exists
248: (select NULL
249: from GMO_INSTR_SET_INSTANCE_B B
250: where B.INSTRUCTION_SET_ID = T.INSTRUCTION_SET_ID
251: );
252:
253: update GMO_INSTR_SET_INSTANCE_TL T set (