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_DIMENSIONS_B

Line 1117: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;

1113: v_cal_period_cv cal_period_cur_type;
1114:
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;

Line 1685: FROM fem_dimensions_b

1681: BEGIN
1682:
1683: SELECT dimension_id
1684: INTO v_calp_dim_id
1685: FROM fem_dimensions_b
1686: WHERE dimension_varchar_label='CAL_PERIOD';
1687:
1688: SELECT dimension_id
1689: INTO v_ledger_dim_id

Line 1690: FROM fem_dimensions_b

1686: WHERE dimension_varchar_label='CAL_PERIOD';
1687:
1688: SELECT dimension_id
1689: INTO v_ledger_dim_id
1690: FROM fem_dimensions_b
1691: WHERE dimension_varchar_label='LEDGER';
1692:
1693:
1694: SELECT attribute_id

Line 1824: FROM fem_dimensions_b

1820: BEGIN
1821:
1822: SELECT dimension_id
1823: INTO v_calp_dim_id
1824: FROM fem_dimensions_b
1825: WHERE dimension_varchar_label='CAL_PERIOD';
1826:
1827: SELECT dimension_id
1828: INTO v_ledger_dim_id

Line 1829: FROM fem_dimensions_b

1825: WHERE dimension_varchar_label='CAL_PERIOD';
1826:
1827: SELECT dimension_id
1828: INTO v_ledger_dim_id
1829: FROM fem_dimensions_b
1830: WHERE dimension_varchar_label='LEDGER';
1831:
1832:
1833: SELECT attribute_id

Line 1974: FROM fem_dimensions_b

1970: FROM fem_tab_columns_b
1971: WHERE table_name = p_table_name
1972: AND dimension_id =
1973: (SELECT dimension_id
1974: FROM fem_dimensions_b
1975: WHERE dimension_varchar_label = 'LEDGER');
1976:
1977: SELECT column_name
1978: INTO v_cal_per_col

Line 1983: FROM fem_dimensions_b

1979: FROM fem_tab_columns_b
1980: WHERE table_name = p_table_name
1981: AND dimension_id =
1982: (SELECT dimension_id
1983: FROM fem_dimensions_b
1984: WHERE dimension_varchar_label = 'CAL_PERIOD');
1985:
1986: SELECT column_name
1987: INTO v_dataset_col

Line 1992: FROM fem_dimensions_b

1988: FROM fem_tab_columns_b
1989: WHERE table_name = p_table_name
1990: AND dimension_id =
1991: (SELECT dimension_id
1992: FROM fem_dimensions_b
1993: WHERE dimension_varchar_label = 'DATASET');
1994:
1995: SELECT column_name
1996: INTO v_source_col

Line 2001: FROM fem_dimensions_b

1997: FROM fem_tab_columns_b
1998: WHERE table_name = p_table_name
1999: AND dimension_id =
2000: (SELECT dimension_id
2001: FROM fem_dimensions_b
2002: WHERE dimension_varchar_label = 'SOURCE_SYSTEM');
2003:
2004: v_sql_cmd :=
2005: 'SELECT MIN(ledger_id)'||

Line 2030: FROM fem_dimensions_b

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

Line 2043: ' FROM fem_dimensions_b'||

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'')'||
2045: ' AND attribute_varchar_label = ''DATASET_BALANCE_TYPE_CODE'')'||
2046: ' AND A.attribute_id = V.attribute_id'||
2047: ' AND A.version_id = V.version_id'||

Line 2233: FROM fem_dimensions_b

2229:
2230: BEGIN
2231: SELECT dimension_varchar_label
2232: INTO v_dim_label
2233: FROM fem_dimensions_b
2234: WHERE dimension_id = p_dim_id;
2235: EXCEPTION
2236: WHEN no_data_found THEN
2237: RETURN null;

Line 3074: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;

3070: v_member_code VARCHAR2(250);
3071: v_member_dc VARCHAR2(250);
3072: v_member_name VARCHAR2(150);
3073: v_member_desc VARCHAR2(255);
3074: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
3075: v_member_b_tab FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE;
3076: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;
3077: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
3078: v_member_name_col FEM_XDIM_DIMENSIONS.member_name_col%TYPE;

Line 3195: FROM fem_xdim_dimensions x, fem_dimensions_b d

3191: v_vsr_flag,
3192: v_member_id_method_code,
3193: v_default_member_dc,
3194: v_member_pkg
3195: FROM fem_xdim_dimensions x, fem_dimensions_b d
3196: WHERE d.dimension_varchar_label = p_dim_label
3197: AND x.read_only_flag = 'N'
3198: AND x.composite_dimension_flag = 'N'
3199: AND x.hier_editor_managed_flag = 'Y'

Line 3616: v_dim_label FEM_DIMENSIONS_B.dimension_varchar_label%TYPE;

3612: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3613: 'fem.plsql.fem_dimension_util_pkg.generate_default_load_member(2)';
3614: C_API_NAME CONSTANT VARCHAR2(30) := 'Genereate_Default_Load_Member';
3615:
3616: v_dim_label FEM_DIMENSIONS_B.dimension_varchar_label%TYPE;
3617: v_def_load_id NUMBER;
3618: v_member_code VARCHAR2(38);
3619: BEGIN
3620:

Line 3689: FROM fem_value_sets_b V, fem_dimensions_b D

3685: SELECT D.dimension_varchar_label,
3686: V.default_load_member_id
3687: INTO v_dim_label,
3688: v_def_load_id
3689: FROM fem_value_sets_b V, fem_dimensions_b D
3690: WHERE V.value_set_id = p_vs_id
3691: AND V.dimension_id = D.dimension_id;
3692: EXCEPTION
3693: WHEN no_data_found THEN

Line 3805: FROM fem_xdim_dimensions x, fem_dimensions_b d

3801: CURSOR c_dims IS
3802: SELECT d.dimension_id,
3803: d.dimension_varchar_label,
3804: x.value_set_required_flag
3805: FROM fem_xdim_dimensions x, fem_dimensions_b d
3806: WHERE x.dimension_id = d.dimension_id
3807: AND x.read_only_flag = 'N'
3808: AND x.composite_dimension_flag = 'N'
3809: AND x.hier_editor_managed_flag = 'Y'

Line 4020: FROM fem_dimensions_b

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);
4022:
4023: TYPE cv_curs_type IS REF CURSOR;
4024: cv_attr_dim cv_curs_type;

Line 4036: FROM fem_dimensions_b

4032: -- Get New Dataset ID --
4033: ------------------------
4034: SELECT dimension_id
4035: INTO v_dim_id
4036: FROM fem_dimensions_b
4037: WHERE dimension_varchar_label = c_dim_label;
4038:
4039: v_ds_cd := FEM_Dimension_Util_Pkg.Generate_Member_ID(
4040: p_dim_id => v_dim_id,

Line 4473: FROM fem_dimensions_b

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);
4475:
4476: TYPE cv_curs_type IS REF CURSOR;
4477: cv_attr_dim cv_curs_type;

Line 4504: FROM fem_dimensions_b

4500: -- Get New Dataset ID --
4501: ------------------------
4502: SELECT dimension_id
4503: INTO v_dim_id
4504: FROM fem_dimensions_b
4505: WHERE dimension_varchar_label = c_dim_label;
4506:
4507: v_ds_cd := FEM_Dimension_Util_Pkg.Generate_Member_ID(
4508: p_api_version => p_api_version,

Line 4987: FROM fem_dimensions_b

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);
4989:
4990: BEGIN
4991:

Line 5000: FROM fem_dimensions_b

4996: -- Get New Ledger ID --
4997: ------------------------
4998: SELECT dimension_id
4999: INTO v_dim_id
5000: FROM fem_dimensions_b
5001: WHERE dimension_varchar_label = c_dim_label;
5002:
5003: v_lg_id := FEM_Dimension_Util_Pkg.Generate_Member_ID(
5004: p_dim_id => v_dim_id,

Line 5506: FROM fem_dimensions_b

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);
5508:
5509: BEGIN
5510:

Line 5534: FROM fem_dimensions_b

5530: -- Get New Ledger ID --
5531: ------------------------
5532: SELECT dimension_id
5533: INTO v_dim_id
5534: FROM fem_dimensions_b
5535: WHERE dimension_varchar_label = c_dim_label;
5536:
5537: v_lg_id := FEM_Dimension_Util_Pkg.Generate_Member_ID(
5538: p_api_version => p_api_version,

Line 6067: FROM fem_dimensions_b

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')
6069: AND attribute_required_flag = 'Y';
6070:
6071: TYPE cv_curs_type IS REF CURSOR;

Line 6099: FROM fem_dimensions_b

6095: -- Get the next BUDGET_ID value available --
6096: ------------------------
6097: SELECT dimension_id
6098: INTO v_budget_dimension_id
6099: FROM fem_dimensions_b
6100: WHERE dimension_varchar_label = c_budget_label;
6101:
6102: v_budget_id := FEM_Dimension_Util_Pkg.Generate_Member_ID(
6103: p_api_version => p_api_version,

Line 6228: from fem_dimension_grps_b D, fem_dimensions_b B

6224:
6225: BEGIN
6226: select time_dimension_group_key
6227: into v_first_period_time_dimgrp_key
6228: from fem_dimension_grps_b D, fem_dimensions_b B
6229: where D.dimension_group_display_code = p_first_period_dimgrp
6230: and D.dimension_id = B.dimension_id
6231: and B.dimension_varchar_label = 'CAL_PERIOD';
6232: EXCEPTION

Line 6261: from fem_dimension_grps_b D, fem_dimensions_b B

6257:
6258: BEGIN
6259: select time_dimension_group_key
6260: into v_last_period_time_dimgrp_key
6261: from fem_dimension_grps_b D, fem_dimensions_b B
6262: where D.dimension_group_display_code = p_last_period_dimgrp
6263: and D.dimension_id = B.dimension_id
6264: and B.dimension_varchar_label = 'CAL_PERIOD';
6265: EXCEPTION

Line 6550: FROM fem_dimensions_b

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')
6552: AND attribute_required_flag = 'Y';
6553:
6554: TYPE cv_curs_type IS REF CURSOR;

Line 6568: FROM fem_dimensions_b

6564: -- Validate Budget ID
6565: ---------------------
6566: SELECT dimension_id
6567: INTO v_dim_id
6568: FROM fem_dimensions_b
6569: WHERE dimension_varchar_label = c_budget_label;
6570:
6571: BEGIN
6572: SELECT budget_id

Line 6715: from fem_dimension_grps_b D, fem_dimensions_b B

6711:
6712: BEGIN
6713: select time_dimension_group_key
6714: into v_first_period_time_dimgrp_key
6715: from fem_dimension_grps_b D, fem_dimensions_b B
6716: where D.dimension_group_display_code = p_first_period_dimgrp
6717: and D.dimension_id = B.dimension_id
6718: and B.dimension_varchar_label = 'CAL_PERIOD';
6719: EXCEPTION

Line 6748: from fem_dimension_grps_b D, fem_dimensions_b B

6744:
6745: BEGIN
6746: select time_dimension_group_key
6747: into v_last_period_time_dimgrp_key
6748: from fem_dimension_grps_b D, fem_dimensions_b B
6749: where D.dimension_group_display_code = p_last_period_dimgrp
6750: and D.dimension_id = B.dimension_id
6751: and B.dimension_varchar_label = 'CAL_PERIOD';
6752: EXCEPTION

Line 7061: FROM fem_dimensions_b

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);
7063:
7064: e_dup_reg_id EXCEPTION;
7065:

Line 7075: FROM fem_dimensions_b

7071: -- Validate Ledger ID
7072: ---------------------
7073: SELECT dimension_id
7074: INTO v_dim_id
7075: FROM fem_dimensions_b
7076: WHERE dimension_varchar_label = c_dim_label;
7077:
7078: BEGIN
7079: SELECT ledger_id

Line 7614: FROM fem_dimensions_b

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);
7616:
7617: BEGIN
7618:

Line 7643: FROM fem_dimensions_b

7639: -- Get New Encumbrance Type ID --
7640: ---------------------------------
7641: SELECT dimension_id
7642: INTO v_dim_id
7643: FROM fem_dimensions_b
7644: WHERE dimension_varchar_label = c_dim_label;
7645:
7646: v_enc_type_id := FEM_Dimension_Util_Pkg.Generate_Member_ID(
7647: p_api_version => p_api_version,

Line 8089: FROM fem_dimensions_b

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);
8091:
8092: e_dup_reg_id EXCEPTION;
8093:

Line 8103: FROM fem_dimensions_b

8099: -- Validate Encumbrance Type ID
8100: -------------------------------
8101: SELECT dimension_id
8102: INTO v_dim_id
8103: FROM fem_dimensions_b
8104: WHERE dimension_varchar_label = c_dim_label;
8105:
8106: BEGIN
8107: SELECT encumbrance_type_id

Line 8811: FROM fem_dimensions_b

8807: ---------------------------------
8808: BEGIN
8809: SELECT dimension_id
8810: INTO v_dim_id
8811: FROM fem_dimensions_b
8812: WHERE dimension_varchar_label = p_dimension_varchar_label;
8813: EXCEPTION
8814: WHEN no_data_found THEN
8815: RAISE e_bad_dim_label;

Line 9053: fem_dimensions_b DB

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
9056: AND AB.dimension_id = DB.dimension_id
9057: AND AT.attribute_id = AB.attribute_id

Line 9104: FROM fem_dimensions_b B,

9100: BEGIN
9101:
9102: SELECT T.dimension_name
9103: INTO v_dim_name
9104: FROM fem_dimensions_b B,
9105: fem_dimensions_tl T
9106: WHERE B.dimension_varchar_label = p_dim_label
9107: AND T.dimension_id = B.dimension_id
9108: AND T.language = userenv('LANG');

Line 9246: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;

9242: C_API_VERSION CONSTANT NUMBER := 1.0;
9243: C_API_NAME CONSTANT VARCHAR2(30) := 'Get_Default_Dim_Member';
9244: e_no_member EXCEPTION;
9245:
9246: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
9247: v_member_table FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE;
9248: v_member_col FEM_XDIM_DIMENSIONS.member_col%TYPE;
9249: v_member_dc_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE;
9250: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;

Line 9332: FROM fem_dimensions_b

9328: BEGIN
9329: IF p_dimension_id IS NULL THEN
9330: SELECT dimension_id
9331: INTO v_dim_id
9332: FROM fem_dimensions_b
9333: WHERE dimension_varchar_label = p_dimension_varchar_label;
9334: ELSE
9335: v_dim_id := p_dimension_id;
9336: END IF;

Line 9370: p_msg_text => 'Dimension is not registered in FEM_DIMENSIONS_B or FEM_XDIM_DIMENSIONS');

9366: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9367: FEM_ENGINES_PKG.TECH_MESSAGE(
9368: p_severity => FND_LOG.level_statement,
9369: p_module => C_MODULE,
9370: p_msg_text => 'Dimension is not registered in FEM_DIMENSIONS_B or FEM_XDIM_DIMENSIONS');
9371: END IF;
9372: RAISE e_unexp;
9373: END;
9374:

Line 9584: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;

9580: 'fem.plsql.fem_dimension_util_pkg.get_default_dim_member.table';
9581: C_API_VERSION CONSTANT NUMBER := 1.0;
9582: C_API_NAME CONSTANT VARCHAR2(30) := 'Get_Default_Dim_Member';
9583:
9584: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
9585:
9586: BEGIN
9587:
9588: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 9750: FROM fem_dimensions_b

9746: ---------------------------------
9747: BEGIN
9748: SELECT dimension_id
9749: INTO v_dim_id
9750: FROM fem_dimensions_b
9751: WHERE dimension_id = p_dimension_id;
9752: EXCEPTION
9753: WHEN no_data_found THEN
9754: RAISE e_error;

Line 9873: FROM fem_dimensions_b

9869: ---------------------------------
9870: BEGIN
9871: SELECT dimension_id
9872: INTO v_dim_id
9873: FROM fem_dimensions_b
9874: WHERE dimension_id = p_dimension_id;
9875: EXCEPTION
9876: WHEN no_data_found THEN
9877: RAISE e_error;