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_FORM_FUNCTIONS

Line 18: type t_fnd_form_functions IS TABLE OF fnd_form_functions % rowtype;

14: x_rowid VARCHAR2(64);
15: type t_fnd_grants IS TABLE OF fnd_grants % rowtype;
16: type t_fnd_menus IS TABLE OF fnd_menus % rowtype;
17: type t_fnd_menu_entries IS TABLE OF fnd_menu_entries % rowtype;
18: type t_fnd_form_functions IS TABLE OF fnd_form_functions % rowtype;
19:
20: function_id fnd_form_functions.function_id%TYPE;
21: menu_id fnd_menus.menu_id%TYPE;
22:

Line 20: function_id fnd_form_functions.function_id%TYPE;

16: type t_fnd_menus IS TABLE OF fnd_menus % rowtype;
17: type t_fnd_menu_entries IS TABLE OF fnd_menu_entries % rowtype;
18: type t_fnd_form_functions IS TABLE OF fnd_form_functions % rowtype;
19:
20: function_id fnd_form_functions.function_id%TYPE;
21: menu_id fnd_menus.menu_id%TYPE;
22:
23: type t_fnd_menus_tl IS TABLE OF fnd_menus_tl % rowtype;
24: type t_fnd_menu_entries_tl IS TABLE OF fnd_menu_entries_tl % rowtype;

Line 25: type t_fnd_form_functions_tl IS TABLE OF fnd_form_functions_tl % rowtype;

21: menu_id fnd_menus.menu_id%TYPE;
22:
23: type t_fnd_menus_tl IS TABLE OF fnd_menus_tl % rowtype;
24: type t_fnd_menu_entries_tl IS TABLE OF fnd_menu_entries_tl % rowtype;
25: type t_fnd_form_functions_tl IS TABLE OF fnd_form_functions_tl % rowtype;
26:
27:
28: -- to store existing menus and grants
29: v_fnd_grants t_fnd_grants;

Line 32: v_fnd_form_functions t_fnd_form_functions;

28: -- to store existing menus and grants
29: v_fnd_grants t_fnd_grants;
30: v_fnd_menus t_fnd_menus;
31: v_fnd_menu_entries t_fnd_menu_entries;
32: v_fnd_form_functions t_fnd_form_functions;
33: v_fnd_menus_tl t_fnd_menus_tl;
34: v_fnd_menu_entries_tl t_fnd_menu_entries_tl;
35: v_fnd_grants_new t_fnd_grants;
36: v_fnd_menus_new t_fnd_menus;

Line 38: v_fnd_form_functions_new t_fnd_form_functions;

34: v_fnd_menu_entries_tl t_fnd_menu_entries_tl;
35: v_fnd_grants_new t_fnd_grants;
36: v_fnd_menus_new t_fnd_menus;
37: v_fnd_menu_entries_new t_fnd_menu_entries;
38: v_fnd_form_functions_new t_fnd_form_functions;
39: v_fnd_menus_tl_new t_fnd_menus_tl;
40: v_fnd_menu_entries_tl_new t_fnd_menu_entries_tl;
41:
42: menu_entry_count number;

Line 220: if v_fnd_form_functions is not null then

216:
217: begin
218:
219: -- Delete collections
220: if v_fnd_form_functions is not null then
221: v_fnd_form_functions.DELETE;
222: end if;
223: if v_fnd_menu_entries is not null then
224: v_fnd_menu_entries.DELETE;

Line 221: v_fnd_form_functions.DELETE;

217: begin
218:
219: -- Delete collections
220: if v_fnd_form_functions is not null then
221: v_fnd_form_functions.DELETE;
222: end if;
223: if v_fnd_menu_entries is not null then
224: v_fnd_menu_entries.DELETE;
225: end if;

Line 419: from FND_FORM_FUNCTIONS

415: Delete from FND_LOOKUP_ASSIGNMENTS
416: where obj_name = 'FND_IREP_FUNCTION_FLAVORS'
417: and INSTANCE_PK1_VALUE in
418: (select function_id
419: from FND_FORM_FUNCTIONS
420: where irep_class_id = key_id);
421:
422: Delete from FND_CHILD_ANNOTATIONS
423: where parent_flag = 'F'

Line 426: from FND_FORM_FUNCTIONS

422: Delete from FND_CHILD_ANNOTATIONS
423: where parent_flag = 'F'
424: and parent_id in
425: (select function_id
426: from FND_FORM_FUNCTIONS
427: where irep_class_id = key_id);
428:
429: Delete from FND_PARAMETERS
430: where function_id in

