372: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_CONTEXTS',NULL);
373: DELETE hr_s_contexts;
374: COMMIT;
375:
376: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTE_PARAMETERS',NULL);
377: DELETE hr_s_route_parameters;
378: COMMIT;
379:
380: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_USER_ENTITIES',NULL);
373: DELETE hr_s_contexts;
374: COMMIT;
375:
376: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTE_PARAMETERS',NULL);
377: DELETE hr_s_route_parameters;
378: COMMIT;
379:
380: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_USER_ENTITIES',NULL);
381: DELETE hr_s_user_entities;
1053:
1054: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',60);
1055: -- Route Parameters
1056: write_log('LOG',NULL,NULL,NULL);
1057: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Route Parameters', 'HR_S_ROUTE_PARAMETERS');
1058: INSERT INTO hr_s_route_parameters
1059: (SELECT
1060: route_parameter_id
1061: ,route_id
1054: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',60);
1055: -- Route Parameters
1056: write_log('LOG',NULL,NULL,NULL);
1057: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Route Parameters', 'HR_S_ROUTE_PARAMETERS');
1058: INSERT INTO hr_s_route_parameters
1059: (SELECT
1060: route_parameter_id
1061: ,route_id
1062: ,data_type