APPS.FEM_ALLOC_BR_UTIL_PKG dependencies on FEM_OBJECT_DEFINITION_VL

Line 395: FROM fem_object_catalog_vl C, fem_object_definition_vl D

391: D.description
392: INTO v_folder_id, v_local_vs_combo_id, v_object_access_code,
393: v_object_origin_code, v_object_name, v_description, v_display_name,
394: v_objdef_desc
395: FROM fem_object_catalog_vl C, fem_object_definition_vl D
396: WHERE D.object_id = C.object_id
397: AND D.object_definition_id = p_map_rule_obj_def_id
398: AND C.object_type_code IN (C_RULE_OBJTYPE, C_DFLT_OBJTYPE);
399:

Line 703: FROM fem_object_catalog_vl C, fem_object_definition_vl D

699: BEGIN
700:
701: SELECT 1
702: INTO v_count
703: FROM fem_object_catalog_vl C, fem_object_definition_vl D
704: WHERE D.object_id = C.object_id
705: AND D.object_definition_id = p_map_rule_obj_def_id
706: AND C.object_type_code IN (C_RULE_OBJTYPE, C_DFLT_OBJTYPE);
707:

Line 753: FROM fem_object_definition_vl

749:
750: /* update the objdef name/description */
751: SELECT display_name, description, effective_start_date, effective_end_date
752: INTO v_snap_objdef_name, v_snap_objdef_desc, v_snap_start_date, v_snap_end_date
753: FROM fem_object_definition_vl
754: WHERE object_definition_id = v_helper_obj_def_id;
755:
756: UPDATE fem_object_definition_vl
757: SET display_name = v_snap_objdef_name, description = v_snap_objdef_desc,

Line 756: UPDATE fem_object_definition_vl

752: INTO v_snap_objdef_name, v_snap_objdef_desc, v_snap_start_date, v_snap_end_date
753: FROM fem_object_definition_vl
754: WHERE object_definition_id = v_helper_obj_def_id;
755:
756: UPDATE fem_object_definition_vl
757: SET display_name = v_snap_objdef_name, description = v_snap_objdef_desc,
758: effective_start_date = v_snap_start_date, effective_end_date = v_snap_end_date
759: WHERE object_definition_id = p_map_rule_obj_def_id;
760:

Line 945: FROM fem_object_catalog_vl C, fem_object_definition_vl D

941: BEGIN
942:
943: SELECT 1
944: INTO v_count
945: FROM fem_object_catalog_vl C, fem_object_definition_vl D
946: WHERE D.object_id = C.object_id
947: AND D.object_definition_id = p_map_rule_obj_def_id
948: AND C.object_type_code IN (C_RULE_OBJTYPE, C_DFLT_OBJTYPE);
949:

Line 1006: FROM fem_object_definition_vl

1002:
1003: /* update the objdef name/description */
1004: SELECT display_name, description, effective_start_date, effective_end_date
1005: INTO v_maprule_objdef_name, v_maprule_objdef_desc,v_maprule_start_date, v_maprule_end_date
1006: FROM fem_object_definition_vl
1007: WHERE object_definition_id = p_map_rule_obj_def_id;
1008:
1009: UPDATE fem_object_definition_vl
1010: SET display_name = v_maprule_objdef_name, description = v_maprule_objdef_desc,

Line 1009: UPDATE fem_object_definition_vl

1005: INTO v_maprule_objdef_name, v_maprule_objdef_desc,v_maprule_start_date, v_maprule_end_date
1006: FROM fem_object_definition_vl
1007: WHERE object_definition_id = p_map_rule_obj_def_id;
1008:
1009: UPDATE fem_object_definition_vl
1010: SET display_name = v_maprule_objdef_name, description = v_maprule_objdef_desc,
1011: effective_start_date = v_maprule_start_date, effective_end_date = v_maprule_end_date
1012: WHERE object_definition_id = v_helper_obj_def_id;
1013:

Line 1182: FROM fem_object_catalog_vl C, fem_object_definition_vl D,

1178: BEGIN
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'

Line 1528: FROM fem_object_definition_vl

1524: END IF;
1525:
1526: SELECT display_name, description
1527: INTO v_objdef_name, v_objdef_desc
1528: FROM fem_object_definition_vl
1529: WHERE object_definition_id = v_seeded_dflt_obj_def_id;
1530:
1531: /* Get the profile option start/end dates */
1532: v_profile_start_value := fnd_profile.value_specific (

Line 2560: v_fem_obj_def_row FEM_OBJECT_DEFINITION_VL%ROWTYPE;

2556: v_return_status VARCHAR2(30);
2557: v_msg_count NUMBER;
2558: v_msg_data VARCHAR2(4000);
2559:
2560: v_fem_obj_def_row FEM_OBJECT_DEFINITION_VL%ROWTYPE;
2561:
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;

Line 2662: FROM fem_object_definition_vl

2658:
2659: /* Create the mapping rule object definition using default obj def as a template */
2660: SELECT *
2661: INTO v_fem_obj_def_row
2662: FROM fem_object_definition_vl
2663: WHERE object_definition_id = v_dflt_obj_def_id;
2664:
2665: FEM_OBJECT_CATALOG_UTIL_PKG.create_object_definition(x_object_definition_id => x_map_rule_objdef_id,
2666: x_msg_count => x_msg_count,

Line 2682: UPDATE fem_object_definition_vl

2678: if(x_return_status <> c_success) THEN
2679: RAISE e_no_objdef;
2680: END IF;
2681:
2682: UPDATE fem_object_definition_vl
2683: SET description = v_fem_obj_def_row.description
2684: WHERE object_definition_id = x_map_rule_objdef_id;
2685:
2686: /* identify the edit snapshot for the mapping rule */