APPS.XLA_TAB_ACCT_TYPES_F_PKG dependencies on XLA_TAB_ACCT_TYPES_TL

Line 115: insert into XLA_TAB_ACCT_TYPES_TL (

111: X_LAST_UPDATED_BY,
112: X_LAST_UPDATE_LOGIN
113: );
114:
115: insert into XLA_TAB_ACCT_TYPES_TL (
116: APPLICATION_ID,
117: ACCOUNT_TYPE_CODE,
118: NAME,
119: DESCRIPTION,

Line 143: from XLA_TAB_ACCT_TYPES_TL T

139: from FND_LANGUAGES L
140: where L.INSTALLED_FLAG in ('I', 'B')
141: and not exists
142: (select NULL
143: from XLA_TAB_ACCT_TYPES_TL T
144: where T.APPLICATION_ID = X_APPLICATION_ID
145: and T.ACCOUNT_TYPE_CODE = X_ACCOUNT_TYPE_CODE
146: and T.LANGUAGE = L.LANGUAGE_CODE);
147:

Line 190: from XLA_TAB_ACCT_TYPES_TL

186: cursor c1 is select
187: NAME,
188: DESCRIPTION,
189: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
190: from XLA_TAB_ACCT_TYPES_TL
191: where APPLICATION_ID = X_APPLICATION_ID
192: and ACCOUNT_TYPE_CODE = X_ACCOUNT_TYPE_CODE
193: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
194: for update of APPLICATION_ID nowait;

Line 271: update XLA_TAB_ACCT_TYPES_TL set

267: if (sql%notfound) then
268: raise no_data_found;
269: end if;
270:
271: update XLA_TAB_ACCT_TYPES_TL set
272: NAME = X_NAME,
273: DESCRIPTION = X_DESCRIPTION,
274: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
275: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 298: delete from XLA_TAB_ACCT_TYPES_TL

294: X_APPLICATION_ID in NUMBER,
295: X_ACCOUNT_TYPE_CODE in VARCHAR2
296: ) is
297: begin
298: delete from XLA_TAB_ACCT_TYPES_TL
299: where APPLICATION_ID = X_APPLICATION_ID
300: and ACCOUNT_TYPE_CODE = X_ACCOUNT_TYPE_CODE;
301:
302: if (sql%notfound) then

Line 325: delete from XLA_TAB_ACCT_TYPES_TL T

321:
322: procedure ADD_LANGUAGE
323: is
324: begin
325: delete from XLA_TAB_ACCT_TYPES_TL T
326: where not exists
327: (select NULL
328: from XLA_TAB_ACCT_TYPES_B B
329: where B.APPLICATION_ID = T.APPLICATION_ID

Line 333: update XLA_TAB_ACCT_TYPES_TL T set (

329: where B.APPLICATION_ID = T.APPLICATION_ID
330: and B.ACCOUNT_TYPE_CODE = T.ACCOUNT_TYPE_CODE
331: );
332:
333: update XLA_TAB_ACCT_TYPES_TL T set (
334: NAME,
335: DESCRIPTION
336: ) = (select
337: B.NAME,

Line 339: from XLA_TAB_ACCT_TYPES_TL B

335: DESCRIPTION
336: ) = (select
337: B.NAME,
338: B.DESCRIPTION
339: from XLA_TAB_ACCT_TYPES_TL B
340: where B.APPLICATION_ID = T.APPLICATION_ID
341: and B.ACCOUNT_TYPE_CODE = T.ACCOUNT_TYPE_CODE
342: and B.LANGUAGE = T.SOURCE_LANG)
343: where (

Line 351: from XLA_TAB_ACCT_TYPES_TL SUBB, XLA_TAB_ACCT_TYPES_TL SUBT

347: ) in (select
348: SUBT.APPLICATION_ID,
349: SUBT.ACCOUNT_TYPE_CODE,
350: SUBT.LANGUAGE
351: from XLA_TAB_ACCT_TYPES_TL SUBB, XLA_TAB_ACCT_TYPES_TL SUBT
352: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
353: and SUBB.ACCOUNT_TYPE_CODE = SUBT.ACCOUNT_TYPE_CODE
354: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
355: and (SUBB.NAME <> SUBT.NAME

Line 361: insert into XLA_TAB_ACCT_TYPES_TL (

357: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
358: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
359: ));
360:
361: insert into XLA_TAB_ACCT_TYPES_TL (
362: APPLICATION_ID,
363: ACCOUNT_TYPE_CODE,
364: NAME,
365: DESCRIPTION,

Line 385: from XLA_TAB_ACCT_TYPES_TL B, FND_LANGUAGES L

381: B.LAST_UPDATED_BY,
382: B.LAST_UPDATE_LOGIN,
383: L.LANGUAGE_CODE,
384: B.SOURCE_LANG
385: from XLA_TAB_ACCT_TYPES_TL B, FND_LANGUAGES L
386: where L.INSTALLED_FLAG in ('I', 'B')
387: and B.LANGUAGE = userenv('LANG')
388: and not exists
389: (select NULL

Line 390: from XLA_TAB_ACCT_TYPES_TL T

386: where L.INSTALLED_FLAG in ('I', 'B')
387: and B.LANGUAGE = userenv('LANG')
388: and not exists
389: (select NULL
390: from XLA_TAB_ACCT_TYPES_TL T
391: where T.APPLICATION_ID = B.APPLICATION_ID
392: and T.ACCOUNT_TYPE_CODE = B.ACCOUNT_TYPE_CODE
393: and T.LANGUAGE = L.LANGUAGE_CODE);
394: end ADD_LANGUAGE;

Line 449: FROM xla_tab_acct_types_tl

445:
446: BEGIN
447: SELECT last_updated_by, last_update_date
448: INTO db_luby, db_ludate
449: FROM xla_tab_acct_types_tl
450: WHERE application_id = l_application_id
451: AND account_type_code = p_account_type_code
452: AND language = userenv('LANG');
453:

Line 456: UPDATE xla_tab_acct_types_tl

452: AND language = userenv('LANG');
453:
454: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
455: db_ludate, p_custom_mode)) then
456: UPDATE xla_tab_acct_types_tl
457: SET name = p_name
458: ,description = p_description
459: ,last_update_date = f_ludate
460: ,last_updated_by = f_luby