APPS.XLA_TAB_ACCT_DEFS_F_PKG dependencies on XLA_TAB_ACCT_DEFS_TL

Line 88: insert into XLA_TAB_ACCT_DEFS_TL (

84: X_LAST_UPDATED_BY,
85: X_LAST_UPDATE_LOGIN
86: );
87:
88: insert into XLA_TAB_ACCT_DEFS_TL (
89: APPLICATION_ID,
90: ACCOUNT_DEFINITION_TYPE_CODE,
91: ACCOUNT_DEFINITION_CODE,
92: NAME,

Line 120: from XLA_TAB_ACCT_DEFS_TL T

116: from FND_LANGUAGES L
117: where L.INSTALLED_FLAG in ('I', 'B')
118: and not exists
119: (select NULL
120: from XLA_TAB_ACCT_DEFS_TL T
121: where T.APPLICATION_ID = X_APPLICATION_ID
122: and T.AMB_CONTEXT_CODE = X_AMB_CONTEXT_CODE
123: and T.ACCOUNT_DEFINITION_TYPE_CODE = X_ACCOUNT_DEFINITION_TYPE_CODE
124: and T.ACCOUNT_DEFINITION_CODE = X_ACCOUNT_DEFINITION_CODE

Line 176: from XLA_TAB_ACCT_DEFS_TL

172: cursor c1 is select
173: NAME,
174: DESCRIPTION,
175: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
176: from XLA_TAB_ACCT_DEFS_TL
177: where APPLICATION_ID = X_APPLICATION_ID
178: and AMB_CONTEXT_CODE = X_AMB_CONTEXT_CODE
179: and ACCOUNT_DEFINITION_TYPE_CODE = X_ACCOUNT_DEFINITION_TYPE_CODE
180: and ACCOUNT_DEFINITION_CODE = X_ACCOUNT_DEFINITION_CODE

Line 268: update XLA_TAB_ACCT_DEFS_TL set

264: if (sql%notfound) then
265: raise no_data_found;
266: end if;
267:
268: update XLA_TAB_ACCT_DEFS_TL set
269: NAME = X_NAME,
270: DESCRIPTION = X_DESCRIPTION,
271: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
272: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 303: delete from XLA_TAB_ACCT_DEFS_TL

299: ) is
300:
301: BEGIN
302:
303: delete from XLA_TAB_ACCT_DEFS_TL
304: where APPLICATION_ID = X_APPLICATION_ID
305: and AMB_CONTEXT_CODE = X_AMB_CONTEXT_CODE
306: and ACCOUNT_DEFINITION_TYPE_CODE = X_ACCOUNT_DEFINITION_TYPE_CODE
307: and ACCOUNT_DEFINITION_CODE = X_ACCOUNT_DEFINITION_CODE;

Line 335: delete from XLA_TAB_ACCT_DEFS_TL T

331: procedure ADD_LANGUAGE
332: is
333:
334: BEGIN
335: delete from XLA_TAB_ACCT_DEFS_TL T
336: where not exists
337: (select NULL
338: from XLA_TAB_ACCT_DEFS_B B
339: where B.APPLICATION_ID = T.APPLICATION_ID

Line 345: update XLA_TAB_ACCT_DEFS_TL T set (

341: and B.ACCOUNT_DEFINITION_TYPE_CODE = T.ACCOUNT_DEFINITION_TYPE_CODE
342: and B.ACCOUNT_DEFINITION_CODE = T.ACCOUNT_DEFINITION_CODE
343: );
344:
345: update XLA_TAB_ACCT_DEFS_TL T set (
346: NAME,
347: DESCRIPTION
348: ) = (select
349: B.NAME,

Line 351: from XLA_TAB_ACCT_DEFS_TL B

347: DESCRIPTION
348: ) = (select
349: B.NAME,
350: B.DESCRIPTION
351: from XLA_TAB_ACCT_DEFS_TL B
352: where B.APPLICATION_ID = T.APPLICATION_ID
353: and B.AMB_CONTEXT_CODE = T.AMB_CONTEXT_CODE
354: and B.ACCOUNT_DEFINITION_TYPE_CODE = T.ACCOUNT_DEFINITION_TYPE_CODE
355: and B.ACCOUNT_DEFINITION_CODE = T.ACCOUNT_DEFINITION_CODE

Line 369: from XLA_TAB_ACCT_DEFS_TL SUBB, XLA_TAB_ACCT_DEFS_TL SUBT

365: SUBT.AMB_CONTEXT_CODE,
366: SUBT.ACCOUNT_DEFINITION_TYPE_CODE,
367: SUBT.ACCOUNT_DEFINITION_CODE,
368: SUBT.LANGUAGE
369: from XLA_TAB_ACCT_DEFS_TL SUBB, XLA_TAB_ACCT_DEFS_TL SUBT
370: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
371: and SUBB.AMB_CONTEXT_CODE = SUBT.AMB_CONTEXT_CODE
372: and SUBB.ACCOUNT_DEFINITION_TYPE_CODE = SUBT.ACCOUNT_DEFINITION_TYPE_CODE
373: and SUBB.ACCOUNT_DEFINITION_CODE = SUBT.ACCOUNT_DEFINITION_CODE

Line 381: insert into XLA_TAB_ACCT_DEFS_TL (

377: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
378: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
379: ));
380:
381: insert into XLA_TAB_ACCT_DEFS_TL (
382: APPLICATION_ID,
383: ACCOUNT_DEFINITION_TYPE_CODE,
384: ACCOUNT_DEFINITION_CODE,
385: NAME,

Line 409: from XLA_TAB_ACCT_DEFS_TL B, FND_LANGUAGES L

405: B.LAST_UPDATE_LOGIN,
406: B.AMB_CONTEXT_CODE,
407: L.LANGUAGE_CODE,
408: B.SOURCE_LANG
409: from XLA_TAB_ACCT_DEFS_TL B, FND_LANGUAGES L
410: where L.INSTALLED_FLAG in ('I', 'B')
411: and B.LANGUAGE = userenv('LANG')
412: and not exists
413: (select NULL

Line 414: from XLA_TAB_ACCT_DEFS_TL T

410: where L.INSTALLED_FLAG in ('I', 'B')
411: and B.LANGUAGE = userenv('LANG')
412: and not exists
413: (select NULL
414: from XLA_TAB_ACCT_DEFS_TL T
415: where T.APPLICATION_ID = B.APPLICATION_ID
416: and T.AMB_CONTEXT_CODE = B.AMB_CONTEXT_CODE
417: and T.ACCOUNT_DEFINITION_TYPE_CODE = B.ACCOUNT_DEFINITION_TYPE_CODE
418: and T.ACCOUNT_DEFINITION_CODE = B.ACCOUNT_DEFINITION_CODE