APPS.HZ_MIXNM_WEBUI_UTILITY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 79

      SELECT attribute_group_name, entity_attr_id
      FROM hz_entity_attributes
      WHERE attribute_name IS NOT NULL
      AND entity_name = p_entity
      ORDER BY attribute_group_name;

Line: 162

	SELECT entity_name
	FROM hz_entity_attributes
	WHERE entity_attr_id = p_entity_attr_id;

Line: 421

      SELECT hz_ext_data_rules_tl_s.NEXTVAL
      INTO p_rule_id
      FROM DUAL;

Line: 425

      HZ_EXT_DATA_RULES_PKG.INSERT_ROW (
        p_rule_id, p_rule_type, p_rule_name );

Line: 434

        INSERT INTO hz_user_create_rules (
          rule_id,
          entity_attr_id,
          creation_flag,
          created_by,
          creation_date,
          last_update_login,
          last_update_date,
          last_updated_by
        ) VALUES (
          p_rule_id,
          p_entity_attr_id_tab(i),
          p_flag_tab(i),
          hz_utility_v2pub.created_by,
          SYSDATE,
          hz_utility_v2pub.last_update_login,
          SYSDATE,
          hz_utility_v2pub.last_updated_by
        );

Line: 470

        INSERT INTO hz_user_overwrite_rules (
          rule_id,
          entity_attr_id,
          overwrite_flag,
          created_by,
          creation_date,
          last_update_login,
          last_update_date,
          last_updated_by,
	  orig_system
        ) VALUES (
          p_rule_id,
          l_entity_attr_id_tab(i),
          l_flag_tab(i),
          hz_utility_v2pub.created_by,
          SYSDATE,
          hz_utility_v2pub.last_update_login,
          SYSDATE,
          hz_utility_v2pub.last_updated_by,
	  l_os_tab(i)
        );

Line: 497

 * PROCEDURE Update_Rule
 *
 * DESCRIPTION
 *    Update an user creation / overwrite rule.
 *
 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
 *
 * ARGUMENTS
 *   IN:
 *     p_rule_type                  Rule type. 'USER_CREATE_RULE' is for user create rule.
 *                                  'USER_OVERWRITE_RULE is for user overwrite rule.
 *     p_rule_id                    Rule id.
 *     p_rule_name                  Rule name.
 *     p_entity_attr_id_tab         Entity / attribute id list.
 *     p_attribute_group_name_tab   A list of attribute group name.
 *     p_flag_tab                   A list of creation / overwrite flags for each
 *                                  entity / attribute.
 *
 * NOTES
 *
 * MODIFICATION HISTORY
 *
 *   03-01-2002    Jianying Huang   o Created.
 */

PROCEDURE Update_Rule (
    p_rule_type                        IN     VARCHAR2,
    p_rule_id                          IN     NUMBER,
    p_rule_name                        IN     VARCHAR2,
    p_entity_attr_id_tab               IN     IDList,
    p_attribute_group_name_tab         IN     VARCHARList,
    p_flag_tab                         IN     VARCHARList,
    p_os_tab                         IN     VARCHARList
) IS

    l_entity_attr_id_tab               IDList;

Line: 541

      HZ_EXT_DATA_RULES_PKG.UPDATE_ROW (
        p_rule_id, p_rule_name );

Line: 550

        UPDATE hz_user_create_rules
        SET creation_flag = p_flag_tab(i),
            last_update_login = hz_utility_v2pub.last_update_login,
            last_update_date = SYSDATE,
            last_updated_by = hz_utility_v2pub.last_updated_by
        WHERE rule_id = p_rule_id
	AND creation_flag <> p_flag_tab(i)
        AND entity_attr_id = p_entity_attr_id_tab(i);

Line: 575

            DELETE hz_user_overwrite_rules
            WHERE entity_attr_id = l_entity_attr_id_tab(i)
            AND orig_system = l_os_tab(i)
            AND rule_id = p_rule_id;

Line: 580

	    UPDATE hz_user_overwrite_rules
	    SET last_update_date = SYSDATE
            WHERE entity_attr_id = l_entity_attr_id_tab(i)
            AND rule_id = p_rule_id
	    AND ROWNUM = 1;

Line: 587

          INSERT INTO hz_user_overwrite_rules (
          rule_id,
          entity_attr_id,
          overwrite_flag,
          created_by,
          creation_date,
          last_update_login,
          last_update_date,
          last_updated_by,
          orig_system
        ) VALUES (
          p_rule_id,
          l_entity_attr_id_tab(i),
          l_flag_tab(i),
          hz_utility_v2pub.created_by,
          SYSDATE,
          hz_utility_v2pub.last_update_login,
          SYSDATE,
          hz_utility_v2pub.last_updated_by,
          l_os_tab(i)
        );

