DBA Data[Home] [Help]

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.0.12010000.8 2008/10/08 17:03:01 asrajago ship $ */
3: ----------------------------------------------------------------------------
4: -- Procedure Name : restore_process
5: -- Description : This procedure is called durINg Restore Data Set process.

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

674:
675:
676: l_tc_del_count := sql%rowcount;
677:
678: hxc_restore.log_data_mismatch(p_scope => 'Timecard',
679: p_insert => l_tc_count,
680: p_delete => l_tc_del_count,
681: p_mismatch => data_mismatch
682: );

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

740: AND thread_id = p_thread_id );
741:
742: l_tal_del_count := SQL%ROWCOUNT;
743:
744: hxc_restore.log_data_mismatch(p_scope => 'TC App LINKs ',
745: p_insert => l_tal_count,
746: p_delete => l_tal_del_count,
747: p_mismatch => data_mismatch );
748:

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

788: AND data_set_id = p_data_set_id ;
789:
790: l_app_del_count := SQL%ROWCOUNT;
791:
792: hxc_restore.log_data_mismatch( p_scope => 'Application Period ',
793: p_insert => l_app_period_count,
794: p_delete => l_app_del_count,
795: p_mismatch => data_mismatch );
796:

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

829: AND data_set_id = p_data_set_id ;
830:
831: l_app_sum_del_count := SQL%ROWCOUNT;
832:
833: hxc_restore.log_data_mismatch( p_scope => 'App Period Summary ',
834: p_insert => l_app_period_sum_count,
835: p_delete => l_app_sum_del_count,
836: p_mismatch => data_mismatch );
837:

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

910:
911: END LOOP;
912: CLOSE get_tbb_rowid;
913:
914: hxc_restore.log_data_mismatch( p_scope => 'Day ',
915: p_insert => l_day_count,
916: p_delete => l_day_del_count,
917: p_mismatch => data_mismatch );
918:

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

989: rowid_tab.DELETE;
990: END LOOP;
991: CLOSE get_tbb_rowid;
992:
993: hxc_restore.log_data_mismatch( p_scope => 'Detail ',
994: p_insert => l_det_count,
995: p_delete => l_det_del_count,
996: p_mismatch => data_mismatch );
997:

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

1135: END LOOP;
1136:
1137: CLOSE get_transactions;
1138:
1139: hxc_restore.log_data_mismatch( p_scope => 'Transaction Detail ',
1140: p_insert => l_td_count,
1141: p_delete => l_td_del_count,
1142: p_mismatch => data_mismatch );
1143:

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

1146: write_data_mismatch('Transaction Detail ');
1147: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
1148: END IF;
1149:
1150: hxc_restore.log_data_mismatch( p_scope => 'Transaction ',
1151: p_insert => l_trans_count,
1152: p_delete => l_trans_del_count,
1153: p_mismatch => data_mismatch );
1154:

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

1265:
1266: END LOOP ;
1267: CLOSE get_attributes;
1268:
1269: hxc_restore.log_data_mismatch( p_scope => 'Attribute Usages ',
1270: p_insert => l_tau_count,
1271: p_delete => l_tau_del_count,
1272: p_mismatch => data_mismatch );
1273:

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

1276: write_data_mismatch('Attribute Usages ');
1277: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
1278: END IF;
1279:
1280: hxc_restore.log_data_mismatch( p_scope => 'Attributes ',
1281: p_insert => l_ta_count,
1282: p_delete => l_ta_del_count,
1283: p_mismatch => data_mismatch );
1284:

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

1317: WHERE scope = 'DETAIL'
1318: AND thread_id = p_thread_id );
1319: l_adl_del_count := SQL%ROWCOUNT;
1320:
1321: hxc_restore.log_data_mismatch( p_scope => 'App Detail LINKs ',
1322: p_insert => l_adl_count,
1323: p_delete => l_adl_del_count,
1324: p_mismatch => data_mismatch );
1325:

Line 1482: END hxc_restore;

1478:
1479:
1480:
1481:
1482: END hxc_restore;