The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_WebAssist_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_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
)
AS
BEGIN
/* Vertical to add the customization procedures here - for post processing */
null;
PROCEDURE Update_WebAssist_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_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
)
AS
BEGIN
/* Vertical to add the customization procedures here - for post processing */
null;
PROCEDURE Delete_WebAssist_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_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
)
AS
BEGIN
/* Vertical to add the customization procedures here - for post processing */
null;
PROCEDURE Delete_WebAssist_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_assist_rec IN ast_WebAssist_PVT.assist_rec_type,
p_web_assist_rec IN ast_WebAssist_PVT.web_assist_rec_type,
p_web_search_rec IN ast_WebAssist_PVT.web_search_rec_type,
p_query_string_rec IN ast_WebAssist_PVT.query_string_rec_type
)
AS
BEGIN
/* Vertical to add the customization procedures here - for post processing */
null;