APPS.HXC_RESTORE dependencies on HXC_RESTORE

Line 1: PACKAGE BODY hxc_restore AS

1: PACKAGE BODY hxc_restore AS
2: /* $Header: hxcrestore.pkb 120.12.12020000.2 2012/07/04 09:31:18 amnaraya ship $ */
3: ----------------------------------------------------------------------------
4: -- Procedure Name : restore_process
5: -- Description : This procedure is called durINg Restore Data Set process.

Line 773: hxc_restore.log_data_mismatch(p_scope => 'Timecard',

769:
770:
771: l_tc_del_count := sql%rowcount;
772:
773: hxc_restore.log_data_mismatch(p_scope => 'Timecard',
774: p_insert => l_tc_count,
775: p_delete => l_tc_del_count,
776: p_mismatch => data_mismatch
777: );

Line 839: hxc_restore.log_data_mismatch(p_scope => 'TC App LINKs ',

835: AND thread_id = p_thread_id );
836:
837: l_tal_del_count := SQL%ROWCOUNT;
838:
839: hxc_restore.log_data_mismatch(p_scope => 'TC App LINKs ',
840: p_insert => l_tal_count,
841: p_delete => l_tal_del_count,
842: p_mismatch => data_mismatch );
843:

Line 887: hxc_restore.log_data_mismatch( p_scope => 'Application Period ',

883: AND data_set_id = p_data_set_id ;
884:
885: l_app_del_count := SQL%ROWCOUNT;
886:
887: hxc_restore.log_data_mismatch( p_scope => 'Application Period ',
888: p_insert => l_app_period_count,
889: p_delete => l_app_del_count,
890: p_mismatch => data_mismatch );
891:

Line 928: hxc_restore.log_data_mismatch( p_scope => 'App Period Summary ',

924: AND data_set_id = p_data_set_id ;
925:
926: l_app_sum_del_count := SQL%ROWCOUNT;
927:
928: hxc_restore.log_data_mismatch( p_scope => 'App Period Summary ',
929: p_insert => l_app_period_sum_count,
930: p_delete => l_app_sum_del_count,
931: p_mismatch => data_mismatch );
932:

Line 1009: hxc_restore.log_data_mismatch( p_scope => 'Day ',

1005:
1006: END LOOP;
1007: CLOSE get_tbb_rowid;
1008:
1009: hxc_restore.log_data_mismatch( p_scope => 'Day ',
1010: p_insert => l_day_count,
1011: p_delete => l_day_del_count,
1012: p_mismatch => data_mismatch );
1013:

Line 1088: hxc_restore.log_data_mismatch( p_scope => 'Detail ',

1084: rowid_tab.DELETE;
1085: END LOOP;
1086: CLOSE get_tbb_rowid;
1087:
1088: hxc_restore.log_data_mismatch( p_scope => 'Detail ',
1089: p_insert => l_det_count,
1090: p_delete => l_det_del_count,
1091: p_mismatch => data_mismatch );
1092:

Line 1252: hxc_restore.log_data_mismatch( p_scope => 'Transaction Detail ',

1248: END LOOP;
1249:
1250: CLOSE get_transactions;
1251:
1252: hxc_restore.log_data_mismatch( p_scope => 'Transaction Detail ',
1253: p_insert => l_td_count,
1254: p_delete => l_td_del_count,
1255: p_mismatch => data_mismatch );
1256:

Line 1507: hxc_restore.log_data_mismatch( p_scope => 'Deposit Transaction ',

1503:
1504: END LOOP;
1505:
1506: CLOSE get_dep_transactions;
1507: hxc_restore.log_data_mismatch( p_scope => 'Deposit Transaction ',
1508: p_insert => l_trans_count,
1509: p_delete => l_trans_del_count,
1510: p_mismatch => data_mismatch );
1511:

Line 1520: hxc_restore.log_data_mismatch( p_scope => 'Deposit Transaction Detail ',

1516: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
1517: END IF;
1518:
1519:
1520: hxc_restore.log_data_mismatch( p_scope => 'Deposit Transaction Detail ',
1521: p_insert => l_td_count,
1522: p_delete => l_td_del_count,
1523: p_mismatch => data_mismatch );
1524:

Line 1638: hxc_restore.log_data_mismatch( p_scope => 'Attribute Usages ',

1634:
1635: END LOOP ;
1636: CLOSE get_attributes;
1637:
1638: hxc_restore.log_data_mismatch( p_scope => 'Attribute Usages ',
1639: p_insert => l_tau_count,
1640: p_delete => l_tau_del_count,
1641: p_mismatch => data_mismatch );
1642:

Line 1649: hxc_restore.log_data_mismatch( p_scope => 'Attributes ',

1645: write_data_mismatch('Attribute Usages ');
1646: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
1647: END IF;
1648:
1649: hxc_restore.log_data_mismatch( p_scope => 'Attributes ',
1650: p_insert => l_ta_count,
1651: p_delete => l_ta_del_count,
1652: p_mismatch => data_mismatch );
1653:

Line 1820: hxc_restore.log_data_mismatch( p_scope => 'App Detail LINKs ',

1816: WHERE scope = 'DETAIL'
1817: AND thread_id = p_thread_id );
1818: l_adl_del_count := SQL%ROWCOUNT;
1819:
1820: hxc_restore.log_data_mismatch( p_scope => 'App Detail LINKs ',
1821: p_insert => l_adl_count,
1822: p_delete => l_adl_del_count,
1823: p_mismatch => data_mismatch );
1824:

Line 2003: END hxc_restore;

1999:
2000:
2001:
2002:
2003: END hxc_restore;