[Home] [Help]
PACKAGE BODY: APPS.FEM_COL_POP_TMPL_PVT
Source
1 PACKAGE BODY FEM_COL_POP_TMPL_PVT AS
2 /* $Header: FEMVCOTB.pls 120.0 2005/06/06 21:16:45 appldev noship $ */
3
4 --------------------------------------------------------------------------------
5 -- PRIVATE CONSTANTS
6 --------------------------------------------------------------------------------
7
8 G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_BR_COLUMN_OBJ_TMPL_PVT;';
9
10 --------------------------------------------------------------------------------
11 -- PRIVATE SPECIFICATIONS
12 --------------------------------------------------------------------------------
13
14
15
16
17 PROCEDURE CopyColPopTmpltRec(
18 p_source_obj_def_id IN NUMBER
19 ,p_target_obj_def_id IN NUMBER
20 ,p_created_by IN NUMBER
21 ,p_creation_date IN DATE
22 );
23
24
25 PROCEDURE DeleteColPopTmpltRec(
26 p_obj_def_id IN NUMBER
27 );
28
29 --------------------------------------------------------------------------------
30 -- PUBLIC BODIES
31 --------------------------------------------------------------------------------
32
33
34 --
35 -- PROCEDURE
36 -- CopyObjectDefinition
37 --
38 -- DESCRIPTION
39 -- Creates all the detail records of a new Column Object Template Definition(target)
40 -- by copying the detail records of another Column Object Template Definition (source).
41 --
42 -- IN
43 -- p_source_obj_def_id - Source Object Definition ID.
44 -- p_target_obj_def_id - Target Object Definition ID.
45 -- p_created_by - FND User ID (optional).
46 -- p_creation_date - System Date (optional).
47 --
48 --------------------------------------------------------------------------------
49 PROCEDURE CopyObjectDefinition(
50 p_source_obj_def_id IN NUMBER
51 ,p_target_obj_def_id IN NUMBER
52 ,p_created_by IN NUMBER
53 ,p_creation_date IN DATE
54 )
55 --------------------------------------------------------------------------------
56 IS
57
58 g_api_name CONSTANT VARCHAR2(30) := 'CopyObjectDefinition';
59
60 BEGIN
61
62
63 CopyColPopTmpltRec(
64 p_source_obj_def_id => p_source_obj_def_id
65 ,p_target_obj_def_id => p_target_obj_def_id
66 ,p_created_by => p_created_by
67 ,p_creation_date => p_creation_date
68
69 );
70
71
72 EXCEPTION
73
74 WHEN OTHERS THEN
75 FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, g_api_name);
76 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77
78 END CopyObjectDefinition;
79
80
81 --
82 -- PROCEDURE
83 -- DeleteObjectDefinition
84 --
85 -- DESCRIPTION
86 -- Deletes all the details records of a Column Object Template Definition.
87 --
88 -- IN
89 -- p_obj_def_id - Object Definition ID.
90 --
91 --------------------------------------------------------------------------------
92 PROCEDURE DeleteObjectDefinition(
93 p_obj_def_id IN NUMBER
94 )
95 --------------------------------------------------------------------------------
96 IS
97
98 g_api_name CONSTANT VARCHAR2(30) := 'DeleteObjectDefinition';
99
100 BEGIN
101
102 DeleteColPopTmpltRec(
103 p_obj_def_id => p_obj_def_id
104 );
105
106 EXCEPTION
107
108 WHEN OTHERS THEN
109 FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, g_api_name);
110 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111
112 END DeleteObjectDefinition;
113
114
115
116 --------------------------------------------------------------------------------
117 -- PRIVATE BODIES
118 --------------------------------------------------------------------------------
119
120
121
122 --
123 -- PROCEDURE
124 -- CopyColPopTmpltRec
125 --
126 -- DESCRIPTION
127 -- Creates a new Column Object Template Definition by copying records in the
128 -- FEM_COL_POP_TMPLT_DTL table.
129 --
130 -- IN
131 -- p_source_obj_def_id - Source Object Definition ID.
132 -- p_target_obj_def_id - Target Object Definition ID.
133 -- p_created_by - FND User ID (optional).
134 -- p_creation_date - System Date (optional).
135 --
136 --------------------------------------------------------------------------------
137 PROCEDURE CopyColPopTmpltRec(
138 p_source_obj_def_id IN NUMBER
139 ,p_target_obj_def_id IN NUMBER
140 ,p_created_by IN NUMBER
141 ,p_creation_date IN DATE
142 )
143 --------------------------------------------------------------------------------
144 IS
145
146 l_row_id VARCHAR2(500);
147 l_last_updated_by NUMBER;
148 l_last_update_login NUMBER;
149 l_source_table_name VARCHAR2(50);
150
151 BEGIN
152
153 l_last_updated_by := FND_GLOBAL.USER_ID;
154 l_last_update_login := FND_GLOBAL.LOGIN_ID;
155
156 INSERT INTO FEM_COL_POPULATION_TMPLT_VL(
157 COL_POP_TEMPLT_OBJ_DEF_ID
158 ,TARGET_TABLE_NAME
159 ,TARGET_COLUMN_NAME
160 ,DATA_POPULATION_METHOD_CODE
161 ,SOURCE_TABLE_NAME
162 ,SOURCE_COLUMN_NAME
163 ,DIMENSION_ID
164 ,ATTRIBUTE_ID
165 ,ATTRIBUTE_VERSION_ID
166 ,AGGREGATION_METHOD
167 ,CONSTANT_NUMERIC_VALUE
168 ,CONSTANT_ALPHANUMERIC_VALUE
169 ,CONSTANT_DATE_VALUE
170 ,CREATED_BY
171 ,CREATION_DATE
172 ,LAST_UPDATED_BY
173 ,LAST_UPDATE_DATE
174 ,LAST_UPDATE_LOGIN
175 ,OBJECT_VERSION_NUMBER
176 ,SYSTEM_RESERVED_FLAG
177 ,ENG_PROC_PARAM
178 ,PARAMETER_FLAG
179 ,DESCRIPTION
180 ) SELECT
181 p_target_obj_def_id
182 ,TARGET_TABLE_NAME
183 ,TARGET_COLUMN_NAME
184 ,DATA_POPULATION_METHOD_CODE
185 ,SOURCE_TABLE_NAME
186 ,SOURCE_COLUMN_NAME
187 ,DIMENSION_ID
188 ,ATTRIBUTE_ID
189 ,ATTRIBUTE_VERSION_ID
190 ,AGGREGATION_METHOD
191 ,CONSTANT_NUMERIC_VALUE
192 ,CONSTANT_ALPHANUMERIC_VALUE
193 ,CONSTANT_DATE_VALUE
194 ,NVL(p_created_by,created_by)
195 ,NVL(p_creation_date,creation_date)
196 ,FND_GLOBAL.user_id
197 ,SYSDATE
198 ,FND_GLOBAL.login_id
199 ,OBJECT_VERSION_NUMBER
200 ,SYSTEM_RESERVED_FLAG
201 ,ENG_PROC_PARAM
202 ,PARAMETER_FLAG
203 ,DESCRIPTION
204 FROM FEM_COL_POPULATION_TMPLT_VL
205 WHERE COL_POP_TEMPLT_OBJ_DEF_ID = p_source_obj_def_id;
206
207 END CopyColPopTmpltRec;
208
209
210 --
211 -- PROCEDURE
212 -- DeleteCalRuleRec
213 --
214 -- DESCRIPTION
215 -- Deletes a Column Object Template Definition by performing deletes on records
216 -- in the FEM_COL_POP_TMPLT_DTL table.
217 --
218 -- IN
219 -- p_obj_def_id - Object Definition ID.
220 --
221 --------------------------------------------------------------------------------
222 PROCEDURE DeleteColPopTmpltRec(
223 p_obj_def_id IN NUMBER
224 )
225 --------------------------------------------------------------------------------
226 IS
227 BEGIN
228
229
230 DELETE FROM FEM_COL_POPULATION_TMPLT_VL
231 WHERE COL_POP_TEMPLT_OBJ_DEF_ID = p_obj_def_id;
232
233 END DeleteColPopTmpltRec;
234
235
236 END FEM_COL_POP_TMPL_PVT;