APPS.HZ_DQM_DUP_ID_PKG dependencies on HZ_MATCH_RULES_B

Line 2223: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'C' WHERE MATCH_RULE_ID = p_match_rule_id;

2219: p_encoded => FND_API.G_FALSE,
2220: p_count => x_msg_count,
2221: p_data => x_msg_data);
2222:
2223: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'C' WHERE MATCH_RULE_ID = p_match_rule_id;
2224: COMMIT;
2225: EXCEPTION
2226: WHEN FND_API.G_EXC_ERROR THEN
2227: FND_MSG_PUB.Count_And_Get(

Line 2232: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;

2228: p_encoded => FND_API.G_FALSE,
2229: p_count => x_msg_count,
2230: p_data => x_msg_data);
2231: x_return_status := FND_API.G_RET_STS_ERROR;
2232: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;
2233: COMMIT;
2234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2235: FND_MSG_PUB.Count_And_Get(
2236: p_encoded => FND_API.G_FALSE,

Line 2240: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;

2236: p_encoded => FND_API.G_FALSE,
2237: p_count => x_msg_count,
2238: p_data => x_msg_data);
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2240: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;
2241: COMMIT;
2242: WHEN OTHERS THEN
2243:
2244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2254: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;

2250: p_encoded => FND_API.G_FALSE,
2251: p_count => x_msg_count,
2252: p_data => x_msg_data);
2253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2254: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;
2255: COMMIT;
2256: END;
2257:
2258: