APPS.HZ_MIXNM_REGISTRY_PUB dependencies on HZ_USER_OVERWRITE_RULES

Line 1125: FROM hz_user_overwrite_rules;

1121: ) IS
1122: /*
1123: CURSOR c_user_overwrite_rule IS
1124: SELECT UNIQUE rule_id
1125: FROM hz_user_overwrite_rules;
1126:
1127: i_rule_id INDEXIDList;
1128:
1129: CURSOR c_third_party_rule IS

Line 1185: INSERT INTO hz_user_overwrite_rules (

1181: FETCH c_user_overwrite_rule BULK COLLECT INTO i_rule_id;
1182: CLOSE c_user_overwrite_rule;
1183:
1184: FORALL i IN 1..i_rule_id.COUNT
1185: INSERT INTO hz_user_overwrite_rules (
1186: rule_id,
1187: entity_attr_id,
1188: overwrite_flag,
1189: created_by,

Line 1851: DELETE hz_user_overwrite_rules

1847: DELETE hz_entity_attributes
1848: WHERE entity_attr_id = l_entity_attr_id;
1849:
1850: -- delete corresponding rules
1851: DELETE hz_user_overwrite_rules
1852: WHERE entity_attr_id = l_entity_attr_id;
1853:
1854: DELETE hz_thirdparty_rule
1855: WHERE entity_attr_id = l_entity_attr_id;

Line 2133: DELETE hz_user_overwrite_rules

2129: RETURNING entity_attr_id BULK COLLECT INTO i_entity_attr_id;
2130:
2131: -- delete corresponding rules
2132: FORALL i IN 1..i_entity_attr_id.COUNT
2133: DELETE hz_user_overwrite_rules
2134: WHERE entity_attr_id = i_entity_attr_id(i);
2135:
2136: FORALL i IN 1..i_entity_attr_id.COUNT
2137: DELETE hz_thirdparty_rule