APPS.FEM_BR_CONDITION_PVT dependencies on FEM_COND_COMPONENTS

Line 311: from fem_cond_components

307:
308: CURSOR c1 IS
309: SELECT cond_component_obj_id,
310: data_dim_flag
311: from fem_cond_components
312: where condition_obj_def_id = p_obj_def_id;
313: l_api_name constant varchar2(30) := 'DeleteConditions';
314:
315:

Line 332: FROM fem_cond_components

328: FETCH c1 into v_cond_comp_obj_id, v_data_dim_flag;
329:
330: SELECT count(*)
331: INTO v_component_rows_num
332: FROM fem_cond_components
333: WHERE cond_component_obj_id = v_cond_comp_obj_id;
334:
335: FEM_ENGINES_PKG.Tech_Message (
336: p_severity => G_LOG_LEVEL_3

Line 375: delete from fem_cond_components

371: ,p_module => G_BLOCK||'.'||l_api_name
372: ,p_msg_text => 'continue'
373: );
374:
375: delete from fem_cond_components
376: where condition_obj_def_id = p_obj_def_id;
377:
378: delete from fem_object_dependencies where object_definition_id = p_obj_def_id;
379: FEM_ENGINES_PKG.Tech_Message (

Line 393: -- FEM_COND_COMPONENTS table.

389: -- CopyConditions
390: --
391: -- DESCRIPTION
392: -- Creates a new Condition Rule Definition by copying records in the
393: -- FEM_COND_COMPONENTS table.
394: --
395: -- IN
396: -- p_source_obj_def_id - Source Object Definition ID.
397: -- p_target_obj_def_id - Target Object Definition ID.

Line 412: insert into fem_cond_components(

408: --------------------------------------------------------------------------------
409: IS
410: BEGIN
411:
412: insert into fem_cond_components(
413: condition_obj_def_id
414: ,cond_component_obj_id
415: ,data_dim_flag
416: ,created_by

Line 432: from fem_cond_components

428: ,FND_GLOBAL.user_id
429: ,sysdate
430: ,FND_GLOBAL.login_id
431: ,object_version_number
432: from fem_cond_components
433: where condition_obj_def_id = p_source_obj_def_id;
434:
435: END CopyConditions;
436:

Line 478: FROM fem_cond_components

474: );
475:
476: SELECT count(*)
477: INTO v_component_rows_num
478: FROM fem_cond_components
479: WHERE cond_component_obj_id = p_cond_component_obj_id
480: AND condition_obj_def_id <> p_condition_obj_def_id;
481:
482: FEM_ENGINES_PKG.Tech_Message (