APPS.HZ_MIXNM_REGISTRY_PUB dependencies on HZ_THIRDPARTY_RULE

Line 1109: FROM hz_thirdparty_rule

1105: i_rule_id INDEXIDList;
1106:
1107: CURSOR c_third_party_rule IS
1108: SELECT 'Y'
1109: FROM hz_thirdparty_rule
1110: WHERE ROWNUM = 1;
1111:
1112: l_dummy VARCHAR2(1);
1113: */

Line 1192: INSERT INTO hz_thirdparty_rule (

1188: END IF;
1189: CLOSE c_third_party_rule;
1190:
1191: IF l_dummy = 'Y' THEN
1192: INSERT INTO hz_thirdparty_rule (
1193: entity_attr_id,
1194: overwrite_flag,
1195: created_by,
1196: creation_date,

Line 1832: DELETE hz_thirdparty_rule

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;
1834:
1835: ELSE
1836: fnd_message.set_name('AR', 'HZ_API_CANNOT_DELETE_ENTITY');

Line 2115: DELETE hz_thirdparty_rule

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
2116: WHERE entity_attr_id = i_entity_attr_id(i);
2117:
2118: END LOOP;
2119: