DBA Data[Home] [Help]

APPS.PER_STT_INS SQL Statements

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

Line: 49

Procedure insert_dml(p_rec in out nocopy per_stt_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';
Line: 59

  insert into per_shared_types_tl
  (	shared_type_id,
	language,
	source_lang,
	shared_type_name
  )
  Values
  (	p_rec.shared_type_id,
	p_rec.language,
	p_rec.source_lang,
	p_rec.shared_type_name
  );
Line: 88

End insert_dml;
Line: 127

Procedure pre_insert(p_rec            in out nocopy per_stt_shd.g_rec_type,
                     p_shared_type_id in number ) is
--
  l_proc  varchar2(72) := g_package||'pre_insert';
Line: 138

End pre_insert;
Line: 172

Procedure post_insert(p_rec in per_stt_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_insert';
Line: 184

    per_stt_rki.after_insert
      (
  p_shared_type_id                =>p_rec.shared_type_id
 ,p_language                      =>p_rec.language
 ,p_source_lang                   =>p_rec.source_lang
 ,p_shared_type_name              =>p_rec.shared_type_name
      );
Line: 206

End post_insert;
Line: 224

  per_stt_bus.insert_validate(p_rec);
Line: 228

  pre_insert(p_rec            => p_rec,
             p_shared_type_id => p_shared_type_id );
Line: 233

  insert_dml(p_rec);
Line: 237

  post_insert(p_rec);
Line: 284

      select l.language_code
      from fnd_languages l
      where l.installed_flag in ('I','B')
      and not exists ( select null
                       from per_shared_types_tl stt
                       where stt.shared_type_id = p_shared_type_id
                       and stt.language         = l.language_code );