[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,
691:
692: -- This code is for future use when decided to validate
693: -- and delete categories.
694: /*
695: delete from MTL_CATEGORIES_TL
696: where CATEGORY_ID = X_CATEGORY_ID ;
697:
698: if (sql%notfound) then
699: raise no_data_found;
713: procedure ADD_LANGUAGE
714: is
715: begin
716:
717: delete from MTL_CATEGORIES_TL T
718: where not exists
719: ( select NULL
720: from MTL_CATEGORIES_B B
721: where B.CATEGORY_ID = T.CATEGORY_ID
720: from MTL_CATEGORIES_B B
721: where B.CATEGORY_ID = T.CATEGORY_ID
722: );
723:
724: update MTL_CATEGORIES_TL T set (
725: DESCRIPTION
726: ) = ( select
727: B.DESCRIPTION
728: from MTL_CATEGORIES_TL B
724: update MTL_CATEGORIES_TL T set (
725: DESCRIPTION
726: ) = ( select
727: B.DESCRIPTION
728: from MTL_CATEGORIES_TL B
729: where B.CATEGORY_ID = T.CATEGORY_ID
730: and B.LANGUAGE = T.SOURCE_LANG )
731: where (
732: T.CATEGORY_ID,
733: T.LANGUAGE
734: ) in ( select
735: SUBT.CATEGORY_ID,
736: SUBT.LANGUAGE
737: from MTL_CATEGORIES_TL SUBB,
738: MTL_CATEGORIES_TL SUBT
739: where SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
740: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
741: and ( SUBB.DESCRIPTION <> SUBT.DESCRIPTION
734: ) in ( select
735: SUBT.CATEGORY_ID,
736: SUBT.LANGUAGE
737: from MTL_CATEGORIES_TL SUBB,
738: MTL_CATEGORIES_TL SUBT
739: where SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
740: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
741: and ( SUBB.DESCRIPTION <> SUBT.DESCRIPTION
742: or ( SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null )
742: or ( SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null )
743: or ( SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null ) )
744: );
745:
746: insert into MTL_CATEGORIES_TL (
747: CREATED_BY,
748: LAST_UPDATE_LOGIN,
749: CATEGORY_ID,
750: DESCRIPTION,
762: B.LAST_UPDATED_BY,
763: B.CREATION_DATE,
764: L.LANGUAGE_CODE,
765: B.SOURCE_LANG
766: from MTL_CATEGORIES_TL B,
767: FND_LANGUAGES L
768: where L.INSTALLED_FLAG in ('I', 'B')
769: and B.LANGUAGE = userenv('LANG')
770: and not exists
768: where L.INSTALLED_FLAG in ('I', 'B')
769: and B.LANGUAGE = userenv('LANG')
770: and not exists
771: ( select NULL
772: from MTL_CATEGORIES_TL T
773: where T.CATEGORY_ID = B.CATEGORY_ID
774: and T.LANGUAGE = L.LANGUAGE_CODE );
775:
776: end ADD_LANGUAGE;
863: fnd_message.set_token('REASON','Category does not exist');
864: app_exception.raise_exception;
865: END;
866:
867: UPDATE mtl_categories_tl
868: SET description = NVL(x_description, description)
869: , last_update_date = SYSDATE
870: , last_updated_by = f_luby
871: , last_update_login = 0
923: ,X_CATEGORY_SET_ID IN MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE
924: ,X_CATEGORY_SET_NAME IN MTL_CATEGORY_SETS_TL.CATEGORY_SET_NAME%TYPE
925: ,X_OWNER IN VARCHAR2
926: ,X_LAST_UPDATE_DATE IN MTL_CATEGORIES_B.LAST_UPDATE_DATE%TYPE
927: ,X_DESCRIPTION IN MTL_CATEGORIES_TL.DESCRIPTION%TYPE
928: ,X_APPLICATION_SHORT_NAME IN VARCHAR2
929: ,X_UPLOAD_TO_FUNCTIONAL_AREA IN VARCHAR2
930: ) IS
931: