1 PACKAGE FEM_BR_MAPPING_RULE_PVT AS
2 /* $Header: FEMVMAPS.pls 120.4.12010000.1 2008/07/24 11:02:34 appldev ship $ */
3
4 --------------------------------------------------------------------------------
5 -- PUBLIC CONSTANTS
6 --------------------------------------------------------------------------------
7
8 --------------------------------------------------------------------------------
9 -- PUBLIC SPECIFICATIONS
10 --------------------------------------------------------------------------------
11
12 --
13 -- PROCEDURE
14 -- CopyObjectDetails
15 --
16 -- DESCRIPTION
17 -- Copies the object extension data for fem_alloc_br_objects
18 -- for mapping rules.
19 --
20 -- IN
21 -- p_copy_type_code - Copy Type Code (ignored by procedure)
22 -- p_source_obj_def_id - Source Object ID.
23 -- p_target_obj_def_id - Target Object ID.
24 -- p_created_by - FND User ID (optional).
25 -- p_creation_date - System Date (optional).
26 --
27 PROCEDURE CopyObjectDetails (
28 p_copy_type_code in varchar2
29 ,p_source_obj_id in number
30 ,p_target_obj_id in number
31 ,p_created_by in number
32 ,p_creation_date in date
33 );
34
35 --
36 -- PROCEDURE
37 -- DeleteObjectDetails
38 --
39 -- DESCRIPTION
40 -- Deletes the object extension data from fem_alloc_br_objects
41 -- for mapping rules.
42 --
43 -- IN
44 -- p_obj_id - Object ID.
45 --
46 PROCEDURE DeleteObjectDetails (
47 p_obj_id in number
48 );
49
50
51 --
52 -- PROCEDURE
53 -- DeleteObjectDefinition
54 --
55 -- DESCRIPTION
56 -- Deletes all the details records of a Mapping Rule Definition.
57 --
58 -- IN
59 -- p_obj_def_id - Object Definition ID.
60 --
61 PROCEDURE DeleteObjectDefinition(
62 p_obj_def_id in number
63 );
64
65
66 --
67 -- PROCEDURE
68 -- CopyObjectDefinition
69 --
70 -- DESCRIPTION
71 -- Creates all the detail records of a new Mapping Rule Definition (target)
72 -- by copying the detail records of another Mapping Rule Definition (source).
73 --
74 -- IN
75 -- p_copy_type_code - Copy Type Code
76 -- p_source_obj_def_id - Source Object Definition ID.
77 -- p_target_obj_def_id - Target Object Definition ID.
78 -- p_created_by - FND User ID (optional).
79 -- p_creation_date - System Date (optional).
80 --
81 PROCEDURE CopyObjectDefinition(
82 p_copy_type_code in varchar2
83 ,p_source_obj_def_id in number
84 ,p_target_obj_def_id in number
85 ,p_created_by in number
86 ,p_creation_date in date
87 );
88
89 --
90 -- PROCEDURE
91 -- synchronize_mapping_definition
92 --
93 -- DESCRIPTION
94 -- Synchronize the mappping definition with meta data.
95 -- Psudo code
96 -- Loop through all corresponding formula rows
97 -- for every formula row that includes a table
98 -- if the table is enabled
99 -- call synchronize_dim_rows
100 -- else if FEM_BALANCES is enabled
101 -- update the formula row with FEM_BALANCES
102 -- delete all corresponding rows in the FEM_ALLOC_BR_DIMENSIONS
103 -- populate default rows in the FEM_ALLOC_BR_DIMENSIONS for FEM_BALANCES
104 -- else if FEM_BALANCES is disabled
105 -- error out
106 --
107 -- IN
108 -- p_api_version - API Version
109 -- p_init_msg_list - Initialize Message List Flag (Boolean)
110 -- p_commit - Commit Work Flag (Boolean)
111 -- p_obj_def_id - Object Definition ID
112 --
113 -- OUT
114 -- x_return_status - Return Status of API Call
115 -- x_msg_count - Total Count of Error Messages in API Call
116 -- x_msg_data - Error Message in API Call
117 --
118 PROCEDURE synchronize_mapping_definition(
119 p_api_version in number
120 ,p_init_msg_list in varchar2 := FND_API.G_FALSE
121 ,p_commit in varchar2 := FND_API.G_FALSE
122 ,p_obj_def_id in number
123 ,x_return_status out nocopy varchar2
124 ,x_msg_count out nocopy number
125 ,x_msg_data out nocopy varchar2
126 );
127
128
129
130 --
131 -- PROCEDURE
132 -- delete_map_rule_content
133 --
134 -- DESCRIPTION
135 -- Deletes all the contents of the mapping rule definition.
136 -- except for the catalog data.
137 -- The helper records are not deleted by this API.
138 --
139 -- IN
140 -- p_object_definition_id - Object Definition ID.
141 --
142 PROCEDURE delete_map_rule_content(
143 p_object_definition_id in number
144 );
145
146 -- Bug#6496686 -- Begin
147 --
148 -- PROCEDURE
149 -- DeleteTuningOptionDetails
150 --
151 -- DESCRIPTION
152 -- Deletes any other details associated with a mapping rule.
153 --
154 -- IN
155 -- p_obj_id - Object ID
156 --
157 PROCEDURE DeleteTuningOptionDetails(
158 p_obj_id in number
159 );
160 -- Bug#6496686 -- End
161
162 END FEM_BR_MAPPING_RULE_PVT;