APPS.HZ_SEED_CLASS_CAT_PKG SQL Statements

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

Line: 12

      SELECT 'Y'
        FROM sys.all_tab_columns
       WHERE table_name = 'HZ_CLASS_CATEGORIES'
         AND column_name = 'ALLOW_LEAF_NODE_ONLY_FLAG'
         AND owner = l_schema;

Line: 19

  select 'Y'
  from
    user_synonyms syn
  , dba_tab_columns col
  where syn.synonym_name = 'HZ_CLASS_CATEGORIES'
  and col.owner      = syn.table_owner
  and col.table_name  = syn.table_name
  and col.column_name = 'ALLOW_LEAF_NODE_ONLY_FLAG';

Line: 33

      SELECT 'Y'
        FROM hz_class_categories
       WHERE class_category = l_cat;

Line: 76

             l_str :=' update HZ_CLASS_CATEGORIES  set '||
                     ' ALLOW_MULTI_ASSIGN_FLAG = '''||l_allow_maf||''', '||
                     ' ALLOW_MULTI_PARENT_FLAG = '''||l_allow_mpf||''', '||
                     ' ALLOW_LEAF_NODE_ONLY_FLAG = '''||l_allow_lnof||''', '||
                     ' LAST_UPDATED_BY = '''||TO_CHAR(p_user_id)||''', '||
                     ' LAST_UPDATE_DATE = '''|| TO_CHAR(SYSDATE)||''', '||
                     ' LAST_UPDATE_LOGIN = 0 '||
                     ' where  CLASS_CATEGORY = '''||l_class_cat||'''';

Line: 86

             l_str :=' insert into HZ_CLASS_CATEGORIES( '||
                     ' CLASS_CATEGORY,  '||
                     ' ALLOW_MULTI_ASSIGN_FLAG, '||
                     ' ALLOW_MULTI_PARENT_FLAG, '||
                     ' ALLOW_LEAF_NODE_ONLY_FLAG, '||
                     ' DELIMITER, ' ||
                     ' FROZEN_FLAG, ' ||
                     ' LAST_UPDATED_BY, '||
                     ' LAST_UPDATE_DATE, '||
                     ' CREATED_BY, '||
                     ' CREATION_DATE, '||
                     ' LAST_UPDATE_LOGIN)  values ( '||
                     ' '''||l_class_cat||''', '||
                     ' '''||l_allow_maf||''', '||
                     ' '''||l_allow_mpf||''', '||
                     ' '''||l_allow_lnof||''', '||
                     ' ''/'','||
                     ' ''N'','||
                     ' '''||TO_CHAR(p_user_id)||''', '||
                     ' '''||TO_CHAR(sysdate)||''', '||
                     ' '''||TO_CHAR(p_user_id)||''', '||
                     ' '''||TO_CHAR(sysdate)||''', '||
                     ' 0) ';

Line: 115

            l_str := ' update HZ_CLASS_CATEGORIES  set '||
                     ' ALLOW_MULTI_ASSIGN_FLAG = '''||l_allow_maf||''', '||
                     ' ALLOW_MULTI_PARENT_FLAG = '''||l_allow_mpf||''', '||
                     ' LAST_UPDATED_BY = '''||TO_CHAR(p_user_id)||''', '||
                     ' LAST_UPDATE_DATE = '''|| TO_CHAR(SYSDATE)||''', '||
                     ' LAST_UPDATE_LOGIN = 0 '||
                     ' where  CLASS_CATEGORY = '''||l_class_cat||'''';

Line: 124

             l_str :=' insert into HZ_CLASS_CATEGORIES( '||
                     ' CLASS_CATEGORY,  '||
                     ' ALLOW_MULTI_ASSIGN_FLAG, '||
                     ' ALLOW_MULTI_PARENT_FLAG, '||
                     ' DELIMITER, ' ||
                     ' FROZEN_FLAG, ' ||
                     ' LAST_UPDATED_BY, '||
                     ' LAST_UPDATE_DATE, '||
                     ' CREATED_BY, '||
                     ' CREATION_DATE, '||
                     ' LAST_UPDATE_LOGIN)  values ( '||
                     ' '''||l_class_cat||''', '||
                     ' '''||l_allow_maf||''', '||
                     ' '''||l_allow_mpf||''', '||
                     ' ''/'','||
                     ' ''N'','||
                     ' '''||TO_CHAR(p_user_id)||''', '||
                     ' '''||TO_CHAR(sysdate)||''', '||
                     ' '''||TO_CHAR(p_user_id)||''', '||
                     ' '''||TO_CHAR(sysdate)||''', '||
                     ' 0) ';

Line: 163

    SELECT 'Y'
      FROM sys.all_tab_columns
     WHERE table_name = 'HZ_CLASS_CATEGORY_USES'
       AND column_name = 'ADDITIONAL_WHERE_CLAUSE'
       AND owner = l_schema;

Line: 170

select 'Y'
from
    user_synonyms syn
  , dba_tab_columns col
where syn.synonym_name = 'HZ_CLASS_CATEGORY_USES'
  and col.owner      = syn.table_owner
  and col.table_name  = syn.table_name
  and col.column_name = 'ADDITIONAL_WHERE_CLAUSE';

Line: 213

       'SELECT ''Y''  FROM HZ_CLASS_CATEGORY_USES
       WHERE owner_table = '''||l_owner_tab||''' AND '||
         ' class_category = '''||l_class||'''';

Line: 223

        l_str := ' UPDATE HZ_CLASS_CATEGORY_USES  SET COLUMN_NAME  = '''|| l_col_name ||''', '||
                 ' ADDITIONAL_WHERE_CLAUSE = '''||l_awc||''', '||
                 ' LAST_UPDATED_BY   =  '''||to_char(p_user_id)||''', '||
                 ' LAST_UPDATE_DATE  =  '''||to_char(SYSDATE)||''', '||
                 ' LAST_UPDATE_LOGIN = 0 '||
                 ' WHERE CLASS_CATEGORY = '''||l_class||''''||
                 ' AND OWNER_TABLE    = '''||l_owner_tab||'''';

Line: 231

        l_str := ' insert into HZ_CLASS_CATEGORY_USES( CLASS_CATEGORY, OWNER_TABLE, COLUMN_NAME, '||
                 ' ADDITIONAL_WHERE_CLAUSE, LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, '||
                 ' CREATION_DATE, LAST_UPDATE_LOGIN ) values ( '||
                 ''''||l_class||''','''||l_owner_tab||''','''||l_col_name||''','''||l_awc||''','||
                 ''''||TO_CHAR(p_user_id)||''','''||TO_CHAR(sysdate)||''','''||TO_CHAR(p_user_id)||''','||
                 ''''||TO_CHAR(sysdate)||''', 0)';