APPS.HZ_MIXNM_REGISTRY_PUB dependencies on HZ_USER_OVERWRITE_RULES

Line 1103: FROM hz_user_overwrite_rules;

1099: ) IS
1100: /*
1101: CURSOR c_user_overwrite_rule IS
1102: SELECT UNIQUE rule_id
1103: FROM hz_user_overwrite_rules;
1104:
1105: i_rule_id INDEXIDList;
1106:
1107: CURSOR c_third_party_rule IS

Line 1163: INSERT INTO hz_user_overwrite_rules (

1159: FETCH c_user_overwrite_rule BULK COLLECT INTO i_rule_id;
1160: CLOSE c_user_overwrite_rule;
1161:
1162: FORALL i IN 1..i_rule_id.COUNT
1163: INSERT INTO hz_user_overwrite_rules (
1164: rule_id,
1165: entity_attr_id,
1166: overwrite_flag,
1167: created_by,

Line 1829: DELETE hz_user_overwrite_rules

1825: DELETE hz_entity_attributes
1826: WHERE entity_attr_id = l_entity_attr_id;
1827:
1828: -- delete corresponding rules
1829: DELETE hz_user_overwrite_rules
1830: WHERE entity_attr_id = l_entity_attr_id;
1831:
1832: DELETE hz_thirdparty_rule
1833: WHERE entity_attr_id = l_entity_attr_id;

Line 2111: DELETE hz_user_overwrite_rules

2107: RETURNING entity_attr_id BULK COLLECT INTO i_entity_attr_id;
2108:
2109: -- delete corresponding rules
2110: FORALL i IN 1..i_entity_attr_id.COUNT
2111: DELETE hz_user_overwrite_rules
2112: WHERE entity_attr_id = i_entity_attr_id(i);
2113:
2114: FORALL i IN 1..i_entity_attr_id.COUNT
2115: DELETE hz_thirdparty_rule