Line: 612

        UPDATE hz_user_overwrite_rules
        SET overwrite_flag = l_flag_tab(i),
            last_update_login = hz_utility_v2pub.last_update_login,
            last_update_date = SYSDATE,
            last_updated_by = hz_utility_v2pub.last_updated_by
        WHERE rule_id = p_rule_id
        AND entity_attr_id = l_entity_attr_id_tab(i);

Line: 622

END Update_Rule;

Line: 658

    SELECT hz_ext_data_rules_tl_s.NEXTVAL
    INTO x_new_rule_id
    FROM DUAL;

Line: 662

    HZ_EXT_DATA_RULES_PKG.INSERT_ROW (
      x_new_rule_id, p_rule_type, p_rule_name );

Line: 669

      INSERT INTO hz_user_create_rules (
        rule_id,
        entity_attr_id,
        creation_flag,
        created_by,
        creation_date,
        last_update_login,
        last_update_date,
        last_updated_by
      )
      SELECT
        x_new_rule_id,
        entity_attr_id,
        creation_flag,
        hz_utility_v2pub.created_by,
        SYSDATE,
        hz_utility_v2pub.last_update_login,
        SYSDATE,
        hz_utility_v2pub.last_updated_by
      FROM hz_user_create_rules
      WHERE rule_id = p_rule_id;

Line: 691

      INSERT INTO hz_user_overwrite_rules (
        rule_id,
        entity_attr_id,
        overwrite_flag,
        created_by,
        creation_date,
        last_update_login,
        last_update_date,
        last_updated_by,
        orig_system
      )
      SELECT
        x_new_rule_id,
        entity_attr_id,
        overwrite_flag,
        hz_utility_v2pub.created_by,
        SYSDATE,
        hz_utility_v2pub.last_update_login,
        SYSDATE,
        hz_utility_v2pub.last_updated_by,
        orig_system
      FROM hz_user_overwrite_rules
      WHERE rule_id = p_rule_id;

Line: 720

      INSERT INTO hz_user_overwrite_rules (
        rule_id,
        entity_attr_id,
        overwrite_flag,
        created_by,
        creation_date,
        last_update_login,
        last_update_date,
        last_updated_by,
	orig_system
      )
      SELECT
        x_new_rule_id,
        entity_attr_id,
        overwrite_flag,
        hz_utility_v2pub.created_by,
        SYSDATE,
        hz_utility_v2pub.last_update_login,
        SYSDATE,
        hz_utility_v2pub.last_updated_by,
	orig_system
      FROM hz_user_overwrite_rules
      WHERE rule_id = p_rule_id;

Line: 749

 * PROCEDURE Delete_Rule
 *
 * DESCRIPTION
 *    Delete an user creation / overwrite rule.
 *
 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
 *
 * ARGUMENTS
 *   IN:
 *     p_rule_type                  Rule type. 'USER_CREATE_RULE' is for user create rule.
 *                                  'USER_OVERWRITE_RULE is for user overwrite rule.
 *     p_rule_id                    Rule id.
 *
 * NOTES
 *
 * MODIFICATION HISTORY
 *
 *   03-01-2002    Jianying Huang   o Created.
 */

PROCEDURE Delete_Rule (
    p_rule_type                        IN     VARCHAR2,
    p_rule_id                          IN     NUMBER
) IS

    l_profile_option_name              VARCHAR(300);

Line: 780

      DELETE hz_user_create_rules
      WHERE rule_id = p_rule_id;

Line: 783

      DELETE hz_user_overwrite_rules
      WHERE rule_id = p_rule_id;

Line: 790

      DELETE hz_user_overwrite_rules
      WHERE rule_id = p_rule_id;

Line: 797

    DELETE fnd_profile_option_values
    WHERE profile_option_id = (
      SELECT profile_option_id
      FROM fnd_profile_options
      WHERE profile_option_name = l_profile_option_name )
    AND profile_option_value = to_char(p_rule_id);

Line: 806

    HZ_EXT_DATA_RULES_PKG.DELETE_ROW(p_rule_id);

Line: 808

END Delete_Rule;

Line: 811

 * PROCEDURE Update_ThirdPartyRule
 *
 * DESCRIPTION
 *    Update the third party rule.
 *
 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
 *
 * ARGUMENTS
 *   IN:
 *     p_rule_exists                'Y'/'N' indicator to indicate if the rule
 *                                  for certain profile exists.
 *     p_entity_attr_id_tab         Entity / attribute id list.
 *     p_attribute_group_name_tab   A list of attribute group name.
 *     p_flag_tab                   A list of overwrite flags for each attribute.
 *
 * NOTES
 *
 * MODIFICATION HISTORY
 *
 *   03-01-2002    Jianying Huang   o Created.
 */

