eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_IREP_LOADER_PRIVATE dependencies on FND_OBJECTS

Line 135: from FND_OBJECTS

131: begin
132: if (P_DEST_TABLE = 'O') then
133: Select object_id, IREP_SOURCE_FILE_VERSION
134: into key_id, DB_Version
135: from FND_OBJECTS
136: where obj_name = P_OBJECT_NAME;
137: else
138: Select class_id, SOURCE_FILE_VERSION
139: into key_id, DB_Version

Line 150: Update FND_OBJECTS

146: end;
147: if (COMPARE_VERSIONS(P_SOURCE_FILE_VERSION, DB_Version) <> '>') then
148: /* Mark flag to indicate that the file data is [O]bsolete */
149: if (P_DEST_TABLE = 'O') then
150: Update FND_OBJECTS
151: set IREP_LDR_INTERNAL_FLAG = 'O'
152: where obj_name = P_OBJECT_NAME;
153: else
154: Update FND_IREP_CLASSES

Line 163: Update FND_OBJECTS

159: return TRUE;
160: else
161: /* Clear flag to indicate that the file data is not [O]bsolete */
162: if (P_DEST_TABLE = 'O') then
163: Update FND_OBJECTS
164: set IREP_LDR_INTERNAL_FLAG = null
165: where obj_name = P_OBJECT_NAME;
166: else
167: Update FND_IREP_CLASSES

Line 198: from FND_OBJECTS

194: begin
195: if (P_DEST_TABLE = 'O') then
196: Select object_id, sysdate - LAST_UPDATE_DATE, IREP_LDR_INTERNAL_FLAG
197: into key_id, DB_age, LDR_Flag
198: from FND_OBJECTS
199: where obj_name = P_OBJECT_NAME;
200: else
201: Select class_id, sysdate - LAST_UPDATE_DATE, IREP_LDR_INTERNAL_FLAG
202: into key_id, DB_age, LDR_Flag

Line 325: from fnd_objects

321: where CLASS_NAME = P_OBJECT_NAME;
322: else
323: select OBJECT_ID
324: into key_id
325: from fnd_objects
326: where OBJ_NAME = P_OBJECT_NAME;
327: end if;
328:
329: exception

Line 346: UPDATE FND_OBJECTS_TL

342: LAST_UPDATE_LOGIN = 0
343: WHERE userenv('LANG') in (language, source_lang)
344: AND CLASS_ID = key_id;
345: else
346: UPDATE FND_OBJECTS_TL
347: SET source_lang=userenv('LANG'),
348: DISPLAY_NAME = nvl(P_DISPNAME, DISPLAY_NAME),
349: DESCRIPTION = nvl(P_SHORTDISC, DESCRIPTION),
350: LAST_UPDATED_BY = f_luby,

Line 458: update fnd_objects

454: --Fetch and save menus and grants
455: GET_DELETE_GRANTS(key_id);
456:
457: else
458: update fnd_objects
459: set IREP_NAME = P_API_NAME,
460: IREP_OBJECT_TYPE = P_OBJ_TYPE,
461: IREP_PRODUCT = LOWER(P_PRODUCT),
462: IREP_COMPATIBILITY = NVL(UPPER(P_COMPATABILITY), 'S'),

Line 506: where obj_name = 'FND_OBJECTS'

502: Delete from FND_OBJECT_KEY_SETS
503: where object_id = key_id;
504:
505: Delete from FND_LOOKUP_ASSIGNMENTS
506: where obj_name = 'FND_OBJECTS'
507: and INSTANCE_PK1_VALUE = to_char(key_id);
508:
509: Delete from FND_CHILD_ANNOTATIONS
510: where parent_id = key_id

Line 530: UPDATE FND_OBJECTS_TL

526: where userenv('LANG') in (language, source_lang)
527: and CLASS_ID = key_id;
528:
529: else
530: UPDATE FND_OBJECTS_TL
531: SET SOURCE_LANG = userenv('LANG'),
532: DISPLAY_NAME = nvl(P_DISPNAME, DISPLAY_NAME),
533: DESCRIPTION = nvl(P_SHORTDISC, DESCRIPTION),
534: LAST_UPDATED_BY = f_luby,

