APPS.FF_GLOBALS_F_PKG dependencies on FF_GLOBALS_F_TL

Line 354: delete from FF_GLOBALS_F_TL T

350: ---For MLS----------------------------------------------------------------------
351: procedure ADD_LANGUAGE
352: is
353: begin
354: delete from FF_GLOBALS_F_TL T
355: where not exists
356: (select NULL
357: from FF_GLOBALS_F B
358: where B.GLOBAL_ID = T.GLOBAL_ID

Line 360: update FF_GLOBALS_F_TL T set (

356: (select NULL
357: from FF_GLOBALS_F B
358: where B.GLOBAL_ID = T.GLOBAL_ID
359: );
360: update FF_GLOBALS_F_TL T set (
361: GLOBAL_NAME,
362: GLOBAL_DESCRIPTION
363: ) = (select
364: B.GLOBAL_NAME,

Line 366: from FF_GLOBALS_F_TL B

362: GLOBAL_DESCRIPTION
363: ) = (select
364: B.GLOBAL_NAME,
365: B.GLOBAL_DESCRIPTION
366: from FF_GLOBALS_F_TL B
367: where B.GLOBAL_ID = T.GLOBAL_ID
368: and B.LANGUAGE = T.SOURCE_LANG)
369: where (
370: T.GLOBAL_ID,

Line 375: from FF_GLOBALS_F_TL SUBB, FF_GLOBALS_F_TL SUBT

371: T.LANGUAGE
372: ) in (select
373: SUBT.GLOBAL_ID,
374: SUBT.LANGUAGE
375: from FF_GLOBALS_F_TL SUBB, FF_GLOBALS_F_TL SUBT
376: where SUBB.GLOBAL_ID = SUBT.GLOBAL_ID
377: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
378: and (SUBB.GLOBAL_NAME <> SUBT.GLOBAL_NAME
379: or SUBB.GLOBAL_DESCRIPTION <> SUBT.GLOBAL_DESCRIPTION

Line 386: insert into FF_GLOBALS_F_TL (

382: or (SUBB.GLOBAL_DESCRIPTION is not null
383: and SUBT.GLOBAL_DESCRIPTION is null)
384: ));
385:
386: insert into FF_GLOBALS_F_TL (
387: GLOBAL_ID,
388: GLOBAL_NAME,
389: GLOBAL_DESCRIPTION,
390: LAST_UPDATE_DATE,

Line 408: from FF_GLOBALS_F_TL B, FND_LANGUAGES L

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

Line 413: from FF_GLOBALS_F_TL T

409: where L.INSTALLED_FLAG in ('I', 'B')
410: and B.LANGUAGE = userenv('LANG')
411: and not exists
412: (select NULL
413: from FF_GLOBALS_F_TL T
414: where T.GLOBAL_ID = B.GLOBAL_ID
415: and T.LANGUAGE = L.LANGUAGE_CODE);
416: end ADD_LANGUAGE;
417: ---

Line 469: UPDATE ff_globals_f_tl

465:
466: --
467: -- Update the global value.
468: --
469: UPDATE ff_globals_f_tl
470: SET GLOBAL_NAME = nvl(X_GLOBAL_NAME,GLOBAL_NAME),
471: GLOBAL_DESCRIPTION = nvl(X_GLOBAL_DESCRIPTION,GLOBAL_DESCRIPTION),
472: last_update_date = SYSDATE,
473: last_updated_by = decode(x_owner,'SEED',1,0),

Line 698: delete ff_globals_f_tl

694: where user_entity_id=i.user_entity_id;
695:
696: end loop;
697:
698: delete ff_globals_f_tl
699: where global_id=p_global_id;
700:
701: delete ff_globals_f
702: where global_id=p_global_id;