Line 432: from FND_FORM_FUNCTIONS

428:
429: Delete from FND_PARAMETERS
430: where function_id in
431: (select function_id
432: from FND_FORM_FUNCTIONS
433: where irep_class_id = key_id);
434:
435: -- remove flavors
436: Delete from FND_IREP_FUNCTION_FLAVORS

Line 439: from FND_FORM_FUNCTIONS

435: -- remove flavors
436: Delete from FND_IREP_FUNCTION_FLAVORS
437: where FUNCTION_ID in
438: (select function_id
439: from FND_FORM_FUNCTIONS
440: where irep_class_id = key_id);
441:
442:
443:

Line 448: Delete from fnd_form_functions

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
451: from fnd_irep_classes
452: where assoc_class_id = key_id);

Line 1065: FND_FORM_FUNCTIONS f

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;
1069:

Line 1070: update FND_FORM_FUNCTIONS_TL

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;
1069:
1070: update FND_FORM_FUNCTIONS_TL
1071: set source_lang=userenv('LANG'),
1072: USER_FUNCTION_NAME = nvl(P_USER_FN_NAME, USER_FUNCTION_NAME),
1073: DESCRIPTION = nvl(P_SHORT_DESCRIPTION, DESCRIPTION),
1074: last_updated_by = f_luby,

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 1106: FND_FORM_FUNCTIONS_S.nextval, 1, 1

1102: AND F.FUNCTION_NAME = P_FUNCTION_NAME;
1103: exception
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

Line 1110: Insert into FND_FORM_FUNCTIONS

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,
1113: TYPE,
1114: IREP_CLASS_ID, MAINTENANCE_MODE_SUPPORT, CONTEXT_DEPENDENCE,

Line 1126: Insert into FND_FORM_FUNCTIONS_TL

1122: P_METHOD_NAME, P_OVERLOAD_SEQ, nice_scope,
1123: nice_lifecy, P_DESCRIPTION,
1124: nice_compat, nice_synch, nice_direct);
1125:
1126: Insert into FND_FORM_FUNCTIONS_TL
1127: (FUNCTION_ID, USER_FUNCTION_NAME, DESCRIPTION, language,
1128: source_lang, last_update_date, last_updated_by,
1129: created_by, creation_date, last_update_login
1130: ) select

Line 1137: from FND_FORM_FUNCTIONS_TL t

1133: from fnd_languages l
1134: where l.installed_flag in ('I','B')
1135: and not exists
1136: (select null
1137: from FND_FORM_FUNCTIONS_TL t
1138: where t.FUNCTION_ID = fn_id
1139: and t.language = l.language_code);
1140:
1141: -- Restore earlier saved grants

Line 1154: Update FND_FORM_FUNCTIONS

1150: primary_flavor := 0;
1151: end if;
1152:
1153: -- update function and tl
1154: Update FND_FORM_FUNCTIONS
1155: set FUNCTION_NAME = P_FUNCTION_NAME,
1156: LAST_UPDATE_DATE = f_ludate,
1157: LAST_UPDATED_BY = f_luby,
1158: LAST_UPDATE_LOGIN = 0,

Line 1189: UPDATE FND_FORM_FUNCTIONS

1185: WHERE FUNCTION_ID = fn_id;
1186:
1187: if (primary_flavor = 1) then
1188: /* try to avoid ora-01461 */
1189: UPDATE FND_FORM_FUNCTIONS
1190: SET IREP_DESCRIPTION = P_DESCRIPTION
1191: WHERE FUNCTION_ID = fn_id;
1192:
1193: UPDATE FND_FORM_FUNCTIONS_TL

Line 1193: UPDATE FND_FORM_FUNCTIONS_TL

1189: UPDATE FND_FORM_FUNCTIONS
1190: SET IREP_DESCRIPTION = P_DESCRIPTION
1191: WHERE FUNCTION_ID = fn_id;
1192:
1193: UPDATE FND_FORM_FUNCTIONS_TL
1194: SET USER_FUNCTION_NAME = P_USER_FN_NAME,
1195: DESCRIPTION = P_SHORT_DESCRIPTION,
1196: last_update_date = f_ludate,
1197: last_updated_by = f_luby,

Line 1246: FND_FORM_FUNCTIONS F

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;
1250: end;

Line 1278: FND_FORM_FUNCTIONS F

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;
1282: end;

Line 1328: FND_FORM_FUNCTIONS F

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;
1332:

