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_HIER_LOADER_PKG dependencies on FEM_HIER_VALUE_SETS

Line 1868: -- FEM_HIER_VALUE_SETS_T for that hierarchy.

1864:
1865: ------------------------------------------------------------------------------
1866: -- STEP 5.8.1: Verify that MULTI_VALUE_SET_FLAG on FEM_HIERARCHIES_T
1867: -- is valid. If flag ='N', check that only one value set row is listed in
1868: -- FEM_HIER_VALUE_SETS_T for that hierarchy.
1869: ------------------------------------------------------------------------------
1870: FEM_ENGINES_PKG.tech_message (
1871: p_severity => g_log_level_1
1872: ,p_module => G_BLOCK||'.'||l_api_name

Line 1878: ' from fem_hier_value_sets_t'||

1874: );
1875:
1876: execute immediate
1877: ' select count(*)'||
1878: ' from fem_hier_value_sets_t'||
1879: ' where hierarchy_object_name = :b_hierarchy_object_name'||
1880: l_status_clause||
1881: ' and language = userenv(''LANG'')'
1882: into l_vs_count

Line 1901: p_hier_table_name => 'FEM_HIER_VALUE_SETS_T'

1897: l_hierarchy_error_flag := true;
1898: ld_status := 'MULTIPLE_VALUE_SETS';
1899:
1900: set_hier_table_err_msg (
1901: p_hier_table_name => 'FEM_HIER_VALUE_SETS_T'
1902: ,p_status => ld_status
1903: );
1904:
1905: execute immediate

Line 1906: ' update fem_hier_value_sets_t'||

1902: ,p_status => ld_status
1903: );
1904:
1905: execute immediate
1906: ' update fem_hier_value_sets_t'||
1907: ' set status = :b_status'||
1908: ' where hierarchy_object_name = :b_hierarchy_object_name'||
1909: l_status_clause||
1910: ' and language = userenv(''LANG'')'

Line 2035: -- STEP 5.10.1: Verify that VALUE_SET_DISPLAY_CODE on FEM_HIER_VALUE_SETS_T

2031: ------------------------------------------------------------------------------
2032: if (l_value_set_required_flag = 'Y') then
2033:
2034: ------------------------------------------------------------------------------
2035: -- STEP 5.10.1: Verify that VALUE_SET_DISPLAY_CODE on FEM_HIER_VALUE_SETS_T
2036: -- is a valid value set for the dimension. This is needed for all new
2037: -- hiearchies, and for updates on multi value set hierarchies where we allow
2038: -- more value sets to be added (Bug 4661474).
2039: ------------------------------------------------------------------------------

Line 2045: ,p_msg_text => 'Step 5.10.1: VALUE_SET_DISPLAY_CODE in FEM_HIER_VALUE_SETS_T Validation'

2041:
2042: FEM_ENGINES_PKG.tech_message (
2043: p_severity => g_log_level_1
2044: ,p_module => G_BLOCK||'.'||l_api_name
2045: ,p_msg_text => 'Step 5.10.1: VALUE_SET_DISPLAY_CODE in FEM_HIER_VALUE_SETS_T Validation'
2046: );
2047:
2048: open cv_bad_value_sets
2049: for l_bad_value_sets_stmt

Line 2072: p_hier_table_name => 'FEM_HIER_VALUE_SETS_T'

2068: l_hierarchy_error_flag := true;
2069: ld_status := tv_status(1);
2070:
2071: set_hier_table_err_msg (
2072: p_hier_table_name => 'FEM_HIER_VALUE_SETS_T'
2073: ,p_status => ld_status
2074: );
2075:
2076: forall j in 1..l_bad_value_sets_last_row

Line 2078: ' update fem_hier_value_sets_t'||

2074: );
2075:
2076: forall j in 1..l_bad_value_sets_last_row
2077: execute immediate
2078: ' update fem_hier_value_sets_t'||
2079: ' set status = :b_status'||
2080: ' where rowid = :b_rowid'||
2081: l_status_clause||
2082: ' and language = userenv(''LANG'')'

