DBA Data[Home] [Help]

APPS.FEM_ALLOC_BR_UTIL_PKG dependencies on FEM_OBJECT_DEFINITION_TL

Line 317: v_display_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;

313: v_object_access_code FEM_OBJECT_CATALOG_B.object_access_code%TYPE;
314: v_object_origin_code FEM_OBJECT_CATALOG_B.object_origin_code%TYPE;
315: v_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
316: v_description FEM_OBJECT_CATALOG_TL.description%TYPE;
317: v_display_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
318: v_object_type_code FEM_OBJECT_CATALOG_B.object_type_code%TYPE;
319:
320: v_profile_start_value VARCHAR2(1000);
321: v_profile_end_value VARCHAR2(1000);

Line 489: update fem_object_definition_tl

485: /* Need to update the description of the snapshot
486: to be the same as the source default rule (since
487: the create_object api doesn't allow us to specify
488: description */
489: update fem_object_definition_tl
490: set description = v_objdef_desc
491: where object_definition_id = x_snapshot_objdef_id;
492:
493:

Line 632: v_snap_objdef_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;

628: v_msg_count NUMBER;
629: v_msg_data VARCHAR2(4000);
630:
631: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
632: v_snap_objdef_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
633: v_snap_objdef_desc FEM_OBJECT_DEFINITION_TL.description%TYPE;
634: v_snap_start_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
635: v_snap_end_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
636:

Line 633: v_snap_objdef_desc FEM_OBJECT_DEFINITION_TL.description%TYPE;

629: v_msg_data VARCHAR2(4000);
630:
631: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
632: v_snap_objdef_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
633: v_snap_objdef_desc FEM_OBJECT_DEFINITION_TL.description%TYPE;
634: v_snap_start_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
635: v_snap_end_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
636:
637:

Line 877: v_maprule_objdef_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;

873: v_msg_data VARCHAR2(4000);
874:
875: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
876:
877: v_maprule_objdef_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
878: v_maprule_objdef_desc FEM_OBJECT_DEFINITION_TL.description%TYPE;
879: v_maprule_start_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
880: v_maprule_end_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
881:

Line 878: v_maprule_objdef_desc FEM_OBJECT_DEFINITION_TL.description%TYPE;

874:
875: v_helper_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
876:
877: v_maprule_objdef_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
878: v_maprule_objdef_desc FEM_OBJECT_DEFINITION_TL.description%TYPE;
879: v_maprule_start_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
880: v_maprule_end_date FEM_OBJECT_DEFINITION_B.effective_start_date%TYPE;
881:
882: v_snapshot_object_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

Line 1598: UPDATE fem_object_definition_tl

1594: END IF;
1595:
1596: /* Update the default rule description (for all languages),
1597: since we couldn't provide it when we created the default rule object */
1598: UPDATE fem_object_definition_tl
1599: SET description = v_objdef_desc
1600: WHERE object_definition_id = x_dflt_objdef_id;
1601:
1602: /* copy the content from the seeded gvsc = null default rule to the new default rule */