APPS.AMW_EXCEPTIONS_PKG dependencies on AMW_EXCEPTIONS_TL

Line 60: delete from amw_exceptions_tl where exception_id IN

56: RAISE FND_API.G_EXC_ERROR;
57: END IF;
58:
59: if ( (p_Object_Type = 'PROCESS_VARIANT_ADD') AND (p_Transaction_Type = 'DELETE_EXIST') ) then
60: delete from amw_exceptions_tl where exception_id IN
61: (select exception_id from amw_exceptions_b
62: where old_pk1 = p_Old_pk1 and new_pk1 = p_New_pk1
63: and object_type = 'PROCESS_VARIANT_ADD');
64:

Line 78: delete from amw_exceptions_tl where exception_id = p_existing_ex_id;

74: else
75:
76: if p_existing_ex_id <> 0 then
77: delete from amw_exceptions_b where exception_id = p_existing_ex_id;
78: delete from amw_exceptions_tl where exception_id = p_existing_ex_id;
79: else
80: insert into amw_exceptions_b (
81: Exception_Id,
82: Object_Type,

Line 133: insert into amw_exceptions_tl (

129: 1
130: );
131:
132:
133: insert into amw_exceptions_tl (
134: EXCEPTION_ID,
135: LANGUAGE,
136: SOURCE_LANG,
137: JUSTIFICATION,

Line 161: from AMW_EXCEPTIONS_TL T

157: from FND_LANGUAGES L
158: where L.INSTALLED_FLAG in ('I', 'B')
159: and not exists
160: (select NULL
161: from AMW_EXCEPTIONS_TL T
162: where T.EXCEPTION_ID = p_Exception_Id
163: and T.LANGUAGE = L.LANGUAGE_CODE);
164:
165: end if; -- p_existing_ex_id 0

Line 324: delete from amw_exceptions_tl T

320:
321: procedure ADD_LANGUAGE
322: is
323: begin
324: delete from amw_exceptions_tl T
325: where not exists
326: (select NULL
327: from amw_exceptions_b B
328: where B.exception_id = T.exception_id

Line 331: update amw_exceptions_tl T set (

327: from amw_exceptions_b B
328: where B.exception_id = T.exception_id
329: );
330:
331: update amw_exceptions_tl T set (
332: JUSTIFICATION
333: ) = (select
334: B.JUSTIFICATION
335: from amw_exceptions_tl B

Line 335: from amw_exceptions_tl B

331: update amw_exceptions_tl T set (
332: JUSTIFICATION
333: ) = (select
334: B.JUSTIFICATION
335: from amw_exceptions_tl B
336: where B.exception_id = T.exception_id
337: and B.LANGUAGE = T.SOURCE_LANG)
338: where (
339: T.exception_id,

Line 344: from amw_exceptions_tl SUBB, amw_exceptions_tl SUBT

340: T.LANGUAGE
341: ) in (select
342: SUBT.exception_id,
343: SUBT.LANGUAGE
344: from amw_exceptions_tl SUBB, amw_exceptions_tl SUBT
345: where SUBB.exception_id = SUBT.exception_id
346: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
347: and (SUBB.JUSTIFICATION <> SUBT.JUSTIFICATION
348: or (SUBB.JUSTIFICATION is null and SUBT.JUSTIFICATION is not null)

Line 353: insert into amw_exceptions_tl (

349: or (SUBB.JUSTIFICATION is not null and SUBT.JUSTIFICATION is null)
350: ));
351:
352:
353: insert into amw_exceptions_tl (
354: exception_id,
355: JUSTIFICATION,
356: LAST_UPDATE_DATE,
357: LAST_UPDATED_BY,

Line 375: from amw_exceptions_tl B, FND_LANGUAGES L

371: B.LAST_UPDATE_LOGIN,
372: B.SECURITY_GROUP_ID,
373: L.LANGUAGE_CODE,
374: B.SOURCE_LANG
375: from amw_exceptions_tl B, FND_LANGUAGES L
376: where L.INSTALLED_FLAG in ('I', 'B')
377: and B.LANGUAGE = userenv('LANG')
378: and not exists
379: (select NULL

Line 380: from amw_exceptions_tl T

376: where L.INSTALLED_FLAG in ('I', 'B')
377: and B.LANGUAGE = userenv('LANG')
378: and not exists
379: (select NULL
380: from amw_exceptions_tl T
381: where T.exception_id = B.exception_id
382: and T.LANGUAGE = L.LANGUAGE_CODE);
383: end ADD_LANGUAGE;
384: