APPS.AME_ADMIN_PKG dependencies on AME_EXCEPTIONS_LOG

Line 2363: delete from ame_exceptions_log

2359: */
2360: procedure clearTransException(applicationIdIn in integer,
2361: transactionIdIn in varchar2) as
2362: begin
2363: delete from ame_exceptions_log
2364: where
2365: application_id = applicationIdIn and
2366: transaction_id = transactionIdIn;
2367: commit;

Line 2399: delete from ame_exceptions_log

2395: raise;
2396: end clearTransTypeConfigVarValue;
2397: procedure clearTransTypeExceptions(applicationIdIn in integer) as
2398: begin
2399: delete from ame_exceptions_log
2400: where application_id = applicationIdIn;
2401: commit;
2402: exception
2403: when others then

Line 2413: delete from ame_exceptions_log

2409: raise;
2410: end clearTransTypeExceptions;
2411: procedure clearWebExceptions as
2412: begin
2413: delete from ame_exceptions_log
2414: where
2415: application_id is null and
2416: transaction_id is null;
2417: commit;

Line 3509: from ame_exceptions_log

3505: transactionIdIn in varchar2,
3506: exceptionLogOut out nocopy ame_util.exceptionLogTable) as
3507: cursor exceptionLogCursor is
3508: select *
3509: from ame_exceptions_log
3510: where
3511: application_id = applicationIdIn and
3512: transaction_id = transactionIdIn
3513: order by log_id desc;

Line 3566: from ame_exceptions_log

3562: procedure getTransTypeExceptions1(applicationIdIn in integer,
3563: exceptionLogOut out nocopy ame_util.exceptionLogTable) as
3564: cursor exceptionLogCursor(applicationIdIn in integer) is
3565: select *
3566: from ame_exceptions_log
3567: where application_id = applicationIdIn
3568: order by log_id desc;
3569: logLength integer;
3570: tempIndex integer;

Line 3620: from ame_exceptions_log

3616: procedure getTransTypeExceptions2(applicationIdIn in integer,
3617: exceptionLogOut out nocopy ame_util.exceptionLogTable) as
3618: cursor exceptionLogCursor is
3619: select *
3620: from ame_exceptions_log
3621: where application_id = applicationIdIn
3622: order by
3623: package_name,
3624: routine_name;

Line 3884: from ame_exceptions_log

3880: package_name,
3881: routine_name,
3882: exception_number,
3883: exception_string
3884: from ame_exceptions_log
3885: where
3886: transaction_id is null and
3887: application_id is null
3888: order by log_id desc;