APPS.AMS_SCRIPTING_PUB SQL Statements

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

Line: 238

PROCEDURE Update_Person_Profile(
	p_api_version_number		IN  NUMBER,
	p_init_msg_list                 IN  VARCHAR2	 := FND_API.G_FALSE,
	p_commit			IN  VARCHAR2     := FND_API.G_FALSE,
	p_validation_level		IN  NUMBER       := FND_API.g_valid_level_full,
	x_return_status                 OUT NOCOPY VARCHAR2,
	x_msg_count                     OUT NOCOPY NUMBER,
	x_msg_data                      OUT NOCOPY VARCHAR2,

	p_party_id			IN      NUMBER,
	p_profile_id                    IN  OUT NOCOPY NUMBER,
	p_person_profile_rec            IN      ams_person_profile_rec_type := g_miss_ams_person_profile_rec,
	p_party_object_version_number   IN  OUT NOCOPY  NUMBER
)
IS

	L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Person_Profile';

Line: 321

	AMS_UTILITY_PVT.debug_message( 'Public API: Calling HZ_PARTY_V2PUB.UPDATE_PERSON');

Line: 324

	hz_party_v2pub.update_person (
	    p_init_msg_list => p_init_msg_list,
	    p_person_rec => l_personRec,
	    p_party_object_version_number  => p_party_object_version_number,
	    x_profile_id => p_profile_id,
	    x_return_status => x_return_status,
	    x_msg_count => x_msg_count,
	    x_msg_data => x_msg_data
	);

Line: 408

END Update_Person_Profile;