DBA Data[Home] [Help]

APPS.HXC_ARCHIVE_RESTORE_PROCESS dependencies on HXC_ARCHIVE

Line 1: PACKAGE BODY hxc_archive_restore_process as

1: PACKAGE BODY hxc_archive_restore_process as
2: /* $Header: hxcarcrespkg.pkb 120.8.12010000.4 2008/10/16 10:00:51 asrajago ship $ */
3:
4:
5:

Line 319: IF hxc_archive_restore_utils.incompatibility_pg_running

315:
316: END IF;
317:
318:
319: IF hxc_archive_restore_utils.incompatibility_pg_running
320: THEN
321: fnd_file.put_line(fnd_file.LOG,'Detected another Archive/Restore or Consolidation Attributes process(es) running.');
322: retcode := 2;
323: RETURN;

Line 360: l_min_data_set_age := nvl(fnd_profile.value('HXC_ARCHIVE_DATA_SET_MIN_AGE'),6);

356: END IF;
357:
358:
359: l_data_set_age := months_between(trunc(sysdate),trunc(l_data_set_end_date));
360: l_min_data_set_age := nvl(fnd_profile.value('HXC_ARCHIVE_DATA_SET_MIN_AGE'),6);
361:
362: fnd_file.put_line(fnd_file.LOG,'--- >Profile Value for minimum age value is: '||l_min_data_set_age);
363:
364: IF (l_data_set_age < 0)

Line 393: if hxc_archive_restore_utils.check_data_corruption(p_data_set_id) then

389: END IF;
390:
391: /********* THAT SHOULD BE DONE DURING THE DATA SET VALIDATION *********/
392: /*
393: if hxc_archive_restore_utils.check_data_corruption(p_data_set_id) then
394:
395: fnd_file.put_line(fnd_file.LOG,'--- >Data Corruption observed before beginning to Archive the data set');
396: retcode := 2;
397: return;

Line 429: --hxc_archive_restore_utils.populate_hxc_data_set_details(p_data_set_id);

425:
426: END IF;
427:
428: --fnd_file.put_line(fnd_file.LOG,'--- >Before populating the hxc_data_set_details table with table counts');
429: --hxc_archive_restore_utils.populate_hxc_data_set_details(p_data_set_id);
430: END IF;
431:
432:
433:

Line 474: hxc_archive_restore_utils.core_table_count_snapshot

470: hxc_data_set.validate_data_set (p_data_set_id => p_data_set_id,
471: p_error_count => l_error_count,
472: p_all_errors => true);
473:
474: hxc_archive_restore_utils.core_table_count_snapshot
475: (p_tbb_count => l_tbb_count_1,
476: p_tau_count => l_tau_count_1,
477: p_ta_count => l_ta_count_1,
478: p_td_count => l_td_count_1,

Line 487: hxc_archive_restore_utils.bkup_table_count_snapshot

483: p_ld_count => l_ld_count_1,
484: p_ts_count => l_ts_count_1);
485:
486:
487: hxc_archive_restore_utils.bkup_table_count_snapshot
488: (p_tbb_ar_count => l_tbb_ar_count_1,
489: p_tau_ar_count => l_tau_ar_count_1,
490: p_ta_ar_count => l_ta_ar_count_1,
491: p_td_ar_count => l_td_ar_count_1,

Line 501: hxc_archive.archive_process(p_data_set_id => p_data_set_id,

497: */
498: --
499: -- call the archive process
500: --
501: hxc_archive.archive_process(p_data_set_id => p_data_set_id,
502: p_data_set_start_date => l_data_set_start_date,
503: p_data_set_end_date => l_data_set_end_date);
504:
505:

Line 522: hxc_archive_restore_utils.core_table_count_snapshot

518: /*
519:
520: hxc_data_set.release_lock_data_set(p_data_set_id);
521:
522: hxc_archive_restore_utils.core_table_count_snapshot
523: (p_tbb_count => l_tbb_count_2,
524: p_tau_count => l_tau_count_2,
525: p_ta_count => l_ta_count_2,
526: p_td_count => l_td_count_2,

Line 535: hxc_archive_restore_utils.bkup_table_count_snapshot

531: p_ld_count => l_ld_count_2,
532: p_ts_count => l_ts_count_2);
533:
534:
535: hxc_archive_restore_utils.bkup_table_count_snapshot
536: (p_tbb_ar_count => l_tbb_ar_count_2,
537: p_tau_ar_count => l_tau_ar_count_2,
538: p_ta_ar_count => l_ta_ar_count_2,
539: p_td_ar_count => l_td_ar_count_2,

Line 545: hxc_archive_restore_utils.count_snapshot_check

541: p_tal_ar_count => l_tal_ar_count_2,
542: p_adl_ar_count => l_adl_ar_count_2,
543: p_aps_ar_count => l_aps_ar_count_2);
544:
545: hxc_archive_restore_utils.count_snapshot_check
546: (p_tbb_count_1 => l_tbb_count_1,
547: p_tau_count_1 => l_tau_count_1,
548: p_ta_count_1 => l_ta_count_1,
549: p_td_count_1 => l_td_count_1,

Line 725: IF hxc_archive_restore_utils.incompatibility_pg_running

721:
722:
723: -- let's check if there are no program that are running
724: -- and are incompatible with this one
725: IF hxc_archive_restore_utils.incompatibility_pg_running
726: THEN
727: fnd_file.put_line(fnd_file.LOG,'Detected another Archive/Restore or Consolidation Attributes process(es) running.');
728: retcode := 2;
729: RETURN;

Line 745: hxc_archive_restore_utils.core_table_count_snapshot

741: -- Core Table count snapshot
742: -- Backup Table count snapshot
743: -- Count Snapshot check.
744:
745: hxc_archive_restore_utils.core_table_count_snapshot
746: (p_tbb_count => l_tbb_count_1,
747: p_tau_count => l_tau_count_1,
748: p_ta_count => l_ta_count_1,
749: p_td_count => l_td_count_1,

Line 758: hxc_archive_restore_utils.bkup_table_count_snapshot

754: p_ld_count => l_ld_count_1,
755: p_ts_count => l_ts_count_1);
756:
757:
758: hxc_archive_restore_utils.bkup_table_count_snapshot
759: (p_tbb_ar_count => l_tbb_ar_count_1,
760: p_tau_ar_count => l_tau_ar_count_1,
761: p_ta_ar_count => l_ta_ar_count_1,
762: p_td_ar_count => l_td_ar_count_1,

Line 806: hxc_archive_restore_utils.core_table_count_snapshot

802: END IF;
803:
804:
805: /*
806: hxc_archive_restore_utils.core_table_count_snapshot
807: (p_tbb_count => l_tbb_count_2,
808: p_tau_count => l_tau_count_2,
809: p_ta_count => l_ta_count_2,
810: p_td_count => l_td_count_2,

Line 819: hxc_archive_restore_utils.bkup_table_count_snapshot

815: p_ld_count => l_ld_count_2,
816: p_ts_count => l_ts_count_2);
817:
818:
819: hxc_archive_restore_utils.bkup_table_count_snapshot
820: (p_tbb_ar_count => l_tbb_ar_count_2,
821: p_tau_ar_count => l_tau_ar_count_2,
822: p_ta_ar_count => l_ta_ar_count_2,
823: p_td_ar_count => l_td_ar_count_2,

Line 829: hxc_archive_restore_utils.count_snapshot_check

825: p_tal_ar_count => l_tal_ar_count_2,
826: p_adl_ar_count => l_adl_ar_count_2,
827: p_aps_ar_count => l_aps_ar_count_2);
828:
829: hxc_archive_restore_utils.count_snapshot_check
830: (p_tbb_count_1 => l_tbb_count_1,
831: p_tau_count_1 => l_tau_count_1,
832: p_ta_count_1 => l_ta_count_1,
833: p_td_count_1 => l_td_count_1,

Line 881: IF NOT (hxc_archive_restore_utils.check_if_copy_successful

877: fnd_file.put_line(fnd_file.LOG,'--------------------------------------------------------------');
878: END IF;
879:
880:
881: IF NOT (hxc_archive_restore_utils.check_if_copy_successful
882: (p_data_set_id,'RESTORE'))
883: THEN
884: --error
885: fnd_file.put_line(fnd_file.LOG,'--- >Copy failed');

Line 1011: End hxc_archive_restore_process;

1007:
1008: ----------------------------------------------------------------------------------------
1009:
1010:
1011: End hxc_archive_restore_process;