APPS.CSD_PARTIES_UTIL SQL Statements

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

Line: 21

/*                 the email contact point id and last updated    */
/*                 date for that party.                           */
/*                                                                */
/* p_api_version                Standard IN param                 */
/* p_commit                     Standard IN param                 */
/* p_init_msg_list              Standard IN param                 */
/* p_validation_level           Standard IN param                 */
/* p_party_id                   Party ID to get email details for */
/* x_email_cnt_point_id         Email Contact Point ID            */
/* x_email_last_update_date     Last Updated Date for Contact Pt  */
/* x_return_status              Standard OUT param                */
/* x_msg_count                  Standard OUT param                */
/* x_msg_data                   Standard OUT param                */
/*                                                                */
/*----------------------------------------------------------------*/
PROCEDURE Get_EmailDetails
(
   p_api_version            IN  NUMBER,
   p_commit                 IN  VARCHAR2 := fnd_api.g_false,
   p_init_msg_list          IN  VARCHAR2 := fnd_api.g_false,
   p_validation_level       IN  NUMBER   := fnd_api.g_valid_level_full,
   p_party_id               IN  NUMBER,
   x_email_cnt_point_id     OUT NOCOPY NUMBER,
   x_email_last_update_date OUT NOCOPY DATE,
   x_return_status          OUT NOCOPY VARCHAR2,
   x_msg_count              OUT NOCOPY NUMBER,
   x_msg_data               OUT NOCOPY VARCHAR2 )
IS
   l_api_name               CONSTANT VARCHAR2(30) := 'Get_EmailDetails';

Line: 54

       SELECT contact_point_id,
              last_update_date
       FROM   hz_contact_points
       WHERE  owner_table_id = l_party_id
       AND    owner_table_name = 'HZ_PARTIES'
       AND    contact_point_type='EMAIL'
       AND    primary_flag='Y' ;

Line: 87

          x_email_last_update_date:=get_email_details_rec.last_update_date;

Line: 132

/*                 updated date of both items for that party.     */
/*                                                                */
/* p_api_version                 Standard IN param                */
/* p_commit                      Standard IN param                */
/* p_init_msg_list               Standard IN param                */
/* p_validation_level            Standard IN param                */
/* p_party_id                    Party ID to get addr details for */
/* x_addr_location_id            Location ID for party            */
/* x_party_site_id               Site ID for location             */
/* x_addr_last_update_date       Last updated date for location   */
/* x_party_site_last_update_date Last updated date for site       */
/* x_return_status               Standard OUT param               */
/* x_msg_count                   Standard OUT param               */
/* x_msg_data                    Standard OUT param               */
/*                                                                */
/*----------------------------------------------------------------*/
PROCEDURE Get_AddrDetails
(
   p_api_version                 IN  NUMBER,
   p_commit                      IN  VARCHAR2 := fnd_api.g_false,
   p_init_msg_list               IN  VARCHAR2 := fnd_api.g_false,
   p_validation_level            IN  NUMBER   := fnd_api.g_valid_level_full,
   p_party_id                    IN  NUMBER,
   x_addr_location_id            OUT NOCOPY NUMBER,
   x_party_site_id               OUT NOCOPY NUMBER,
   x_addr_last_update_date       OUT NOCOPY DATE,
   x_party_site_last_update_date OUT NOCOPY DATE,
   x_return_status               OUT NOCOPY VARCHAR2,
   x_msg_count                   OUT NOCOPY NUMBER,
   x_msg_data                    OUT NOCOPY VARCHAR2 )
IS
   l_api_name          CONSTANT VARCHAR2(30) := 'Get_AddrDetails';

Line: 168

       SELECT loc.location_id,
              loc.last_update_date,
              sites.party_site_id,
              sites.last_update_date sites_last_update_date
       FROM   hz_party_sites sites, hz_locations loc
       WHERE  sites.party_id  = l_party_id
       AND    loc.location_id = sites.location_id
       AND    sites.identifying_address_flag='Y' ;

Line: 204

       x_party_site_last_update_date:=get_address_details_rec.sites_last_update_date;

Line: 205

       x_addr_last_update_date:=get_address_details_rec.last_update_date;

Line: 248

/*                 and returns the last updated for that contact  */
/*                 point.                                         */
/*                                                                */
/* p_api_version                Standard IN param                 */
/* p_commit                     Standard IN param                 */
/* p_init_msg_list              Standard IN param                 */
/* p_validation_level           Standard IN param                 */
/* p_phone_cnt_point_id         Phone Contact Point ID            */
/* x_phone_last_update_date     Last Updated Date for Contact Pt  */
/* x_return_status              Standard OUT param                */
/* x_msg_count                  Standard OUT param                */
/* x_msg_data                   Standard OUT param                */
/*                                                                */
/*----------------------------------------------------------------*/
PROCEDURE Get_PhoneDetails
(
   p_api_version            IN  NUMBER,
   p_commit                 IN  VARCHAR2 := fnd_api.g_false,
   p_init_msg_list          IN  VARCHAR2 := fnd_api.g_false,
   p_validation_level       IN  NUMBER   := fnd_api.g_valid_level_full,
   p_phone_cnt_point_id     IN  NUMBER,
   x_phone_last_update_date OUT NOCOPY DATE,
   x_return_status          OUT NOCOPY VARCHAR2,
   x_msg_count              OUT NOCOPY NUMBER,
   x_msg_data               OUT NOCOPY VARCHAR2 )
IS
   l_api_name               CONSTANT VARCHAR2(30) := 'Get_PhoneDetails';

Line: 279

      SELECT LAST_UPDATE_DATE
      FROM   HZ_CONTACT_POINTS
      WHERE  CONTACT_POINT_ID = l_phone_cnt_point_id;

Line: 308

        x_phone_last_update_date:=get_phone_details_rec.last_update_date;

Line: 351

/*                 returns the last updated for that party.       */
/*                                                                */
/* p_api_version                Standard IN param                 */
/* p_commit                     Standard IN param                 */
/* p_init_msg_list              Standard IN param                 */
/* p_validation_level           Standard IN param                 */
/* p_party_id                   Party ID to get details for       */
/* x_last_update_date           Last Updated Date for Party       */
/* x_return_status              Standard OUT param                */
/* x_msg_count                  Standard OUT param                */
/* x_msg_data                   Standard OUT param                */
/*                                                                */
/*----------------------------------------------------------------*/
PROCEDURE Get_PartyDetails
(
   p_api_version            IN  NUMBER,
   p_commit                 IN  VARCHAR2 := fnd_api.g_false,
   p_init_msg_list          IN  VARCHAR2 := fnd_api.g_false,
   p_validation_level       IN  NUMBER   := fnd_api.g_valid_level_full,
   p_party_id               IN  NUMBER,
   x_last_update_date       OUT NOCOPY DATE,
   x_return_status          OUT NOCOPY VARCHAR2,
   x_msg_count              OUT NOCOPY NUMBER,
   x_msg_data               OUT NOCOPY VARCHAR2 )
IS
   l_api_name               CONSTANT VARCHAR2(30) := 'Get_PartyDetails';

Line: 380

      SELECT LAST_UPDATE_DATE
      FROM   HZ_PARTIES
      WHERE  PARTY_ID=l_curr_party_id;

Line: 409

           x_last_update_date:=get_party_details_rec.last_update_date;