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_ATTR_VERSIONS_B

Line 347: FROM fem_dim_attr_versions_b

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
348: WHERE attribute_id = f.attribute_id
349: AND default_version_flag = 'Y');
350: EXCEPTION
351: WHEN no_data_found THEN

Line 461: FROM fem_dim_attr_versions_b

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
462: WHERE attribute_id = f.attribute_id
463: AND default_version_flag = 'Y');
464: EXCEPTION
465: WHEN no_data_found THEN

Line 741: FROM fem_dim_attr_versions_b

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
742: WHERE attribute_id = f.attribute_id
743: AND default_version_flag = 'Y');
744: EXCEPTION
745: WHEN no_data_found THEN

Line 1120: v_dim_attr_ver_id FEM_DIM_ATTR_VERSIONS_B.version_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;
1124: v_incl_adj_period FEM_CALENDARS_ATTR.dim_attribute_varchar_member%TYPE;

Line 1122: v_cal_attr_ver_id FEM_DIM_ATTR_VERSIONS_B.version_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:
1126: v_return_code NUMBER;

Line 1702: FROM fem_dim_attr_versions_b

1698: AND dimension_id = v_ledger_dim_id;
1699:
1700: SELECT version_id
1701: INTO v_ledgerobj_vers_id
1702: FROM fem_dim_attr_versions_b
1703: WHERE attribute_id = v_ledgerobj_attr_id
1704: AND default_version_flag='Y';
1705:
1706: SELECT dim_attribute_numeric_member

Line 1737: FROM fem_dim_attr_versions_b

1733: AND dimension_id = v_calp_dim_id;
1734:
1735: SELECT version_id
1736: INTO v_periodnum_vers_id
1737: FROM fem_dim_attr_versions_b
1738: WHERE attribute_id = v_periodnum_attr_id
1739: AND default_version_flag = 'Y';
1740:
1741: SELECT version_id

Line 1743: FROM fem_dim_attr_versions_b

1739: AND default_version_flag = 'Y';
1740:
1741: SELECT version_id
1742: INTO v_acctyear_vers_id
1743: FROM fem_dim_attr_versions_b
1744: WHERE attribute_id = v_acctyear_attr_id
1745: AND default_version_flag = 'Y';
1746:
1747:

Line 1841: FROM fem_dim_attr_versions_b

1837: AND dimension_id = v_ledger_dim_id;
1838:
1839: SELECT version_id
1840: INTO v_ledgerobj_vers_id
1841: FROM fem_dim_attr_versions_b
1842: WHERE attribute_id = v_ledgerobj_attr_id
1843: AND default_version_flag='Y';
1844:
1845: SELECT dim_attribute_numeric_member

Line 1876: FROM fem_dim_attr_versions_b

1872: AND dimension_id = v_calp_dim_id;
1873:
1874: SELECT version_id
1875: INTO v_periodnum_vers_id
1876: FROM fem_dim_attr_versions_b
1877: WHERE attribute_id = v_periodnum_attr_id
1878: AND default_version_flag = 'Y';
1879:
1880: SELECT version_id

Line 1882: FROM fem_dim_attr_versions_b

1878: AND default_version_flag = 'Y';
1879:
1880: SELECT version_id
1881: INTO v_enddate_vers_id
1882: FROM fem_dim_attr_versions_b
1883: WHERE attribute_id = v_enddate_attr_id
1884: AND default_version_flag = 'Y';
1885:
1886:

Line 2036: ' FROM fem_datasets_attr A,fem_dim_attr_versions_b V'||

2032: AND attribute_varchar_label = 'DATASET_BALANCE_TYPE_CODE';
2033:
2034: v_sql_cmd :=
2035: 'SELECT '||v_bal_type_col||
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'||

Line 2558: fem_dim_attr_versions_b V

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
2562: AND G.time_group_type_code = T.time_group_type_code

Line 2632: fem_dim_attr_versions_b V

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
2636: AND G.time_group_type_code = T.time_group_type_code

Line 2760: fem_dim_attr_versions_b V

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
2764: AND G.time_group_type_code = T.time_group_type_code

Line 2905: fem_dim_attr_versions_b V

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
2909: AND G.time_group_type_code = T.time_group_type_code

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 3104: FROM fem_dim_attr_versions_b V2

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)
3104: FROM fem_dim_attr_versions_b V2
3105: WHERE V2.attribute_id = A.attribute_id
3106: AND V2.default_version_flag = 'Y');
3107:
3108: BEGIN

Line 4088: FROM fem_dim_attr_versions_b

4084: -- Check Attribute's Version --
4085: -------------------------------
4086: SELECT MIN(version_id)
4087: INTO v_ver_id
4088: FROM fem_dim_attr_versions_b
4089: WHERE attribute_id = v_attr_id
4090: AND default_version_flag = 'Y';
4091:
4092: IF (v_ver_id IS NULL)

Line 4102: SELECT fem_dim_attr_versions_b_s.NEXTVAL

4098: THEN
4099: RAISE e_no_version_name;
4100: END IF;
4101:
4102: SELECT fem_dim_attr_versions_b_s.NEXTVAL
4103: INTO v_ver_id FROM dual;
4104:
4105: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
4106: x_rowid => v_row_id,

Line 4562: FROM fem_dim_attr_versions_b

4558: -- Check Attribute's Version --
4559: -------------------------------
4560: SELECT MIN(version_id)
4561: INTO v_ver_id
4562: FROM fem_dim_attr_versions_b
4563: WHERE attribute_id = v_attr_id
4564: AND default_version_flag = 'Y';
4565:
4566: IF (v_ver_id IS NULL)

Line 4576: SELECT fem_dim_attr_versions_b_s.NEXTVAL

4572: THEN
4573: RAISE e_no_version_name;
4574: END IF;
4575:
4576: SELECT fem_dim_attr_versions_b_s.NEXTVAL
4577: INTO v_ver_id FROM dual;
4578:
4579: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
4580: x_rowid => v_row_id,

Line 5052: FROM fem_dim_attr_versions_b

5048: -- Check Attribute's Version --
5049: -------------------------------
5050: SELECT MIN(version_id)
5051: INTO v_ver_id
5052: FROM fem_dim_attr_versions_b
5053: WHERE attribute_id = v_attr_id
5054: AND default_version_flag = 'Y';
5055:
5056: IF (v_ver_id IS NULL)

Line 5066: SELECT fem_dim_attr_versions_b_s.NEXTVAL

5062: THEN
5063: RAISE e_no_version_name;
5064: END IF;
5065:
5066: SELECT fem_dim_attr_versions_b_s.NEXTVAL
5067: INTO v_ver_id FROM dual;
5068:
5069: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
5070: x_rowid => v_row_id,

Line 5592: FROM fem_dim_attr_versions_b

5588: -- Check Attribute's Version --
5589: -------------------------------
5590: SELECT MIN(version_id)
5591: INTO v_ver_id
5592: FROM fem_dim_attr_versions_b
5593: WHERE attribute_id = v_attr_id
5594: AND default_version_flag = 'Y';
5595:
5596: IF (v_ver_id IS NULL)

Line 5606: SELECT fem_dim_attr_versions_b_s.NEXTVAL

5602: THEN
5603: RAISE e_no_version_name;
5604: END IF;
5605:
5606: SELECT fem_dim_attr_versions_b_s.NEXTVAL
5607: INTO v_ver_id FROM dual;
5608:
5609: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
5610: x_rowid => v_row_id,

Line 6155: FROM fem_dim_attr_versions_b

6151: -------------------------------
6152: BEGIN
6153: SELECT MIN(version_id)
6154: INTO v_version_id
6155: FROM fem_dim_attr_versions_b
6156: WHERE attribute_id = v_attribute_id
6157: AND default_version_flag = 'Y';
6158: EXCEPTION
6159: WHEN no_data_found THEN

Line 6172: SELECT fem_dim_attr_versions_b_s.NEXTVAL

6168: THEN
6169: RAISE e_no_version_name;
6170: END IF;
6171:
6172: SELECT fem_dim_attr_versions_b_s.NEXTVAL
6173: INTO v_version_id FROM dual;
6174:
6175: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
6176: x_rowid => v_row_id,

Line 6641: FROM fem_dim_attr_versions_b

6637: -- Check Attribute Version --
6638: -------------------------------
6639: SELECT MIN(version_id)
6640: INTO v_version_id
6641: FROM fem_dim_attr_versions_b
6642: WHERE attribute_id = v_attribute_id
6643: AND default_version_flag = 'Y';
6644:
6645: IF (v_version_id IS NULL)

Line 6659: SELECT fem_dim_attr_versions_b_s.NEXTVAL

6655: THEN
6656: RAISE e_no_version_name;
6657: END IF;
6658:
6659: SELECT fem_dim_attr_versions_b_s.NEXTVAL
6660: INTO v_version_id FROM dual;
6661:
6662: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
6663: x_rowid => v_row_id,

Line 7151: FROM fem_dim_attr_versions_b

7147: -- Check Attribute's Version --
7148: -------------------------------
7149: SELECT MIN(version_id)
7150: INTO v_ver_id
7151: FROM fem_dim_attr_versions_b
7152: WHERE attribute_id = v_attr_id
7153: AND default_version_flag = 'Y';
7154:
7155: IF (v_ver_id IS NULL)

Line 7165: SELECT fem_dim_attr_versions_b_s.NEXTVAL

7161: THEN
7162: RAISE e_no_version_name;
7163: END IF;
7164:
7165: SELECT fem_dim_attr_versions_b_s.NEXTVAL
7166: INTO v_ver_id FROM dual;
7167:
7168: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
7169: x_rowid => v_row_id,

Line 7701: FROM fem_dim_attr_versions_b

7697: -- Check Attribute's Version --
7698: -------------------------------
7699: SELECT MIN(version_id)
7700: INTO v_ver_id
7701: FROM fem_dim_attr_versions_b
7702: WHERE attribute_id = v_attr_id
7703: AND default_version_flag = 'Y';
7704:
7705: IF (v_ver_id IS NULL)

Line 7715: SELECT fem_dim_attr_versions_b_s.NEXTVAL

7711: THEN
7712: RAISE e_no_version_name;
7713: END IF;
7714:
7715: SELECT fem_dim_attr_versions_b_s.NEXTVAL
7716: INTO v_ver_id FROM dual;
7717:
7718: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
7719: x_rowid => v_row_id,

Line 8179: FROM fem_dim_attr_versions_b

8175: -- Check Attribute's Version --
8176: -------------------------------
8177: SELECT MIN(version_id)
8178: INTO v_ver_id
8179: FROM fem_dim_attr_versions_b
8180: WHERE attribute_id = v_attr_id
8181: AND default_version_flag = 'Y';
8182:
8183: IF (v_ver_id IS NULL)

Line 8193: SELECT fem_dim_attr_versions_b_s.NEXTVAL

8189: THEN
8190: RAISE e_no_version_name;
8191: END IF;
8192:
8193: SELECT fem_dim_attr_versions_b_s.NEXTVAL
8194: INTO v_ver_id FROM dual;
8195:
8196: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
8197: x_rowid => v_row_id,

Line 8715: fem_dim_attr_versions_b V

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
8719: AND V.default_version_flag = 'Y';