APPS.FND_IREP_LOADER_PRIVATE dependencies on FND_IREP_CLASSES_TL

Line 336: UPDATE FND_IREP_CLASSES_TL

332: end;
333:
334: if (P_UPLOAD_MODE = 'NLS') then
335: if (P_DEST_TABLE = 'C') then
336: UPDATE FND_IREP_CLASSES_TL
337: SET source_lang=userenv('LANG'),
338: DISPLAY_NAME = nvl(P_DISPNAME, DISPLAY_NAME),
339: SHORT_DESCRIPTION = nvl(P_SHORTDISC, SHORT_DESCRIPTION),
340: LAST_UPDATED_BY = f_luby,

Line 519: UPDATE FND_IREP_CLASSES_TL

515:
516: end if;
517:
518: if (P_DEST_TABLE = 'C') then
519: UPDATE FND_IREP_CLASSES_TL
520: SET SOURCE_LANG = userenv('LANG'),
521: DISPLAY_NAME = nvl(P_DISPNAME, DISPLAY_NAME),
522: SHORT_DESCRIPTION = nvl(P_SHORTDISC, SHORT_DESCRIPTION),
523: LAST_UPDATED_BY = f_luby,

Line 581: INSERT INTO FND_IREP_CLASSES_TL (

577: f_ludate, f_luby, key_id, P_OBJECT_NAME,
578: DECODE(P_OBJ_TYPE, 'SERVICEBEAN', 'Y', NULL)
579: );
580:
581: INSERT INTO FND_IREP_CLASSES_TL (
582: CLASS_ID, DISPLAY_NAME, SHORT_DESCRIPTION, LANGUAGE,
583: SOURCE_LANG, LAST_UPDATE_DATE, LAST_UPDATED_BY,
584: CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN
585: ) SELECT

Line 592: FROM FND_IREP_CLASSES_TL T

588: FROM FND_LANGUAGES L
589: WHERE L.INSTALLED_FLAG IN ('I','B')
590: AND NOT EXISTS
591: (SELECT NULL
592: FROM FND_IREP_CLASSES_TL T
593: WHERE T.CLASS_ID = key_id
594: AND T.LANGUAGE = l.language_code);
595:
596: else

Line 1442: insert into FND_IREP_CLASSES_TL (

1438: procedure ADD_LANGUAGE
1439: is
1440: begin
1441:
1442: insert into FND_IREP_CLASSES_TL (
1443: CLASS_ID,
1444: DISPLAY_NAME,
1445: SHORT_DESCRIPTION,
1446: LANGUAGE,

Line 1464: from FND_IREP_CLASSES_TL B, FND_LANGUAGES L

1460: B.LAST_UPDATED_BY,
1461: B.CREATED_BY,
1462: B.CREATION_DATE,
1463: B.LAST_UPDATE_LOGIN
1464: from FND_IREP_CLASSES_TL B, FND_LANGUAGES L
1465: where L.INSTALLED_FLAG in ('I', 'B')
1466: and B.LANGUAGE = userenv('LANG')
1467: and not exists
1468: (select NULL

Line 1469: from FND_IREP_CLASSES_TL T

1465: where L.INSTALLED_FLAG in ('I', 'B')
1466: and B.LANGUAGE = userenv('LANG')
1467: and not exists
1468: (select NULL
1469: from FND_IREP_CLASSES_TL T
1470: where T.CLASS_ID = B.CLASS_ID
1471: and T.LANGUAGE = L.LANGUAGE_CODE);
1472:
1473: end ADD_LANGUAGE;