APPS.HZ_MIXNM_UTILITY dependencies on HZ_USER_OVERWRITE_RULES

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

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

Line 439: FROM hz_user_overwrite_rules

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

Line 953: FROM hz_user_overwrite_rules

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

Line 5453: from hz_user_overwrite_rules u, hz_orig_systems_vl v

5449: ) Return VARCHAR2 IS
5450:
5451: cursor overwrite_allowed is
5452: select v.orig_system_name
5453: from hz_user_overwrite_rules u, hz_orig_systems_vl v
5454: where u.entity_attr_id = p_entity_attr_id
5455: and u.orig_system = v.orig_system
5456: and u.overwrite_flag = 'Y'
5457: and u.rule_id = p_rule_id;