1 PACKAGE FEM_FUNC_DIM_PVT AS
2 /* $Header: FEMVFUNCDIMS.pls 120.0 2006/05/11 05:46:10 ahyanki noship $ */
3
4 --------------------------------------------------------------------------------
5 -- PUBLIC CONSTANTS
6 --------------------------------------------------------------------------------
7
8
9 --------------------------------------------------------------------------------
10 -- PUBLIC SPECIFICATIONS
11 --------------------------------------------------------------------------------
12
13
14 --
15 -- PROCEDURE
16 -- CopyObjectDefinition
17 --
18 -- DESCRIPTION
19 -- Creates all the detail records of a Functional Dimension Definition (target)
20 -- by copying the detail records of another Functional Dimension Definition (source).
21 --
22 -- IN
23 -- p_source_obj_def_id - Source Object Definition ID.
24 -- p_target_obj_def_id - Target Object Definition ID.
25 -- p_created_by - FND User ID (optional).
26 -- p_creation_date - System Date (optional).
27
28 PROCEDURE CopyObjectDefinition(
29 p_source_obj_def_id IN NUMBER
30 ,p_target_obj_def_id IN NUMBER
31 ,p_created_by IN NUMBER
32 ,p_creation_date IN DATE
33 );
34
35 --
36 -- PROCEDURE
37 -- DeleteObjectDefinition
38 --
39 -- DESCRIPTION
40 -- Deletes all the details records related to a FUnctional Dimension Definition.
41 --
42 -- IN
43 -- p_obj_def_id - Object Definition ID.
44 --
45 PROCEDURE DeleteObjectDefinition(
46 p_obj_def_id IN NUMBER
47 );
48
49 --
50 -- PROCEDURE
51 -- GetDataColumnDimension
52 --
53 -- DESCRIPTION
54 -- Fetches dimension_id and functional dimension set name for a given
55 -- version id, table name and column name
56 --
57 -- IN
58 -- p_version_id - given version id.
59 -- p_table_name - given table name.
60 -- p_column_name - given column name.
61 -- x_dimension_id - out parameter for dimension id.
62 -- x_func_dim_set_name - out parameter for functional dimension set name.
63 --
64 PROCEDURE GetDataColumnDimension(
65 p_version_id IN NUMBER
66 ,p_table_name IN VARCHAR2
67 ,p_column_name IN VARCHAR2
68 ,x_dimension_id OUT NOCOPY NUMBER
69 ,x_func_dim_set_name OUT NOCOPY VARCHAR2
70 );
71
72 --
73 -- PROCEDURE
74 -- UpdateColumnDisplayNames
75 --
76 -- DESCRIPTION
77 -- Updates display name for a column-table combination in FEM_TAB_COLUMNS_VL depending upon given
78 -- p_set_ids in a collection
79 -- IN
80 -- p_sets - given set ids.
81 --
82 PROCEDURE UpdateColumnDisplayNames(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85 p_commit IN VARCHAR2 := FND_API.G_FALSE,
86 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 --
91 p_sets IN FEM_FUNC_DIM_SET_TYP
92 );
93
94
95 END FEM_FUNC_DIM_PVT;