APPS.IBY_TRXN_TYPES_PKG dependencies on IBY_TRXN_TYPES_TL

Line 48: insert into IBY_TRXN_TYPES_TL (

44: X_LAST_UPDATED_BY,
45: X_LAST_UPDATE_LOGIN
46: );
47:
48: insert into IBY_TRXN_TYPES_TL (
49: APPLICATION_ID,
50: PAY_PROC_TRXN_TYPE_CODE,
51: NAME,
52: DESCRIPTION,

Line 78: from IBY_TRXN_TYPES_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_TRXN_TYPES_TL T
79: where T.APPLICATION_ID = X_APPLICATION_ID
80: and T.PAY_PROC_TRXN_TYPE_CODE = X_PAY_PROC_TRXN_TYPE_CODE
81: and T.LANGUAGE = L.LANGUAGE_CODE);
82:

Line 116: from IBY_TRXN_TYPES_TL

112: cursor c1 is select
113: NAME,
114: DESCRIPTION,
115: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
116: from IBY_TRXN_TYPES_TL
117: where APPLICATION_ID = X_APPLICATION_ID
118: and PAY_PROC_TRXN_TYPE_CODE = X_PAY_PROC_TRXN_TYPE_CODE
119: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
120: for update of APPLICATION_ID nowait;

Line 183: update IBY_TRXN_TYPES_TL set

179: if (sql%notfound) then
180: raise no_data_found;
181: end if;
182:
183: update IBY_TRXN_TYPES_TL set
184: NAME = X_NAME,
185: DESCRIPTION = X_DESCRIPTION,
186: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
187: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 204: delete from IBY_TRXN_TYPES_TL

200: X_APPLICATION_ID in NUMBER,
201: X_PAY_PROC_TRXN_TYPE_CODE in VARCHAR2
202: ) is
203: begin
204: delete from IBY_TRXN_TYPES_TL
205: where APPLICATION_ID = X_APPLICATION_ID
206: and PAY_PROC_TRXN_TYPE_CODE = X_PAY_PROC_TRXN_TYPE_CODE;
207:
208: if (sql%notfound) then

Line 224: delete from IBY_TRXN_TYPES_TL T

220:
221: procedure ADD_LANGUAGE
222: is
223: begin
224: delete from IBY_TRXN_TYPES_TL T
225: where not exists
226: (select NULL
227: from IBY_TRXN_TYPES_B B
228: where B.APPLICATION_ID = T.APPLICATION_ID

Line 232: update IBY_TRXN_TYPES_TL T set (

228: where B.APPLICATION_ID = T.APPLICATION_ID
229: and B.PAY_PROC_TRXN_TYPE_CODE = T.PAY_PROC_TRXN_TYPE_CODE
230: );
231:
232: update IBY_TRXN_TYPES_TL T set (
233: NAME,
234: DESCRIPTION
235: ) = (select
236: B.NAME,

Line 238: from IBY_TRXN_TYPES_TL B

234: DESCRIPTION
235: ) = (select
236: B.NAME,
237: B.DESCRIPTION
238: from IBY_TRXN_TYPES_TL B
239: where B.APPLICATION_ID = T.APPLICATION_ID
240: and B.PAY_PROC_TRXN_TYPE_CODE = T.PAY_PROC_TRXN_TYPE_CODE
241: and B.LANGUAGE = T.SOURCE_LANG)
242: where (

Line 250: from IBY_TRXN_TYPES_TL SUBB, IBY_TRXN_TYPES_TL SUBT

246: ) in (select
247: SUBT.APPLICATION_ID,
248: SUBT.PAY_PROC_TRXN_TYPE_CODE,
249: SUBT.LANGUAGE
250: from IBY_TRXN_TYPES_TL SUBB, IBY_TRXN_TYPES_TL SUBT
251: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
252: and SUBB.PAY_PROC_TRXN_TYPE_CODE = SUBT.PAY_PROC_TRXN_TYPE_CODE
253: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
254: and (SUBB.NAME <> SUBT.NAME

Line 260: insert into IBY_TRXN_TYPES_TL (

256: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
257: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
258: ));
259:
260: insert into IBY_TRXN_TYPES_TL (
261: APPLICATION_ID,
262: PAY_PROC_TRXN_TYPE_CODE,
263: NAME,
264: DESCRIPTION,

Line 286: from IBY_TRXN_TYPES_TL B, FND_LANGUAGES L

282: B.LAST_UPDATE_LOGIN,
283: B.OBJECT_VERSION_NUMBER,
284: L.LANGUAGE_CODE,
285: B.SOURCE_LANG
286: from IBY_TRXN_TYPES_TL B, FND_LANGUAGES L
287: where L.INSTALLED_FLAG in ('I', 'B')
288: and B.LANGUAGE = userenv('LANG')
289: and not exists
290: (select NULL

Line 291: from IBY_TRXN_TYPES_TL T

287: where L.INSTALLED_FLAG in ('I', 'B')
288: and B.LANGUAGE = userenv('LANG')
289: and not exists
290: (select NULL
291: from IBY_TRXN_TYPES_TL T
292: where T.APPLICATION_ID = B.APPLICATION_ID
293: and T.PAY_PROC_TRXN_TYPE_CODE = B.PAY_PROC_TRXN_TYPE_CODE
294: and T.LANGUAGE = L.LANGUAGE_CODE);
295: end ADD_LANGUAGE;

Line 357: update IBY_TRXN_TYPES_TL set

353: X_OBJECT_VERSION_NUMBER in NUMBER,
354: X_OWNER in VARCHAR2)
355: is
356: begin
357: update IBY_TRXN_TYPES_TL set
358: NAME = X_NAME,
359: DESCRIPTION = X_DESCRIPTION,
360: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
361: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),