APPS.FA_CATEGORIES_PKG dependencies on FA_CATEGORIES_TL

Line 201: insert into FA_CATEGORIES_TL (

197: X_LAST_UPDATED_BY,
198: X_LAST_UPDATE_LOGIN
199: );
200:
201: insert into FA_CATEGORIES_TL (
202: DESCRIPTION,
203: LAST_UPDATE_DATE,
204: LAST_UPDATED_BY,
205: CREATED_BY,

Line 225: from FA_CATEGORIES_TL T

221: from FND_LANGUAGES L
222: where L.INSTALLED_FLAG in ('I', 'B')
223: and not exists
224: (select NULL
225: from FA_CATEGORIES_TL T
226: where T.CATEGORY_ID = X_CATEGORY_ID
227: and T.LANGUAGE = L.LANGUAGE_CODE);
228:
229: open c;

Line 364: from FA_CATEGORIES_TL

360:
361: cursor c1 is select
362: DESCRIPTION,
363: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
364: from FA_CATEGORIES_TL
365: where CATEGORY_ID = X_CATEGORY_ID
366: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
367: for update of CATEGORY_ID nowait;
368: begin

Line 634: update FA_CATEGORIES_TL set

630: if (sql%notfound) then
631: raise no_data_found;
632: end if;
633:
634: update FA_CATEGORIES_TL set
635: DESCRIPTION = X_DESCRIPTION,
636: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
637: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
638: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 652: delete from FA_CATEGORIES_TL

648: procedure DELETE_ROW (
649: X_CATEGORY_ID in NUMBER
650: ,p_log_level_rec in fa_api_types.log_level_rec_type default null) is
651: begin
652: delete from FA_CATEGORIES_TL
653: where CATEGORY_ID = X_CATEGORY_ID;
654:
655: if (sql%notfound) then
656: raise no_data_found;

Line 670: delete from FA_CATEGORIES_TL T

666:
667: procedure ADD_LANGUAGE(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
668: is
669: begin
670: delete from FA_CATEGORIES_TL T
671: where not exists
672: (select NULL
673: from FA_CATEGORIES_B B
674: where B.CATEGORY_ID = T.CATEGORY_ID

Line 677: update FA_CATEGORIES_TL T set (

673: from FA_CATEGORIES_B B
674: where B.CATEGORY_ID = T.CATEGORY_ID
675: );
676:
677: update FA_CATEGORIES_TL T set (
678: DESCRIPTION
679: ) = (select
680: B.DESCRIPTION
681: from FA_CATEGORIES_TL B

Line 681: from FA_CATEGORIES_TL B

677: update FA_CATEGORIES_TL T set (
678: DESCRIPTION
679: ) = (select
680: B.DESCRIPTION
681: from FA_CATEGORIES_TL B
682: where B.CATEGORY_ID = T.CATEGORY_ID
683: and B.LANGUAGE = T.SOURCE_LANG)
684: where (
685: T.CATEGORY_ID,

Line 690: from FA_CATEGORIES_TL SUBB, FA_CATEGORIES_TL SUBT

686: T.LANGUAGE
687: ) in (select
688: SUBT.CATEGORY_ID,
689: SUBT.LANGUAGE
690: from FA_CATEGORIES_TL SUBB, FA_CATEGORIES_TL SUBT
691: where SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
692: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
693: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
694: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 698: insert into FA_CATEGORIES_TL (

694: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
695: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
696: ));
697:
698: insert into FA_CATEGORIES_TL (
699: DESCRIPTION,
700: LAST_UPDATE_DATE,
701: LAST_UPDATED_BY,
702: CREATED_BY,

Line 718: from FA_CATEGORIES_TL B, FND_LANGUAGES L

714: B.LAST_UPDATE_LOGIN,
715: B.CATEGORY_ID,
716: L.LANGUAGE_CODE,
717: B.SOURCE_LANG
718: from FA_CATEGORIES_TL B, FND_LANGUAGES L
719: where L.INSTALLED_FLAG in ('I', 'B')
720: and B.LANGUAGE = userenv('LANG')
721: and not exists
722: (select NULL

Line 723: from FA_CATEGORIES_TL T

719: where L.INSTALLED_FLAG in ('I', 'B')
720: and B.LANGUAGE = userenv('LANG')
721: and not exists
722: (select NULL
723: from FA_CATEGORIES_TL T
724: where T.CATEGORY_ID = B.CATEGORY_ID
725: and T.LANGUAGE = L.LANGUAGE_CODE);
726: end ADD_LANGUAGE;
727:

Line 976: from fa_categories_tl

972: begin
973:
974: select last_updated_by, last_update_date
975: into db_last_updated_by, db_last_update_date
976: from fa_categories_tl
977: where category_id = X_Category_Id
978: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
979:
980: user_id := fnd_load_util.owner_id (X_Owner);

Line 986: update FA_CATEGORIES_TL set

982: if (fnd_load_util.upload_test(user_id, x_last_update_date,
983: db_last_updated_by, db_last_update_date,
984: X_CUSTOM_MODE)) then
985:
986: update FA_CATEGORIES_TL set
987: DESCRIPTION = nvl(X_Description, DESCRIPTION),
988: LAST_UPDATE_DATE = sysdate,
989: LAST_UPDATED_BY = 0,
990: LAST_UPDATE_LOGIN = 0,