APPS.AMW_OPINION_VALUES_PKG dependencies on AMW_OPINION_VALUES_TL

Line 58: insert into AMW_OPINION_VALUES_TL (

54: X_LAST_UPDATED_BY,
55: X_LAST_UPDATE_LOGIN
56: );
57:
58: insert into AMW_OPINION_VALUES_TL (
59: OPINION_VALUE_ID,
60: OPINION_VALUE_NAME,
61: CREATED_BY,
62: CREATION_DATE,

Line 86: from AMW_OPINION_VALUES_TL T

82: from FND_LANGUAGES L
83: where L.INSTALLED_FLAG in ('I', 'B')
84: and not exists
85: (select NULL
86: from AMW_OPINION_VALUES_TL T
87: where T.OPINION_VALUE_ID = X_OPINION_VALUE_ID
88: and T.LANGUAGE = L.LANGUAGE_CODE);
89:
90: open c;

Line 129: from AMW_OPINION_VALUES_TL

125:
126: cursor c1 is select
127: OPINION_VALUE_NAME,
128: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
129: from AMW_OPINION_VALUES_TL
130: where OPINION_VALUE_ID = X_OPINION_VALUE_ID
131: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
132: for update of OPINION_VALUE_ID nowait;
133: begin

Line 212: update AMW_OPINION_VALUES_TL set

208: if (sql%notfound) then
209: raise no_data_found;
210: end if;
211:
212: update AMW_OPINION_VALUES_TL set
213: OPINION_VALUE_NAME = X_OPINION_VALUE_NAME,
214: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
215: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
216: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 230: delete from AMW_OPINION_VALUES_TL

226: procedure DELETE_ROW (
227: X_OPINION_VALUE_ID in NUMBER
228: ) is
229: begin
230: delete from AMW_OPINION_VALUES_TL
231: where OPINION_VALUE_ID = X_OPINION_VALUE_ID;
232:
233: if (sql%notfound) then
234: raise no_data_found;

Line 248: delete from AMW_OPINION_VALUES_TL T

244:
245: procedure ADD_LANGUAGE
246: is
247: begin
248: delete from AMW_OPINION_VALUES_TL T
249: where not exists
250: (select NULL
251: from AMW_OPINION_VALUES_B B
252: where B.OPINION_VALUE_ID = T.OPINION_VALUE_ID

Line 255: update AMW_OPINION_VALUES_TL T set (

251: from AMW_OPINION_VALUES_B B
252: where B.OPINION_VALUE_ID = T.OPINION_VALUE_ID
253: );
254:
255: update AMW_OPINION_VALUES_TL T set (
256: OPINION_VALUE_NAME
257: ) = (select
258: B.OPINION_VALUE_NAME
259: from AMW_OPINION_VALUES_TL B

Line 259: from AMW_OPINION_VALUES_TL B

255: update AMW_OPINION_VALUES_TL T set (
256: OPINION_VALUE_NAME
257: ) = (select
258: B.OPINION_VALUE_NAME
259: from AMW_OPINION_VALUES_TL B
260: where B.OPINION_VALUE_ID = T.OPINION_VALUE_ID
261: and B.LANGUAGE = T.SOURCE_LANG)
262: where (
263: T.OPINION_VALUE_ID,

Line 268: from AMW_OPINION_VALUES_TL SUBB, AMW_OPINION_VALUES_TL SUBT

264: T.LANGUAGE
265: ) in (select
266: SUBT.OPINION_VALUE_ID,
267: SUBT.LANGUAGE
268: from AMW_OPINION_VALUES_TL SUBB, AMW_OPINION_VALUES_TL SUBT
269: where SUBB.OPINION_VALUE_ID = SUBT.OPINION_VALUE_ID
270: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
271: and (SUBB.OPINION_VALUE_NAME <> SUBT.OPINION_VALUE_NAME
272: or (SUBB.OPINION_VALUE_NAME is null and SUBT.OPINION_VALUE_NAME is not null)

Line 276: insert into AMW_OPINION_VALUES_TL (

272: or (SUBB.OPINION_VALUE_NAME is null and SUBT.OPINION_VALUE_NAME is not null)
273: or (SUBB.OPINION_VALUE_NAME is not null and SUBT.OPINION_VALUE_NAME is null)
274: ));
275:
276: insert into AMW_OPINION_VALUES_TL (
277: OPINION_VALUE_ID,
278: OPINION_VALUE_NAME,
279: CREATED_BY,
280: CREATION_DATE,

Line 300: from AMW_OPINION_VALUES_TL B, FND_LANGUAGES L

296: B.SECURITY_GROUP_ID,
297: B.OBJECT_VERSION_NUMBER,
298: L.LANGUAGE_CODE,
299: B.SOURCE_LANG
300: from AMW_OPINION_VALUES_TL B, FND_LANGUAGES L
301: where L.INSTALLED_FLAG in ('I', 'B')
302: and B.LANGUAGE = userenv('LANG')
303: and not exists
304: (select NULL

Line 305: from AMW_OPINION_VALUES_TL T

301: where L.INSTALLED_FLAG in ('I', 'B')
302: and B.LANGUAGE = userenv('LANG')
303: and not exists
304: (select NULL
305: from AMW_OPINION_VALUES_TL T
306: where T.OPINION_VALUE_ID = B.OPINION_VALUE_ID
307: and T.LANGUAGE = L.LANGUAGE_CODE);
308: end ADD_LANGUAGE;
309:

Line 397: from AMW_OPINION_VALUES_TL

393: -- Translate char last_update_date to date
394: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
395:
396: select last_updated_by, last_update_date into db_luby, db_ludate
397: from AMW_OPINION_VALUES_TL
398: where opinion_value_id = X_OPINION_VALUE_ID and language = userenv('LANG');
399:
400: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
401: then update AMW_OPINION_VALUES_TL set

Line 401: then update AMW_OPINION_VALUES_TL set

397: from AMW_OPINION_VALUES_TL
398: where opinion_value_id = X_OPINION_VALUE_ID and language = userenv('LANG');
399:
400: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
401: then update AMW_OPINION_VALUES_TL set
402: opinion_value_name = nvl(X_OPINION_VALUE_NAME, opinion_value_name),
403: source_lang = userenv('LANG'),
404: last_update_date = f_ludate,
405: last_updated_by = f_luby,