APPS.HZ_POP_MRULE_SET_ATTR_V2PUB dependencies on HZ_MATCH_RULE_PRIMARY

Line 37: FROM HZ_MATCH_RULE_PRIMARY p1

33: PROCEDURE pop_mrule_set_attributes(p_mrule_set_id IN NUMBER)
34: IS
35: CURSOR c_insert_prim IS ( SELECT p.ATTRIBUTE_ID FROM
36: (SELECT unique p1.ATTRIBUTE_ID
37: FROM HZ_MATCH_RULE_PRIMARY p1
38: WHERE p1.match_rule_id in (Select unique condition_match_rule_id
39: from hz_match_rule_conditions
40: where match_rule_set_id = p_mrule_set_id)
41: UNION

Line 50: FROM HZ_MATCH_RULE_PRIMARY p1

46: )
47: ) p
48: WHERE NOT EXISTS (
49: SELECT 1
50: FROM HZ_MATCH_RULE_PRIMARY p1
51: WHERE p1.match_rule_id = p_mrule_set_id
52: AND p1.ATTRIBUTE_ID = p.ATTRIBUTE_ID
53: )
54: );

Line 56: FROM HZ_MATCH_RULE_PRIMARY

52: AND p1.ATTRIBUTE_ID = p.ATTRIBUTE_ID
53: )
54: );
55: CURSOR c_delete_prim IS SELECT primary_attribute_id
56: FROM HZ_MATCH_RULE_PRIMARY
57: WHERE match_rule_id = p_mrule_set_id
58: AND ATTRIBUTE_ID IN (SELECT unique p1.ATTRIBUTE_ID
59: FROM HZ_MATCH_RULE_PRIMARY p1
60: WHERE p1.match_rule_id = p_mrule_set_id

Line 59: FROM HZ_MATCH_RULE_PRIMARY p1

55: CURSOR c_delete_prim IS SELECT primary_attribute_id
56: FROM HZ_MATCH_RULE_PRIMARY
57: WHERE match_rule_id = p_mrule_set_id
58: AND ATTRIBUTE_ID IN (SELECT unique p1.ATTRIBUTE_ID
59: FROM HZ_MATCH_RULE_PRIMARY p1
60: WHERE p1.match_rule_id = p_mrule_set_id
61: MINUS
62: (SELECT unique p1.ATTRIBUTE_ID
63: FROM HZ_MATCH_RULE_PRIMARY p1

Line 63: FROM HZ_MATCH_RULE_PRIMARY p1

59: FROM HZ_MATCH_RULE_PRIMARY p1
60: WHERE p1.match_rule_id = p_mrule_set_id
61: MINUS
62: (SELECT unique p1.ATTRIBUTE_ID
63: FROM HZ_MATCH_RULE_PRIMARY p1
64: WHERE p1.match_rule_id in (Select unique condition_match_rule_id
65: from hz_match_rule_conditions
66: where match_rule_set_id = p_mrule_set_id)
67: UNION

Line 119: HZ_MATCH_RULE_PRIMARY_PKG.INSERT_ROW(x_primary_attribute_id, --px_PRIMARY_ATTRIBUTE_ID

115:
116: IF v_attr_id_list.COUNT >0 THEN
117: FOR i IN v_attr_id_list.FIRST..v_attr_id_list.LAST
118: LOOP
119: HZ_MATCH_RULE_PRIMARY_PKG.INSERT_ROW(x_primary_attribute_id, --px_PRIMARY_ATTRIBUTE_ID
120: p_mrule_set_id, --p_MATCH_RULE_ID
121: v_attr_id_list(i), --p_ATTRIBUTE_ID
122: NULL, --p_ACTIVE_FLAG
123: NULL, --p_FILTER_FLAG

Line 143: DELETE FROM HZ_MATCH_RULE_PRIMARY

139: CLOSE c_delete_prim;
140:
141: IF v_attr_id_list.COUNT >0 THEN
142: FORALL i IN v_attr_id_list.FIRST..v_attr_id_list.LAST
143: DELETE FROM HZ_MATCH_RULE_PRIMARY
144: WHERE PRIMARY_ATTRIBUTE_ID = v_attr_id_list(i);
145: END IF;
146: /* Update the primary attributes display order */
147: update_prim_display_order(p_mrule_set_id);

Line 206: FROM HZ_MATCH_RULE_PRIMARY p1

202: where match_rule_set_id = p_mrule_set_id
203: and attribute_id is not null
204: UNION
205: SELECT p1.ATTRIBUTE_ID,min(nvl(p1.display_order,l_g_miss_num)) display_order
206: FROM HZ_MATCH_RULE_PRIMARY p1
207: WHERE EXISTS (Select 1
208: from hz_match_rule_conditions cond1
209: where cond1.match_rule_set_id = p_mrule_set_id
210: and cond1.condition_match_rule_id = p1.match_rule_id

Line 226: UPDATE HZ_MATCH_RULE_PRIMARY

222: OPEN c_prim_attr;
223: FETCH c_prim_attr BULK COLLECT INTO v_attr_id_list,v_attr_order_list;
224: CLOSE c_prim_attr;
225: FORALL i IN v_attr_id_list.FIRST..v_attr_id_list.LAST
226: UPDATE HZ_MATCH_RULE_PRIMARY
227: SET DISPLAY_ORDER = decode(v_attr_order_list(i),l_g_miss_num,null,v_attr_order_list(i))
228: WHERE match_rule_id = p_mrule_set_id
229: AND attribute_id = v_attr_id_list(i);
230: