DBA Data[Home] [Help]

APPS.AMW_UTILITY_PVT dependencies on AMW_EXCEPTIONS_TL

Line 980: from amw_exceptions_tl aetl

976: l_process_name varchar2(240);
977: begin
978: if p_type = 'A' then
979: select new_process_name into l_process_name
980: from amw_exceptions_tl aetl
981: where
982: aetl.exception_id = p_exception_id
983: and aetl.language = userenv('LANG');
984: elsif p_type='D' then

Line 986: from amw_exceptions_tl aetl

982: aetl.exception_id = p_exception_id
983: and aetl.language = userenv('LANG');
984: elsif p_type='D' then
985: select old_process_name into l_process_name
986: from amw_exceptions_tl aetl
987: where
988: aetl.exception_id = p_exception_id
989: and aetl.language = userenv('LANG');
990: else

Line 1772: FROM AMW_EXCEPTIONS_TL

1768: AND END_DATE IS NULL;
1769:
1770: CURSOR EX_COMMENTS(p_exception_id in NUMBER) IS
1771: SELECT JUSTIFICATION
1772: FROM AMW_EXCEPTIONS_TL
1773: WHERE EXCEPTION_ID = p_exception_id
1774: AND LANGUAGE = USERENV('LANG');
1775:
1776: l_comments VARCHAR2(4000) :=NULL;