APPS.FEM_GL_POST_PROCESS_PKG dependencies on FEM_DIMENSIONS_B

Line 1651: FROM fem_dimensions_b

1647: -- Get the Dimension ID for Cal Period.
1648:
1649: SELECT dimension_id
1650: INTO pv_cal_per_dim_id
1651: FROM fem_dimensions_b
1652: WHERE dimension_varchar_label = 'CAL_PERIOD';
1653:
1654: -- Set variables used in messaging upon failure.
1655:

Line 1841: FROM fem_dimensions_b

1837: -- Get the Dimension ID for Ledger.
1838:
1839: SELECT dimension_id
1840: INTO pv_ledger_dim_id
1841: FROM fem_dimensions_b
1842: WHERE dimension_varchar_label = 'LEDGER';
1843:
1844: -- Set variables used in messaging upon failure.
1845:

Line 1895: FROM fem_dimensions_b

1891: -- Get the Dimension ID for Dataset Code.
1892:
1893: SELECT dimension_id
1894: INTO pv_dataset_dim_id
1895: FROM fem_dimensions_b
1896: WHERE dimension_varchar_label = 'DATASET';
1897:
1898: -- Set variables used in messaging upon failure.
1899:

Line 2037: FROM fem_dimensions_b

2033: -- Look up the Budget Display Code
2034:
2035: SELECT dimension_id
2036: INTO pv_budget_dim_id
2037: FROM fem_dimensions_b
2038: WHERE dimension_varchar_label = 'BUDGET';
2039:
2040: v_param_name := FEM_DIMENSION_UTIL_PKG.Get_Dimension_Name
2041: (p_dim_id => pv_budget_dim_id);

Line 2145: FROM fem_dimensions_b

2141: -- Look up the Encumbrance Type (Display) Code
2142:
2143: SELECT dimension_id
2144: INTO pv_enc_type_dim_id
2145: FROM fem_dimensions_b
2146: WHERE dimension_varchar_label = 'ENCUMBRANCE_TYPE';
2147:
2148: v_param_name := FEM_DIMENSION_UTIL_PKG.Get_Dimension_Name
2149: (p_dim_id => pv_enc_type_dim_id);

Line 2358: FROM fem_dimensions_b

2354: p_msg_text => 'Get Calendar Period dimension ID');
2355:
2356: SELECT dimension_id
2357: INTO pv_cal_per_dim_id
2358: FROM fem_dimensions_b
2359: WHERE dimension_varchar_label = 'CAL_PERIOD';
2360:
2361: FEM_ENGINES_PKG.Tech_Message
2362: (p_severity => pc_log_level_statement,

Line 2369: FROM fem_dimensions_b

2365: p_msg_text => 'Get Ledger dimension ID');
2366:
2367: SELECT dimension_id
2368: INTO pv_ledger_dim_id
2369: FROM fem_dimensions_b
2370: WHERE dimension_varchar_label = 'LEDGER';
2371:
2372: FEM_ENGINES_PKG.Tech_Message
2373: (p_severity => pc_log_level_statement,

Line 2380: FROM fem_dimensions_b

2376: p_msg_text => 'Get Dataset dimension ID');
2377:
2378: SELECT dimension_id
2379: INTO pv_dataset_dim_id
2380: FROM fem_dimensions_b
2381: WHERE dimension_varchar_label = 'DATASET';
2382:
2383: FEM_ENGINES_PKG.Tech_Message
2384: (p_severity => pc_log_level_statement,

Line 2391: FROM fem_dimensions_b

2387: p_msg_text => 'Get Budget dimension ID');
2388:
2389: SELECT dimension_id
2390: INTO pv_budget_dim_id
2391: FROM fem_dimensions_b
2392: WHERE dimension_varchar_label = 'BUDGET';
2393:
2394: FEM_ENGINES_PKG.Tech_Message
2395: (p_severity => pc_log_level_statement,

Line 2402: FROM fem_dimensions_b

2398: p_msg_text => 'Get Encumbrance Type dimension ID');
2399:
2400: SELECT dimension_id
2401: INTO pv_enc_type_dim_id
2402: FROM fem_dimensions_b
2403: WHERE dimension_varchar_label = 'ENCUMBRANCE_TYPE';
2404:
2405: FEM_ENGINES_PKG.Tech_Message
2406: (p_severity => pc_log_level_statement,

Line 2413: FROM fem_dimensions_b

2409: p_msg_text => 'Get Extended Account Type dimension ID');
2410:
2411: SELECT dimension_id
2412: INTO pv_ext_acct_type_dim_id
2413: FROM fem_dimensions_b
2414: WHERE dimension_varchar_label = 'EXTENDED_ACCOUNT_TYPE';
2415:
2416: FEM_ENGINES_PKG.Tech_Message
2417: (p_severity => pc_log_level_statement,

Line 2424: FROM fem_dimensions_b

2420: p_msg_text => 'Get Natural Account dimension ID');
2421:
2422: SELECT dimension_id
2423: INTO pv_nat_acct_dim_id
2424: FROM fem_dimensions_b
2425: WHERE dimension_varchar_label = 'NATURAL_ACCOUNT';
2426:
2427: FEM_ENGINES_PKG.Tech_Message
2428: (p_severity => pc_log_level_procedure,

Line 4689: FROM fem_dimensions_b fdb,

4685:
4686: -- Bug 4294018 hkaniven start - Count the no of 'SIGN' attribute rows
4687: SELECT COUNT(*)
4688: INTO v_count
4689: FROM fem_dimensions_b fdb,
4690: fem_dim_attributes_b fdab,
4691: fem_dim_attr_versions_b fdavb,
4692: fem_ext_acct_types_attr feata
4693: WHERE fdb.dimension_varchar_label = 'EXTENDED_ACCOUNT_TYPE'

Line 5090: FROM FEM_XDIM_DIMENSIONS xdim, FEM_DIMENSIONS_B dim

5086: -- Value Set Combination
5087: BEGIN
5088: SELECT DISTINCT 'X'
5089: INTO v_dummy_flag
5090: FROM FEM_XDIM_DIMENSIONS xdim, FEM_DIMENSIONS_B dim
5091: WHERE xdim.VALUE_SET_REQUIRED_FLAG = 'Y'
5092: AND xdim.DIMENSION_ID = dim.DIMENSION_ID
5093: AND dim.DIMENSION_VARCHAR_LABEL
5094: NOT IN ('COMPANY', 'COST_CENTER') -- Bug fix 4158130