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 636: update FA_CATEGORIES_TL set

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

Line 654: delete from FA_CATEGORIES_TL

650: procedure DELETE_ROW (
651: X_CATEGORY_ID in NUMBER
652: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
653: begin
654: delete from FA_CATEGORIES_TL
655: where CATEGORY_ID = X_CATEGORY_ID;
656:
657: if (sql%notfound) then
658: raise no_data_found;

Line 672: delete from FA_CATEGORIES_TL T

668:
669: procedure ADD_LANGUAGE
670: is
671: begin
672: delete from FA_CATEGORIES_TL T
673: where not exists
674: (select NULL
675: from FA_CATEGORIES_B B
676: where B.CATEGORY_ID = T.CATEGORY_ID

Line 679: update FA_CATEGORIES_TL T set (

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

Line 683: from FA_CATEGORIES_TL B

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

Line 692: from FA_CATEGORIES_TL SUBB, FA_CATEGORIES_TL SUBT

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

Line 700: insert into FA_CATEGORIES_TL (

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

Line 720: from FA_CATEGORIES_TL B, FND_LANGUAGES L

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

Line 725: from FA_CATEGORIES_TL T

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

Line 1182: update FA_CATEGORIES_TL set

1178: X_DESCRIPTION in VARCHAR2
1179: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
1180: begin
1181:
1182: update FA_CATEGORIES_TL set
1183: DESCRIPTION = nvl(X_Description, DESCRIPTION),
1184: LAST_UPDATE_DATE = sysdate,
1185: LAST_UPDATED_BY = 0,
1186: LAST_UPDATE_LOGIN = 0,

Line 1218: from fa_categories_tl

1214: begin
1215:
1216: select last_updated_by, last_update_date
1217: into db_last_updated_by, db_last_update_date
1218: from fa_categories_tl
1219: where category_id = X_Category_Id
1220: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1221:
1222: user_id := fnd_load_util.owner_id (X_Owner);

Line 1228: update FA_CATEGORIES_TL set

1224: if (fnd_load_util.upload_test(user_id, x_last_update_date,
1225: db_last_updated_by, db_last_update_date,
1226: X_CUSTOM_MODE)) then
1227:
1228: update FA_CATEGORIES_TL set
1229: DESCRIPTION = nvl(X_Description, DESCRIPTION),
1230: LAST_UPDATE_DATE = sysdate,
1231: LAST_UPDATED_BY = 0,
1232: LAST_UPDATE_LOGIN = 0,