[Home] [Help]
87:
88: -- assign out parameters
89: x_object_version_number := l_object_version_number;
90:
91: INSERT INTO CSC_PROF_TABLE_COLUMNS_TL(
92: TABLE_COLUMN_ID,
93: LABEL,
94: CREATED_BY,
95: CREATION_DATE,
111: from FND_LANGUAGES L
112: where L.INSTALLED_FLAG in ('I', 'B')
113: and not exists
114: (select NULL
115: from CSC_PROF_TABLE_COLUMNS_TL T
116: where T.TABLE_COLUMN_ID = Px_TABLE_COLUMN_ID
117: and T.LANGUAGE = L.LANGUAGE_CODE);
118:
119:
153: OBJECT_VERSION_NUMBER = object_version_number + 1
154: where TABLE_COLUMN_ID = p_TABLE_COLUMN_ID
155: RETURNING OBJECT_VERSION_NUMBER INTO px_OBJECT_VERSION_NUMBER;
156:
157: Update CSC_PROF_TABLE_COLUMNS_TL
158: SET
159: LABEL = decode( p_LABEL, CSC_CORE_UTILS_PVT.G_MISS_CHAR, LABEL, p_LABEL),
160: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, CSC_CORE_UTILS_PVT.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
161: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, CSC_CORE_UTILS_PVT.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
188:
189: cursor c1 is select
190: LABEL,
191: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
192: from CSC_PROF_TABLE_COLUMNS_TL
193: where TABLE_COLUMN_ID = P_TABLE_COLUMN_ID
194: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
195: for update of TABLE_COLUMN_ID nowait;
196: begin
209: P_TABLE_COLUMN_ID NUMBER,
210: P_OBJECT_VERSION_NUMBER NUMBER
211: ) is
212: begin
213: delete from CSC_PROF_TABLE_COLUMNS_TL
214: where TABLE_COLUMN_ID = P_TABLE_COLUMN_ID;
215:
216: if (sql%notfound) then
217: raise no_data_found;
230: p_BLOCK_ID NUMBER,
231: p_TABLE_NAME VARCHAR2,
232: p_COLUMN_NAME VARCHAR2) IS
233: Begin
234: DELETE FROM CSC_PROF_TABLE_COLUMNS_TL
235: WHERE TABLE_COLUMN_ID IN (SELECT TABLE_COLUMN_ID FROM CSC_PROF_TABLE_COLUMNS_B
236: WHERE BLOCK_ID = p_BLOCK_ID
237: AND TABLE_NAME = p_TABLE_NAME
238: AND COLUMN_NAME = p_COLUMN_NAME);
246:
247: procedure ADD_LANGUAGE
248: is
249: begin
250: delete from CSC_PROF_TABLE_COLUMNS_TL T
251: where not exists
252: (select NULL
253: from CSC_PROF_TABLE_COLUMNS_B B
254: where B.TABLE_COLUMN_ID = T.TABLE_COLUMN_ID
253: from CSC_PROF_TABLE_COLUMNS_B B
254: where B.TABLE_COLUMN_ID = T.TABLE_COLUMN_ID
255: );
256:
257: update CSC_PROF_TABLE_COLUMNS_TL T set (
258: LABEL
259: ) = (select
260: B.LABEL
261: from CSC_PROF_TABLE_COLUMNS_TL B
257: update CSC_PROF_TABLE_COLUMNS_TL T set (
258: LABEL
259: ) = (select
260: B.LABEL
261: from CSC_PROF_TABLE_COLUMNS_TL B
262: where B.TABLE_COLUMN_ID = T.TABLE_COLUMN_ID
263: and B.LANGUAGE = T.SOURCE_LANG)
264: where (
265: T.TABLE_COLUMN_ID,
266: T.LANGUAGE
267: ) in (select
268: SUBT.TABLE_COLUMN_ID,
269: SUBT.LANGUAGE
270: from CSC_PROF_TABLE_COLUMNS_TL SUBB, CSC_PROF_TABLE_COLUMNS_TL SUBT
271: where SUBB.TABLE_COLUMN_ID = SUBT.TABLE_COLUMN_ID
272: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
273: and (SUBB.LABEL <> SUBT.LABEL
274: or (SUBB.LABEL is null and SUBT.LABEL is not null)
274: or (SUBB.LABEL is null and SUBT.LABEL is not null)
275: or (SUBB.LABEL is not null and SUBT.LABEL is null)
276: ));
277:
278: insert into CSC_PROF_TABLE_COLUMNS_TL (
279: TABLE_COLUMN_ID,
280: LABEL,
281: CREATED_BY,
282: CREATION_DATE,
294: B.LAST_UPDATE_DATE,
295: B.LAST_UPDATE_LOGIN,
296: L.LANGUAGE_CODE,
297: B.SOURCE_LANG
298: from CSC_PROF_TABLE_COLUMNS_TL B, FND_LANGUAGES L
299: where L.INSTALLED_FLAG in ('I', 'B')
300: and B.LANGUAGE = userenv('LANG')
301: and not exists
302: (select NULL
299: where L.INSTALLED_FLAG in ('I', 'B')
300: and B.LANGUAGE = userenv('LANG')
301: and not exists
302: (select NULL
303: from CSC_PROF_TABLE_COLUMNS_TL T
304: where T.TABLE_COLUMN_ID = B.TABLE_COLUMN_ID
305: and T.LANGUAGE = L.LANGUAGE_CODE);
306: end ADD_LANGUAGE;
307:
310: p_TABLE_COLUMN_ID in number,
311: p_OWNER in varchar2 ) is
312:
313: Begin
314: Update Csc_Prof_Table_Columns_TL set
315: label = nvl(P_LABEL,label),
316: last_update_date = sysdate,
317: last_updated_by = decode(p_OWNER,'SEED',1,0),
318: last_update_login = 0,