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_DIMENSION_UTIL_PKG dependencies on FEM_DIM_ATTRIBUTES_B

Line 343: FROM fem_dim_attributes_b

339: FROM fem_ledgers_attr f
340: WHERE f.ledger_id = v_ledger_id
341: AND f.attribute_id =
342: (SELECT attribute_id
343: FROM fem_dim_attributes_b
344: WHERE attribute_varchar_label = 'GLOBAL_VS_COMBO')
345: AND f.version_id =
346: (SELECT version_id
347: FROM fem_dim_attr_versions_b

Line 457: FROM fem_dim_attributes_b

453: FROM fem_ledgers_attr f
454: WHERE f.ledger_id = v_ledger_id
455: AND f.attribute_id =
456: (SELECT attribute_id
457: FROM fem_dim_attributes_b
458: WHERE attribute_varchar_label = 'GLOBAL_VS_COMBO')
459: AND f.version_id =
460: (SELECT version_id
461: FROM fem_dim_attr_versions_b

Line 737: FROM fem_dim_attributes_b

733: FROM fem_ledgers_attr f
734: WHERE f.ledger_id = v_current_session_ledger_id
735: AND f.attribute_id =
736: (SELECT attribute_id
737: FROM fem_dim_attributes_b
738: WHERE attribute_varchar_label = 'GLOBAL_VS_COMBO')
739: AND f.version_id =
740: (SELECT version_id
741: FROM fem_dim_attr_versions_b

Line 1119: v_dim_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;

1115: v_base_dimgrp_id FEM_CAL_PERIODS_B.calendar_id%TYPE;
1116: v_base_calendar_id FEM_CAL_PERIODS_B.dimension_group_id%TYPE;
1117: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
1118: v_dim_name FEM_DIMENSIONS_TL.dimension_name%TYPE;
1119: v_dim_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;
1120: v_dim_attr_ver_id FEM_DIM_ATTR_VERSIONS_B.version_id%TYPE;
1121: v_cal_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;
1122: v_cal_attr_ver_id FEM_DIM_ATTR_VERSIONS_B.version_id%TYPE;
1123: v_cal_attr_name FEM_DIM_ATTRIBUTES_TL.attribute_name%TYPE;

Line 1121: v_cal_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;

1117: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
1118: v_dim_name FEM_DIMENSIONS_TL.dimension_name%TYPE;
1119: v_dim_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;
1120: v_dim_attr_ver_id FEM_DIM_ATTR_VERSIONS_B.version_id%TYPE;
1121: v_cal_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;
1122: v_cal_attr_ver_id FEM_DIM_ATTR_VERSIONS_B.version_id%TYPE;
1123: v_cal_attr_name FEM_DIM_ATTRIBUTES_TL.attribute_name%TYPE;
1124: v_incl_adj_period FEM_CALENDARS_ATTR.dim_attribute_varchar_member%TYPE;
1125:

Line 1696: FROM fem_dim_attributes_b

1692:
1693:
1694: SELECT attribute_id
1695: INTO v_ledgerobj_attr_id
1696: FROM fem_dim_attributes_b
1697: WHERE attribute_varchar_label='CAL_PERIOD_HIER_OBJ_DEF_ID'
1698: AND dimension_id = v_ledger_dim_id;
1699:
1700: SELECT version_id

Line 1725: FROM fem_dim_attributes_b

1721: WHERE hierarchy_obj_id = v_ledger_calphier_obj_id;
1722:
1723: SELECT attribute_id
1724: INTO v_periodnum_attr_id
1725: FROM fem_dim_attributes_b
1726: WHERE attribute_varchar_label='GL_PERIOD_NUM'
1727: AND dimension_id = v_calp_dim_id;
1728:
1729: SELECT attribute_id

Line 1731: FROM fem_dim_attributes_b

1727: AND dimension_id = v_calp_dim_id;
1728:
1729: SELECT attribute_id
1730: INTO v_acctyear_attr_id
1731: FROM fem_dim_attributes_b
1732: WHERE attribute_varchar_label='ACCOUNTING_YEAR'
1733: AND dimension_id = v_calp_dim_id;
1734:
1735: SELECT version_id

Line 1835: FROM fem_dim_attributes_b

1831:
1832:
1833: SELECT attribute_id
1834: INTO v_ledgerobj_attr_id
1835: FROM fem_dim_attributes_b
1836: WHERE attribute_varchar_label='CAL_PERIOD_HIER_OBJ_DEF_ID'
1837: AND dimension_id = v_ledger_dim_id;
1838:
1839: SELECT version_id

Line 1864: FROM fem_dim_attributes_b

1860: WHERE hierarchy_obj_id = v_ledger_calphier_obj_id;
1861:
1862: SELECT attribute_id
1863: INTO v_periodnum_attr_id
1864: FROM fem_dim_attributes_b
1865: WHERE attribute_varchar_label='GL_PERIOD_NUM'
1866: AND dimension_id = v_calp_dim_id;
1867:
1868: SELECT attribute_id

Line 1870: FROM fem_dim_attributes_b

1866: AND dimension_id = v_calp_dim_id;
1867:
1868: SELECT attribute_id
1869: INTO v_enddate_attr_id
1870: FROM fem_dim_attributes_b
1871: WHERE attribute_varchar_label='CAL_PERIOD_END_DATE'
1872: AND dimension_id = v_calp_dim_id;
1873:
1874: SELECT version_id

Line 2027: FROM fem_dim_attributes_b

2023: THEN
2024: -- Grab the dataset balance type code
2025: SELECT attribute_value_column_name
2026: INTO v_bal_type_col
2027: FROM fem_dim_attributes_b
2028: WHERE dimension_id =
2029: (SELECT dimension_id
2030: FROM fem_dimensions_b
2031: WHERE dimension_varchar_label = 'DATASET')

Line 2040: ' FROM fem_dim_attributes_b'||

2036: ' FROM fem_datasets_attr A,fem_dim_attr_versions_b V'||
2037: ' WHERE dataset_code = :b_dataset_cd'||
2038: ' AND A.attribute_id = '||
2039: ' (SELECT attribute_id'||
2040: ' FROM fem_dim_attributes_b'||
2041: ' WHERE dimension_id ='||
2042: ' (SELECT dimension_id'||
2043: ' FROM fem_dimensions_b'||
2044: ' WHERE dimension_varchar_label = ''DATASET'')'||

Line 2557: fem_dim_attributes_b A,

2553: SELECT T.number_assign_value
2554: INTO v_num_of_periods
2555: FROM fem_time_grp_types_attr T,
2556: fem_dimension_grps_b G,
2557: fem_dim_attributes_b A,
2558: fem_dim_attr_versions_b V
2559: WHERE G.dimension_group_id = p_dim_grp_id
2560: AND A.attribute_varchar_label = 'PERIODS_IN_YEAR'
2561: AND A.attribute_id = T.attribute_id

Line 2631: fem_dim_attributes_b A,

2627: SELECT T.number_assign_value
2628: INTO v_num_of_periods
2629: FROM fem_time_grp_types_attr T,
2630: fem_dimension_grps_b G,
2631: fem_dim_attributes_b A,
2632: fem_dim_attr_versions_b V
2633: WHERE G.dimension_group_display_code = p_dim_grp_dc
2634: AND A.attribute_varchar_label = 'PERIODS_IN_YEAR'
2635: AND A.attribute_id = T.attribute_id

Line 2759: fem_dim_attributes_b A,

2755: SELECT T.number_assign_value
2756: INTO v_num_of_periods
2757: FROM fem_time_grp_types_attr T,
2758: fem_dimension_grps_b G,
2759: fem_dim_attributes_b A,
2760: fem_dim_attr_versions_b V
2761: WHERE G.dimension_group_id = p_dim_grp_id
2762: AND A.attribute_varchar_label = 'PERIODS_IN_YEAR'
2763: AND A.attribute_id = T.attribute_id

Line 2904: fem_dim_attributes_b A,

2900: SELECT T.number_assign_value
2901: INTO v_num_of_periods
2902: FROM fem_time_grp_types_attr T,
2903: fem_dimension_grps_b G,
2904: fem_dim_attributes_b A,
2905: fem_dim_attr_versions_b V
2906: WHERE G.dimension_group_id = p_dim_grp_id
2907: AND A.attribute_varchar_label = 'PERIODS_IN_YEAR'
2908: AND A.attribute_id = T.attribute_id

Line 3044: These assignments are defined in the fem_dim_attributes_b.

3040: default member display code.
3041:
3042: When each member is created, the procedure also creates the
3043: assignments for any required attributes of the dimension.
3044: These assignments are defined in the fem_dim_attributes_b.
3045:
3046: This procedure is run at installation time. It may also
3047: be called separately after installation.
3048:

Line 3099: FROM fem_dim_attributes_b A, fem_dim_attr_versions_b V

3095: A.attribute_data_type_code,
3096: A.default_assignment,
3097: A.default_assignment_vs_id,
3098: V.version_id
3099: FROM fem_dim_attributes_b A, fem_dim_attr_versions_b V
3100: WHERE A.attribute_required_flag = 'Y'
3101: AND A.dimension_id = p_dimension_id
3102: AND V.version_id =
3103: (SELECT min(version_id)

Line 4017: FROM fem_dim_attributes_b

4013: attribute_varchar_label,
4014: attribute_dimension_id,
4015: attribute_value_column_name,
4016: attribute_required_flag
4017: FROM fem_dim_attributes_b
4018: WHERE dimension_id =
4019: (SELECT dimension_id
4020: FROM fem_dimensions_b
4021: WHERE dimension_varchar_label = c_dim_label);

Line 4144: ' is in FEM_DIM_ATTRIBUTES_B but not in'||

4140: FEM_ENGINES_PKG.Tech_Message(
4141: p_severity => c_log_level_1,
4142: p_module => c_module_pkg||'.New_Dataset.bad_attr_list',
4143: p_msg_text => 'The Dataset attribute '||v_attr_label||
4144: ' is in FEM_DIM_ATTRIBUTES_B but not in'||
4145: ' the API''s list of attribute labels');
4146:
4147: FEM_ENGINES_PKG.Put_Message(
4148: p_app_name => 'FEM',

Line 4470: FROM fem_dim_attributes_b

4466: attribute_varchar_label,
4467: attribute_dimension_id,
4468: attribute_value_column_name,
4469: attribute_required_flag
4470: FROM fem_dim_attributes_b
4471: WHERE dimension_id =
4472: (SELECT dimension_id
4473: FROM fem_dimensions_b
4474: WHERE dimension_varchar_label = c_dim_label);

Line 4618: ' is in FEM_DIM_ATTRIBUTES_B but not in'||

4614: FEM_ENGINES_PKG.Tech_Message(
4615: p_severity => c_log_level_1,
4616: p_module => c_module_pkg||'.New_Dataset.bad_attr_list',
4617: p_msg_text => 'The Dataset attribute '||v_attr_label||
4618: ' is in FEM_DIM_ATTRIBUTES_B but not in'||
4619: ' the API''s list of attribute labels');
4620:
4621: FEM_ENGINES_PKG.Put_Message(
4622: p_app_name => 'FEM',

Line 4984: FROM fem_dim_attributes_b

4980: attribute_varchar_label,
4981: attribute_dimension_id,
4982: attribute_value_column_name,
4983: attribute_required_flag
4984: FROM fem_dim_attributes_b
4985: WHERE dimension_id =
4986: (SELECT dimension_id
4987: FROM fem_dimensions_b
4988: WHERE dimension_varchar_label = c_dim_label);

Line 5152: ' is in FEM_DIM_ATTRIBUTES_B but not in'||

5148: FEM_ENGINES_PKG.Tech_Message(
5149: p_severity => c_log_level_1,
5150: p_module => c_module_pkg||'.New_Ledger.bad_attr_list',
5151: p_msg_text => 'The Ledger attribute '||v_attr_label||
5152: ' is in FEM_DIM_ATTRIBUTES_B but not in'||
5153: ' the API''s list of attribute labels');
5154:
5155: FEM_ENGINES_PKG.Put_Message(
5156: p_app_name => 'FEM',

Line 5503: FROM fem_dim_attributes_b

5499: attribute_varchar_label,
5500: attribute_dimension_id,
5501: attribute_value_column_name,
5502: attribute_required_flag
5503: FROM fem_dim_attributes_b
5504: WHERE dimension_id =
5505: (SELECT dimension_id
5506: FROM fem_dimensions_b
5507: WHERE dimension_varchar_label = c_dim_label);

Line 5692: ' is in FEM_DIM_ATTRIBUTES_B but not in'||

5688: FEM_ENGINES_PKG.Tech_Message(
5689: p_severity => c_log_level_1,
5690: p_module => c_module_pkg||'.New_Ledger.bad_attr_list',
5691: p_msg_text => 'The Ledger attribute '||v_attr_label||
5692: ' is in FEM_DIM_ATTRIBUTES_B but not in'||
5693: ' the API''s list of attribute labels');
5694:
5695: FEM_ENGINES_PKG.Put_Message(
5696: p_app_name => 'FEM',

Line 6064: FROM fem_dim_attributes_b

6060: SELECT attribute_id,
6061: attribute_varchar_label,
6062: attribute_dimension_id,
6063: attribute_value_column_name
6064: FROM fem_dim_attributes_b
6065: WHERE dimension_id =
6066: (SELECT dimension_id
6067: FROM fem_dimensions_b
6068: WHERE dimension_varchar_label = 'BUDGET')

Line 6283: ' is in FEM_DIM_ATTRIBUTES_B but not in'||

6279: FEM_ENGINES_PKG.Tech_Message(
6280: p_severity => c_log_level_1,
6281: p_module => c_module_pkg||'.New_Budget.bad_attr_list',
6282: p_msg_text => 'The Budget attribute '||v_attr_label||
6283: ' is in FEM_DIM_ATTRIBUTES_B but not in'||
6284: ' the API''s list of attribute labels');
6285:
6286: FEM_ENGINES_PKG.Put_Message(
6287: p_app_name => 'FEM',

Line 6547: FROM fem_dim_attributes_b

6543: SELECT attribute_id,
6544: attribute_varchar_label,
6545: attribute_dimension_id,
6546: attribute_value_column_name
6547: FROM fem_dim_attributes_b
6548: WHERE dimension_id =
6549: (SELECT dimension_id
6550: FROM fem_dimensions_b
6551: WHERE dimension_varchar_label = 'BUDGET')

Line 6770: ' is in FEM_DIM_ATTRIBUTES_B but not in'||

6766: FEM_ENGINES_PKG.Tech_Message(
6767: p_severity => c_log_level_1,
6768: p_module => c_module_pkg||'.New_Budget.bad_attr_list',
6769: p_msg_text => 'The Budget attribute '||v_attr_label||
6770: ' is in FEM_DIM_ATTRIBUTES_B but not in'||
6771: ' the API''s list of attribute labels');
6772:
6773: FEM_ENGINES_PKG.Put_Message(
6774: p_app_name => 'FEM',

Line 7058: FROM fem_dim_attributes_b

7054: attribute_varchar_label,
7055: attribute_dimension_id,
7056: attribute_value_column_name,
7057: attribute_required_flag
7058: FROM fem_dim_attributes_b
7059: WHERE dimension_id =
7060: (SELECT dimension_id
7061: FROM fem_dimensions_b
7062: WHERE dimension_varchar_label = c_dim_label);

Line 7251: ' is in FEM_DIM_ATTRIBUTES_B but not in'||

7247: FEM_ENGINES_PKG.Tech_Message(
7248: p_severity => c_log_level_1,
7249: p_module => c_module_pkg||'.New_Ledger.bad_attr_list',
7250: p_msg_text => 'The Ledger attribute '||v_attr_label||
7251: ' is in FEM_DIM_ATTRIBUTES_B but not in'||
7252: ' the API''s list of attribute labels');
7253:
7254: FEM_ENGINES_PKG.Put_Message(
7255: p_app_name => 'FEM',

Line 7611: FROM fem_dim_attributes_b

7607: attribute_varchar_label,
7608: attribute_dimension_id,
7609: attribute_value_column_name,
7610: attribute_required_flag
7611: FROM fem_dim_attributes_b
7612: WHERE dimension_id =
7613: (SELECT dimension_id
7614: FROM fem_dimensions_b
7615: WHERE dimension_varchar_label = c_dim_label);

Line 7747: ' is in FEM_DIM_ATTRIBUTES_B but not in'||

7743: FEM_ENGINES_PKG.Tech_Message(
7744: p_severity => c_log_level_1,
7745: p_module => c_module_pkg||'.New_Encumbrance Type.bad_attr_list',
7746: p_msg_text => 'The Encumbrance Type attribute '||v_attr_label||
7747: ' is in FEM_DIM_ATTRIBUTES_B but not in'||
7748: ' the API''s list of attribute labels');
7749:
7750: FEM_ENGINES_PKG.Put_Message(
7751: p_app_name => 'FEM',

Line 8086: FROM fem_dim_attributes_b

8082: attribute_varchar_label,
8083: attribute_dimension_id,
8084: attribute_value_column_name,
8085: attribute_required_flag
8086: FROM fem_dim_attributes_b
8087: WHERE dimension_id =
8088: (SELECT dimension_id
8089: FROM fem_dimensions_b
8090: WHERE dimension_varchar_label = c_dim_label);

Line 8225: ' is in FEM_DIM_ATTRIBUTES_B but not in'||

8221: FEM_ENGINES_PKG.Tech_Message(
8222: p_severity => c_log_level_1,
8223: p_module => c_module_pkg||'.New_Encumbrance Type.bad_attr_list',
8224: p_msg_text => 'The Encumbrance Type attribute '||v_attr_label||
8225: ' is in FEM_DIM_ATTRIBUTES_B but not in'||
8226: ' the API''s list of attribute labels');
8227:
8228: FEM_ENGINES_PKG.Put_Message(
8229: p_app_name => 'FEM',

Line 8714: FROM fem_dim_attributes_b A,

8710: SELECT A.attribute_id,
8711: V.version_id
8712: INTO x_attr_id,
8713: x_ver_id
8714: FROM fem_dim_attributes_b A,
8715: fem_dim_attr_versions_b V
8716: WHERE attribute_varchar_label = p_attr_label
8717: AND dimension_id = p_dim_id
8718: AND A.attribute_id = V.attribute_id

Line 9025: FROM fem_dim_attributes_b B,

9021: BEGIN
9022:
9023: SELECT T.attribute_name
9024: INTO v_attr_name
9025: FROM fem_dim_attributes_b B,
9026: fem_dim_attributes_tl T
9027: WHERE B.attribute_varchar_label = p_attr_label
9028: AND B.dimension_id = p_dim_id
9029: AND T.attribute_id = B.attribute_id

Line 9051: FROM fem_dim_attributes_b AB,

9047: BEGIN
9048:
9049: SELECT AT.attribute_name
9050: INTO v_attr_name
9051: FROM fem_dim_attributes_b AB,
9052: fem_dim_attributes_tl AT,
9053: fem_dimensions_b DB
9054: WHERE AB.attribute_varchar_label = p_attr_label
9055: AND DB.dimension_varchar_label = p_dim_label