APPS.FA_ADDITIONS_PKG dependencies on FA_ADDITIONS_TL

Line 279: insert into FA_ADDITIONS_TL (

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

Line 303: from FA_ADDITIONS_TL T

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

Line 424: from fa_additions_tl

420: Recinfo C%ROWTYPE;
421:
422: cursor c1 is
423: select description,decode(language,userenv('LANG'),'Y','N') BASELANG
424: from fa_additions_tl
425: where asset_id = x_asset_id
426: and userenv('LANG') in (LANGUAGE,SOURCE_LANG)
427: for update of asset_id nowait;
428:

Line 1038: update FA_ADDITIONS_TL set

1034: else
1035: l_asset_id := X_asset_id;
1036: end if;
1037:
1038: update FA_ADDITIONS_TL set
1039: DESCRIPTION = decode(X_DESCRIPTION,
1040: NULL, description,
1041: FND_API.G_MISS_CHAR, NULL,
1042: X_description),

Line 1085: delete from FA_ADDITIONS_TL

1081: -- OPEN C;
1082: -- FETCH C INTO h_asset_id;
1083: -- CLOSE C;
1084:
1085: delete from FA_ADDITIONS_TL
1086: where ASSET_ID = X_asset_id;
1087:
1088: if (sql%notfound) then
1089: raise no_data_found;

Line 1139: delete from FA_ADDITIONS_TL T

1135:
1136: BEGIN
1137:
1138: -- delete from tl table if same asset doesn't exist in base table
1139: delete from FA_ADDITIONS_TL T
1140: where not exists
1141: (select NULL
1142: from FA_ADDITIONS_B B
1143: where B.ASSET_ID = T.ASSET_ID

Line 1147: update FA_ADDITIONS_TL T

1143: where B.ASSET_ID = T.ASSET_ID
1144: );
1145:
1146: -- repair description in tl table
1147: update FA_ADDITIONS_TL T
1148: set (DESCRIPTION) =
1149: (select B.DESCRIPTION
1150: from FA_ADDITIONS_TL B
1151: where B.ASSET_ID = T.ASSET_ID

Line 1150: from FA_ADDITIONS_TL B

1146: -- repair description in tl table
1147: update FA_ADDITIONS_TL T
1148: set (DESCRIPTION) =
1149: (select B.DESCRIPTION
1150: from FA_ADDITIONS_TL B
1151: where B.ASSET_ID = T.ASSET_ID
1152: and B.LANGUAGE = T.SOURCE_LANG)
1153: where (T.ASSET_ID, T.LANGUAGE) in
1154: (select SUBT.ASSET_ID,

Line 1156: from FA_ADDITIONS_TL SUBB, FA_ADDITIONS_TL SUBT

1152: and B.LANGUAGE = T.SOURCE_LANG)
1153: where (T.ASSET_ID, T.LANGUAGE) in
1154: (select SUBT.ASSET_ID,
1155: SUBT.LANGUAGE
1156: from FA_ADDITIONS_TL SUBB, FA_ADDITIONS_TL SUBT
1157: where SUBB.ASSET_ID = SUBT.ASSET_ID
1158: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1159: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION));
1160:

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

1157: where SUBB.ASSET_ID = SUBT.ASSET_ID
1158: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1159: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION));
1160:
1161: -- insert new row into fa_additions_tl for new language
1162:
1163: insert into FA_ADDITIONS_TL (
1164: LAST_UPDATED_BY,
1165: CREATED_BY,

Line 1163: insert into FA_ADDITIONS_TL (

1159: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION));
1160:
1161: -- insert new row into fa_additions_tl for new language
1162:
1163: insert into FA_ADDITIONS_TL (
1164: LAST_UPDATED_BY,
1165: CREATED_BY,
1166: CREATION_DATE,
1167: LAST_UPDATE_LOGIN,

Line 1183: from FA_ADDITIONS_TL B, FND_LANGUAGES L

1179: B.DESCRIPTION,
1180: B.LAST_UPDATE_DATE,
1181: L.LANGUAGE_CODE,
1182: B.SOURCE_LANG
1183: from FA_ADDITIONS_TL B, FND_LANGUAGES L
1184: where L.INSTALLED_FLAG in ('I', 'B')
1185: and B.LANGUAGE = userenv('LANG')
1186: and not exists
1187: (select NULL

Line 1188: from FA_ADDITIONS_TL T

1184: where L.INSTALLED_FLAG in ('I', 'B')
1185: and B.LANGUAGE = userenv('LANG')
1186: and not exists
1187: (select NULL
1188: from FA_ADDITIONS_TL T
1189: where T.ASSET_ID = B.ASSET_ID
1190: and T.LANGUAGE = L.LANGUAGE_CODE);
1191: end ADD_LANGUAGE;
1192:

Line 1788: update FA_ADDITIONS_TL set

1784: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1785:
1786: begin
1787:
1788: update FA_ADDITIONS_TL set
1789: DESCRIPTION = nvl(X_Description, DESCRIPTION),
1790: LAST_UPDATE_DATE = sysdate,
1791: LAST_UPDATED_BY = 0,
1792: LAST_UPDATE_LOGIN = 0,

Line 1825: from fa_additions_tl

1821: BEGIN
1822:
1823: select last_updated_by, last_update_date
1824: into db_last_updated_by, db_last_update_date
1825: from fa_additions_tl
1826: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1827: and asset_id = X_Asset_ID;
1828:
1829: user_id := fnd_load_util.owner_id (X_Owner);

Line 1835: update FA_ADDITIONS_TL set

1831: if (fnd_load_util.upload_test(user_id, x_last_update_date,
1832: db_last_updated_by, db_last_update_date,
1833: X_CUSTOM_MODE )) then
1834:
1835: update FA_ADDITIONS_TL set
1836: DESCRIPTION = nvl(X_Description, DESCRIPTION),
1837: LAST_UPDATE_DATE = sysdate,
1838: LAST_UPDATED_BY = 0,
1839: LAST_UPDATE_LOGIN = 0,