APPS.AMW_EXCEPTIONS_PKG dependencies on AMW_EXCEPTIONS_REASONS

Line 65: delete from amw_exceptions_reasons 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:
65: delete from amw_exceptions_reasons where exception_id IN
66: (select exception_id from amw_exceptions_b
67: where old_pk1 = p_Old_pk1 and new_pk1 = p_New_pk1
68: and object_type = 'PROCESS_VARIANT_ADD');
69:

Line 273: delete from amw_exceptions_reasons where exception_id = p_existing_ex_id;

269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271:
272: if p_existing_ex_id <> 0 then
273: delete from amw_exceptions_reasons where exception_id = p_existing_ex_id;
274: else
275: insert into amw_exceptions_reasons (
276: EXCEPTION_ID,
277: REASON_CODE,

Line 275: insert into amw_exceptions_reasons (

271:
272: if p_existing_ex_id <> 0 then
273: delete from amw_exceptions_reasons where exception_id = p_existing_ex_id;
274: else
275: insert into amw_exceptions_reasons (
276: EXCEPTION_ID,
277: REASON_CODE,
278: Last_Update_Date,
279: Last_Updated_By,