APPS.AMW_UTILITY_PVT dependencies on AMW_EXCEPTIONS_B

Line 1672: FROM AMW_EXCEPTIONS_B

1668: IS
1669:
1670: CURSOR DEL_EXCEPTION IS
1671: SELECT EXCEPTION_ID
1672: FROM AMW_EXCEPTIONS_B
1673: WHERE OBJECT_TYPE = p_object
1674: AND OLD_PK1 = p_pk1
1675: AND OLD_PK2 = p_pk2
1676: AND OLD_PK3 = p_pk3

Line 1684: FROM AMW_EXCEPTIONS_B

1680: AND END_DATE IS NULL;
1681:
1682: CURSOR ADD_EXCEPTION IS
1683: SELECT EXCEPTION_ID
1684: FROM AMW_EXCEPTIONS_B
1685: WHERE OBJECT_TYPE = p_object
1686: AND NEW_PK1 = p_pk1
1687: AND NEW_PK2 = p_pk2
1688: AND NEW_PK3 = p_pk3

Line 1703: l_exception_id AMW_EXCEPTIONS_B.EXCEPTION_ID%TYPE;

1699: AND LOOKUP_CODE = REASON_CODE
1700: AND EXCEPTION_ID = p_exception_id;
1701:
1702: l_reasons_string VARCHAR2(4000) :=NULL;
1703: l_exception_id AMW_EXCEPTIONS_B.EXCEPTION_ID%TYPE;
1704: BEGIN
1705:
1706: IF p_action = 'DEL' THEN
1707: OPEN DEL_EXCEPTION;

Line 1748: FROM AMW_EXCEPTIONS_B

1744: IS
1745:
1746: CURSOR DEL_EXCEPTION IS
1747: SELECT EXCEPTION_ID
1748: FROM AMW_EXCEPTIONS_B
1749: WHERE OBJECT_TYPE = p_object
1750: AND OLD_PK1 = p_pk1
1751: AND OLD_PK2 = p_pk2
1752: AND OLD_PK3 = p_pk3

Line 1760: FROM AMW_EXCEPTIONS_B

1756: AND END_DATE IS NULL;
1757:
1758: CURSOR ADD_EXCEPTION IS
1759: SELECT EXCEPTION_ID
1760: FROM AMW_EXCEPTIONS_B
1761: WHERE OBJECT_TYPE = p_object
1762: AND NEW_PK1 = p_pk1
1763: AND NEW_PK2 = p_pk2
1764: AND NEW_PK3 = p_pk3

Line 1777: l_exception_id AMW_EXCEPTIONS_B.EXCEPTION_ID%TYPE;

1773: WHERE EXCEPTION_ID = p_exception_id
1774: AND LANGUAGE = USERENV('LANG');
1775:
1776: l_comments VARCHAR2(4000) :=NULL;
1777: l_exception_id AMW_EXCEPTIONS_B.EXCEPTION_ID%TYPE;
1778: BEGIN
1779:
1780: IF p_action = 'DEL' THEN
1781: OPEN DEL_EXCEPTION;