APPS.AME_UTILITY_PKG dependencies on AME_EXCEPTIONS_LOG

Line 436: from ame_exceptions_log

432:
433: if (p_transaction_id is null) and (p_transaction_type is not null ) then
434: select count(*)
435: into l_count
436: from ame_exceptions_log
437: where application_id = l_application_id ;
438: if l_count > 0 then
439: delete from ame_exceptions_log
440: where application_id = l_application_id ;

Line 439: delete from ame_exceptions_log

435: into l_count
436: from ame_exceptions_log
437: where application_id = l_application_id ;
438: if l_count > 0 then
439: delete from ame_exceptions_log
440: where application_id = l_application_id ;
441: p_success :='Y';
442: else
443: p_success :='N';

Line 448: from ame_exceptions_log

444: end if;
445: elsif (p_transaction_id is not null) and (p_transaction_type is null) then
446: select count(*)
447: into l_count
448: from ame_exceptions_log
449: where transaction_id like (p_transaction_id || '%');
450: if l_count > 0 then
451: delete from ame_exceptions_log
452: where transaction_id like (p_transaction_id || '%');

Line 451: delete from ame_exceptions_log

447: into l_count
448: from ame_exceptions_log
449: where transaction_id like (p_transaction_id || '%');
450: if l_count > 0 then
451: delete from ame_exceptions_log
452: where transaction_id like (p_transaction_id || '%');
453: p_success :='Y';
454: else
455: p_success :='N';

Line 460: from ame_exceptions_log

456: end if;
457: elsif (p_transaction_id is not null) and (p_transaction_type is not null) then
458: select count(*)
459: into l_count
460: from ame_exceptions_log
461: where transaction_id like (p_transaction_id || '%')
462: and application_id = l_application_id ;
463: if l_count > 0 then
464: delete from ame_exceptions_log

Line 464: delete from ame_exceptions_log

460: from ame_exceptions_log
461: where transaction_id like (p_transaction_id || '%')
462: and application_id = l_application_id ;
463: if l_count > 0 then
464: delete from ame_exceptions_log
465: where application_id = l_application_id
466: and transaction_id like (p_transaction_id || '%');
467: p_success :='Y';
468: else