APPS.HZ_MIXNM_WEBUI_UTILITY dependencies on HZ_USER_CREATE_RULES

Line 434: INSERT INTO hz_user_create_rules (

430:
431: -- create user create rule.
432:
433: FORALL i IN 1..p_entity_attr_id_tab.COUNT
434: INSERT INTO hz_user_create_rules (
435: rule_id,
436: entity_attr_id,
437: creation_flag,
438: created_by,

Line 550: UPDATE hz_user_create_rules

546:
547: -- update user create rule.
548:
549: FORALL i IN 1..p_entity_attr_id_tab.COUNT
550: UPDATE hz_user_create_rules
551: SET creation_flag = p_flag_tab(i),
552: last_update_login = hz_utility_v2pub.last_update_login,
553: last_update_date = SYSDATE,
554: last_updated_by = hz_utility_v2pub.last_updated_by

Line 669: INSERT INTO hz_user_create_rules (

665: IF p_rule_type = G_USER_CREATE_RULE_TYPE THEN
666:
667: -- copy user create rule.
668:
669: INSERT INTO hz_user_create_rules (
670: rule_id,
671: entity_attr_id,
672: creation_flag,
673: created_by,

Line 688: FROM hz_user_create_rules

684: SYSDATE,
685: hz_utility_v2pub.last_update_login,
686: SYSDATE,
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,

Line 780: DELETE hz_user_create_rules

776: BEGIN
777:
778: IF p_rule_type = G_USER_CREATE_RULE_TYPE THEN
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;