[Home] [Help]
173: X_CREATED_BY,
174: X_LAST_UPDATE_LOGIN
175: );
176:
177: insert into MTL_CATEGORIES_TL (
178: CATEGORY_ID,
179: LANGUAGE,
180: SOURCE_LANG,
181: DESCRIPTION,
197: from FND_LANGUAGES L
198: where L.INSTALLED_FLAG in ('I', 'B')
199: and not exists
200: ( select NULL
201: from MTL_CATEGORIES_TL T
202: where T.CATEGORY_ID = X_CATEGORY_ID
203: and T.LANGUAGE = L.LANGUAGE_CODE );
204:
205: open c;
348: cursor c1 is
349: select
350: DESCRIPTION,
351: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
352: from MTL_CATEGORIES_TL
353: where CATEGORY_ID = X_CATEGORY_ID
354: -- Commented out. All translation rows need to be locked.
355: -- and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
356: for update of CATEGORY_ID nowait;
599: if ( sql%notfound ) then
600: raise no_data_found;
601: end if;
602:
603: update MTL_CATEGORIES_TL
604: set
605: DESCRIPTION = X_DESCRIPTION,
606: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
607: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
692:
693: -- This code is for future use when decided to validate
694: -- and delete categories.
695: /*
696: delete from MTL_CATEGORIES_TL
697: where CATEGORY_ID = X_CATEGORY_ID ;
698:
699: if (sql%notfound) then
700: raise no_data_found;
714: procedure ADD_LANGUAGE
715: is
716: begin
717:
718: delete from MTL_CATEGORIES_TL T
719: where not exists
720: ( select NULL
721: from MTL_CATEGORIES_B B
722: where B.CATEGORY_ID = T.CATEGORY_ID
721: from MTL_CATEGORIES_B B
722: where B.CATEGORY_ID = T.CATEGORY_ID
723: );
724:
725: update MTL_CATEGORIES_TL T set (
726: DESCRIPTION
727: ) = ( select
728: B.DESCRIPTION
729: from MTL_CATEGORIES_TL B
725: update MTL_CATEGORIES_TL T set (
726: DESCRIPTION
727: ) = ( select
728: B.DESCRIPTION
729: from MTL_CATEGORIES_TL B
730: where B.CATEGORY_ID = T.CATEGORY_ID
731: and B.LANGUAGE = T.SOURCE_LANG )
732: where (
733: T.CATEGORY_ID,
734: T.LANGUAGE
735: ) in ( select
736: SUBT.CATEGORY_ID,
737: SUBT.LANGUAGE
738: from MTL_CATEGORIES_TL SUBB,
739: MTL_CATEGORIES_TL SUBT
740: where SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
741: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
742: and ( SUBB.DESCRIPTION <> SUBT.DESCRIPTION
735: ) in ( select
736: SUBT.CATEGORY_ID,
737: SUBT.LANGUAGE
738: from MTL_CATEGORIES_TL SUBB,
739: MTL_CATEGORIES_TL SUBT
740: where SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
741: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
742: and ( SUBB.DESCRIPTION <> SUBT.DESCRIPTION
743: or ( SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null )
743: or ( SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null )
744: or ( SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null ) )
745: );
746:
747: insert into MTL_CATEGORIES_TL (
748: CREATED_BY,
749: LAST_UPDATE_LOGIN,
750: CATEGORY_ID,
751: DESCRIPTION,
763: B.LAST_UPDATED_BY,
764: B.CREATION_DATE,
765: L.LANGUAGE_CODE,
766: B.SOURCE_LANG
767: from MTL_CATEGORIES_TL B,
768: FND_LANGUAGES L
769: where L.INSTALLED_FLAG in ('I', 'B')
770: and B.LANGUAGE = userenv('LANG')
771: and not exists
769: where L.INSTALLED_FLAG in ('I', 'B')
770: and B.LANGUAGE = userenv('LANG')
771: and not exists
772: ( select NULL
773: from MTL_CATEGORIES_TL T
774: where T.CATEGORY_ID = B.CATEGORY_ID
775: and T.LANGUAGE = L.LANGUAGE_CODE );
776:
777: end ADD_LANGUAGE;
864: fnd_message.set_token('REASON','Category does not exist');
865: app_exception.raise_exception;
866: END;
867:
868: UPDATE mtl_categories_tl
869: SET description = NVL(x_description, description)
870: , last_update_date = SYSDATE
871: , last_updated_by = f_luby
872: , last_update_login = 0
924: ,X_CATEGORY_SET_ID IN MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE
925: ,X_CATEGORY_SET_NAME IN MTL_CATEGORY_SETS_TL.CATEGORY_SET_NAME%TYPE
926: ,X_OWNER IN VARCHAR2
927: ,X_LAST_UPDATE_DATE IN MTL_CATEGORIES_B.LAST_UPDATE_DATE%TYPE
928: ,X_DESCRIPTION IN MTL_CATEGORIES_TL.DESCRIPTION%TYPE
929: ,X_APPLICATION_SHORT_NAME IN VARCHAR2
930: ,X_UPLOAD_TO_FUNCTIONAL_AREA IN VARCHAR2
931: ) IS
932: