APPS.PER_TASKFLOW_MIGRATION SQL Statements

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

Line: 21

   select language_code,
   nls_language
  from fnd_languages
  where installed_flag in ('I','B');

Line: 34

delete from HR_NAVIGATION_UNITS_TL T
where not exists
   (select NULL
    from HR_NAVIGATION_UNITS B
    where B.NAV_UNIT_ID = T.NAV_UNIT_ID
    );

Line: 42

** For each installed language insert a new record into the TL table for
** each record in the range provided that is present in the base table.
*/
for c_language in csr_installed_languages loop

/*
** Set language for iteration....
*/

hr_kflex_utility.set_session_nls_language(c_language.nls_language);

Line: 55

   ** insert the TL rows
   */

  insert into hr_navigation_units_tl (
    nav_unit_id
   ,language
   ,source_lang
   ,default_label
   ,created_by
   ,creation_date
   ,last_updated_by
   ,last_update_date
)
  select b.nav_unit_id
        ,l_current_language
        ,l_userenv_language_code
        ,b.default_label
        ,1
        ,sysdate
        ,1
        ,sysdate
  from hr_navigation_units b
  where not exists
    (select '1'
     from hr_navigation_units_tl t
     where t.nav_unit_id = b.nav_unit_id
       and t.language = l_current_language);

Line: 114

   select language_code,
   nls_language
  from fnd_languages
  where installed_flag in ('I','B');

Line: 127

delete from HR_NAVIGATION_PATHS_TL T
where not exists
   (select NULL
    from HR_NAVIGATION_PATHS B
    where B.NAV_PATH_ID = T.NAV_PATH_ID
    );

Line: 135

** For each installed language insert a new record into the TL table for
** each record in the range provided that is present in the base table.
*/
for c_language in csr_installed_languages loop

/*
** Set language for iteration....
*/

hr_kflex_utility.set_session_nls_language(c_language.nls_language);

Line: 148

   ** insert the TL rows
   */

  insert into hr_navigation_paths_tl (
    nav_path_id
   ,language
   ,source_lang
   ,override_label
   ,created_by
   ,creation_date
   ,last_updated_by
   ,last_update_date
)
  select b.nav_path_id
        ,l_current_language
        ,l_userenv_language_code
        ,b.override_label
        ,1
        ,sysdate
        ,1
        ,sysdate
  from hr_navigation_paths b
  where not exists
    (select '1'
     from hr_navigation_paths_tl t
     where t.nav_path_id = b.nav_path_id
       and t.language = l_current_language);