APPS.HZ_MATCH_RULE_51 dependencies on HZ_SRCH_CONTACTS

Line 4124: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;

4120: END IF;
4121: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4122: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4123: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4124: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4125: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4126: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4127: hz_utility_v2pub.debug(p_message=>'get_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4128: END IF;

Line 4134: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;

4130: WHEN FND_API.G_EXC_ERROR THEN
4131: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4132: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4133: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4134: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4135: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4136: RAISE FND_API.G_EXC_ERROR;
4137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4138: --------------- DELETE FROM ALL SRCH TABLES ---------------------

Line 4141: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;

4137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4138: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4139: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4140: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4141: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4142: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4144: WHEN OTHERS THEN
4145: --------------- DELETE FROM ALL SRCH TABLES ---------------------

Line 4148: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;

4144: WHEN OTHERS THEN
4145: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4146: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4147: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4148: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4149: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_score_details');
4152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );