APPS.IBY_BANK_INSTRUCTIONS_PKG dependencies on IBY_BANK_INSTRUCTIONS_B

Line 20: cursor C is select ROWID from IBY_BANK_INSTRUCTIONS_B

16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER,
18: X_SEEDED_FLAG in VARCHAR2
19: ) is
20: cursor C is select ROWID from IBY_BANK_INSTRUCTIONS_B
21: where BANK_INSTRUCTION_CODE = X_BANK_INSTRUCTION_CODE
22: ;
23: begin
24: insert into IBY_BANK_INSTRUCTIONS_B (

Line 24: insert into IBY_BANK_INSTRUCTIONS_B (

20: cursor C is select ROWID from IBY_BANK_INSTRUCTIONS_B
21: where BANK_INSTRUCTION_CODE = X_BANK_INSTRUCTION_CODE
22: ;
23: begin
24: insert into IBY_BANK_INSTRUCTIONS_B (
25: INACTIVE_DATE,
26: TERRITORY_CODE,
27: OBJECT_VERSION_NUMBER,
28: BANK_INSTRUCTION_CODE,

Line 106: from IBY_BANK_INSTRUCTIONS_B

102: INACTIVE_DATE,
103: TERRITORY_CODE,
104: OBJECT_VERSION_NUMBER,
105: FORMAT_VALUE
106: from IBY_BANK_INSTRUCTIONS_B
107: where BANK_INSTRUCTION_CODE = X_BANK_INSTRUCTION_CODE
108: for update of BANK_INSTRUCTION_CODE nowait;
109: recinfo c%rowtype;
110:

Line 172: update IBY_BANK_INSTRUCTIONS_B set

168: X_LAST_UPDATED_BY in NUMBER,
169: X_LAST_UPDATE_LOGIN in NUMBER
170: ) is
171: begin
172: update IBY_BANK_INSTRUCTIONS_B set
173: INACTIVE_DATE = X_INACTIVE_DATE,
174: TERRITORY_CODE = X_TERRITORY_CODE,
175: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
176: FORMAT_VALUE = X_FORMAT_VALUE,

Line 212: delete from IBY_BANK_INSTRUCTIONS_B

208: if (sql%notfound) then
209: raise no_data_found;
210: end if;
211:
212: delete from IBY_BANK_INSTRUCTIONS_B
213: where BANK_INSTRUCTION_CODE = X_BANK_INSTRUCTION_CODE;
214:
215: if (sql%notfound) then
216: raise no_data_found;

Line 226: from IBY_BANK_INSTRUCTIONS_B B

222: begin
223: delete from IBY_BANK_INSTRUCTIONS_TL T
224: where not exists
225: (select NULL
226: from IBY_BANK_INSTRUCTIONS_B B
227: where B.BANK_INSTRUCTION_CODE = T.BANK_INSTRUCTION_CODE
228: );
229:
230: update IBY_BANK_INSTRUCTIONS_TL T set (