46:
47: IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
48: THEN
49:
50: hxc_retrieval_rules_api.update_retrieval_rules (
51: p_effective_date => sysdate
52: , p_retrieval_rule_id => l_retrieval_rule_id
53: , p_retrieval_process_id => l_retrieval_process_id
54: , p_name => p_name
58:
59: EXCEPTION WHEN NO_DATA_FOUND
60: THEN
61:
62: hxc_retrieval_rules_api.create_retrieval_rules (
63: p_effective_date => sysdate
64: , p_name => p_name
65: , p_retrieval_rule_id => l_retrieval_rule_id
66: , p_retrieval_process_id => l_retrieval_process_id