APPS.HZ_MIXNM_REGISTRY_PUB dependencies on HZ_THIRDPARTY_RULE

Line 1131: FROM hz_thirdparty_rule

1127: i_rule_id INDEXIDList;
1128:
1129: CURSOR c_third_party_rule IS
1130: SELECT 'Y'
1131: FROM hz_thirdparty_rule
1132: WHERE ROWNUM = 1;
1133:
1134: l_dummy VARCHAR2(1);
1135: */

Line 1214: INSERT INTO hz_thirdparty_rule (

1210: END IF;
1211: CLOSE c_third_party_rule;
1212:
1213: IF l_dummy = 'Y' THEN
1214: INSERT INTO hz_thirdparty_rule (
1215: entity_attr_id,
1216: overwrite_flag,
1217: created_by,
1218: creation_date,

Line 1854: DELETE hz_thirdparty_rule

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;
1856:
1857: ELSE
1858: fnd_message.set_name('AR', 'HZ_API_CANNOT_DELETE_ENTITY');

Line 2137: DELETE hz_thirdparty_rule

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
2138: WHERE entity_attr_id = i_entity_attr_id(i);
2139:
2140: END LOOP;
2141: