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_REQUESTS

Line 2258: v_request_name FEM_BR_DIS_MBR_REQUESTS.request_name%TYPE;

2254: v_global_vs_id NUMBER;
2255: v_num_root_rules NUMBER;
2256: v_num_rules_invalid NUMBER;
2257: v_all_rules_are_valid VARCHAR2(1);
2258: v_request_name FEM_BR_DIS_MBR_REQUESTS.request_name%TYPE;
2259: v_request_date DATE;
2260: --
2261: -- Get all root rules to be checked for disabled members
2262: CURSOR c_root_rules IS

Line 2371: -- 2. Populate FEM_BR_DIS_MBR_REQUESTS

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;
2375:

Line 2386: INSERT INTO fem_br_dis_mbr_requests(

2382: ELSE
2383: v_request_name := p_request_name;
2384: END IF;
2385:
2386: INSERT INTO fem_br_dis_mbr_requests(
2387: request_id, request_date, request_name,
2388: object_type_code, object_type_name,
2389: ledger_id, ledger_name,
2390: effective_date, object_id, object_name,

Line 2506: DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_ID = p_request_id;

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:
2509: ELSIF(l_start_date IS NOT NULL AND l_end_date IS NOT NULL) THEN
2510:

Line 2512: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND

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
2516: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND

Line 2516: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND

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
2516: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND
2517: l_end_date);
2518:
2519: DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND
2520: l_end_date;

Line 2519: DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND

2515: DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
2516: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND
2517: l_end_date);
2518:
2519: DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND
2520: l_end_date;
2521:
2522: ELSIF(l_start_date IS NOT NULL AND l_end_date IS NULL) THEN
2523:

Line 2525: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE > l_start_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);
2529:

Line 2528: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE > l_start_date);

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);
2529:
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

Line 2530: DELETE FROM 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);
2529:
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

Line 2535: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE < l_end_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);
2539:

Line 2538: FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE < l_end_date);

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);
2539:
2540: DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE < l_end_date;
2541:
2542: ELSE -- Delete all :-(

Line 2540: DELETE FROM 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);
2539:
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;

Line 2546: DELETE FROM FEM_BR_DIS_MBR_REQUESTS;

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;
2549:
2550: COMMIT;