[Home] [Help]
1: PACKAGE BODY FEM_CHECK_BR_DIS_MBRS_PKG AS
2: /* $Header: fem_chk_dis_mbrs.plb 120.3.12010000.2 2008/10/10 22:27:08 huli ship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PRIVATE VARIABLES
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,
576: l.meaning context, b.dimension_id, dim.dimension_name,
2226: -- DESCRIPTION
2227: -- This is the entrance to the reporting program and is invoked
2228: -- by the concurrent manager for the executable FEM_CHECK_BRDIS_MBRS.
2229: -- It will make calls to other procedures in the
2230: -- FEM_CHECK_BR_DIS_MBRS_PKG to check the root rules
2231: -- for Disabled Members and report on the results.
2232: --
2233: -------------------------------------------------------------------------------
2234: PROCEDURE Report_Invalid_Rules (
2244: -------------------------------------------------------------------------------
2245: IS
2246: --
2247: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2248: 'fem.plsql.fem_check_br_dis_mbrs_pkg.report_invalid_rules';
2249: --
2250: l_effective_date DATE;
2251: v_return_status VARCHAR2(1);
2252: v_msg_count NUMBER;
2483: p_execution_end_date IN VARCHAR2,
2484: p_request_id IN NUMBER) IS
2485:
2486: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2487: 'fem.plsql.fem_check_br_dis_mbrs_pkg.purge_report_data';
2488: l_start_date DATE;
2489: l_end_date DATE;
2490:
2491: BEGIN
2564: END Purge_Report_Data;
2565: ------------------------------------------------------------------------------
2566:
2567:
2568: END FEM_CHECK_BR_DIS_MBRS_PKG;