APPS.AMW_NONSTANDARD_VARIATIONS_PKG dependencies on AMW_NONSTANDARD_VARIATIONS_TL

Line 61: insert into AMW_NONSTANDARD_VARIATIONS_TL (

57: X_LAST_UPDATED_BY,
58: X_LAST_UPDATE_LOGIN
59: );
60:
61: insert into AMW_NONSTANDARD_VARIATIONS_TL (
62: VARIATION_ROW_ID,
63: REASON,
64: LAST_UPDATE_DATE,
65: LAST_UPDATED_BY,

Line 87: from AMW_NONSTANDARD_VARIATIONS_TL T

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

Line 132: from AMW_NONSTANDARD_VARIATIONS_TL

128:
129: cursor c1 is select
130: REASON,
131: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
132: from AMW_NONSTANDARD_VARIATIONS_TL
133: where VARIATION_ROW_ID = X_VARIATION_ROW_ID
134: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
135: for update of VARIATION_ROW_ID nowait;
136: begin

Line 220: update AMW_NONSTANDARD_VARIATIONS_TL set

216: if (sql%notfound) then
217: raise no_data_found;
218: end if;
219:
220: update AMW_NONSTANDARD_VARIATIONS_TL set
221: REASON = X_REASON,
222: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
223: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
224: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 238: delete from AMW_NONSTANDARD_VARIATIONS_TL

234: procedure DELETE_ROW (
235: X_VARIATION_ROW_ID in NUMBER
236: ) is
237: begin
238: delete from AMW_NONSTANDARD_VARIATIONS_TL
239: where VARIATION_ROW_ID = X_VARIATION_ROW_ID;
240:
241: if (sql%notfound) then
242: raise no_data_found;

Line 256: delete from AMW_NONSTANDARD_VARIATIONS_TL T

252:
253: procedure ADD_LANGUAGE
254: is
255: begin
256: delete from AMW_NONSTANDARD_VARIATIONS_TL T
257: where not exists
258: (select NULL
259: from AMW_NONSTANDARD_VARIATIONS_B B
260: where B.VARIATION_ROW_ID = T.VARIATION_ROW_ID

Line 263: update AMW_NONSTANDARD_VARIATIONS_TL T set (

259: from AMW_NONSTANDARD_VARIATIONS_B B
260: where B.VARIATION_ROW_ID = T.VARIATION_ROW_ID
261: );
262:
263: update AMW_NONSTANDARD_VARIATIONS_TL T set (
264: REASON
265: ) = (select
266: B.REASON
267: from AMW_NONSTANDARD_VARIATIONS_TL B

Line 267: from AMW_NONSTANDARD_VARIATIONS_TL B

263: update AMW_NONSTANDARD_VARIATIONS_TL T set (
264: REASON
265: ) = (select
266: B.REASON
267: from AMW_NONSTANDARD_VARIATIONS_TL B
268: where B.VARIATION_ROW_ID = T.VARIATION_ROW_ID
269: and B.LANGUAGE = T.SOURCE_LANG)
270: where (
271: T.VARIATION_ROW_ID,

Line 276: from AMW_NONSTANDARD_VARIATIONS_TL SUBB, AMW_NONSTANDARD_VARIATIONS_TL SUBT

272: T.LANGUAGE
273: ) in (select
274: SUBT.VARIATION_ROW_ID,
275: SUBT.LANGUAGE
276: from AMW_NONSTANDARD_VARIATIONS_TL SUBB, AMW_NONSTANDARD_VARIATIONS_TL SUBT
277: where SUBB.VARIATION_ROW_ID = SUBT.VARIATION_ROW_ID
278: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
279: and (SUBB.REASON <> SUBT.REASON
280: or (SUBB.REASON is null and SUBT.REASON is not null)

Line 284: insert into AMW_NONSTANDARD_VARIATIONS_TL (

280: or (SUBB.REASON is null and SUBT.REASON is not null)
281: or (SUBB.REASON is not null and SUBT.REASON is null)
282: ));
283:
284: insert into AMW_NONSTANDARD_VARIATIONS_TL (
285: VARIATION_ROW_ID,
286: REASON,
287: LAST_UPDATE_DATE,
288: LAST_UPDATED_BY,

Line 306: from AMW_NONSTANDARD_VARIATIONS_TL B, FND_LANGUAGES L

302: B.CREATED_BY,
303: B.OBJECT_VERSION_NUMBER,
304: L.LANGUAGE_CODE,
305: B.SOURCE_LANG
306: from AMW_NONSTANDARD_VARIATIONS_TL B, FND_LANGUAGES L
307: where L.INSTALLED_FLAG in ('I', 'B')
308: and B.LANGUAGE = userenv('LANG')
309: and not exists
310: (select NULL

Line 311: from AMW_NONSTANDARD_VARIATIONS_TL T

307: where L.INSTALLED_FLAG in ('I', 'B')
308: and B.LANGUAGE = userenv('LANG')
309: and not exists
310: (select NULL
311: from AMW_NONSTANDARD_VARIATIONS_TL T
312: where T.VARIATION_ROW_ID = B.VARIATION_ROW_ID
313: and T.LANGUAGE = L.LANGUAGE_CODE);
314: end ADD_LANGUAGE;
315: