APPS.AST_PHONE_ASSIST_VUHK SQL Statements

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

Line: 4

PROCEDURE Insert_Phone_Assist_PRE(
	p_api_version			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 VARCHAR2,
	x_msg_count				OUT NUMBER,
	x_msg_data				OUT VARCHAR2,
	p_name					IN  VARCHAR2,
	p_description			IN  VARCHAR2,
	p_enabled_flag			IN  VARCHAR2,
	p_phone_country_code    IN  VARCHAR2,
	p_phone_area_code       IN  VARCHAR2,
	p_phone_number          IN  VARCHAR2,
	p_phone_extension       IN  VARCHAR2)
AS

BEGIN
	/* Vertical to add the customization procedures here - for pre processing */
	null;

Line: 26

PROCEDURE Insert_Phone_Assist_POST(
	p_api_version			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 VARCHAR2,
	x_msg_count				OUT NUMBER,
	x_msg_data				OUT VARCHAR2,
	p_name					IN  VARCHAR2,
	p_description			IN  VARCHAR2,
	p_enabled_flag			IN  VARCHAR2,
	p_phone_country_code    IN  VARCHAR2,
	p_phone_area_code       IN  VARCHAR2,
	p_phone_number          IN  VARCHAR2,
	p_phone_extension       IN  VARCHAR2)
AS

BEGIN
	/* Vertical to add the customization procedures here - for post processing */
	null;

Line: 48

PROCEDURE Update_Phone_Assist_PRE(
	p_api_version			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 VARCHAR2,
	x_msg_count				OUT NUMBER,
	x_msg_data				OUT VARCHAR2,
	p_phone_assist_id		IN  NUMBER,
	p_contact_point_id		IN  NUMBER,
	p_name					IN  VARCHAR2,
	p_description			IN  VARCHAR2,
	p_enabled_flag			IN  VARCHAR2,
	p_phone_country_code    IN  VARCHAR2,
	p_phone_area_code       IN  VARCHAR2,
	p_phone_number          IN  VARCHAR2,
	p_phone_extension       IN  VARCHAR2)
AS

BEGIN
	/* Vertical to add the customization procedures here - for pre processing */
	null;

Line: 72

PROCEDURE Update_Phone_Assist_POST(
	p_api_version			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 VARCHAR2,
	x_msg_count				OUT NUMBER,
	x_msg_data				OUT VARCHAR2,
	p_phone_assist_id		IN  NUMBER,
	p_contact_point_id		IN  NUMBER,
	p_name					IN  VARCHAR2,
	p_description			IN  VARCHAR2,
	p_enabled_flag			IN  VARCHAR2,
	p_phone_country_code    IN  VARCHAR2,
	p_phone_area_code       IN  VARCHAR2,
	p_phone_number          IN  VARCHAR2,
	p_phone_extension       IN  VARCHAR2)
AS

BEGIN
	/* Vertical to add the customization procedures here - for post processing */
	null;

Line: 96

PROCEDURE Delete_Phone_Assist_PRE(
	p_api_version			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 VARCHAR2,
	x_msg_count				OUT NUMBER,
	x_msg_data				OUT VARCHAR2,
	p_phone_assist_id		IN  NUMBER,
	p_contact_point_id		IN  NUMBER,
	p_party_id				IN  NUMBER,
	p_assist_id				IN  NUMBER)
AS

BEGIN
	/* Vertical to add the customization procedures here - for pre processing */
	null;

Line: 115

PROCEDURE Delete_Phone_Assist_POST(
	p_api_version			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 VARCHAR2,
	x_msg_count				OUT NUMBER,
	x_msg_data				OUT VARCHAR2,
	p_phone_assist_id		IN  NUMBER,
	p_contact_point_id		IN  NUMBER,
	p_party_id				IN  NUMBER,
	p_assist_id				IN  NUMBER)
AS

BEGIN
	/* Vertical to add the customization procedures here - for post processing */
	null;