APPS.PQP_ADDRESS_SYNCHRONIZATION SQL Statements

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

Line: 13

    SELECT pei.pei_information5
      FROM per_people_extra_info  pei
     WHERE pei.information_type         = 'PQP_OSS_PERSON_DETAILS'
       AND pei.pei_information_category = 'PQP_OSS_PERSON_DETAILS'
       AND pei.person_id                = c_person_id;

Line: 21

    SELECT ppf.party_id,pbg.legislation_code
      FROM per_all_people_f ppf
          ,per_business_groups_perf pbg
     WHERE ppf.person_id = c_person_id
       AND pbg.business_group_id = ppf.business_group_id;

Line: 29

    'SELECT hps.party_site_id ' ||
    '      ,hzl.location_id   ' ||
    '      ,hzl.object_version_number ' ||
    '      ,hps.object_version_number ' ||
    '      ,hzl.Rowid ' ||
    '      ,hzl.last_update_date    ' ||
    '  FROM hz_party_sites      hps ' ||
    '      ,hz_locations        hzl ' ||
    ' WHERE hps.party_id        = :c_party_id     ' ||
    '   AND hzl.location_id(+)  = hps.location_id ' ||
    '   AND hps.status          = '||'''A'''||
    '   AND hps.identifying_address_flag(+) = '||'''Y''';

Line: 44

   SELECT pbg.legislation_code
     FROM per_business_groups pbg
    WHERE pbg.business_group_id = c_bg_grp_id;

Line: 95

  l_last_update_date    Date;

Line: 106

  l_update_oss_addr     Boolean;

Line: 142

    l_update_oss_addr := TRUE;

Line: 187

     ,p_action                 => 'INSERT'
     ,p_status                 => 'A'
      -- In Out Variables
     ,p_location_id            => l_location_id
     ,p_party_site_id          => l_party_site_id
     ,p_last_update_date       => l_last_update_date
     ,p_party_site_ovn         => l_party_site_ovn
     ,p_location_ovn           => l_location_ovn
     ,p_rowid                  => l_rowid
      -- Out Variables
     ,p_return_status          => l_return_status
     ,p_msg_data               => l_msg_data
     );

Line: 202

  IF l_update_oss_addr THEN
     l_addr_rec_new := l_addr_rec;

Line: 205

     PQP_HRTCA_Integration.Update_Address_HR_To_TCA
     (p_business_group_id      => p_business_group_id
     ,p_person_id              => p_person_id
     ,p_party_id               => p_party_id
     ,p_address_id             => p_address_id
     ,p_effective_date         => p_effective_date
     ,p_per_addr_rec_new       => l_addr_rec_new
     ,p_per_addr_rec_old       => l_addr_rec_old
      -- TCA
     ,p_party_type             => 'PERSON'
     ,p_action                 => 'UPDATE'
     ,p_status                 => 'A'
      -- In Out Variables
     ,p_location_id            => l_location_id
     ,p_party_site_id          => l_party_site_id
     ,p_last_update_date       => l_hz_loc_upd_dt
     ,p_party_site_ovn         => l_party_site_ovn
     ,p_location_ovn           => l_location_ovn
     ,p_rowid                  => l_hz_loc_rowid
      -- Out Variables
     ,p_return_status          => l_return_status
     ,p_msg_data               => l_msg_data
     );

Line: 325

  l_update_oss_addr     Boolean;

Line: 356

    l_update_oss_addr := TRUE;

Line: 433

     ,p_action                 => 'INSERT'
     ,p_status                 => 'A'
      -- In Out Variables
     ,p_location_id            => l_location_id
     ,p_party_site_id          => l_party_site_id
     ,p_last_update_date       => l_hz_loc_upd_dt
     ,p_party_site_ovn         => l_party_site_ovn
     ,p_location_ovn           => l_location_ovn
     ,p_rowid                  => l_hz_loc_rowid
      -- Out Variables
     ,p_return_status          => l_return_status
     ,p_msg_data               => l_msg_data
     );

Line: 448

  IF l_update_oss_addr THEN
     Pqp_Hrtca_Integration.Update_Address_HR_To_TCA
     (p_business_group_id      => p_business_group_id
     ,p_person_id              => p_person_id
     ,p_party_id               => p_party_id_o
     ,p_address_id             => p_address_id
     ,p_effective_date         => p_effective_date
     ,p_per_addr_rec_new       => l_addr_rec_new
     ,p_per_addr_rec_old       => l_addr_rec_old
      -- TCA
     ,p_party_type             => 'PERSON'
     ,p_action                 => 'UPDATE'
     ,p_status                 => 'A'
      -- In Out Variables
     ,p_location_id            => l_location_id
     ,p_party_site_id          => l_party_site_id
     ,p_last_update_date       => l_hz_loc_upd_dt
     ,p_party_site_ovn         => l_party_site_ovn
     ,p_location_ovn           => l_location_ovn
     ,p_rowid                  => l_hz_loc_rowid
      -- Out Variables
     ,p_return_status          => l_return_status
     ,p_msg_data               => l_msg_data
     );