APPS.AMW_EXCEPTIONS_PKG dependencies on AMW_EXCEPTIONS_B

Line 61: (select exception_id from amw_exceptions_b

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:
65: delete from amw_exceptions_reasons where exception_id IN

Line 66: (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:
70: delete from amw_exceptions_b

Line 70: delete from amw_exceptions_b

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:
70: delete from amw_exceptions_b
71: where old_pk1 = p_Old_pk1 and new_pk1 = p_New_pk1
72: and object_type = 'PROCESS_VARIANT_ADD';
73:
74: else

Line 77: delete from amw_exceptions_b where exception_id = p_existing_ex_id;

73:
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,

Line 80: insert into amw_exceptions_b (

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,
83: Old_pk1,
84: Old_pk2,

Line 327: from amw_exceptions_b B

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
329: );
330:
331: update amw_exceptions_tl T set (