Line 544: select fnd_objects_s.nextval, NVL(LOWER(P_PRODUCT), 'fnd'),

540:
541: exception
542: when no_data_found then
543:
544: select fnd_objects_s.nextval, NVL(LOWER(P_PRODUCT), 'fnd'),
545: NVL(UPPER(P_COMPATABILITY),'S'), NVL(UPPER(P_SCOPE), 'PUBLIC'),
546: NVL(UPPER(P_LIFECYCLE),'ACTIVE'), UPPER(P_SOURCE_FILE_PRODUCT),
547: UPPER(NVL(P_OI_FLAG, 'N'))
548: into key_id, nice_prod,

Line 597: INSERT INTO FND_OBJECTS (

593: WHERE T.CLASS_ID = key_id
594: AND T.LANGUAGE = l.language_code);
595:
596: else
597: INSERT INTO FND_OBJECTS (
598: IREP_NAME, IREP_OBJECT_TYPE, IREP_PRODUCT,
599: IREP_COMPATIBILITY,
600: IREP_SCOPE,
601: IREP_LIFECYCLE,

Line 649: INSERT INTO FND_OBJECTS_TL (

645: P_CRAWL_DRIVING_TABLE,
646: DECODE(P_OBJ_TYPE, 'SERVICEDOCUMENT', 'Y', NULL)
647: );
648:
649: INSERT INTO FND_OBJECTS_TL (
650: object_id, display_name, description, LANGUAGE,
651: SOURCE_LANG, LAST_UPDATE_DATE, LAST_UPDATED_BY,
652: CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN
653: ) SELECT

Line 660: FROM FND_OBJECTS_TL T

656: FROM FND_LANGUAGES L
657: WHERE L.INSTALLED_FLAG IN ('I','B')
658: AND NOT EXISTS
659: (SELECT NULL
660: FROM FND_OBJECTS_TL T
661: WHERE T.OBJECT_ID = key_id
662: AND T.LANGUAGE = l.language_code);
663:
664: end if;

Line 723: from FND_OBJECTS

719:
720: if (P_DEST_TABLE = 'O') then
721: Select object_id, last_updated_by, last_update_date
722: into key_id, f_luby, f_ludate
723: from FND_OBJECTS
724: where obj_name = P_OBJECT_NAME;
725: else
726: Select class_id, last_updated_by, last_update_date
727: into key_id, f_luby, f_ludate

Line 737: select DECODE(P_DEST_TABLE, 'C', 'FND_IREP_CLASSES', 'FND_OBJECTS'),

733: (OBJ_NAME, INSTANCE_PK1_VALUE,
734: LOOKUP_TYPE, LOOKUP_CODE, LOOKUP_ASSIGNMENT_ID,
735: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
736: LAST_UPDATE_LOGIN, DISPLAY_SEQUENCE)
737: select DECODE(P_DEST_TABLE, 'C', 'FND_IREP_CLASSES', 'FND_OBJECTS'),
738: key_id,
739: P_TYPE, P_CODE, FND_LOOKUP_ASSIGNMENTS_S.nextval,
740: f_luby, f_ludate, f_luby, f_ludate,
741: 0, P_SEQUENCE

Line 771: from FND_OBJECTS

767:
768: if (P_DEST_TABLE = 'O') then
769: Select object_id
770: into key_id
771: from FND_OBJECTS
772: where obj_name = P_OBJECT_NAME;
773: else
774: Select class_id
775: into key_id

Line 839: FROM FND_OBJECTS

835: end if;
836:
837: SELECT object_id
838: INTO obj_id
839: FROM FND_OBJECTS
840: WHERE OBJ_NAME = P_OBJECT_NAME;
841:
842: Insert into FND_OBJECT_TYPE_MEMBERS
843: (OBJECT_ID, MEMBER_SEQUENCE, INNERTYPE_SEQUENCE, MEMBER_NAME,

Line 996: FROM FND_OBJECTS

992: end if;
993:
994: SELECT object_id
995: INTO obj_id
996: FROM FND_OBJECTS
997: WHERE OBJ_NAME = P_OBJECT_NAME;
998:
999: Insert into FND_OBJECT_KEY_SETS
1000: (OBJECT_ID, KEY_SET_NAME, KEY_SET_SEQUENCE,