APPS.HZ_LOCATION_SERVICES_PUB dependencies on HZ_LOCATION_PROFILE_PVT

Line 645: l_location_profile_rec hz_location_profile_pvt.location_profile_rec_type;

641: p_postal_code IN VARCHAR2,
642: p_validation_status_code IN VARCHAR2 )
643: IS
644: l_location_rec hz_location_v2pub.location_rec_type;
645: l_location_profile_rec hz_location_profile_pvt.location_profile_rec_type;
646: l_location_profile_id NUMBER;
647: l_state VARCHAR2(60);
648: l_province VARCHAR2(60);
649: l_country VARCHAR2(60);

Line 795: -- hz_location_profile_pvt

791: RETURN;
792: END IF;
793:
794: -- Fix bug 3395521, if returned value is NULL, then pass it as g_miss to
795: -- hz_location_profile_pvt
796: l_location_profile_rec.location_id := p_location_id;
797: l_location_profile_rec.address1 := nvl(p_address1,fnd_api.g_miss_char);
798: l_location_profile_rec.address2 := nvl(p_address2,fnd_api.g_miss_char);
799: l_location_profile_rec.address3 := nvl(p_address3,fnd_api.g_miss_char);

Line 847: hz_location_profile_pvt.create_location_profile (

843: l_location_profile_rec.effective_end_date := sysdate;
844:
845: -- as this location does not pass tax validation, we only need to create
846: -- an entry in location profiles. Therefore, call create_location_profile
847: hz_location_profile_pvt.create_location_profile (
848: p_location_profile_rec => l_location_profile_rec,
849: x_location_profile_id => l_location_profile_id,
850: x_return_status => l_return_status,
851: x_msg_count => l_msg_count,

Line 861: hz_location_profile_pvt.update_location_profile (

857: -- maintain history profile option and if adapter content source already exist
858:
859: l_location_profile_rec.validation_sst_flag := 'N';
860:
861: hz_location_profile_pvt.update_location_profile (
862: p_location_profile_rec => l_location_profile_rec,
863: x_return_status => l_return_status,
864: x_msg_count => l_msg_count,
865: x_msg_data => l_msg_data

Line 906: hz_location_profile_pvt.update_location_profile (

902: -- to determine the sst flag by checking profile option
903: -- HZ_UPDATE_STD_ADDRESS and existing actual_content_source
904: l_location_profile_rec.validation_sst_flag := l_validation_sst_flag;
905:
906: hz_location_profile_pvt.update_location_profile (
907: p_location_profile_rec => l_location_profile_rec,
908: x_return_status => l_return_status,
909: x_msg_count => l_msg_count,
910: x_msg_data => l_msg_data

Line 1111: hz_location_profile_pvt.update_location_profile (

1107: l_location_profile_rec.validation_sst_flag := 'N';
1108: --l_location_profile_rec.effective_start_date := sysdate;
1109: --l_location_profile_rec.effective_end_date := sysdate;
1110:
1111: hz_location_profile_pvt.update_location_profile (
1112: p_location_profile_rec => l_location_profile_rec,
1113: x_return_status => l_return_status,
1114: x_msg_count => l_msg_count,
1115: x_msg_data => l_msg_data