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.FEM_ALLOC_BR_UTIL_PKG dependencies on FEM_OBJECT_CATALOG_B

Line 312: v_local_vs_combo_id FEM_OBJECT_CATALOG_B.local_vs_combo_id%TYPE;

308: e_helper_reg EXCEPTION;
309: e_objtype EXCEPTION;
310:
311: v_folder_id FEM_FOLDERS_B.folder_id%TYPE;
312: v_local_vs_combo_id FEM_OBJECT_CATALOG_B.local_vs_combo_id%TYPE;
313: v_object_access_code FEM_OBJECT_CATALOG_B.object_access_code%TYPE;
314: v_object_origin_code FEM_OBJECT_CATALOG_B.object_origin_code%TYPE;
315: v_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
316: v_description FEM_OBJECT_CATALOG_TL.description%TYPE;

Line 313: v_object_access_code FEM_OBJECT_CATALOG_B.object_access_code%TYPE;

309: e_objtype EXCEPTION;
310:
311: v_folder_id FEM_FOLDERS_B.folder_id%TYPE;
312: v_local_vs_combo_id FEM_OBJECT_CATALOG_B.local_vs_combo_id%TYPE;
313: v_object_access_code FEM_OBJECT_CATALOG_B.object_access_code%TYPE;
314: v_object_origin_code FEM_OBJECT_CATALOG_B.object_origin_code%TYPE;
315: v_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
316: v_description FEM_OBJECT_CATALOG_TL.description%TYPE;
317: v_display_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;

Line 314: v_object_origin_code FEM_OBJECT_CATALOG_B.object_origin_code%TYPE;

310:
311: v_folder_id FEM_FOLDERS_B.folder_id%TYPE;
312: v_local_vs_combo_id FEM_OBJECT_CATALOG_B.local_vs_combo_id%TYPE;
313: v_object_access_code FEM_OBJECT_CATALOG_B.object_access_code%TYPE;
314: v_object_origin_code FEM_OBJECT_CATALOG_B.object_origin_code%TYPE;
315: v_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
316: v_description FEM_OBJECT_CATALOG_TL.description%TYPE;
317: v_display_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
318: v_object_type_code FEM_OBJECT_CATALOG_B.object_type_code%TYPE;

Line 318: v_object_type_code FEM_OBJECT_CATALOG_B.object_type_code%TYPE;

314: v_object_origin_code FEM_OBJECT_CATALOG_B.object_origin_code%TYPE;
315: v_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
316: v_description FEM_OBJECT_CATALOG_TL.description%TYPE;
317: v_display_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
318: v_object_type_code FEM_OBJECT_CATALOG_B.object_type_code%TYPE;
319:
320: v_profile_start_value VARCHAR2(1000);
321: v_profile_end_value VARCHAR2(1000);
322: v_effective_start_date DATE;

Line 1206: fem_object_catalog_b C

1202: BEGIN
1203: SELECT min (D.object_definition_id)
1204: INTO v_dflt_obj_def_id
1205: FROM fem_object_definition_b D, fem_alloc_br_objects O,
1206: fem_object_catalog_b C
1207: WHERE C.object_id = D.object_id
1208: AND C.object_type_code = C_DFLT_OBJTYPE
1209: AND C.object_id = O.map_rule_object_id
1210: AND O.map_rule_type_code = v_map_rule_type_code

Line 1383: v_dflt_object_id fem_object_catalog_b.object_id%TYPE;

1379:
1380: v_global_vs_combo_id fem_global_vs_combos_b.global_vs_combo_id%TYPE;
1381: v_object_name fem_object_catalog_tl.object_name%TYPE;
1382: v_description fem_object_catalog_tl.description%TYPE;
1383: v_dflt_object_id fem_object_catalog_b.object_id%TYPE;
1384: v_seeded_dflt_obj_def_id fem_object_definition_b.object_definition_id%TYPE;
1385: v_seeded_dflt_object_id fem_object_catalog_b.object_id%TYPE;
1386: v_new_dflt_object_id fem_object_catalog_b.object_id%TYPE;
1387: v_folder_id fem_object_catalog_b.folder_id%TYPE;

Line 1385: v_seeded_dflt_object_id fem_object_catalog_b.object_id%TYPE;

1381: v_object_name fem_object_catalog_tl.object_name%TYPE;
1382: v_description fem_object_catalog_tl.description%TYPE;
1383: v_dflt_object_id fem_object_catalog_b.object_id%TYPE;
1384: v_seeded_dflt_obj_def_id fem_object_definition_b.object_definition_id%TYPE;
1385: v_seeded_dflt_object_id fem_object_catalog_b.object_id%TYPE;
1386: v_new_dflt_object_id fem_object_catalog_b.object_id%TYPE;
1387: v_folder_id fem_object_catalog_b.folder_id%TYPE;
1388: v_dflt_folder_id fem_object_catalog_b.folder_id%TYPE;
1389:

Line 1386: v_new_dflt_object_id fem_object_catalog_b.object_id%TYPE;

1382: v_description fem_object_catalog_tl.description%TYPE;
1383: v_dflt_object_id fem_object_catalog_b.object_id%TYPE;
1384: v_seeded_dflt_obj_def_id fem_object_definition_b.object_definition_id%TYPE;
1385: v_seeded_dflt_object_id fem_object_catalog_b.object_id%TYPE;
1386: v_new_dflt_object_id fem_object_catalog_b.object_id%TYPE;
1387: v_folder_id fem_object_catalog_b.folder_id%TYPE;
1388: v_dflt_folder_id fem_object_catalog_b.folder_id%TYPE;
1389:
1390: v_profile_start_value VARCHAR2(1000);

Line 1387: v_folder_id fem_object_catalog_b.folder_id%TYPE;

1383: v_dflt_object_id fem_object_catalog_b.object_id%TYPE;
1384: v_seeded_dflt_obj_def_id fem_object_definition_b.object_definition_id%TYPE;
1385: v_seeded_dflt_object_id fem_object_catalog_b.object_id%TYPE;
1386: v_new_dflt_object_id fem_object_catalog_b.object_id%TYPE;
1387: v_folder_id fem_object_catalog_b.folder_id%TYPE;
1388: v_dflt_folder_id fem_object_catalog_b.folder_id%TYPE;
1389:
1390: v_profile_start_value VARCHAR2(1000);
1391: v_profile_end_value VARCHAR2(1000);

Line 1388: v_dflt_folder_id fem_object_catalog_b.folder_id%TYPE;

1384: v_seeded_dflt_obj_def_id fem_object_definition_b.object_definition_id%TYPE;
1385: v_seeded_dflt_object_id fem_object_catalog_b.object_id%TYPE;
1386: v_new_dflt_object_id fem_object_catalog_b.object_id%TYPE;
1387: v_folder_id fem_object_catalog_b.folder_id%TYPE;
1388: v_dflt_folder_id fem_object_catalog_b.folder_id%TYPE;
1389:
1390: v_profile_start_value VARCHAR2(1000);
1391: v_profile_end_value VARCHAR2(1000);
1392: v_effective_start_date DATE;

Line 1476: fem_object_catalog_b C

1472:
1473: SELECT min (D.object_definition_id)
1474: INTO x_dflt_objdef_id
1475: FROM fem_object_definition_b D, fem_alloc_br_objects O,
1476: fem_object_catalog_b C
1477: WHERE C.object_id = D.object_id
1478: AND C.object_type_code = C_DFLT_OBJTYPE
1479: AND C.object_id = O.map_rule_object_id
1480: AND O.map_rule_type_code = p_map_rule_type_code

Line 1499: fem_object_catalog_b C

1495: INTO v_seeded_dflt_obj_def_id,v_seeded_dflt_object_id
1496: FROM
1497: (SELECT min (D.object_definition_id) objdef
1498: FROM fem_object_definition_b D, fem_alloc_br_objects O,
1499: fem_object_catalog_b C
1500: WHERE C.object_id = D.object_id
1501: AND C.object_type_code = C_DFLT_OBJTYPE
1502: AND C.object_id = O.map_rule_object_id
1503: AND O.map_rule_type_code = p_map_rule_type_code

Line 2116: fem_object_catalog_b OB

2112: C.data_dim_flag,
2113: OB.local_vs_combo_id global_vs_combo_id
2114: FROM fem_cond_components C,
2115: fem_object_definition_b O,
2116: fem_object_catalog_b OB
2117: WHERE C.cond_component_obj_id = O.object_id
2118: AND C.condition_obj_def_id = p_object_definition_id
2119: AND O.object_id = OB.object_id;
2120:

Line 2572: v_dflt_object_id fem_object_catalog_b.object_id%TYPE;

2568:
2569: v_folder_id fem_folders_b.folder_id%TYPE;
2570: v_object_name fem_object_catalog_tl.object_name%TYPE;
2571: v_description fem_object_catalog_tl.description%TYPE;
2572: v_dflt_object_id fem_object_catalog_b.object_id%TYPE;
2573:
2574:
2575: e_unexp EXCEPTION;
2576: e_no_default EXCEPTION;

Line 2637: FROM fem_object_catalog_b C, fem_alloc_br_objects O

2633: BEGIN
2634:
2635: SELECT O.map_rule_type_code, C.folder_id
2636: INTO v_map_rule_type_code, v_folder_id
2637: FROM fem_object_catalog_b C, fem_alloc_br_objects O
2638: WHERE C.object_id = p_map_rule_obj_id
2639: AND C.object_type_code = 'MAPPING_RULE'
2640: AND C.object_id = O.map_rule_object_id;
2641:

Line 2861: fem_object_catalog_b C

2857: BEGIN
2858: SELECT min (D.object_definition_id)
2859: INTO v_dflt_objdef_id
2860: FROM fem_object_definition_b D, fem_alloc_br_objects O,
2861: fem_object_catalog_b C
2862: WHERE C.object_id = D.object_id
2863: AND C.object_type_code = C_DFLT_OBJTYPE
2864: AND C.object_id = O.map_rule_object_id
2865: AND O.map_rule_type_code = p_map_rule_type_code