[Home] [Help]
23: | 20-MAR-07 RFlippo modfied refresh_maprule_from_snapshot to handle
24: | data in fem_object_dependencies
25: | 27-MAR-07 RFlippo fixed issues with cr_new_ver_from_defaults; added
26: | get_default_definition
27: | 29-MAR-07 RFlippo added insert into fem_alloc_br_objects when create
28: | new default rule
29: | 12-APR-07 RFlippo fixed issues with Table data components in
30: | generate_condition_summary
31: | 26-APR-07 RFlippo added generate_fctr_summary API for creating the
35: | except for gen_cond_summary and gen_fctr_summary;
36: | also changed start/end date default logic to use
37: | profile options first
38: | 24-MAY-07 RFlippo modified get_default_definition so that
39: | it does not try to insert into fem_alloc_br_objects
40: | when a default definition already exists
41: | 29-JUN-2007 asadadek bug#6158146. Call API delete_map_rule_content to handle
42: | deletion of map rule contents minus the helper records
43: | instead of DeleteObjectDefinition.
196: AND helper_object_type_code = 'MAPPING_EDIT_SNAPSHOT';
197:
198: SELECT map_rule_type_code
199: INTO v_rule_type_code
200: FROM fem_alloc_br_objects
201: WHERE map_rule_object_id = v_object_id;
202:
203: IF v_rule_type_code = 'ADJUSTMENT' THEN
204: v_dflt_usage := 'VALUE';
1112: v_msg_count NUMBER;
1113: v_msg_data VARCHAR2(4000);
1114:
1115: v_dflt_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
1116: v_map_rule_type_code FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
1117: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
1118: v_global_vs_combo_id fem_global_vs_combos_b.global_vs_combo_id%TYPE;
1119:
1120: e_unexp EXCEPTION;
1179:
1180: SELECT O.map_rule_type_code
1181: INTO v_map_rule_type_code
1182: FROM fem_object_catalog_vl C, fem_object_definition_vl D,
1183: fem_alloc_br_objects O
1184: WHERE D.object_id = C.object_id
1185: AND D.object_definition_id = p_map_rule_obj_def_id
1186: AND C.object_type_code = 'MAPPING_RULE'
1187: AND C.object_id = O.map_rule_object_id;
1201:
1202: BEGIN
1203: SELECT min (D.object_definition_id)
1204: INTO v_dflt_obj_def_id
1205: FROM fem_object_definition_b D, fem_alloc_br_objects O,
1206: fem_object_catalog_b C
1207: WHERE C.object_id = D.object_id
1208: AND C.object_type_code = C_DFLT_OBJTYPE
1209: AND C.object_id = O.map_rule_object_id
1373:
1374: v_count NUMBER;
1375:
1376: v_dflt_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
1377: v_map_rule_type_code FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
1378: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
1379:
1380: v_global_vs_combo_id fem_global_vs_combos_b.global_vs_combo_id%TYPE;
1381: v_object_name fem_object_catalog_tl.object_name%TYPE;
1471: ,x_msg_data => v_msg_data);
1472:
1473: SELECT min (D.object_definition_id)
1474: INTO x_dflt_objdef_id
1475: FROM fem_object_definition_b D, fem_alloc_br_objects O,
1476: fem_object_catalog_b C
1477: WHERE C.object_id = D.object_id
1478: AND C.object_type_code = C_DFLT_OBJTYPE
1479: AND C.object_id = O.map_rule_object_id
1494: SELECT D1.objdef, C1.object_id
1495: INTO v_seeded_dflt_obj_def_id,v_seeded_dflt_object_id
1496: FROM
1497: (SELECT min (D.object_definition_id) objdef
1498: FROM fem_object_definition_b D, fem_alloc_br_objects O,
1499: fem_object_catalog_b C
1500: WHERE C.object_id = D.object_id
1501: AND C.object_type_code = C_DFLT_OBJTYPE
1502: AND C.object_id = O.map_rule_object_id
1606: ,p_target_obj_def_id => x_dflt_objdef_id
1607: ,p_created_by => c_user_id
1608: ,p_creation_date => sysdate);
1609:
1610: /* Insert the rule type information into fem_alloc_br_objects */
1611: INSERT INTO fem_alloc_br_objects (
1612: MAP_RULE_OBJECT_ID
1613: ,MAP_RULE_TYPE_CODE
1614: ,OBJECT_VERSION_NUMBER
1607: ,p_created_by => c_user_id
1608: ,p_creation_date => sysdate);
1609:
1610: /* Insert the rule type information into fem_alloc_br_objects */
1611: INSERT INTO fem_alloc_br_objects (
1612: MAP_RULE_OBJECT_ID
1613: ,MAP_RULE_TYPE_CODE
1614: ,OBJECT_VERSION_NUMBER
1615: ,CREATION_DATE
2562:
2563: v_dflt_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
2564: v_snap_obj_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
2565: v_snap_objdef_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
2566: v_map_rule_type_code FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
2567:
2568:
2569: v_folder_id fem_folders_b.folder_id%TYPE;
2570: v_object_name fem_object_catalog_tl.object_name%TYPE;
2633: BEGIN
2634:
2635: SELECT O.map_rule_type_code, C.folder_id
2636: INTO v_map_rule_type_code, v_folder_id
2637: FROM fem_object_catalog_b C, fem_alloc_br_objects O
2638: WHERE C.object_id = p_map_rule_obj_id
2639: AND C.object_type_code = 'MAPPING_RULE'
2640: AND C.object_id = O.map_rule_object_id;
2641:
2856:
2857: BEGIN
2858: SELECT min (D.object_definition_id)
2859: INTO v_dflt_objdef_id
2860: FROM fem_object_definition_b D, fem_alloc_br_objects O,
2861: fem_object_catalog_b C
2862: WHERE C.object_id = D.object_id
2863: AND C.object_type_code = C_DFLT_OBJTYPE
2864: AND C.object_id = O.map_rule_object_id
3078: --Get the mapping Rule Type Code.
3079: BEGIN
3080:
3081: select map_rule_type_code into v_map_rule_type_code
3082: from fem_alloc_br_objects abo,fem_object_definition_b defs
3083: where defs.object_definition_id = p_object_definition_id
3084: and abo.map_rule_object_id = defs.object_id ;
3085:
3086: EXCEPTION