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_IREP_CLASSES

Line 140: from FND_IREP_CLASSES

136: where obj_name = P_OBJECT_NAME;
137: else
138: Select class_id, SOURCE_FILE_VERSION
139: into key_id, DB_Version
140: from FND_IREP_CLASSES
141: where class_name = P_OBJECT_NAME;
142: end if;
143: exception
144: when no_data_found then -- totally new object or class

Line 154: Update FND_IREP_CLASSES

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
155: set IREP_LDR_INTERNAL_FLAG = 'O'
156: where class_name = P_OBJECT_NAME;
157: end if;
158:

Line 167: Update FND_IREP_CLASSES

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
168: set IREP_LDR_INTERNAL_FLAG = null
169: where class_name = P_OBJECT_NAME;
170: end if;
171:

Line 203: from FND_IREP_CLASSES

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
203: from FND_IREP_CLASSES
204: where class_name = P_OBJECT_NAME;
205: end if;
206:
207: if (LDR_Flag = 'O') then

Line 320: from fnd_irep_classes

316:
317: if (P_DEST_TABLE = 'C') then
318: select CLASS_ID
319: into key_id
320: from fnd_irep_classes
321: where CLASS_NAME = P_OBJECT_NAME;
322: else
323: select OBJECT_ID
324: into key_id

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 359: update fnd_irep_classes

355: end if;
356: else
357: begin
358: if (P_DEST_TABLE = 'C') then
359: update fnd_irep_classes
360: set IREP_NAME = P_API_NAME,
361: CLASS_TYPE = P_OBJ_TYPE,
362: PRODUCT_CODE = NVL(LOWER(P_PRODUCT), 'fnd'),
363: DEPLOYED_FLAG = 'N',

Line 401: where obj_name = 'FND_IREP_CLASSES'

397: Delete from FND_IREP_CLASS_PARENT_ASSIGNS
398: where CLASS_NAME = P_OBJECT_NAME;
399:
400: Delete from FND_LOOKUP_ASSIGNMENTS
401: where obj_name = 'FND_IREP_CLASSES'
402: and INSTANCE_PK1_VALUE = to_char(key_id);
403:
404: Delete from FND_CHILD_ANNOTATIONS
405: where parent_id = key_id

Line 446: Delete from fnd_irep_classes

