APPS.HZ_MIXNM_UTILITY dependencies on HZ_USER_OVERWRITE_RULES

Line 435: -- Now hz_user_overwrite_rules will store orig_system for overwrite_flag = 'Y'.

431: -- find out the attributes which can be overwrited by user
432: -- when they store third party data.
433:
434: -- SSM SST Integration and Extension
435: -- Now hz_user_overwrite_rules will store orig_system for overwrite_flag = 'Y'.
436: -- Select orig_system instead of overwrite_flag in cursor query.
437: CURSOR c_overwrite_third_party_rule (
438: p_rule_id NUMBER
439: ) IS

Line 442: FROM hz_user_overwrite_rules

438: p_rule_id NUMBER
439: ) IS
440: SELECT entity_attr_id,/* overwrite_flag*/
441: orig_system
442: FROM hz_user_overwrite_rules
443: WHERE rule_id = p_rule_id
444: AND overwrite_flag = 'Y'
445: ORDER BY entity_attr_id;
446:

Line 956: FROM hz_user_overwrite_rules

952: p_rule_id NUMBER
953: ) IS
954: SELECT entity_attr_id,
955: orig_system
956: FROM hz_user_overwrite_rules
957: WHERE overwrite_flag = 'Y'
958: AND rule_id = p_rule_id;
959:
960: -- SSM SST Integration and Extension

Line 5484: from hz_user_overwrite_rules u, hz_orig_systems_vl v

5480: ) Return VARCHAR2 IS
5481:
5482: cursor overwrite_allowed is
5483: select v.orig_system_name
5484: from hz_user_overwrite_rules u, hz_orig_systems_vl v
5485: where u.entity_attr_id = p_entity_attr_id
5486: and u.orig_system = v.orig_system
5487: and u.overwrite_flag = 'Y'
5488: and u.rule_id = p_rule_id;