APPS.HZ_MIXNM_WEBUI_UTILITY dependencies on HZ_USER_OVERWRITE_RULES

Line 470: INSERT INTO hz_user_overwrite_rules (

466:
467: -- create user overwrite rule.
468:
469: FORALL i IN 1..l_entity_attr_id_tab.COUNT
470: INSERT INTO hz_user_overwrite_rules (
471: rule_id,
472: entity_attr_id,
473: overwrite_flag,
474: created_by,

Line 575: DELETE hz_user_overwrite_rules

571: -- update user overwrite rule.
572:
573: FOR i IN 1..l_entity_attr_id_tab.COUNT LOOP
574: IF l_flag_tab(i) = 'N' THEN
575: DELETE hz_user_overwrite_rules
576: WHERE entity_attr_id = l_entity_attr_id_tab(i)
577: AND orig_system = l_os_tab(i)
578: AND rule_id = p_rule_id;
579:

Line 580: UPDATE hz_user_overwrite_rules

576: WHERE entity_attr_id = l_entity_attr_id_tab(i)
577: AND orig_system = l_os_tab(i)
578: AND rule_id = p_rule_id;
579:
580: UPDATE hz_user_overwrite_rules
581: SET last_update_date = SYSDATE
582: WHERE entity_attr_id = l_entity_attr_id_tab(i)
583: AND rule_id = p_rule_id
584: AND ROWNUM = 1;

Line 587: INSERT INTO hz_user_overwrite_rules (

583: AND rule_id = p_rule_id
584: AND ROWNUM = 1;
585:
586: ELSIF l_flag_tab(i) = 'Y' THEN
587: INSERT INTO hz_user_overwrite_rules (
588: rule_id,
589: entity_attr_id,
590: overwrite_flag,
591: created_by,

Line 612: UPDATE hz_user_overwrite_rules

608: END IF;
609: END LOOP;
610: /*
611: FORALL i IN 1..l_entity_attr_id_tab.COUNT
612: UPDATE hz_user_overwrite_rules
613: SET overwrite_flag = l_flag_tab(i),
614: last_update_login = hz_utility_v2pub.last_update_login,
615: last_update_date = SYSDATE,
616: last_updated_by = hz_utility_v2pub.last_updated_by

Line 691: INSERT INTO hz_user_overwrite_rules (

687: hz_utility_v2pub.last_updated_by
688: FROM hz_user_create_rules
689: WHERE rule_id = p_rule_id;
690:
691: INSERT INTO hz_user_overwrite_rules (
692: rule_id,
693: entity_attr_id,
694: overwrite_flag,
695: created_by,

Line 712: FROM hz_user_overwrite_rules

708: hz_utility_v2pub.last_update_login,
709: SYSDATE,
710: hz_utility_v2pub.last_updated_by,
711: orig_system
712: FROM hz_user_overwrite_rules
713: WHERE rule_id = p_rule_id;
714:
715:
716: ELSIF p_rule_type = G_USER_OVERWRITE_RULE_TYPE THEN

Line 720: INSERT INTO hz_user_overwrite_rules (

716: ELSIF p_rule_type = G_USER_OVERWRITE_RULE_TYPE THEN
717:
718: -- copy user overwrite rule.
719:
720: INSERT INTO hz_user_overwrite_rules (
721: rule_id,
722: entity_attr_id,
723: overwrite_flag,
724: created_by,

Line 741: FROM hz_user_overwrite_rules

737: hz_utility_v2pub.last_update_login,
738: SYSDATE,
739: hz_utility_v2pub.last_updated_by,
740: orig_system
741: FROM hz_user_overwrite_rules
742: WHERE rule_id = p_rule_id;
743:
744: END IF;
745:

Line 783: DELETE hz_user_overwrite_rules

779:
780: DELETE hz_user_create_rules
781: WHERE rule_id = p_rule_id;
782:
783: DELETE hz_user_overwrite_rules
784: WHERE rule_id = p_rule_id;
785:
786: l_profile_option_name := 'HZ_USER_DATA_CREATION_RULE';
787:

Line 790: DELETE hz_user_overwrite_rules

786: l_profile_option_name := 'HZ_USER_DATA_CREATION_RULE';
787:
788: ELSIF p_rule_type = G_USER_OVERWRITE_RULE_TYPE THEN
789:
790: DELETE hz_user_overwrite_rules
791: WHERE rule_id = p_rule_id;
792:
793: l_profile_option_name := 'HZ_USER_OVERWRITE_RULE';
794: