APPS.FEM_RULE_SET_MANAGER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 176

         select   o.object_name
            from  fem_object_catalog_vl o
            where o.object_id = p_Obj_ID;

Line: 395

         SELECT o.object_id
            from   fem_object_catalog_b o
                  ,fem_object_definition_b od
            where       o.object_id = od.object_id
                  and   od.object_definition_id = p_Obj_Def_ID;

Line: 457

         select    o.object_name
                  ,f.folder_name
            from   fem_object_catalog_vl o
                  ,fem_folders_vl f
            where       o.object_id = p_Obj_ID
                  and   f.folder_id = o.folder_id;

Line: 1451

      insert into fem_ruleset_process_data
         (RULE_SET_OBJ_ID
         ,CHILD_OBJ_ID
         ,CHILD_OBJ_DEF_ID
         ,ENGINE_EXECUTION_SEQUENCE
         ,REQUEST_ID
         ,CREATION_DATE
         ,CREATED_BY
         ,LAST_UPDATE_DATE
         ,LAST_UPDATED_BY
         ,LAST_UPDATE_LOGIN
         )
         values
         (p_RuleSet_Object_ID
         ,p_Child_Object_ID
         ,p_Child_Object_Definition_ID
         ,p_Engine_Execution_Seq
         ,z_conc_request_id
         ,sysdate
         ,z_user_id
         ,sysdate
         ,z_user_id
         ,z_login_id
         );

Line: 1511

         SELECT   a.dataset_name
                  ,b.output_dataset_code
            from
                   fem_datasets_vl a
                  ,fem_ds_input_output_defs b
            where          b.output_dataset_code = a.dataset_code
                     and   b.dataset_io_obj_def_id = p_DS_IO_Def_ID;

Line: 1520

         select   a.DIM_ATTRIBUTE_VARCHAR_MEMBER
            from  FEM_DATASETS_ATTR a
                  ,FEM_DIM_ATTRIBUTES_B b
            where          a.DATASET_CODE = p_Output_Dataset_Code
                  and      b.ATTRIBUTE_ID = a.ATTRIBUTE_ID
                  and      b.ATTRIBUTE_VARCHAR_LABEL = 'PRODUCTION_FLAG';

Line: 1663

      select
             a.required_object_id
            ,o.object_name
            ,f.folder_name
            ,o.object_type_code
            ,t.OBJECT_TYPE_NAME
         from
             fem_object_dependencies a
            ,fem_object_catalog_vl o
            ,fem_folders_vl f
            ,fem_object_types t
         where       a.object_definition_id = p_Parent_Obj_Def_Id
               and   a.required_object_id = o.object_id
               and   o.folder_id = f.folder_id
               and   t.object_type_code = o.object_type_code;

Line: 1727

         select count(required_object_id)
            into
               l_Dependent_Object_Count
            from fem_object_Dependencies
            where object_definition_id = p_Parent_Obj_Def_Id;

Line: 2075

         select
               rs.RULE_SET_OBJECT_TYPE_CODE        as Current_RuleSet_Obj_Type
               ,rsm.CHILD_EXECUTION_SEQUENCE       as Child_Execution_Sequence
               ,rsm.CHILD_OBJ_ID                   as Child_Object_ID
               ,cm_o.OBJECT_TYPE_CODE              as Child_Object_Type
               ,cm_o.OBJECT_NAME                   as Child_Object_Display_Name
               ,cm_f.FOLDER_NAME                   as Child_Folder_Name
               ,rsm.EXECUTE_CHILD_FLAG             as Execute_Child_Flag
               ,nvl(cm_o.LOCAL_VS_COMBO_ID,-1)     as Child_Local_VS_Combo_ID
            from
                FEM_RULE_SET_MEMBERS rsm
               ,FEM_RULE_SETS rs
               ,FEM_OBJECT_CATALOG_VL cm_o
               ,FEM_OBJECT_DEFINITION_B rsm_d
               ,FEM_FOLDERS_VL cm_f
            where
                     rsm.RULE_SET_OBJ_DEF_ID = rsm_d.OBJECT_DEFINITION_ID
               and   rsm_d.OBJECT_ID = p_Curr_RuleSet_Object_ID
               and   rsm.RULE_SET_OBJ_DEF_ID = rs.RULE_SET_OBJ_DEF_ID
               --and rsm.CHILD_ENABLED_FLAG = 'Y'
               and   rsm.CHILD_OBJ_ID = cm_o.OBJECT_ID
               and   cm_f.FOLDER_ID = cm_o.FOLDER_ID
            order by rsm.CHILD_EXECUTION_SEQUENCE;

Line: 2863

         select   local_vs_combo_id
            into  l_Rule_Local_VSCID
            from  Fem_Object_Catalog_B
            where object_id = p_Rule_Object_ID;

Line: 3135

         select local_vs_combo_id
            into  l_RuleSet_LocalVSComboID
            from  Fem_Object_Catalog_B
            where object_id = p_Orig_RuleSet_Object_ID;

Line: 3284

   PROCEDURE FEM_DeleteFlatRuleList_PVT(
                                 p_api_version                 IN             NUMBER
                                ,p_init_msg_list               IN             VARCHAR2 := FND_API.G_FALSE
                                ,p_commit                      IN             VARCHAR2 := FND_API.G_FALSE
                                ,p_encoded                     IN             VARCHAR2 := FND_API.G_TRUE
                                ,x_return_status               OUT   NOCOPY   VARCHAR2
                                ,x_msg_count                   OUT   NOCOPY   NUMBER
                                ,x_msg_data                    OUT   NOCOPY   VARCHAR2
                                ,p_RuleSet_Object_ID  IN             DEF_OBJECT_ID%TYPE
                                )
   IS
      l_api_version                    NUMBER := 1.0;

Line: 3309

      SAVEPOINT FEM_DeleteFlatRuleList_SvPt;

Line: 3325

      DELETE FROM fem_ruleset_process_DATA
            WHERE       request_id = FND_GLOBAL.CONC_REQUEST_ID
                  AND   rule_set_obj_id = p_RuleSet_Object_ID;

Line: 3355

            ROLLBACK TO FEM_DeleteFlatRuleList_SvPt;

Line: 3363

   END FEM_DeleteFlatRuleList_PVT;

Line: 3595

         select local_vs_combo_id
            into  l_RuleSet_LocalVSComboID
            from  Fem_Object_Catalog_B
            where object_id = p_Orig_RuleSet_Object_ID;