APPS.FND_OBJECTS_PKG dependencies on FND_OBJECTS_TL

Line 74: insert into FND_OBJECTS_TL (

70: X_LAST_UPDATED_BY,
71: X_LAST_UPDATE_LOGIN
72: );
73:
74: insert into FND_OBJECTS_TL (
75: CREATED_BY,
76: CREATION_DATE,
77: LAST_UPDATED_BY,
78: LAST_UPDATE_DATE,

Line 100: from FND_OBJECTS_TL T

96: from FND_LANGUAGES L
97: where L.INSTALLED_FLAG in ('I', 'B')
98: and not exists
99: (select NULL
100: from FND_OBJECTS_TL T
101: where T.OBJECT_ID = X_OBJECT_ID
102: and T.LANGUAGE = L.LANGUAGE_CODE);
103:
104: open c;

Line 155: from FND_OBJECTS_TL

151: cursor c1 is select
152: DISPLAY_NAME,
153: DESCRIPTION,
154: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
155: from FND_OBJECTS_TL
156: where OBJECT_ID = X_OBJECT_ID
157: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
158: for update of OBJECT_ID nowait;
159: begin

Line 255: update FND_OBJECTS_TL set

251: if (sql%notfound) then
252: raise no_data_found;
253: end if;
254:
255: update FND_OBJECTS_TL set
256: DISPLAY_NAME = X_DISPLAY_NAME,
257: DESCRIPTION = X_DESCRIPTION,
258: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
259: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 451: from fnd_objects_tl

447: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
448:
449: select LAST_UPDATED_BY, LAST_UPDATE_DATE
450: into db_luby, db_ludate
451: from fnd_objects_tl
452: where object_id = (select o.object_id from fnd_objects o
453: where o.obj_name = X_OBJ_NAME)
454: and userenv('LANG') = LANGUAGE;
455:

Line 458: update fnd_objects_tl set

454: and userenv('LANG') = LANGUAGE;
455:
456: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
457: db_ludate, X_CUSTOM_MODE)) then
458: update fnd_objects_tl set
459: display_name = nvl(X_DISPLAY_NAME, display_name),
460: description = nvl(X_DESCRIPTION, description),
461: source_lang = userenv('LANG'),
462: last_update_date = f_ludate,

Line 476: delete from FND_OBJECTS_TL

472: procedure DELETE_ROW (
473: X_OBJECT_ID in NUMBER
474: ) is
475: begin
476: delete from FND_OBJECTS_TL
477: where OBJECT_ID = X_OBJECT_ID;
478:
479: if (sql%notfound) then
480: raise no_data_found;

Line 500: delete from FND_OBJECTS_TL T

496: /* as a quick workaround to fix the time-consuming table handler issue */
497: /* Eventually we'll need to turn them into a separate fix_language procedure */
498: /*
499:
500: delete from FND_OBJECTS_TL T
501: where not exists
502: (select NULL
503: from FND_OBJECTS B
504: where B.OBJECT_ID = T.OBJECT_ID

Line 507: update FND_OBJECTS_TL T set (

503: from FND_OBJECTS B
504: where B.OBJECT_ID = T.OBJECT_ID
505: );
506:
507: update FND_OBJECTS_TL T set (
508: DISPLAY_NAME,
509: DESCRIPTION
510: ) = (select
511: B.DISPLAY_NAME,

Line 513: from FND_OBJECTS_TL B

509: DESCRIPTION
510: ) = (select
511: B.DISPLAY_NAME,
512: B.DESCRIPTION
513: from FND_OBJECTS_TL B
514: where B.OBJECT_ID = T.OBJECT_ID
515: and B.LANGUAGE = T.SOURCE_LANG)
516: where (
517: T.OBJECT_ID,

Line 522: from FND_OBJECTS_TL SUBB, FND_OBJECTS_TL SUBT

518: T.LANGUAGE
519: ) in (select
520: SUBT.OBJECT_ID,
521: SUBT.LANGUAGE
522: from FND_OBJECTS_TL SUBB, FND_OBJECTS_TL SUBT
523: where SUBB.OBJECT_ID = SUBT.OBJECT_ID
524: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
525: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
526: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 530: insert into FND_OBJECTS_TL (

526: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
527: ));
528: */
529:
530: insert into FND_OBJECTS_TL (
531: CREATED_BY,
532: CREATION_DATE,
533: LAST_UPDATED_BY,
534: LAST_UPDATE_DATE,

Line 552: from FND_OBJECTS_TL B, FND_LANGUAGES L

548: B.DISPLAY_NAME,
549: B.DESCRIPTION,
550: L.LANGUAGE_CODE,
551: B.SOURCE_LANG
552: from FND_OBJECTS_TL B, FND_LANGUAGES L
553: where L.INSTALLED_FLAG in ('I', 'B')
554: and B.LANGUAGE = userenv('LANG')
555: and not exists
556: (select NULL

Line 557: from FND_OBJECTS_TL T

553: where L.INSTALLED_FLAG in ('I', 'B')
554: and B.LANGUAGE = userenv('LANG')
555: and not exists
556: (select NULL
557: from FND_OBJECTS_TL T
558: where T.OBJECT_ID = B.OBJECT_ID
559: and T.LANGUAGE = L.LANGUAGE_CODE);
560: end ADD_LANGUAGE;
561: