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_DEFINITION_B

Line 631: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

627: v_return_status VARCHAR2(30);
628: v_msg_count NUMBER;
629: v_msg_data VARCHAR2(4000);
630:
631: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
632: v_snap_objdef_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
633: v_snap_objdef_desc FEM_OBJECT_DEFINITION_TL.description%TYPE;
634: v_snap_start_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
635: v_snap_end_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;

Line 634: v_snap_start_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;

630:
631: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
632: v_snap_objdef_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
633: v_snap_objdef_desc FEM_OBJECT_DEFINITION_TL.description%TYPE;
634: v_snap_start_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
635: v_snap_end_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
636:
637:
638: e_unexp EXCEPTION;

Line 635: v_snap_end_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;

631: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
632: v_snap_objdef_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
633: v_snap_objdef_desc FEM_OBJECT_DEFINITION_TL.description%TYPE;
634: v_snap_start_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
635: v_snap_end_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
636:
637:
638: e_unexp EXCEPTION;
639: e_error EXCEPTION;

Line 875: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

871: v_return_status VARCHAR2(30);
872: v_msg_count NUMBER;
873: v_msg_data VARCHAR2(4000);
874:
875: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
876:
877: v_maprule_objdef_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
878: v_maprule_objdef_desc FEM_OBJECT_DEFINITION_TL.description%TYPE;
879: v_maprule_start_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;

Line 879: v_maprule_start_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;

875: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
876:
877: v_maprule_objdef_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
878: v_maprule_objdef_desc FEM_OBJECT_DEFINITION_TL.description%TYPE;
879: v_maprule_start_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
880: v_maprule_end_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
881:
882: v_snapshot_object_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
883:

Line 880: v_maprule_end_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;

876:
877: v_maprule_objdef_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
878: v_maprule_objdef_desc FEM_OBJECT_DEFINITION_TL.description%TYPE;
879: v_maprule_start_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
880: v_maprule_end_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
881:
882: v_snapshot_object_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
883:
884:

Line 882: v_snapshot_object_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

878: v_maprule_objdef_desc FEM_OBJECT_DEFINITION_TL.description%TYPE;
879: v_maprule_start_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
880: v_maprule_end_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
881:
882: v_snapshot_object_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
883:
884:
885: e_unexp EXCEPTION;
886: e_no_helper EXCEPTION;

Line 1115: v_dflt_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

1111: v_return_status VARCHAR2(30);
1112: v_msg_count NUMBER;
1113: v_msg_data VARCHAR2(4000);
1114:
1115: v_dflt_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
1116: v_map_rule_type_code FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
1117: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
1118: v_global_vs_combo_id fem_global_vs_combos_b.global_vs_combo_id%TYPE;
1119:

Line 1117: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

1113: v_msg_data VARCHAR2(4000);
1114:
1115: v_dflt_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
1116: v_map_rule_type_code FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
1117: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
1118: v_global_vs_combo_id fem_global_vs_combos_b.global_vs_combo_id%TYPE;
1119:
1120: e_unexp EXCEPTION;
1121: e_no_default EXCEPTION;

Line 1205: FROM fem_object_definition_b D, fem_alloc_br_objects O,

1201:
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

Line 1376: v_dflt_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

1372: v_msg_data VARCHAR2(4000);
1373:
1374: v_count NUMBER;
1375:
1376: v_dflt_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
1377: v_map_rule_type_code FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
1378: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
1379:
1380: v_global_vs_combo_id fem_global_vs_combos_b.global_vs_combo_id%TYPE;

Line 1378: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

1374: v_count NUMBER;
1375:
1376: v_dflt_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
1377: v_map_rule_type_code FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
1378: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_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;

Line 1384: v_seeded_dflt_obj_def_id fem_object_definition_b.object_definition_id%TYPE;

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;
1388: v_dflt_folder_id fem_object_catalog_b.folder_id%TYPE;

Line 1475: FROM fem_object_definition_b D, fem_alloc_br_objects O,

1471: ,x_msg_data => v_msg_data);
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

Line 1498: FROM fem_object_definition_b D, fem_alloc_br_objects O,

1494: SELECT D1.objdef, C1.object_id
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

Line 1505: fem_object_definition_b C1

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
1504: AND C.local_vs_combo_id IS NULL) D1,
1505: fem_object_definition_b C1
1506: WHERE D1.objdef = C1.object_definition_id;
1507:
1508:
1509:

Line 2105: FROM fem_object_definition_b

2101:
2102:
2103: cursor c_objdef (p_cond_object_id IN NUMBER) IS
2104: SELECT object_definition_id
2105: FROM fem_object_definition_b
2106: WHERE object_id = p_cond_object_id
2107: ORDER BY effective_end_date;
2108:
2109: -- Identify the condition components for that Condition Object:

Line 2115: fem_object_definition_b O,

2111: SELECT C.cond_component_obj_id, O.object_definition_id cond_comp_obj_def_id,
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;

Line 2210: FROM fem_object_definition_b

2206:
2207: -- initialize
2208: DELETE FROM fem_alloc_br_cond_sum_gt
2209: WHERE condition_obj_def_id IN (SELECT object_definition_id
2210: FROM fem_object_definition_b
2211: WHERE object_id = p_condition_object_id);
2212:
2213: SELECT meaning
2214: INTO v_any_table

Line 2563: v_dflt_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

2559:
2560: v_fem_obj_def_row FEM_OBJECT_DEFINITION_VL%ROWTYPE;
2561:
2562:
2563: v_dflt_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
2564: v_snap_obj_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
2565: v_snap_objdef_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
2566: v_map_rule_type_code FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
2567:

Line 2564: v_snap_obj_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

2560: v_fem_obj_def_row FEM_OBJECT_DEFINITION_VL%ROWTYPE;
2561:
2562:
2563: v_dflt_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
2564: v_snap_obj_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
2565: v_snap_objdef_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
2566: v_map_rule_type_code FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
2567:
2568:

Line 2565: v_snap_objdef_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

2561:
2562:
2563: v_dflt_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
2564: v_snap_obj_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
2565: v_snap_objdef_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
2566: v_map_rule_type_code FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
2567:
2568:
2569: v_folder_id fem_folders_b.folder_id%TYPE;

Line 2834: v_dflt_objdef_id fem_object_definition_b.object_definition_id%TYPE;

2830:
2831: v_count NUMBER;
2832:
2833: v_global_vs_combo_id fem_global_vs_combos_b.global_vs_combo_id%TYPE;
2834: v_dflt_objdef_id fem_object_definition_b.object_definition_id%TYPE;
2835:
2836:
2837: BEGIN
2838:

Line 2860: FROM fem_object_definition_b D, fem_alloc_br_objects O,

2856:
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

Line 2927: FROM fem_object_definition_b

2923:
2924:
2925: cursor c_objdef (p_cond_object_id IN NUMBER) IS
2926: SELECT object_definition_id
2927: FROM fem_object_definition_b
2928: WHERE object_id = p_fctr_object_id
2929: ORDER BY effective_end_date;
2930:
2931: -- Identify the factor table dimensions for that Factor Table Object:

Line 2985: FROM fem_object_definition_b

2981:
2982: -- initialize
2983: DELETE FROM fem_alloc_br_fctr_sum_gt
2984: WHERE factor_obj_def_id IN (SELECT object_definition_id
2985: FROM fem_object_definition_b
2986: WHERE object_id = p_fctr_object_id);
2987:
2988:
2989:

Line 3082: from fem_alloc_br_objects abo,fem_object_definition_b defs

3078: --Get the mapping Rule Type Code.
3079: BEGIN
3080:
3081: select map_rule_type_code into v_map_rule_type_code
3082: from fem_alloc_br_objects abo,fem_object_definition_b defs
3083: where defs.object_definition_id = p_object_definition_id
3084: and abo.map_rule_object_id = defs.object_id ;
3085:
3086: EXCEPTION