APPS.AMW_OPINION_TYPES_PKG dependencies on AMW_OPINION_TYPES_TL

Line 39: insert into AMW_OPINION_TYPES_TL (

35: X_LAST_UPDATED_BY,
36: X_LAST_UPDATE_LOGIN
37: );
38:
39: insert into AMW_OPINION_TYPES_TL (
40: OPINION_TYPE_ID,
41: OPINION_TYPE_NAME,
42: CREATED_BY,
43: CREATION_DATE,

Line 67: from AMW_OPINION_TYPES_TL T

63: from FND_LANGUAGES L
64: where L.INSTALLED_FLAG in ('I', 'B')
65: and not exists
66: (select NULL
67: from AMW_OPINION_TYPES_TL T
68: where T.OPINION_TYPE_ID = X_OPINION_TYPE_ID
69: and T.LANGUAGE = L.LANGUAGE_CODE);
70: end INSERT_ROW;
71:

Line 91: from AMW_OPINION_TYPES_TL

87:
88: cursor c1 is select
89: OPINION_TYPE_NAME,
90: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
91: from AMW_OPINION_TYPES_TL
92: where OPINION_TYPE_ID = X_OPINION_TYPE_ID
93: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
94: for update of OPINION_TYPE_ID nowait;
95: begin

Line 155: update AMW_OPINION_TYPES_TL set

151: if (sql%notfound) then
152: raise no_data_found;
153: end if;
154:
155: update AMW_OPINION_TYPES_TL set
156: OPINION_TYPE_NAME = X_OPINION_TYPE_NAME,
157: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
158: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
159: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 173: delete from AMW_OPINION_TYPES_TL

169: procedure DELETE_ROW (
170: X_OPINION_TYPE_ID in NUMBER
171: ) is
172: begin
173: delete from AMW_OPINION_TYPES_TL
174: where OPINION_TYPE_ID = X_OPINION_TYPE_ID;
175:
176: if (sql%notfound) then
177: raise no_data_found;

Line 191: delete from AMW_OPINION_TYPES_TL T

187:
188: procedure ADD_LANGUAGE
189: is
190: begin
191: delete from AMW_OPINION_TYPES_TL T
192: where not exists
193: (select NULL
194: from AMW_OPINION_TYPES_B B
195: where B.OPINION_TYPE_ID = T.OPINION_TYPE_ID

Line 198: update AMW_OPINION_TYPES_TL T set (

194: from AMW_OPINION_TYPES_B B
195: where B.OPINION_TYPE_ID = T.OPINION_TYPE_ID
196: );
197:
198: update AMW_OPINION_TYPES_TL T set (
199: OPINION_TYPE_NAME
200: ) = (select
201: B.OPINION_TYPE_NAME
202: from AMW_OPINION_TYPES_TL B

Line 202: from AMW_OPINION_TYPES_TL B

198: update AMW_OPINION_TYPES_TL T set (
199: OPINION_TYPE_NAME
200: ) = (select
201: B.OPINION_TYPE_NAME
202: from AMW_OPINION_TYPES_TL B
203: where B.OPINION_TYPE_ID = T.OPINION_TYPE_ID
204: and B.LANGUAGE = T.SOURCE_LANG)
205: where (
206: T.OPINION_TYPE_ID,

Line 211: from AMW_OPINION_TYPES_TL SUBB, AMW_OPINION_TYPES_TL SUBT

207: T.LANGUAGE
208: ) in (select
209: SUBT.OPINION_TYPE_ID,
210: SUBT.LANGUAGE
211: from AMW_OPINION_TYPES_TL SUBB, AMW_OPINION_TYPES_TL SUBT
212: where SUBB.OPINION_TYPE_ID = SUBT.OPINION_TYPE_ID
213: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
214: and (SUBB.OPINION_TYPE_NAME <> SUBT.OPINION_TYPE_NAME
215: or (SUBB.OPINION_TYPE_NAME is null and SUBT.OPINION_TYPE_NAME is not null)

Line 219: insert into AMW_OPINION_TYPES_TL (

215: or (SUBB.OPINION_TYPE_NAME is null and SUBT.OPINION_TYPE_NAME is not null)
216: or (SUBB.OPINION_TYPE_NAME is not null and SUBT.OPINION_TYPE_NAME is null)
217: ));
218:
219: insert into AMW_OPINION_TYPES_TL (
220: OPINION_TYPE_ID,
221: OPINION_TYPE_NAME,
222: CREATED_BY,
223: CREATION_DATE,

Line 243: from AMW_OPINION_TYPES_TL B, FND_LANGUAGES L

239: B.SECURITY_GROUP_ID,
240: B.OBJECT_VERSION_NUMBER,
241: L.LANGUAGE_CODE,
242: B.SOURCE_LANG
243: from AMW_OPINION_TYPES_TL B, FND_LANGUAGES L
244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL

Line 248: from AMW_OPINION_TYPES_TL T

244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL
248: from AMW_OPINION_TYPES_TL T
249: where T.OPINION_TYPE_ID = B.OPINION_TYPE_ID
250: and T.LANGUAGE = L.LANGUAGE_CODE);
251: end ADD_LANGUAGE;
252:

Line 322: from AMW_OPINION_TYPES_TL

318: -- Translate char last_update_date to date
319: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
320:
321: select last_updated_by, last_update_date into db_luby, db_ludate
322: from AMW_OPINION_TYPES_TL
323: where opinion_type_id = X_OPINION_TYPE_ID and language = userenv('LANG');
324:
325: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
326: then update AMW_OPINION_TYPES_TL set

Line 326: then update AMW_OPINION_TYPES_TL set

322: from AMW_OPINION_TYPES_TL
323: where opinion_type_id = X_OPINION_TYPE_ID and language = userenv('LANG');
324:
325: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
326: then update AMW_OPINION_TYPES_TL set
327: opinion_type_name = nvl(X_OPINION_TYPE_NAME, opinion_type_name),
328: source_lang = userenv('LANG'),
329: last_update_date = f_ludate,
330: last_updated_by = f_luby,