APPS.IBY_BANK_INSTRUCTIONS_PKG dependencies on IBY_BANK_INSTRUCTIONS_TL

Line 50: insert into IBY_BANK_INSTRUCTIONS_TL (

46: X_LAST_UPDATE_LOGIN,
47: X_SEEDED_FLAG
48: );
49:
50: insert into IBY_BANK_INSTRUCTIONS_TL (
51: CREATED_BY,
52: CREATION_DATE,
53: LAST_UPDATED_BY,
54: LAST_UPDATE_DATE,

Line 78: from IBY_BANK_INSTRUCTIONS_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from IBY_BANK_INSTRUCTIONS_TL T
79: where T.BANK_INSTRUCTION_CODE = X_BANK_INSTRUCTION_CODE
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 115: from IBY_BANK_INSTRUCTIONS_TL

111: cursor c1 is select
112: MEANING,
113: DESCRIPTION,
114: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
115: from IBY_BANK_INSTRUCTIONS_TL
116: where BANK_INSTRUCTION_CODE = X_BANK_INSTRUCTION_CODE
117: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
118: for update of BANK_INSTRUCTION_CODE nowait;
119: begin

Line 186: update IBY_BANK_INSTRUCTIONS_TL set

182: if (sql%notfound) then
183: raise no_data_found;
184: end if;
185:
186: update IBY_BANK_INSTRUCTIONS_TL set
187: MEANING = X_MEANING,
188: DESCRIPTION = X_DESCRIPTION,
189: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
190: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 205: delete from IBY_BANK_INSTRUCTIONS_TL

201: procedure DELETE_ROW (
202: X_BANK_INSTRUCTION_CODE in VARCHAR2
203: ) is
204: begin
205: delete from IBY_BANK_INSTRUCTIONS_TL
206: where BANK_INSTRUCTION_CODE = X_BANK_INSTRUCTION_CODE;
207:
208: if (sql%notfound) then
209: raise no_data_found;

Line 223: delete from IBY_BANK_INSTRUCTIONS_TL T

219:
220: procedure ADD_LANGUAGE
221: is
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

Line 230: update IBY_BANK_INSTRUCTIONS_TL T set (

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 (
231: MEANING,
232: DESCRIPTION
233: ) = (select
234: B.MEANING,

Line 236: from IBY_BANK_INSTRUCTIONS_TL B

232: DESCRIPTION
233: ) = (select
234: B.MEANING,
235: B.DESCRIPTION
236: from IBY_BANK_INSTRUCTIONS_TL B
237: where B.BANK_INSTRUCTION_CODE = T.BANK_INSTRUCTION_CODE
238: and B.LANGUAGE = T.SOURCE_LANG)
239: where (
240: T.BANK_INSTRUCTION_CODE,

Line 245: from IBY_BANK_INSTRUCTIONS_TL SUBB, IBY_BANK_INSTRUCTIONS_TL SUBT

241: T.LANGUAGE
242: ) in (select
243: SUBT.BANK_INSTRUCTION_CODE,
244: SUBT.LANGUAGE
245: from IBY_BANK_INSTRUCTIONS_TL SUBB, IBY_BANK_INSTRUCTIONS_TL SUBT
246: where SUBB.BANK_INSTRUCTION_CODE = SUBT.BANK_INSTRUCTION_CODE
247: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
248: and (SUBB.MEANING <> SUBT.MEANING
249: or (SUBB.MEANING is null and SUBT.MEANING is not null)

Line 256: insert into IBY_BANK_INSTRUCTIONS_TL (

252: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
253: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
254: ));
255:
256: insert into IBY_BANK_INSTRUCTIONS_TL (
257: CREATED_BY,
258: CREATION_DATE,
259: LAST_UPDATED_BY,
260: LAST_UPDATE_DATE,

Line 280: from IBY_BANK_INSTRUCTIONS_TL B, FND_LANGUAGES L

276: B.MEANING,
277: B.DESCRIPTION,
278: L.LANGUAGE_CODE,
279: B.SOURCE_LANG
280: from IBY_BANK_INSTRUCTIONS_TL B, FND_LANGUAGES L
281: where L.INSTALLED_FLAG in ('I', 'B')
282: and B.LANGUAGE = userenv('LANG')
283: and not exists
284: (select NULL

Line 285: from IBY_BANK_INSTRUCTIONS_TL T

281: where L.INSTALLED_FLAG in ('I', 'B')
282: and B.LANGUAGE = userenv('LANG')
283: and not exists
284: (select NULL
285: from IBY_BANK_INSTRUCTIONS_TL T
286: where T.BANK_INSTRUCTION_CODE = B.BANK_INSTRUCTION_CODE
287: and T.LANGUAGE = L.LANGUAGE_CODE);
288: end ADD_LANGUAGE;
289:

Line 352: update iby_bank_instructions_tl set

348: X_OBJECT_VERSION_NUMBER in NUMBER,
349: X_OWNER in VARCHAR2)
350: is
351: begin
352: update iby_bank_instructions_tl set
353: MEANING = X_MEANING,
354: DESCRIPTION = X_DESCRIPTION,
355: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
356: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),