DBA Data[Home] [Help]

APPS.HXC_RETRIEVAL_ROLLBACK dependencies on HXC_ROLLBACK_LOG

Line 528: DELETE FROM hxc_rollback_log

524: PRAGMA AUTONOMOUS_TRANSACTION;
525:
526: BEGIN
527:
528: DELETE FROM hxc_rollback_log
529: WHERE type = 'HXCROLL';
530: COMMIT;
531:
532: END delete_old_log;

Line 545: FROM hxc_rollback_log

541: PRAGMA AUTONOMOUS_TRANSACTION;
542:
543: CURSOR get_log
544: IS SELECT text
545: FROM hxc_rollback_log
546: WHERE type = 'HXCROLL'
547: ORDER BY seq;
548:
549:

Line 581: DELETE FROM hxc_rollback_log;

577: END LOOP;
578: END LOOP;
579: CLOSE get_log;
580:
581: DELETE FROM hxc_rollback_log;
582: COMMIT;
583:
584:
585: END display_cached_log;

Line 3498: INSERT INTO hxc_rollback_log

3494:
3495: IF p_cache = 'Y'
3496: THEN
3497: g_seq := g_seq+1;
3498: INSERT INTO hxc_rollback_log
3499: (seq,text,type)
3500: VALUES
3501: (g_seq,p_text,'HXCROLL');
3502: COMMIT;