APPS.IRC_IDT_INS SQL Statements

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

Line: 53

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

Line: 67

  insert into irc_default_postings_tl
      (default_posting_id
      ,language
      ,source_language
      ,org_name
      ,org_description
      ,job_title
      ,brief_description
      ,detailed_description
      ,job_requirements
      ,additional_details
      ,how_to_apply
      ,image_url
      ,image_url_alt
      )
  Values
    (p_rec.default_posting_id
    ,p_rec.language
    ,p_rec.source_language
    ,p_rec.org_name
    ,empty_clob()
    ,p_rec.job_title
    ,empty_clob()
    ,empty_clob()
    ,empty_clob()
    ,empty_clob()
    ,empty_clob()
    ,empty_clob()
    ,empty_clob()
    );

Line: 121

End insert_dml;

Line: 160

Procedure pre_insert
  (p_rec                          in out nocopy irc_idt_shd.g_rec_type
  ,p_default_posting_id           in number
  ) is
--
  l_proc  varchar2(72) := g_package||'pre_insert';

Line: 173

End pre_insert;

Line: 207

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

Line: 217

    irc_idt_rki.after_insert
      (p_default_posting_id
      => p_rec.default_posting_id
      ,p_language
      => p_rec.language
      ,p_source_language
      => p_rec.source_language
      ,p_org_name
      => p_rec.org_name
      ,p_org_description
      => p_rec.org_description
      ,p_job_title
      => p_rec.job_title
      ,p_brief_description
      => p_rec.brief_description
      ,p_detailed_description
      => p_rec.detailed_description
      ,p_job_requirements
      => p_rec.job_requirements
      ,p_additional_details
      => p_rec.additional_details
      ,p_how_to_apply
      => p_rec.how_to_apply
      ,p_image_url
      => p_rec.image_url
      ,p_image_url_alt
      => p_rec.image_url_alt
      );

Line: 257

End post_insert;

Line: 274

  irc_idt_bus.insert_validate
     (p_rec
     );

Line: 280

  irc_idt_ins.pre_insert
    (p_rec                         => p_rec
    ,p_default_posting_id          => p_default_posting_id
    );

Line: 287

  irc_idt_ins.insert_dml(p_rec);

Line: 291

  irc_idt_ins.post_insert
     (p_rec
     );

Line: 380

    select l.language_code
      from fnd_languages l
     where l.installed_flag in ('I','B')
       and not exists (select null
                         from irc_default_postings_tl idt
                        where idt.default_posting_id = p_default_posting_id
                          and idt.language = l.language_code);