Line 2191: -- FEM_HIER_VALUE_SETS_T (new) or FEM_HIER_VALUE_SETS (existing)

2187:
2188: ------------------------------------------------------------------------------
2189: -- STEP 6.2: Verify that the PARENT_VALUE_SET_DISPLAY_CODE and
2190: -- CHILD_VALUE_SET_DISPLAY_CODE are valid for the hierarchy in
2191: -- FEM_HIER_VALUE_SETS_T (new) or FEM_HIER_VALUE_SETS (existing)
2192: ------------------------------------------------------------------------------
2193: if (l_value_set_required_flag = 'Y') then
2194:
2195: FEM_ENGINES_PKG.tech_message (

Line 3377: -- FEM_HIER_DIMENSION_GRPS, and FEM_HIER_VALUE_SETS

3373: --BEGIN:multi_thread_final_insert
3374: ------------------------------------------------------------------------------
3375: -- STEP 10: If HIERARCHY_OBJECT_NAME does not exist, then insert the
3376: -- necessary rows in FEM_OBJECT_CATALOG_B/_TL, FEM_HIERARCHIES,
3377: -- FEM_HIER_DIMENSION_GRPS, and FEM_HIER_VALUE_SETS
3378: ------------------------------------------------------------------------------
3379:
3380: if (ld_load_type = g_new_hier) then
3381:

Line 3424: p_hier_table_name => 'FEM_HIER_VALUE_SETS_T'

3420: l_hierarchy_error_flag := true;
3421: ld_status := 'MULTIPLE_VALUE_SETS';
3422:
3423: set_hier_table_err_msg (
3424: p_hier_table_name => 'FEM_HIER_VALUE_SETS_T'
3425: ,p_status => ld_status
3426: );
3427:
3428: execute immediate

Line 3429: ' update fem_hier_value_sets_t'||

3425: ,p_status => ld_status
3426: );
3427:
3428: execute immediate
3429: ' update fem_hier_value_sets_t'||
3430: ' set status = :b_status'||
3431: ' where hierarchy_object_name = :b_hierarchy_object_name'||
3432: l_status_clause||
3433: ' and language = userenv(''LANG'')'

Line 3600: -- STEP 10.5: Insert into FEM_HIER_VALUE_SETS for new and updated hierarchies

3596:
3597: end if;
3598:
3599: ------------------------------------------------------------------------------
3600: -- STEP 10.5: Insert into FEM_HIER_VALUE_SETS for new and updated hierarchies
3601: -- that must have value sets or that have a calendar context.
3602: ------------------------------------------------------------------------------
3603: if (l_value_set_required_flag = 'Y') then
3604:

Line 3613: ,p_msg_text => 'Step 10.5: Insert into FEM_HIER_VALUE_SETS'

3609:
3610: FEM_ENGINES_PKG.tech_message (
3611: p_severity => g_log_level_1
3612: ,p_module => G_BLOCK||'.'||l_api_name
3613: ,p_msg_text => 'Step 10.5: Insert into FEM_HIER_VALUE_SETS'
3614: );
3615:
3616: -- For updates on multi value set hierarchies, we must first delete
3617: -- all the hierarchy value sets in FEM_HIER_VALUE_SETS_T hat have

Line 3617: -- all the hierarchy value sets in FEM_HIER_VALUE_SETS_T hat have

3613: ,p_msg_text => 'Step 10.5: Insert into FEM_HIER_VALUE_SETS'
3614: );
3615:
3616: -- For updates on multi value set hierarchies, we must first delete
3617: -- all the hierarchy value sets in FEM_HIER_VALUE_SETS_T hat have
3618: -- already been assigned to the existing hierarchy (Bug 4661474).
3619: if (ld_load_type <> g_new_hier) then
3620:
3621: execute immediate

Line 3622: ' delete from fem_hier_value_sets_t hvst'||

3618: -- already been assigned to the existing hierarchy (Bug 4661474).
3619: if (ld_load_type <> g_new_hier) then
3620:
3621: execute immediate
3622: ' delete from fem_hier_value_sets_t hvst'||
3623: ' where hvst.hierarchy_object_name = :b_hierarchy_object_name'||
3624: l_status_clause||
3625: ' and hvst.language = userenv(''LANG'')'||
3626: ' and exists ('||

Line 3628: ' from fem_hier_value_sets hvs'||

3624: l_status_clause||
3625: ' and hvst.language = userenv(''LANG'')'||
3626: ' and exists ('||
3627: ' select 1'||
3628: ' from fem_hier_value_sets hvs'||
3629: ' ,fem_value_sets_b vsb'||
3630: ' where hvs.hierarchy_obj_id = :b_hierarchy_object_id'||
3631: ' and vsb.value_set_id = hvs.value_set_id'||
3632: ' and vsb.value_set_display_code = hvst.value_set_display_code'||

Line 3659: insert into fem_hier_value_sets (

3655: exit;
3656: end if;
3657:
3658: forall j in 1..l_get_value_sets_last_row
3659: insert into fem_hier_value_sets (
3660: hierarchy_obj_id
3661: ,value_set_id
3662: ,creation_date
3663: ,created_by

Line 3690: -- Bug Fix 3789176: Add Calendar ID row in FEM_HIER_VALUE_SETS

3686: commit;
3687:
3688: end if;
3689:
3690: -- Bug Fix 3789176: Add Calendar ID row in FEM_HIER_VALUE_SETS
3691: -- table for DHM when loading a new CAL_PERIOD hierarchy.
3692: elsif (p_dimension_varchar_label = 'CAL_PERIOD') then
3693:
3694: if (ld_load_type = g_new_hier) then

Line 3696: insert into fem_hier_value_sets (

3692: elsif (p_dimension_varchar_label = 'CAL_PERIOD') then
3693:
3694: if (ld_load_type = g_new_hier) then
3695:
3696: insert into fem_hier_value_sets (
3697: hierarchy_obj_id
3698: ,value_set_id
3699: ,creation_date
3700: ,created_by

Line 3893: ' delete from fem_hier_value_sets_t'||

3889:
3890: if ( (ld_load_type = g_new_hier) or (ld_multi_value_set_flag = 'Y') ) then
3891:
3892: execute immediate
3893: ' delete from fem_hier_value_sets_t'||
3894: ' where hierarchy_object_name = :b_hierarchy_object_name'||
3895: l_status_clause
3896: using ld_hierarchy_object_name;
3897:

Line 3997: -- ' update fem_hier_value_sets_t'||

3993: -- For performance reasons, do not update all other tables and records
3994: -- to INVALID_HIERARCHY.
3995: --
3996: -- execute immediate
3997: -- ' update fem_hier_value_sets_t'||
3998: -- ' set status = ''INVALID_HIERARCHY'''||
3999: -- ' where hierarchy_object_name = ld_hierarchy_object_name'||
4000: -- l_status_clause
4001: -- using ld_hierarchy_object_name;

Line 4912: ' from fem_hier_value_sets_t hvst'||

4908:
4909: x_bad_value_sets_stmt :=
4910: ' select hvst.rowid'||
4911: ' ,''INVALID_VALUE_SET'''||
4912: ' from fem_hier_value_sets_t hvst'||
4913: ' where hvst.hierarchy_object_name = :b_hierarchy_object_name'||
4914: l_status_clause||
4915: ' and hvst.language = userenv(''LANG'')'||
4916: ' and not exists ('||

Line 5083: ' from fem_hier_value_sets_t hvst'||

5079: ' and ht.language = userenv(''LANG'')'||
5080: ' and ('||
5081: ' not exists ('||
5082: ' select 1'||
5083: ' from fem_hier_value_sets_t hvst'||
5084: ' where hvst.hierarchy_object_name = ht.hierarchy_object_name'||
5085: ' and hvst.value_set_display_code = ht.parent_value_set_display_code'||
5086: l_status_clause_2||
5087: ' and hvst.language = userenv(''LANG'')'||

Line 5092: ' from fem_hier_value_sets_t hvst'||

5088: ' )'||
5089: ' or'||
5090: ' not exists ('||
5091: ' select 1'||
5092: ' from fem_hier_value_sets_t hvst'||
5093: ' where hvst.hierarchy_object_name = ht.hierarchy_object_name'||
5094: ' and hvst.value_set_display_code = ht.child_value_set_display_code'||
5095: l_status_clause_2||
5096: ' and hvst.language = userenv(''LANG'')'||

Line 5161: ' from fem_hier_value_sets hvs'||

5157: ' and ht.language = userenv(''LANG'')'||
5158: ' and ('||
5159: ' not exists ('||
5160: ' select 1'||
5161: ' from fem_hier_value_sets hvs'||
5162: ' ,fem_value_sets_b vsb'||
5163: ' where hvs.hierarchy_obj_id = :b_hierarchy_object_id'||
5164: ' and vsb.value_set_id = hvs.value_set_id'||
5165: ' and vsb.value_set_display_code = ht.parent_value_set_display_code'||

Line 5170: ' from fem_hier_value_sets hvs'||

5166: ' )'||
5167: ' or'||
5168: ' not exists ('||
5169: ' select 1'||
5170: ' from fem_hier_value_sets hvs'||
5171: ' ,fem_value_sets_b vsb'||
5172: ' where hvs.hierarchy_obj_id = :b_hierarchy_object_id'||
5173: ' and vsb.value_set_id = hvs.value_set_id'||
5174: ' and vsb.value_set_display_code = ht.child_value_set_display_code'||

Line 5242: ' from fem_hier_value_sets hvs'||

5238: ' and ('||
5239: ' ('||
5240: ' not exists ('||
5241: ' select 1'||
5242: ' from fem_hier_value_sets hvs'||
5243: ' ,fem_value_sets_b vsb'||
5244: ' where hvs.hierarchy_obj_id = :b_hierarchy_object_id'||
5245: ' and vsb.value_set_id = hvs.value_set_id'||
5246: ' and vsb.value_set_display_code = ht.parent_value_set_display_code'||

Line 5251: ' from fem_hier_value_sets_t hvst'||

5247: ' )'||
5248: ' and'||
5249: ' not exists ('||
5250: ' select 1'||
5251: ' from fem_hier_value_sets_t hvst'||
5252: ' where hvst.hierarchy_object_name = ht.hierarchy_object_name'||
5253: ' and hvst.value_set_display_code = ht.parent_value_set_display_code'||
5254: l_status_clause_2||
5255: ' and hvst.language = userenv(''LANG'')'||

Line 5261: ' from fem_hier_value_sets hvs'||

5257: ' )'||
5258: ' or ('||
5259: ' not exists ('||
5260: ' select 1'||
5261: ' from fem_hier_value_sets hvs'||
5262: ' ,fem_value_sets_b vsb'||
5263: ' where hvs.hierarchy_obj_id = :b_hierarchy_object_id'||
5264: ' and vsb.value_set_id = hvs.value_set_id'||
5265: ' and vsb.value_set_display_code = ht.child_value_set_display_code'||

Line 5270: ' from fem_hier_value_sets_t hvst'||

5266: ' )'||
5267: ' and'||
5268: ' not exists ('||
5269: ' select 1'||
5270: ' from fem_hier_value_sets_t hvst'||
5271: ' where hvst.hierarchy_object_name = ht.hierarchy_object_name'||
5272: ' and hvst.value_set_display_code = ht.child_value_set_display_code'||
5273: l_status_clause_2||
5274: ' and hvst.language = userenv(''LANG'')'||

Line 6149: ' from fem_hier_value_sets_t hvst'||

6145: if (p_value_set_required_flag = 'Y') then
6146:
6147: x_get_value_sets_stmt :=
6148: ' select vs.value_set_id'||
6149: ' from fem_hier_value_sets_t hvst'||
6150: ' ,fem_value_sets_b vs'||
6151: ' where hvst.hierarchy_object_name = :b_hierarchy_object_name'||
6152: l_status_clause||
6153: ' and hvst.language = userenv(''LANG'')'||