APPS.HZ_POP_MRULE_SET_ATTR_V2PUB dependencies on HZ_MATCH_RULE_SECONDARY

Line 76: FROM HZ_MATCH_RULE_SECONDARY s1

72: )
73: )
74: );
75: CURSOR c_insert_sec IS ( SELECT s1.ATTRIBUTE_ID
76: FROM HZ_MATCH_RULE_SECONDARY s1
77: WHERE s1.match_rule_id in (Select unique condition_match_rule_id
78: from hz_match_rule_conditions
79: where match_rule_set_id = p_mrule_set_id)
80: AND NOT EXISTS(SELECT 1 FROM HZ_MATCH_RULE_SECONDARY s2

Line 80: AND NOT EXISTS(SELECT 1 FROM HZ_MATCH_RULE_SECONDARY s2

76: FROM HZ_MATCH_RULE_SECONDARY s1
77: WHERE s1.match_rule_id in (Select unique condition_match_rule_id
78: from hz_match_rule_conditions
79: where match_rule_set_id = p_mrule_set_id)
80: AND NOT EXISTS(SELECT 1 FROM HZ_MATCH_RULE_SECONDARY s2
81: WHERE s2.match_rule_id = p_mrule_set_id
82: AND s2.ATTRIBUTE_ID = s1.ATTRIBUTE_ID
83: )
84: );

Line 87: FROM HZ_MATCH_RULE_SECONDARY

83: )
84: );
85:
86: CURSOR c_delete_sec IS SELECT secondary_attribute_id
87: FROM HZ_MATCH_RULE_SECONDARY
88: WHERE match_rule_id = p_mrule_set_id
89: AND ATTRIBUTE_ID IN (SELECT unique s1.ATTRIBUTE_ID
90: FROM HZ_MATCH_RULE_SECONDARY s1
91: WHERE s1.match_rule_id = p_mrule_set_id

Line 90: FROM HZ_MATCH_RULE_SECONDARY s1

86: CURSOR c_delete_sec IS SELECT secondary_attribute_id
87: FROM HZ_MATCH_RULE_SECONDARY
88: WHERE match_rule_id = p_mrule_set_id
89: AND ATTRIBUTE_ID IN (SELECT unique s1.ATTRIBUTE_ID
90: FROM HZ_MATCH_RULE_SECONDARY s1
91: WHERE s1.match_rule_id = p_mrule_set_id
92: MINUS
93: SELECT unique s1.ATTRIBUTE_ID
94: FROM HZ_MATCH_RULE_SECONDARY s1

Line 94: FROM HZ_MATCH_RULE_SECONDARY s1

90: FROM HZ_MATCH_RULE_SECONDARY s1
91: WHERE s1.match_rule_id = p_mrule_set_id
92: MINUS
93: SELECT unique s1.ATTRIBUTE_ID
94: FROM HZ_MATCH_RULE_SECONDARY s1
95: WHERE s1.match_rule_id in (Select unique condition_match_rule_id
96: from hz_match_rule_conditions
97: where match_rule_set_id = p_mrule_set_id)
98: );

Line 158: HZ_MATCH_RULE_SECONDARY_PKG.INSERT_ROW(x_secondary_attribute_id, --px_SECONDARY_ATTRIBUTE_ID

154:
155: IF v_attr_id_list.COUNT >0 THEN
156: FOR i IN v_attr_id_list.FIRST..v_attr_id_list.LAST
157: LOOP
158: HZ_MATCH_RULE_SECONDARY_PKG.INSERT_ROW(x_secondary_attribute_id, --px_SECONDARY_ATTRIBUTE_ID
159: p_mrule_set_id, --p_MATCH_RULE_ID
160: v_attr_id_list(i), --p_ATTRIBUTE_ID
161: 0, --p_SCORE
162: NULL, --p_ACTIVE_FLAG

Line 182: DELETE FROM HZ_MATCH_RULE_SECONDARY

178: CLOSE c_delete_sec;
179:
180: IF v_attr_id_list.COUNT >0 THEN
181: FORALL i IN v_attr_id_list.FIRST..v_attr_id_list.LAST
182: DELETE FROM HZ_MATCH_RULE_SECONDARY
183: WHERE SECONDARY_ATTRIBUTE_ID = v_attr_id_list(i);
184: END IF;
185:
186: /* Update the secondary attributes display order */

Line 244: FROM HZ_MATCH_RULE_SECONDARY s1

240:
241:
242: CURSOR c_sec_attr IS
243: SELECT s1.ATTRIBUTE_ID,min(nvl(s1.display_order,l_g_miss_num)) display_order
244: FROM HZ_MATCH_RULE_SECONDARY s1
245: WHERE EXISTS (Select 1
246: from hz_match_rule_conditions cond1
247: where cond1.match_rule_set_id = p_mrule_set_id
248: and cond1.condition_match_rule_id = s1.match_rule_id

Line 261: UPDATE HZ_MATCH_RULE_SECONDARY

257: FETCH c_sec_attr BULK COLLECT INTO v_attr_id_list,v_attr_order_list;
258: CLOSE c_sec_attr;
259:
260: FORALL i IN v_attr_id_list.FIRST..v_attr_id_list.LAST
261: UPDATE HZ_MATCH_RULE_SECONDARY
262: SET DISPLAY_ORDER = decode(v_attr_order_list(i),l_g_miss_num,null,v_attr_order_list(i))
263: WHERE match_rule_id = p_mrule_set_id
264: AND attribute_id = v_attr_id_list(i);
265: