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

Line: 70

  update irc_rec_team_members
    set
     party_id                        = p_rec.party_id
    ,vacancy_id                      = p_rec.vacancy_id
    ,job_id                         = p_rec.job_id
    ,start_date                      = p_rec.start_date
    ,end_date                        = p_rec.end_date
    ,update_allowed                  = p_rec.update_allowed
    ,delete_allowed                  = p_rec.delete_allowed
    ,person_id                       = p_rec.person_id
    ,object_version_number           = p_rec.object_version_number
    ,interview_security               = p_rec.interview_security
    where rec_team_member_id = p_rec.rec_team_member_id;

Line: 107

End update_dml;

Line: 141

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

Line: 151

End pre_update;

Line: 185

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

Line: 195

    irc_rtm_rku.after_update
      (p_party_id
      => p_rec.party_id
      ,p_rec_team_member_id => p_rec.rec_team_member_id
      ,p_person_id => p_rec.person_id
      ,p_vacancy_id
      => p_rec.vacancy_id
      ,p_job_id
      => p_rec.job_id
      ,p_start_date
      => p_rec.start_date
      ,p_end_date
      => p_rec.end_date
      ,p_update_allowed
      => p_rec.update_allowed
      ,p_delete_allowed
      => p_rec.delete_allowed
      ,p_interview_security
      => p_rec.interview_security
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_job_id_o
      => irc_rtm_shd.g_old_rec.job_id
      ,p_start_date_o
      => irc_rtm_shd.g_old_rec.start_date
      ,p_end_date_o
      => irc_rtm_shd.g_old_rec.end_date
      ,p_update_allowed_o
      => irc_rtm_shd.g_old_rec.update_allowed
      ,p_delete_allowed_o
      => irc_rtm_shd.g_old_rec.delete_allowed
      ,p_object_version_number_o
      => irc_rtm_shd.g_old_rec.object_version_number
      ,p_interview_security_o
      => irc_rtm_shd.g_old_rec.interview_security
      ,p_person_id_o => irc_rtm_shd.g_old_rec.person_id
      ,p_party_id_o => irc_rtm_shd.g_old_rec.party_id
      );

Line: 245

End post_update;

Line: 313

  If (p_rec.update_allowed = hr_api.g_varchar2) then
    p_rec.update_allowed :=
    irc_rtm_shd.g_old_rec.update_allowed;

Line: 321

  If (p_rec.delete_allowed = hr_api.g_varchar2) then
    p_rec.delete_allowed :=
    irc_rtm_shd.g_old_rec.delete_allowed;

Line: 366

  irc_rtm_bus.update_validate
     (p_rec
     );

Line: 374

  irc_rtm_upd.pre_update(p_rec);

Line: 378

  irc_rtm_upd.update_dml(p_rec);

Line: 382

  irc_rtm_upd.post_update
     (p_rec
     );

Line: 399

  ,p_update_allowed               in     varchar2  default hr_api.g_varchar2
  ,p_delete_allowed               in     varchar2  default hr_api.g_varchar2
  ,p_start_date                   in     date      default hr_api.g_date
  ,p_end_date                     in     date      default hr_api.g_date
  ,p_interview_security            in     varchar2  default 'SELF'
  ) is
--
  l_rec   irc_rtm_shd.g_rec_type;

Line: 424

  ,p_update_allowed
  ,p_delete_allowed
  ,p_object_version_number
  ,p_interview_security
  );