[Home] [Help]
93: END IF;
94: END;
95: END LOOP;
96:
97: insert into HZ_TRANS_FUNCTIONS_TL (
98: LAST_UPDATE_DATE,
99: CREATION_DATE,
100: CREATED_BY,
101: LAST_UPDATED_BY,
121: from FND_LANGUAGES L
122: where L.INSTALLED_FLAG in ('I', 'B')
123: and not exists
124: (select NULL
125: from HZ_TRANS_FUNCTIONS_TL T
126: where T.FUNCTION_ID = X_FUNCTION_ID
127: and T.LANGUAGE = L.LANGUAGE_CODE);
128:
129: end INSERT_ROW;
142:
143: cursor c1 is select
144: OBJECT_VERSION_NUMBER,
145: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
146: from HZ_TRANS_FUNCTIONS_TL
147: where FUNCTION_ID = X_FUNCTION_ID
148: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
149: for update of FUNCTION_ID nowait;
150: begin
195:
196: cursor c1 is select
197: TRANSFORMATION_NAME,DESCRIPTION,
198: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
199: from HZ_TRANS_FUNCTIONS_TL
200: where FUNCTION_ID = X_FUNCTION_ID
201: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
202: for update of FUNCTION_ID nowait;
203: begin
291: PROCEDURE_NAME = X_PROCEDURE_NAME,
292: STAGED_FLAG = 'N',
293: OBJECT_VERSION_NUMBER = l_object_version_number
294: where FUNCTION_ID = X_FUNCTION_ID;
295: update HZ_TRANS_FUNCTIONS_TL set
296: TRANSFORMATION_NAME = X_TRANSFORMATION_NAME,
297: DESCRIPTION = X_DESCRIPTION,
298: OBJECT_VERSION_NUMBER = l_object_version_number
299: where FUNCTION_ID = X_FUNCTION_ID
326: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
327: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
328: OBJECT_VERSION_NUMBER = l_object_version_number
329: where FUNCTION_ID = X_FUNCTION_ID;
330: update HZ_TRANS_FUNCTIONS_TL set
331: TRANSFORMATION_NAME = X_TRANSFORMATION_NAME,
332: DESCRIPTION = X_DESCRIPTION,
333: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
334: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
345: procedure DELETE_ROW (
346: X_FUNCTION_ID in NUMBER
347: ) is
348: begin
349: delete from HZ_TRANS_FUNCTIONS_TL
350: where FUNCTION_ID = X_FUNCTION_ID;
351:
352: if (sql%notfound) then
353: raise no_data_found;
363:
364: procedure ADD_LANGUAGE
365: is
366: begin
367: delete from HZ_TRANS_FUNCTIONS_TL T
368: where not exists
369: (select NULL
370: from HZ_TRANS_FUNCTIONS_B B
371: where B.FUNCTION_ID = T.FUNCTION_ID
370: from HZ_TRANS_FUNCTIONS_B B
371: where B.FUNCTION_ID = T.FUNCTION_ID
372: );
373:
374: update HZ_TRANS_FUNCTIONS_TL T set (
375: TRANSFORMATION_NAME,
376: DESCRIPTION
377: ) = (select
378: B.TRANSFORMATION_NAME,
376: DESCRIPTION
377: ) = (select
378: B.TRANSFORMATION_NAME,
379: B.DESCRIPTION
380: from HZ_TRANS_FUNCTIONS_TL B
381: where B.FUNCTION_ID = T.FUNCTION_ID
382: and B.LANGUAGE = T.SOURCE_LANG)
383: where (
384: T.FUNCTION_ID,
385: T.LANGUAGE
386: ) in (select
387: SUBT.FUNCTION_ID,
388: SUBT.LANGUAGE
389: from HZ_TRANS_FUNCTIONS_TL SUBB, HZ_TRANS_FUNCTIONS_TL SUBT
390: where SUBB.FUNCTION_ID = SUBT.FUNCTION_ID
391: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
392: and (SUBB.TRANSFORMATION_NAME <> SUBT.TRANSFORMATION_NAME
393: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
394: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
395: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
396: ));
397:
398: insert into HZ_TRANS_FUNCTIONS_TL (
399: LAST_UPDATE_DATE,
400: CREATION_DATE,
401: CREATED_BY,
402: LAST_UPDATED_BY,
416: B.TRANSFORMATION_NAME,
417: B.DESCRIPTION,
418: L.LANGUAGE_CODE,
419: B.SOURCE_LANG
420: from HZ_TRANS_FUNCTIONS_TL B, FND_LANGUAGES L
421: where L.INSTALLED_FLAG in ('I', 'B')
422: and B.LANGUAGE = userenv('LANG')
423: and L.LANGUAGE_CODE <> B.LANGUAGE
424: and not exists
422: and B.LANGUAGE = userenv('LANG')
423: and L.LANGUAGE_CODE <> B.LANGUAGE
424: and not exists
425: (select NULL
426: from HZ_TRANS_FUNCTIONS_TL T
427: where T.FUNCTION_ID = B.FUNCTION_ID
428: and T.LANGUAGE = L.LANGUAGE_CODE);
429: end ADD_LANGUAGE;
430:
511: X_OWNER in VARCHAR2) IS
512:
513: begin
514: -- only update rows that have not been altered by user
515: update HZ_TRANS_FUNCTIONS_TL set
516: TRANSFORMATION_NAME = X_TRANSFORMATION_NAME,
517: DESCRIPTION = X_DESCRIPTION,
518: source_lang = userenv('LANG'),
519: last_update_date = sysdate,