442:
443:
444: -- Remove derived entries classes and functions
445:
446: Delete from fnd_irep_classes
447: where assoc_class_id = key_id;
448: Delete from fnd_form_functions
449: where irep_class_id =
450: (select class_id

Line 451: from fnd_irep_classes

447: where assoc_class_id = key_id;
448: Delete from fnd_form_functions
449: where irep_class_id =
450: (select class_id
451: from fnd_irep_classes
452: where assoc_class_id = key_id);
453:
454: --Fetch and save menus and grants
455: GET_DELETE_GRANTS(key_id);

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 555: insert into fnd_irep_classes (

551: nice_oiflag
552: from dual;
553:
554: if (P_DEST_TABLE = 'C') then
555: insert into fnd_irep_classes (
556: IREP_NAME, CLASS_TYPE, PRODUCT_CODE, DEPLOYED_FLAG,
557: GENERATED_FLAG, IMPLEMENTATION_NAME, COMPATIBILITY_FLAG,
558: SCOPE_TYPE, MAP_CODE,
559: LIFECYCLE_MODE,

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 728: from FND_IREP_CLASSES

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
728: from FND_IREP_CLASSES
729: where class_name = P_OBJECT_NAME;
730: end if;
731:
732: Insert into FND_LOOKUP_ASSIGNMENTS

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 776: from FND_IREP_CLASSES

772: where obj_name = P_OBJECT_NAME;
773: else
774: Select class_id
775: into key_id
776: from FND_IREP_CLASSES
777: where class_name = P_OBJECT_NAME;
778: end if;
779:
780: Insert into FND_CHILD_ANNOTATIONS

Line 888: from FND_IREP_CLASSES

884: (CLASS_ID, TABLE_USED, DISPLAY_SEQUENCE,
885: TABLE_DIRECTION)
886: select class_id, UPPER(P_TABLE_NAME), P_UT_SEQ,
887: UPPER(NVL(P_UT_DIRECTION, 'I'))
888: from FND_IREP_CLASSES
889: where CLASS_NAME = P_OBJECT_NAME;
890: end;
891:
892:

Line 914: from FND_IREP_CLASSES

910:
911: Insert into FND_IREP_USES_MAPS
912: (CLASS_ID, MAP_USED, DISPLAY_SEQ)
913: select class_id, UPPER(P_MAP_NAME), P_UM_SEQ
914: from FND_IREP_CLASSES
915: where CLASS_NAME = P_OBJECT_NAME;
916: end;
917:
918:

Line 949: from FND_IREP_CLASSES

945: end if;
946:
947: Select class_id
948: into key_id
949: from FND_IREP_CLASSES
950: where class_name = P_OBJECT_NAME;
951:
952: Insert into FND_IREP_CLASS_DATASOURCES
953: (CLASS_ID, DATASOURCE_NAME, DEF_CLASS, QUERYABLE,

Line 1064: from FND_IREP_CLASSES c,

1060: if (P_UPLOAD_MODE = 'NLS') then
1061:
1062: Select c.class_id, c.last_updated_by, c.last_update_date, f.function_id
1063: into key_id, f_luby, f_ludate, fn_id
1064: from FND_IREP_CLASSES c,
1065: FND_FORM_FUNCTIONS f
1066: where c.class_name = P_OBJECT_NAME
1067: and f.irep_class_id = c.class_id
1068: and f.function_name = P_FUNCTION_NAME;

Line 1100: FROM FND_IREP_CLASSES C, FND_FORM_FUNCTIONS F

1096: FROM DUAL;
1097: SELECT C.class_id, C.last_updated_by, C.last_update_date,
1098: F.FUNCTION_ID
1099: INTO key_id, f_luby, f_ludate, fn_id
1100: FROM FND_IREP_CLASSES C, FND_FORM_FUNCTIONS F
1101: WHERE class_name = P_OBJECT_NAME
1102: AND F.FUNCTION_NAME = P_FUNCTION_NAME;
1103: exception
1104: when no_data_found then

Line 1108: from FND_IREP_CLASSES

1104: when no_data_found then
1105: Select class_id, last_updated_by, last_update_date,
1106: FND_FORM_FUNCTIONS_S.nextval, 1, 1
1107: into key_id, f_luby, f_ludate, fn_id, new_fn, primary_flavor
1108: from FND_IREP_CLASSES
1109: where class_name = P_OBJECT_NAME;
1110: Insert into FND_FORM_FUNCTIONS
1111: (FUNCTION_ID, FUNCTION_NAME, CREATION_DATE, CREATED_BY,
1112: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,

Line 1245: from FND_IREP_CLASSES C,

1241: select 'FND_IREP_FUNCTION_FLAVORS', f.function_id, P_OVERLOAD_SEQ,
1242: P_TYPE, P_CODE, FND_LOOKUP_ASSIGNMENTS_S.nextval, P_SEQUENCE,
1243: C.LAST_UPDATED_BY, C.LAST_UPDATE_DATE,
1244: C.LAST_UPDATED_BY, C.LAST_UPDATE_DATE, 0
1245: from FND_IREP_CLASSES C,
1246: FND_FORM_FUNCTIONS F
1247: where c.class_name = P_OBJECT_NAME
1248: and f.irep_class_id = c.class_id
1249: and f.function_name = P_FUNCTION_NAME;

Line 1277: from FND_IREP_CLASSES C,

1273:
1274: Insert into FND_CHILD_ANNOTATIONS
1275: (PARENT_ID, PARENT_ID2, PARENT_FLAG, CHILD_FLAG, ANNOTATION_VALUE)
1276: select f.function_id, P_OVERLOAD_SEQ, 'F', UPPER(P_CHILD_FLAG), P_VALUE
1277: from FND_IREP_CLASSES C,
1278: FND_FORM_FUNCTIONS F
1279: where c.class_name = P_OBJECT_NAME
1280: and f.irep_class_id = c.class_id
1281: and f.function_name = P_FUNCTION_NAME;

Line 1327: FROM FND_IREP_CLASSES C,

1323: SELECT f.function_id, UPPER(P_DIRECTION), UPPER(NVL(P_OPTIONAL,'N')),
1324: UPPER(P_NULL_ALLOWED), NVL(P_DISPLAYED, 'Y')
1325: INTO fn_id, nice_direct, nice_option,
1326: nice_nullok, nice_dispfl
1327: FROM FND_IREP_CLASSES C,
1328: FND_FORM_FUNCTIONS F
1329: WHERE C.CLASS_NAME = P_OBJECT_NAME
1330: AND F.IREP_CLASS_ID = C.CLASS_ID
1331: AND F.FUNCTION_NAME = P_FUNCTION_NAME;

Line 1387: fnd_irep_classes parent_c,

1383: parent_m.IREP_SCOPE, parent_m.IREP_LIFECYCLE,
1384: parent_m.IREP_DESCRIPTION, parent_m.IREP_COMPATIBILITY,
1385: parent_m.IREP_SYNCHRO, parent_m.IREP_DIRECTION
1386: from fnd_irep_class_parent_assigns ass,
1387: fnd_irep_classes parent_c,
1388: fnd_irep_classes child_c,
1389: fnd_form_functions parent_m
1390: where ass.Parent_class_name = Parent_c.class_name
1391: and ass.Class_name = Child_c.class_name

Line 1388: fnd_irep_classes child_c,

1384: parent_m.IREP_DESCRIPTION, parent_m.IREP_COMPATIBILITY,
1385: parent_m.IREP_SYNCHRO, parent_m.IREP_DIRECTION
1386: from fnd_irep_class_parent_assigns ass,
1387: fnd_irep_classes parent_c,
1388: fnd_irep_classes child_c,
1389: fnd_form_functions parent_m
1390: where ass.Parent_class_name = Parent_c.class_name
1391: and ass.Class_name = Child_c.class_name
1392: and parent_m.irep_class_id = parent_c.class_id

Line 1416: fnd_irep_classes parent_c,

1412: parent_tl.source_lang, sysdate,
1413: parent_tl.last_updated_by, parent_tl.created_by,
1414: sysdate, parent_tl.last_update_login
1415: from fnd_irep_class_parent_assigns ass,
1416: fnd_irep_classes parent_c,
1417: fnd_irep_classes child_c,
1418: fnd_form_functions parent_m,
1419: fnd_form_functions child_m,
1420: fnd_form_functions_tl parent_tl

Line 1417: fnd_irep_classes child_c,

1413: parent_tl.last_updated_by, parent_tl.created_by,
1414: sysdate, parent_tl.last_update_login
1415: from fnd_irep_class_parent_assigns ass,
1416: fnd_irep_classes parent_c,
1417: fnd_irep_classes child_c,
1418: fnd_form_functions parent_m,
1419: fnd_form_functions child_m,
1420: fnd_form_functions_tl parent_tl
1421: where ass.Parent_class_name = Parent_c.class_name

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;