APPS.AML_BUSINESS_EVENT_TYPES_PKG dependencies on AML_BUSINESS_EVENT_TYPES_TL

Line 46: insert into AML_BUSINESS_EVENT_TYPES_TL (

42: X_LAST_UPDATED_BY,
43: X_LAST_UPDATE_LOGIN
44: );
45:
46: insert into AML_BUSINESS_EVENT_TYPES_TL (
47: BUSINESS_EVENT_TYPE_ID,
48: MEANING,
49: DESCRIPTION,
50: CREATION_DATE,

Line 72: from AML_BUSINESS_EVENT_TYPES_TL T

68: from FND_LANGUAGES L
69: where L.INSTALLED_FLAG in ('I', 'B')
70: and not exists
71: (select NULL
72: from AML_BUSINESS_EVENT_TYPES_TL T
73: where T.BUSINESS_EVENT_TYPE_ID = X_BUSINESS_EVENT_TYPE_ID
74: and T.LANGUAGE = L.LANGUAGE_CODE);
75:
76: open c;

Line 109: from AML_BUSINESS_EVENT_TYPES_TL

105: cursor c1 is select
106: MEANING,
107: DESCRIPTION,
108: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
109: from AML_BUSINESS_EVENT_TYPES_TL
110: where BUSINESS_EVENT_TYPE_ID = X_BUSINESS_EVENT_TYPE_ID
111: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
112: for update of BUSINESS_EVENT_TYPE_ID nowait;
113: begin

Line 176: update AML_BUSINESS_EVENT_TYPES_TL set

172: if (sql%notfound) then
173: raise no_data_found;
174: end if;
175:
176: update AML_BUSINESS_EVENT_TYPES_TL set
177: MEANING = X_MEANING,
178: DESCRIPTION = X_DESCRIPTION,
179: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
180: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 195: delete from AML_BUSINESS_EVENT_TYPES_TL

191: procedure DELETE_ROW (
192: X_BUSINESS_EVENT_TYPE_ID in NUMBER
193: ) is
194: begin
195: delete from AML_BUSINESS_EVENT_TYPES_TL
196: where BUSINESS_EVENT_TYPE_ID = X_BUSINESS_EVENT_TYPE_ID;
197:
198: if (sql%notfound) then
199: raise no_data_found;

Line 213: delete from AML_BUSINESS_EVENT_TYPES_TL T

209:
210: procedure ADD_LANGUAGE
211: is
212: begin
213: delete from AML_BUSINESS_EVENT_TYPES_TL T
214: where not exists
215: (select NULL
216: from AML_BUSINESS_EVENT_TYPES_B B
217: where B.BUSINESS_EVENT_TYPE_ID = T.BUSINESS_EVENT_TYPE_ID

Line 220: update AML_BUSINESS_EVENT_TYPES_TL T set (

216: from AML_BUSINESS_EVENT_TYPES_B B
217: where B.BUSINESS_EVENT_TYPE_ID = T.BUSINESS_EVENT_TYPE_ID
218: );
219:
220: update AML_BUSINESS_EVENT_TYPES_TL T set (
221: MEANING,
222: DESCRIPTION
223: ) = (select
224: B.MEANING,

Line 226: from AML_BUSINESS_EVENT_TYPES_TL B

222: DESCRIPTION
223: ) = (select
224: B.MEANING,
225: B.DESCRIPTION
226: from AML_BUSINESS_EVENT_TYPES_TL B
227: where B.BUSINESS_EVENT_TYPE_ID = T.BUSINESS_EVENT_TYPE_ID
228: and B.LANGUAGE = T.SOURCE_LANG)
229: where (
230: T.BUSINESS_EVENT_TYPE_ID,

Line 235: from AML_BUSINESS_EVENT_TYPES_TL SUBB, AML_BUSINESS_EVENT_TYPES_TL SUBT

231: T.LANGUAGE
232: ) in (select
233: SUBT.BUSINESS_EVENT_TYPE_ID,
234: SUBT.LANGUAGE
235: from AML_BUSINESS_EVENT_TYPES_TL SUBB, AML_BUSINESS_EVENT_TYPES_TL SUBT
236: where SUBB.BUSINESS_EVENT_TYPE_ID = SUBT.BUSINESS_EVENT_TYPE_ID
237: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
238: and (SUBB.MEANING <> SUBT.MEANING
239: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 244: insert into AML_BUSINESS_EVENT_TYPES_TL (

240: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
241: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
242: ));
243:
244: insert into AML_BUSINESS_EVENT_TYPES_TL (
245: BUSINESS_EVENT_TYPE_ID,
246: MEANING,
247: DESCRIPTION,
248: CREATION_DATE,

Line 266: from AML_BUSINESS_EVENT_TYPES_TL B, FND_LANGUAGES L

262: B.LAST_UPDATED_BY,
263: B.LAST_UPDATE_LOGIN,
264: L.LANGUAGE_CODE,
265: B.SOURCE_LANG
266: from AML_BUSINESS_EVENT_TYPES_TL B, FND_LANGUAGES L
267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL

Line 271: from AML_BUSINESS_EVENT_TYPES_TL T

267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL
271: from AML_BUSINESS_EVENT_TYPES_TL T
272: where T.BUSINESS_EVENT_TYPE_ID = B.BUSINESS_EVENT_TYPE_ID
273: and T.LANGUAGE = L.LANGUAGE_CODE);
274: end ADD_LANGUAGE;
275:

Line 346: UPDATE AML_BUSINESS_EVENT_TYPES_TL

342: p_OWNER IN VARCHAR2
343: ) IS
344: BEGIN
345: -- only UPDATE rows that have not been altered by user
346: UPDATE AML_BUSINESS_EVENT_TYPES_TL
347: SET
348: MEANING = NVL(p_MEANING, MEANING),
349: DESCRIPTION = NVL(p_DESCRIPTION, DESCRIPTION),
350: SOURCE_LANG = userenv('LANG'),