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_CHECK_BR_DIS_MBRS_PKG dependencies on FND_GLOBAL

Line 541: FND_GLOBAL.Conc_Request_ID, v_curr_report_id, p_parent_report_row_id,

537: effective_start_date, effective_end_date,
538: creation_date, created_by,
539: last_updated_by, last_update_date, last_update_login)
540: SELECT
541: FND_GLOBAL.Conc_Request_ID, v_curr_report_id, p_parent_report_row_id,
542: c.object_id, c.object_name, c.object_type_code, t.object_type_name,
543: c.folder_id, f.folder_name, d.object_definition_id, d.display_name,
544: d.effective_start_date, d.effective_end_date,
545: sysdate, FND_GLOBAL.User_ID,

Line 545: sysdate, FND_GLOBAL.User_ID,

541: FND_GLOBAL.Conc_Request_ID, v_curr_report_id, p_parent_report_row_id,
542: c.object_id, c.object_name, c.object_type_code, t.object_type_name,
543: c.folder_id, f.folder_name, d.object_definition_id, d.display_name,
544: d.effective_start_date, d.effective_end_date,
545: sysdate, FND_GLOBAL.User_ID,
546: FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID
547: FROM fem_object_definition_vl d, fem_object_catalog_vl c,
548: fem_object_types_vl t, fem_folders_vl f
549: WHERE d.object_definition_id = p_obj_def_id

Line 546: FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID

542: c.object_id, c.object_name, c.object_type_code, t.object_type_name,
543: c.folder_id, f.folder_name, d.object_definition_id, d.display_name,
544: d.effective_start_date, d.effective_end_date,
545: sysdate, FND_GLOBAL.User_ID,
546: FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID
547: FROM fem_object_definition_vl d, fem_object_catalog_vl c,
548: fem_object_types_vl t, fem_folders_vl f
549: WHERE d.object_definition_id = p_obj_def_id
550: AND d.object_id = c.object_id

Line 571: SELECT FND_GLOBAL.Conc_Request_ID,

567: context, dimension_id, dimension_name,
568: dimension_member, value_set_id, value_set_name,
569: creation_date, created_by,
570: last_updated_by, last_update_date, last_update_login)
571: SELECT FND_GLOBAL.Conc_Request_ID,
572: FEM_CHECK_BR_DIS_MBRS_PKG.Get_Unique_Report_Row(), v_curr_report_id,
573: c.object_id, c.object_name, c.object_type_code, t.object_type_name,
574: c.folder_id, f.folder_name, d.object_definition_id, d.display_name,
575: d.effective_start_date, d.effective_end_date,

Line 578: sysdate, FND_GLOBAL.User_ID,

574: c.folder_id, f.folder_name, d.object_definition_id, d.display_name,
575: d.effective_start_date, d.effective_end_date,
576: l.meaning context, b.dimension_id, dim.dimension_name,
577: b.dimension_member, b.value_set_id, v.value_set_name,
578: sysdate, FND_GLOBAL.User_ID,
579: FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID
580: FROM fem_br_disabled_mbrs_gt b, FEM_LOOKUPS l, fem_value_sets_vl v,
581: fem_object_definition_vl d, fem_object_catalog_vl c,
582: fem_object_types_vl t, fem_folders_vl f, fem_dimensions_vl dim

Line 579: FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID

575: d.effective_start_date, d.effective_end_date,
576: l.meaning context, b.dimension_id, dim.dimension_name,
577: b.dimension_member, b.value_set_id, v.value_set_name,
578: sysdate, FND_GLOBAL.User_ID,
579: FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID
580: FROM fem_br_disabled_mbrs_gt b, FEM_LOOKUPS l, fem_value_sets_vl v,
581: fem_object_definition_vl d, fem_object_catalog_vl c,
582: fem_object_types_vl t, fem_folders_vl f, fem_dimensions_vl dim
583: WHERE b.object_definition_id = p_obj_def_id

Line 1708: SELECT FND_GLOBAL.conc_request_id, ' || v_hier_obj_id || ', ''' ||

1704: last_update_date, last_update_login, parent_value_set_name,
1705: child_value_set_name, parent_value_set_id, child_value_set_id,
1706: disabled_flag, hierarchy_obj_def_id, parent_member_id, child_member_id,
1707: parent_display_code, child_display_code, parent_name, child_name)
1708: SELECT FND_GLOBAL.conc_request_id, ' || v_hier_obj_id || ', ''' ||
1709: v_hier_obj_name || ''', ''' || v_hier_obj_def_name
1710: || ''', SYSDATE, FND_GLOBAL.user_id, FND_GLOBAL.user_id, SYSDATE,
1711: FND_GLOBAL.login_id, ''' || v_value_set_name || ''', ''' ||
1712: v_value_set_name || ''',' || nvl(to_char(v_value_set_id), 'NULL')

Line 1710: || ''', SYSDATE, FND_GLOBAL.user_id, FND_GLOBAL.user_id, SYSDATE,

1706: disabled_flag, hierarchy_obj_def_id, parent_member_id, child_member_id,
1707: parent_display_code, child_display_code, parent_name, child_name)
1708: SELECT FND_GLOBAL.conc_request_id, ' || v_hier_obj_id || ', ''' ||
1709: v_hier_obj_name || ''', ''' || v_hier_obj_def_name
1710: || ''', SYSDATE, FND_GLOBAL.user_id, FND_GLOBAL.user_id, SYSDATE,
1711: FND_GLOBAL.login_id, ''' || v_value_set_name || ''', ''' ||
1712: v_value_set_name || ''',' || nvl(to_char(v_value_set_id), 'NULL')
1713: || ',' || nvl(to_char(v_value_set_id), 'NULL') || ',';
1714:

Line 1711: FND_GLOBAL.login_id, ''' || v_value_set_name || ''', ''' ||

1707: parent_display_code, child_display_code, parent_name, child_name)
1708: SELECT FND_GLOBAL.conc_request_id, ' || v_hier_obj_id || ', ''' ||
1709: v_hier_obj_name || ''', ''' || v_hier_obj_def_name
1710: || ''', SYSDATE, FND_GLOBAL.user_id, FND_GLOBAL.user_id, SYSDATE,
1711: FND_GLOBAL.login_id, ''' || v_value_set_name || ''', ''' ||
1712: v_value_set_name || ''',' || nvl(to_char(v_value_set_id), 'NULL')
1713: || ',' || nvl(to_char(v_value_set_id), 'NULL') || ',';
1714:
1715: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2121: FOR dims IN c_dims(FND_GLOBAL.Conc_Request_ID) LOOP

2117: -- Populate the dimension_member_dc, dimension_member_name columns
2118: -- in FEM_BR_DIS_MBR_CONTEXTS, one dimension at a time.
2119: -- The assumption here is that only those where where DIMENSION_ID column
2120: -- IS NOT NULL would there be a need to populate the dimension names.
2121: FOR dims IN c_dims(FND_GLOBAL.Conc_Request_ID) LOOP
2122: v_sql := 'UPDATE fem_br_dis_mbr_contexts c'
2123: ||' SET (dimension_member_dc, dimension_member_name) = ('
2124: || 'SELECT '||dims.member_display_code_col
2125: || ','||dims.member_name_col

Line 2151: USING dims.dimension_id, FND_GLOBAL.Conc_Request_ID;

2147: p_msg_text => 'v_sql = '||v_sql);
2148: END IF;
2149:
2150: EXECUTE IMMEDIATE v_sql
2151: USING dims.dimension_id, FND_GLOBAL.Conc_Request_ID;
2152:
2153: END LOOP;
2154:
2155: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2380: v_request_name := FND_GLOBAL.User_Name || ' '

2376: -- Put request date into var for consistency
2377: v_request_date := sysdate;
2378:
2379: IF p_request_name IS NULL THEN
2380: v_request_name := FND_GLOBAL.User_Name || ' '
2381: || FND_DATE.Date_To_DisplayDT(v_request_date);
2382: ELSE
2383: v_request_name := p_request_name;
2384: END IF;

Line 2396: FND_GLOBAL.Conc_Request_Id, v_request_date, v_request_name,

2392: dimension_id, dimension_name,
2393: creation_date, created_by,
2394: last_updated_by, last_update_date, last_update_login)
2395: VALUES(
2396: FND_GLOBAL.Conc_Request_Id, v_request_date, v_request_name,
2397: p_rule_type, (SELECT object_type_name
2398: FROM fem_object_types_vl
2399: WHERE object_type_code = p_rule_type),
2400: p_ledger_id, (SELECT ledger_name

Line 2412: v_request_date, FND_GLOBAL.User_ID,

2408: WHERE folder_id = p_folder_id),
2409: p_dim_id, (SELECT dimension_name
2410: FROM fem_dimensions_b
2411: WHERE dimension_id = p_dim_id),
2412: v_request_date, FND_GLOBAL.User_ID,
2413: FND_GLOBAL.User_ID, v_request_date, FND_GLOBAL.Login_ID);
2414: END IF; -- IF (v_num_rules_invalid > 0)
2415:
2416: -- If there are any messages on the stack, post them to concurrent log.

Line 2413: FND_GLOBAL.User_ID, v_request_date, FND_GLOBAL.Login_ID);

2409: p_dim_id, (SELECT dimension_name
2410: FROM fem_dimensions_b
2411: WHERE dimension_id = p_dim_id),
2412: v_request_date, FND_GLOBAL.User_ID,
2413: FND_GLOBAL.User_ID, v_request_date, FND_GLOBAL.Login_ID);
2414: END IF; -- IF (v_num_rules_invalid > 0)
2415:
2416: -- If there are any messages on the stack, post them to concurrent log.
2417: Get_Put_Messages;