APPS.IRC_IDT_UPD SQL Statements

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

Line: 54

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

Line: 68

  update irc_default_postings_tl
    set
     default_posting_id              = p_rec.default_posting_id
    ,language                        = p_rec.language
    ,source_language                 = p_rec.source_language
    ,org_name                        = p_rec.org_name
    ,org_description                 = empty_clob()
    ,job_title                       = p_rec.job_title
    ,brief_description               = empty_clob()
    ,detailed_description            = empty_clob()
    ,job_requirements                = empty_clob()
    ,additional_details              = empty_clob()
    ,how_to_apply                    = empty_clob()
    ,image_url                       = empty_clob()
    ,image_url_alt                   = empty_clob()
    where default_posting_id = p_rec.default_posting_id
    and language = p_rec.language;

Line: 111

End update_dml;

Line: 145

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

Line: 155

End pre_update;

Line: 189

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

Line: 199

    irc_idt_rku.after_update
      (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
      ,p_source_language_o
      => irc_idt_shd.g_old_rec.source_language
      ,p_org_name_o
      => irc_idt_shd.g_old_rec.org_name
      ,p_org_description_o
      => irc_idt_shd.g_old_rec.org_description
      ,p_job_title_o
      => irc_idt_shd.g_old_rec.job_title
      ,p_brief_description_o
      => irc_idt_shd.g_old_rec.brief_description
      ,p_detailed_description_o
      => irc_idt_shd.g_old_rec.detailed_description
      ,p_job_requirements_o
      => irc_idt_shd.g_old_rec.job_requirements
      ,p_additional_details_o
      => irc_idt_shd.g_old_rec.additional_details
      ,p_how_to_apply_o
      => irc_idt_shd.g_old_rec.how_to_apply
      ,p_image_url_o
      => irc_idt_shd.g_old_rec.image_url
      ,p_image_url_alt_o
      => irc_idt_shd.g_old_rec.image_url_alt
      );

Line: 261

End post_update;

Line: 406

  irc_idt_bus.update_validate
     (p_rec
     );

Line: 412

  irc_idt_upd.pre_update(p_rec);

Line: 416

  irc_idt_upd.update_dml(p_rec);

Line: 420

  irc_idt_upd.post_update
     (p_rec
     );

Line: 504

    select idt.language
      from irc_default_postings_tl idt
     where idt.default_posting_id = p_default_posting_id
       and p_language_code in (idt.language
                              ,idt.source_language);