PROCEDURE Update_ThirdPartyRule (
    p_rule_exists                      IN     VARCHAR2,
    p_entity_attr_id_tab               IN     IDList,
    p_attribute_group_name_tab         IN     VARCHARList,
    p_flag_tab                         IN     VARCHARList,
    p_os_tab                         IN     VARCHARList
) IS

    l_entity_attr_id_tab               IDList;

Line: 862

        INSERT INTO hz_thirdparty_rule (
          entity_attr_id,
          overwrite_flag,
          created_by,
          creation_date,
          last_update_login,
          last_update_date,
          last_updated_by,
	  orig_system
        )
        VALUES (
          l_entity_attr_id_tab(i),
          l_flag_tab(i),
          hz_utility_v2pub.created_by,
          SYSDATE,
          hz_utility_v2pub.last_update_login,
          SYSDATE,
          hz_utility_v2pub.last_updated_by,
	  l_os_tab(i)
        );

Line: 888

	    DELETE hz_thirdparty_rule
	    WHERE entity_attr_id = l_entity_attr_id_tab(i)
	    AND orig_system = l_os_tab(i);

Line: 892

	 INSERT INTO hz_thirdparty_rule (
          entity_attr_id,
          overwrite_flag,
          created_by,
          creation_date,
          last_update_login,
          last_update_date,
          last_updated_by,
          orig_system
        )
        VALUES (
          l_entity_attr_id_tab(i),
          l_flag_tab(i),
          hz_utility_v2pub.created_by,
          SYSDATE,
          hz_utility_v2pub.last_update_login,
          SYSDATE,
          hz_utility_v2pub.last_updated_by,
          l_os_tab(i)
        );

Line: 915

        UPDATE hz_thirdparty_rule
        SET overwrite_flag = l_flag_tab(i),
            last_update_login = hz_utility_v2pub.last_update_login,
            last_update_date = SYSDATE,
            last_updated_by = hz_utility_v2pub.last_updated_by
        WHERE entity_attr_id = l_entity_attr_id_tab(i);

Line: 924

END Update_ThirdPartyRule;

Line: 982

          UPDATE hz_select_data_sources
          SET ranking = p_ranking_tab(k),
              last_update_login = hz_utility_v2pub.last_update_login,
              last_update_date = SYSDATE,
              last_updated_by = hz_utility_v2pub.last_updated_by
          WHERE entity_attr_id = l_entity_attr_id_tab(j)
          AND content_source_type = p_data_sources_tab(k);

Line: 993

        UPDATE hz_entity_attributes
        SET updated_flag = 'Y',
            last_update_login = hz_utility_v2pub.last_update_login,
            last_update_date = SYSDATE,
            last_updated_by = hz_utility_v2pub.last_updated_by
        WHERE entity_attr_id = l_entity_attr_id_tab(j);

Line: 1003

      l_entity_attr_id_tab.DELETE;

Line: 1045

      SELECT s.content_source_type, s.ranking,
               o.orig_system_name meaning
      FROM hz_select_data_sources s, hz_orig_systems_vl o
      WHERE s.entity_attr_id = p_entity_attr_id
	and o.orig_system = s.content_source_type
      ORDER BY ranking;

Line: 1077

          l_sql := 'SELECT ''Y'' '||
                   'FROM ( '||
                   '  SELECT COUNT(*) total '||
                   '  FROM hz_select_data_sources '||
                   '  WHERE entity_attr_id IN ('||str||') '||
                   '  GROUP BY content_source_type';

Line: 1115

          l_sql := 'SELECT UNIQUE content_source_type,  '||
                   '       hz_utility_v2pub.Get_LookupMeaning( '||
                   '        ''AR_LOOKUPS'', ''CONTENT_SOURCE_TYPE'', '||
                   '        content_source_type ) meaning '||
                   'FROM hz_select_data_sources '||
                   'WHERE entity_attr_id IN ('||str||') ';

Line: 1215

        UPDATE hz_select_data_sources
        SET ranking = p_ranking_tab(j),
            last_update_login = hz_utility_v2pub.last_update_login,
            last_update_date = SYSDATE,
            last_updated_by = hz_utility_v2pub.last_updated_by
        WHERE entity_attr_id = l_entity_attr_id_tab(i)
        AND content_source_type = p_data_sources_tab(j);

Line: 1225

      UPDATE hz_entity_attributes
      SET updated_flag = 'Y',
          last_update_login = hz_utility_v2pub.last_update_login,
          last_update_date = SYSDATE,
          last_updated_by = hz_utility_v2pub.last_updated_by
      WHERE entity_attr_id = l_entity_attr_id_tab(i);