364: IS
365: CURSOR c_cond_def_id (p_obj_id NUMBER)
366: IS
367: select object_definition_id
368: from fem_object_definition_b
369: where object_id = p_obj_id
370: and old_approved_copy_flag = 'N';
371: l_cond_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
372: BEGIN
367: select object_definition_id
368: from fem_object_definition_b
369: where object_id = p_obj_id
370: and old_approved_copy_flag = 'N';
371: l_cond_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
372: BEGIN
373: OPEN c_cond_def_id (p_obj_id);
374: FETCH c_cond_def_id INTO l_cond_def_id;
375: IF c_cond_def_id%NOTFOUND THEN
484: /* Have we deleted the last object definition for this helper object?
485: If so - delete the helper object also*/
486: SELECT count(*)
487: INTO v_count
488: FROM fem_object_definition_b
489: WHERE object_id = helper_rule.helper_object_id;
490:
491: IF v_count = 0 THEN
492:
866: and obj.object_type_code = 'CONDITION_MAPPING');
867:
868: l_formula_rec c_allc_br_formula%ROWTYPE;
869:
870: l_source_cond_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
871: l_source_cond_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
872:
873: l_target_cond_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
874: l_target_cond_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
869:
870: l_source_cond_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
871: l_source_cond_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
872:
873: l_target_cond_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
874: l_target_cond_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
875: l_target_cond_obj_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
876: l_target_cond_obj_def_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
877:
874: l_target_cond_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
875: l_target_cond_obj_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
876: l_target_cond_obj_def_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
877:
878: l_backup_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
879: l_current_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
880:
881: l_return_status varchar2(1);
882: l_msg_count number;
875: l_target_cond_obj_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
876: l_target_cond_obj_def_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
877:
878: l_backup_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
879: l_current_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
880:
881: l_return_status varchar2(1);
882: l_msg_count number;
883: l_msg_data varchar2(2000);