APPS.FA_ADDITIONS_PKG dependencies on FA_ADDITIONS_TL

Line 280: insert into FA_ADDITIONS_TL (

276: X_Creation_Date,
277: X_Last_Update_Login
278:
279: );
280: insert into FA_ADDITIONS_TL (
281: LAST_UPDATED_BY,
282: CREATED_BY,
283: CREATION_DATE,
284: LAST_UPDATE_LOGIN,

Line 304: from FA_ADDITIONS_TL T

300: from FND_LANGUAGES L
301: where L.INSTALLED_FLAG in ('I', 'B')
302: and not exists
303: (select NULL
304: from FA_ADDITIONS_TL T
305: where T.ASSET_ID = X_ASSET_ID
306: and T.LANGUAGE = L.LANGUAGE_CODE);
307:
308:

Line 431: from fa_additions_tl

427: Recinfo C%ROWTYPE;
428:
429: cursor c1 is
430: select description,decode(language,userenv('LANG'),'Y','N') BASELANG
431: from fa_additions_tl
432: where asset_id = x_asset_id
433: and userenv('LANG') in (LANGUAGE,SOURCE_LANG)
434: for update of asset_id nowait;
435:

Line 1043: update FA_ADDITIONS_TL set

1039: else
1040: l_asset_id := X_asset_id;
1041: end if;
1042:
1043: update FA_ADDITIONS_TL set
1044: DESCRIPTION = decode(X_DESCRIPTION,
1045: NULL, description,
1046: FND_API.G_MISS_CHAR, NULL,
1047: X_description),

Line 1092: delete from FA_ADDITIONS_TL

1088: -- OPEN C;
1089: -- FETCH C INTO h_asset_id;
1090: -- CLOSE C;
1091:
1092: delete from FA_ADDITIONS_TL
1093: where ASSET_ID = X_asset_id;
1094:
1095: if (sql%notfound) then
1096: raise no_data_found;

Line 1149: delete from FA_ADDITIONS_TL T

1145:
1146: BEGIN
1147:
1148: -- delete from tl table if same asset doesn't exist in base table
1149: delete from FA_ADDITIONS_TL T
1150: where not exists
1151: (select NULL
1152: from FA_ADDITIONS_B B
1153: where B.ASSET_ID = T.ASSET_ID

Line 1157: update FA_ADDITIONS_TL T

1153: where B.ASSET_ID = T.ASSET_ID
1154: );
1155:
1156: -- repair description in tl table
1157: update FA_ADDITIONS_TL T
1158: set (DESCRIPTION) =
1159: (select B.DESCRIPTION
1160: from FA_ADDITIONS_TL B
1161: where B.ASSET_ID = T.ASSET_ID

Line 1160: from FA_ADDITIONS_TL B

1156: -- repair description in tl table
1157: update FA_ADDITIONS_TL T
1158: set (DESCRIPTION) =
1159: (select B.DESCRIPTION
1160: from FA_ADDITIONS_TL B
1161: where B.ASSET_ID = T.ASSET_ID
1162: and B.LANGUAGE = T.SOURCE_LANG)
1163: where (T.ASSET_ID, T.LANGUAGE) in
1164: (select SUBT.ASSET_ID,

Line 1166: from FA_ADDITIONS_TL SUBB, FA_ADDITIONS_TL SUBT

1162: and B.LANGUAGE = T.SOURCE_LANG)
1163: where (T.ASSET_ID, T.LANGUAGE) in
1164: (select SUBT.ASSET_ID,
1165: SUBT.LANGUAGE
1166: from FA_ADDITIONS_TL SUBB, FA_ADDITIONS_TL SUBT
1167: where SUBB.ASSET_ID = SUBT.ASSET_ID
1168: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1169: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION));
1170:

Line 1171: -- insert new row into fa_additions_tl for new language

1167: where SUBB.ASSET_ID = SUBT.ASSET_ID
1168: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1169: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION));
1170:
1171: -- insert new row into fa_additions_tl for new language
1172:
1173: insert into FA_ADDITIONS_TL (
1174: LAST_UPDATED_BY,
1175: CREATED_BY,

Line 1173: insert into FA_ADDITIONS_TL (

1169: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION));
1170:
1171: -- insert new row into fa_additions_tl for new language
1172:
1173: insert into FA_ADDITIONS_TL (
1174: LAST_UPDATED_BY,
1175: CREATED_BY,
1176: CREATION_DATE,
1177: LAST_UPDATE_LOGIN,

Line 1193: from FA_ADDITIONS_TL B, FND_LANGUAGES L

1189: B.DESCRIPTION,
1190: B.LAST_UPDATE_DATE,
1191: L.LANGUAGE_CODE,
1192: B.SOURCE_LANG
1193: from FA_ADDITIONS_TL B, FND_LANGUAGES L
1194: where L.INSTALLED_FLAG in ('I', 'B')
1195: and B.LANGUAGE = userenv('LANG')
1196: and not exists
1197: (select NULL

Line 1198: from FA_ADDITIONS_TL T

1194: where L.INSTALLED_FLAG in ('I', 'B')
1195: and B.LANGUAGE = userenv('LANG')
1196: and not exists
1197: (select NULL
1198: from FA_ADDITIONS_TL T
1199: where T.ASSET_ID = B.ASSET_ID
1200: and T.LANGUAGE = L.LANGUAGE_CODE);
1201: end ADD_LANGUAGE;
1202:

Line 1522: from fa_additions_tl

1518: BEGIN
1519:
1520: select last_updated_by, last_update_date
1521: into db_last_updated_by, db_last_update_date
1522: from fa_additions_tl
1523: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1524: and asset_id = X_Asset_ID;
1525:
1526: user_id := fnd_load_util.owner_id (X_Owner);

Line 1532: update FA_ADDITIONS_TL set

1528: if (fnd_load_util.upload_test(user_id, x_last_update_date,
1529: db_last_updated_by, db_last_update_date,
1530: X_CUSTOM_MODE )) then
1531:
1532: update FA_ADDITIONS_TL set
1533: DESCRIPTION = nvl(X_Description, DESCRIPTION),
1534: LAST_UPDATE_DATE = sysdate,
1535: LAST_UPDATED_BY = 0,
1536: LAST_UPDATE_LOGIN = 0,