The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* 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';
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' ;
x_email_last_update_date:=get_email_details_rec.last_update_date;
/* 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';
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' ;
x_party_site_last_update_date:=get_address_details_rec.sites_last_update_date;
x_addr_last_update_date:=get_address_details_rec.last_update_date;
/* 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';
SELECT LAST_UPDATE_DATE
FROM HZ_CONTACT_POINTS
WHERE CONTACT_POINT_ID = l_phone_cnt_point_id;
x_phone_last_update_date:=get_phone_details_rec.last_update_date;
/* 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';
SELECT LAST_UPDATE_DATE
FROM HZ_PARTIES
WHERE PARTY_ID=l_curr_party_id;
x_last_update_date:=get_party_details_rec.last_update_date;