APPS.IRC_IPT_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_ipt_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 68

  update irc_posting_contents_tl
    set
     posting_content_id              = p_rec.posting_content_id
    ,language                        = p_rec.language
    ,source_language                 = p_rec.source_language
    ,name                            = p_rec.name
    ,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 posting_content_id = p_rec.posting_content_id
    and language = p_rec.language;

Line: 113

End update_dml;

Line: 147

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

Line: 157

End pre_update;

Line: 191

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

Line: 201

    irc_ipt_rku.after_update
      (p_posting_content_id
      => p_rec.posting_content_id
      ,p_language
      => p_rec.language
      ,p_source_language
      => p_rec.source_language
      ,p_name
      => p_rec.name
      ,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_benefit_info
      => p_rec.benefit_info
      ,p_image_url
      => p_rec.image_url
      ,p_image_url_alt
      => p_rec.image_url_alt
      ,p_source_language_o
      => irc_ipt_shd.g_old_rec.source_language
      ,p_name_o
      => irc_ipt_shd.g_old_rec.name
      ,p_org_name_o
      => irc_ipt_shd.g_old_rec.org_name
      ,p_org_description_o
      => irc_ipt_shd.g_old_rec.org_description
      ,p_job_title_o
      => irc_ipt_shd.g_old_rec.job_title
      ,p_brief_description_o
      => irc_ipt_shd.g_old_rec.brief_description
      ,p_detailed_description_o
      => irc_ipt_shd.g_old_rec.detailed_description
      ,p_job_requirements_o
      => irc_ipt_shd.g_old_rec.job_requirements
      ,p_additional_details_o
      => irc_ipt_shd.g_old_rec.additional_details
      ,p_how_to_apply_o
      => irc_ipt_shd.g_old_rec.how_to_apply
      ,p_benefit_info_o
      => irc_ipt_shd.g_old_rec.benefit_info
      ,p_image_url_o
      => irc_ipt_shd.g_old_rec.image_url
      ,p_image_url_alt_o
      => irc_ipt_shd.g_old_rec.image_url_alt
      );

Line: 271

End post_update;

Line: 426

  irc_ipt_bus.update_validate
     (p_rec
     );

Line: 433

  irc_ipt_upd.pre_update(p_rec);

Line: 437

  irc_ipt_upd.update_dml(p_rec);

Line: 441

  irc_ipt_upd.post_update
     (p_rec
     );

Line: 532

    select ipt.language
      from irc_posting_contents_tl ipt
     where ipt.posting_content_id = p_posting_content_id
       and p_language_code in (ipt.language
                              ,ipt.source_language);