Line 1363: Insert into FND_FORM_FUNCTIONS (

1359:
1360: Begin
1361: /* Keep copying methods to inheriting classes until no more to copy */
1362: LOOP
1363: Insert into FND_FORM_FUNCTIONS (
1364: irep_class_id,
1365: function_id,
1366: function_name,
1367: CREATION_DATE, CREATED_BY,

Line 1376: fnd_form_functions_s.nextval,

1372: IREP_SCOPE, IREP_LIFECYCLE,
1373: IREP_DESCRIPTION, IREP_COMPATIBILITY,
1374: IREP_SYNCHRO, IREP_DIRECTION)
1375: select child_c.class_id,
1376: fnd_form_functions_s.nextval,
1377: child_c.class_name || ':' || parent_m.irep_method_name,
1378: sysdate, parent_m.CREATED_BY,
1379: sysdate, parent_m.LAST_UPDATED_BY, parent_m.LAST_UPDATE_LOGIN,
1380: parent_m.TYPE,

Line 1389: fnd_form_functions parent_m

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
1393: and not exists (

Line 1395: from fnd_form_functions child_m

1391: and ass.Class_name = Child_c.class_name
1392: and parent_m.irep_class_id = parent_c.class_id
1393: and not exists (
1394: select 1
1395: from fnd_form_functions child_m
1396: where child_m.irep_class_id = child_c.class_id
1397: and child_m.function_name =
1398: child_c.class_name || ':' || parent_m.irep_method_name);
1399:

Line 1404: Insert into FND_FORM_FUNCTIONS_TL (

1400: EXIT WHEN (SQL%ROWCOUNT=0);
1401: END LOOP;
1402:
1403: /* Insert TL shadow rows (for newly created base rows) */
1404: Insert into FND_FORM_FUNCTIONS_TL (
1405: FUNCTION_ID, USER_FUNCTION_NAME,
1406: DESCRIPTION, language,
1407: source_lang, last_update_date,
1408: last_updated_by, created_by,

Line 1418: fnd_form_functions parent_m,

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
1422: and ass.Class_name = Child_c.class_name

Line 1419: fnd_form_functions child_m,

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
1422: and ass.Class_name = Child_c.class_name
1423: and parent_m.irep_class_id = parent_c.class_id

Line 1420: fnd_form_functions_tl parent_tl

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
1422: and ass.Class_name = Child_c.class_name
1423: and parent_m.irep_class_id = parent_c.class_id
1424: and child_m.irep_class_id = child_c.class_id

Line 1430: from fnd_form_functions_tl child_tl

1426: child_c.class_name || ':' || parent_m.irep_method_name
1427: and parent_tl.function_id = parent_m.function_id
1428: and not exists (
1429: select 1
1430: from fnd_form_functions_tl child_tl
1431: where child_tl.function_id = child_m.function_id
1432: and child_tl.source_lang = parent_tl.source_lang
1433: and child_tl.language = parent_tl.language);
1434:

Line 1486: INTO v_fnd_form_functions

1482: v_fnd_menus_tl := t_fnd_menus_tl();
1483: v_fnd_grants := t_fnd_grants();
1484:
1485: SELECT *bulk collect
1486: INTO v_fnd_form_functions
1487: FROM fnd_form_functions
1488: WHERE irep_class_id = key_id;
1489:
1490:

Line 1487: FROM fnd_form_functions

1483: v_fnd_grants := t_fnd_grants();
1484:
1485: SELECT *bulk collect
1486: INTO v_fnd_form_functions
1487: FROM fnd_form_functions
1488: WHERE irep_class_id = key_id;
1489:
1490:
1491: if v_fnd_form_functions is not null and v_fnd_form_functions.count > 0 then

Line 1491: if v_fnd_form_functions is not null and v_fnd_form_functions.count > 0 then

1487: FROM fnd_form_functions
1488: WHERE irep_class_id = key_id;
1489:
1490:
1491: if v_fnd_form_functions is not null and v_fnd_form_functions.count > 0 then
1492: FOR i IN v_fnd_form_functions.FIRST .. v_fnd_form_functions.LAST
1493: LOOP
1494: function_id := v_fnd_form_functions(i).function_id;
1495:

Line 1492: FOR i IN v_fnd_form_functions.FIRST .. v_fnd_form_functions.LAST

1488: WHERE irep_class_id = key_id;
1489:
1490:
1491: if v_fnd_form_functions is not null and v_fnd_form_functions.count > 0 then
1492: FOR i IN v_fnd_form_functions.FIRST .. v_fnd_form_functions.LAST
1493: LOOP
1494: function_id := v_fnd_form_functions(i).function_id;
1495:
1496: IF v_fnd_form_functions(i).function_id IS NOT NULL THEN

Line 1494: function_id := v_fnd_form_functions(i).function_id;

1490:
1491: if v_fnd_form_functions is not null and v_fnd_form_functions.count > 0 then
1492: FOR i IN v_fnd_form_functions.FIRST .. v_fnd_form_functions.LAST
1493: LOOP
1494: function_id := v_fnd_form_functions(i).function_id;
1495:
1496: IF v_fnd_form_functions(i).function_id IS NOT NULL THEN
1497:
1498:

Line 1496: IF v_fnd_form_functions(i).function_id IS NOT NULL THEN

1492: FOR i IN v_fnd_form_functions.FIRST .. v_fnd_form_functions.LAST
1493: LOOP
1494: function_id := v_fnd_form_functions(i).function_id;
1495:
1496: IF v_fnd_form_functions(i).function_id IS NOT NULL THEN
1497:
1498:
1499: -- temp table values are in v_fnd_menu_entries_new
1500: SELECT *bulk collect

Line 1503: WHERE function_id = v_fnd_form_functions(i).function_id;

1499: -- temp table values are in v_fnd_menu_entries_new
1500: SELECT *bulk collect
1501: INTO v_fnd_menu_entries_new
1502: FROM fnd_menu_entries
1503: WHERE function_id = v_fnd_form_functions(i).function_id;
1504:
1505: -- appended table values are in v_fnd_menu_entries
1506: v_fnd_menu_entries.extend(1);
1507: menu_entry_count := v_fnd_menu_entries.last;

Line 1622: fnd_form_functions_pkg.delete_row(v_fnd_form_functions(i).function_id);

1618:
1619: END IF;
1620:
1621: -- remove fucntions
1622: fnd_form_functions_pkg.delete_row(v_fnd_form_functions(i).function_id);
1623:
1624: END LOOP;
1625: end if;
1626:

Line 1648: IF v_fnd_form_functions is not null and v_fnd_form_functions.COUNT > 0 THEN

1644: error1 varchar2(300);
1645: BEGIN
1646: --t_menu_id := fnd_menus_s.nextval;
1647: select fnd_menus_s.nextval into t_menu_id from dual;
1648: IF v_fnd_form_functions is not null and v_fnd_form_functions.COUNT > 0 THEN
1649:
1650: FOR i IN v_fnd_form_functions.FIRST .. v_fnd_form_functions.LAST
1651: LOOP
1652: IF v_fnd_form_functions(i).function_name = f_name THEN

Line 1650: FOR i IN v_fnd_form_functions.FIRST .. v_fnd_form_functions.LAST

1646: --t_menu_id := fnd_menus_s.nextval;
1647: select fnd_menus_s.nextval into t_menu_id from dual;
1648: IF v_fnd_form_functions is not null and v_fnd_form_functions.COUNT > 0 THEN
1649:
1650: FOR i IN v_fnd_form_functions.FIRST .. v_fnd_form_functions.LAST
1651: LOOP
1652: IF v_fnd_form_functions(i).function_name = f_name THEN
1653:
1654: IF v_fnd_menu_entries is not null and v_fnd_menu_entries.count > 0 then

Line 1652: IF v_fnd_form_functions(i).function_name = f_name THEN

1648: IF v_fnd_form_functions is not null and v_fnd_form_functions.COUNT > 0 THEN
1649:
1650: FOR i IN v_fnd_form_functions.FIRST .. v_fnd_form_functions.LAST
1651: LOOP
1652: IF v_fnd_form_functions(i).function_name = f_name THEN
1653:
1654: IF v_fnd_menu_entries is not null and v_fnd_menu_entries.count > 0 then
1655:
1656: FOR k IN v_fnd_menu_entries.FIRST .. v_fnd_menu_entries.LAST

Line 1659: IF v_fnd_menu_entries(k).function_id = v_fnd_form_functions(i).function_id THEN

1655:
1656: FOR k IN v_fnd_menu_entries.FIRST .. v_fnd_menu_entries.LAST
1657: LOOP
1658:
1659: IF v_fnd_menu_entries(k).function_id = v_fnd_form_functions(i).function_id THEN
1660:
1661: FOR j IN v_fnd_menu_entries_tl.FIRST .. v_fnd_menu_entries_tl.LAST
1662: LOOP
1663: