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 FEM_BR_DIS_MBR_CONTEXTS

Line 524: -- 1. Insert the current rule into FEM_BR_DIS_MBR_CONTEXTS

520: p_msg_text => 'v_this_rule_is_valid = '||v_this_rule_is_valid);
521: END IF;
522:
523: -- If the current rule is invalid or any of the referenced rules are invalid,
524: -- 1. Insert the current rule into FEM_BR_DIS_MBR_CONTEXTS
525: -- without the actual context information to simply serve as
526: -- the parent row for the rows that either contain the context
527: -- information or referenced rules that are invalid.
528: -- 2. If the current rule is invalid,

Line 529: -- insert the context information into FEM_BR_DIS_MBR_CONTEXTS

525: -- without the actual context information to simply serve as
526: -- the parent row for the rows that either contain the context
527: -- information or referenced rules that are invalid.
528: -- 2. If the current rule is invalid,
529: -- insert the context information into FEM_BR_DIS_MBR_CONTEXTS
530: -- from FEM_BR_DISABLED_MBRS_GT.
531: IF (v_this_rule_is_valid = 'N' OR v_all_ref_rules_valid = 'N') THEN
532:
533: INSERT INTO fem_br_dis_mbr_contexts

Line 533: INSERT INTO fem_br_dis_mbr_contexts

529: -- insert the context information into FEM_BR_DIS_MBR_CONTEXTS
530: -- from FEM_BR_DISABLED_MBRS_GT.
531: IF (v_this_rule_is_valid = 'N' OR v_all_ref_rules_valid = 'N') THEN
532:
533: INSERT INTO fem_br_dis_mbr_contexts
534: (request_id, report_row_id, parent_report_row_id,
535: object_id, object_name, object_type_code, object_type_name,
536: folder_id, folder_name, object_definition_id, object_definition_name,
537: effective_start_date, effective_end_date,

Line 555: -- When inserting into FEM_BR_DIS_MBR_CONTEXTS, get the translated

551: AND c.object_type_code = t.object_type_code
552: AND c.folder_id = f.folder_id;
553:
554: IF (v_this_rule_is_valid = 'N') THEN
555: -- When inserting into FEM_BR_DIS_MBR_CONTEXTS, get the translated
556: -- context meaning and value set name. The dimension member names
557: -- will need to be filled in the Report_Invalid_Rules procedure
558: -- after this procedure returns so we can populate all member names for
559: -- a given dimension at a time. Otherwise, we would have to populate

Line 562: INSERT INTO fem_br_dis_mbr_contexts

558: -- after this procedure returns so we can populate all member names for
559: -- a given dimension at a time. Otherwise, we would have to populate
560: -- the member names row by row here.
561:
562: INSERT INTO fem_br_dis_mbr_contexts
563: (request_id, report_row_id, parent_report_row_id,
564: object_id, object_name, object_type_code, object_type_name,
565: folder_id, folder_name, object_definition_id, object_definition_name,
566: effective_start_date, effective_end_date,

Line 2085: -- Populates the following columns in FEM_BR_DIS_MBR_CONTEXTS:

2081: -- PROCEDURE
2082: -- Populate_Dim_Info
2083: --
2084: -- DESCRIPTION
2085: -- Populates the following columns in FEM_BR_DIS_MBR_CONTEXTS:
2086: -- DIMENSION_MEMBER_DC, DIMENSION_MEMBER_NAME
2087: --
2088: -------------------------------------------------------------------------------
2089: PROCEDURE Populate_Dim_Info

Line 2105: FROM fem_br_dis_mbr_contexts

2101: value_set_required_flag
2102: FROM fem_xdim_dimensions
2103: WHERE dimension_id IN (
2104: SELECT dimension_id
2105: FROM fem_br_dis_mbr_contexts
2106: WHERE request_id = p_request_id);
2107: --
2108: BEGIN
2109: --

Line 2118: -- in FEM_BR_DIS_MBR_CONTEXTS, one dimension at a time.

2114: p_msg_text => 'Begin Procedure');
2115: END IF;
2116:
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'

Line 2122: v_sql := 'UPDATE fem_br_dis_mbr_contexts c'

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
2126: || ' FROM '||dims.member_vl_object_name||' d';

Line 2370: -- FEM_BR_DIS_MBR_CONTEXTS

2366: END LOOP;
2367:
2368: -- If at least one root rule was invalid,
2369: -- 1. Finish populating denormalized dimension information in
2370: -- FEM_BR_DIS_MBR_CONTEXTS
2371: -- 2. Populate FEM_BR_DIS_MBR_REQUESTS
2372: IF (v_num_rules_invalid > 0) THEN
2373: -- First, populate missing dimension info in FEM_BR_DIS_MBR_CONTEXTS
2374: Populate_Dim_Info;

Line 2373: -- First, populate missing dimension info in FEM_BR_DIS_MBR_CONTEXTS

2369: -- 1. Finish populating denormalized dimension information in
2370: -- FEM_BR_DIS_MBR_CONTEXTS
2371: -- 2. Populate FEM_BR_DIS_MBR_REQUESTS
2372: IF (v_num_rules_invalid > 0) THEN
2373: -- First, populate missing dimension info in FEM_BR_DIS_MBR_CONTEXTS
2374: Populate_Dim_Info;
2375:
2376: -- Put request date into var for consistency
2377: v_request_date := sysdate;

Line 2504: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID = p_request_id;

2500: --the specific request from all the three tables.
2501:
2502: IF(p_request_id is not null) THEN
2503:
2504: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID = p_request_id;
2505: DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID = p_request_id;
2506: DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_ID = p_request_id;
2507:
2508:

Line 2511: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM

2507:
2508:
2509: ELSIF(l_start_date IS NOT NULL AND l_end_date IS NOT NULL) THEN
2510:
2511: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
2512: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND
2513: l_end_date);
2514:
2515: DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM

Line 2524: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM

2520: l_end_date;
2521:
2522: ELSIF(l_start_date IS NOT NULL AND l_end_date IS NULL) THEN
2523:
2524: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
2525: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE > l_start_date);
2526:
2527: DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
2528: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE > l_start_date);

Line 2534: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM

2530: DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE > l_start_date;
2531:
2532: ELSIF(l_start_date IS NULL AND l_end_date IS NOT NULL) THEN
2533:
2534: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
2535: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE < l_end_date);
2536:
2537: DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
2538: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE < l_end_date);

Line 2544: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS;

2540: DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE < l_end_date;
2541:
2542: ELSE -- Delete all :-(
2543:
2544: DELETE FROM FEM_BR_DIS_MBR_CONTEXTS;
2545: DELETE FROM FEM_BR_DIS_MBR_HIER;
2546: DELETE FROM FEM_BR_DIS_MBR_REQUESTS;
2547:
2548: END IF;