APPS.QA_RESULTS_PUB SQL Statements

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

Line: 114

PROCEDURE insert_row (
    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,
    p_plan_id               	IN  	NUMBER,
    p_spec_id               	IN  	NUMBER DEFAULT NULL,
    p_org_id                	IN  	NUMBER,
    p_transaction_number    	IN  	NUMBER DEFAULT NULL,
    p_transaction_id        	IN  	NUMBER DEFAULT NULL,
    p_who_last_updated_by   	IN  	NUMBER := fnd_global.user_id,
    p_who_created_by        	IN  	NUMBER := fnd_global.user_id,
    p_who_last_update_login 	IN  	NUMBER := fnd_global.user_id,
    p_enabled_flag	      	IN  	NUMBER,
    x_collection_id         	IN OUT  NOCOPY NUMBER,
    x_row_elements          	IN OUT 	NOCOPY qa_validation_api.ElementsArray,
    x_return_status		OUT	NOCOPY VARCHAR2,
    x_msg_count			OUT	NOCOPY NUMBER,
    x_msg_data			OUT	NOCOPY VARCHAR2,
    x_occurrence            	IN OUT 	NOCOPY NUMBER,
    x_action_result		OUT 	NOCOPY VARCHAR2,
    x_message_array 		OUT 	NOCOPY qa_validation_api.MessageArray,
    x_error_array 		OUT 	NOCOPY qa_validation_api.ErrorArray,
    p_txn_header_id             IN      NUMBER DEFAULT NULL,
    p_ssqr_operation            IN      NUMBER DEFAULT NULL,
    p_last_update_date          IN      DATE   DEFAULT SYSDATE) IS

    l_api_name			CONSTANT VARCHAR2(30)	:= 'insert_row';

Line: 150

    SAVEPOINT	insert_row_pub;

Line: 177

    x_error_array := qa_results_api.insert_row(p_plan_id,
                                               p_spec_id,
                                               p_org_id,
                                               p_transaction_number,
                                               p_transaction_id,
                                               x_collection_id,
                                               p_who_last_updated_by,
                                               p_who_created_by,
                                               p_who_last_update_login,
                                               p_enabled_flag,
                                               FND_API.To_Boolean(p_commit),
                                               l_error_found,
                                               x_occurrence,
                                               l_action_return,
                                               x_message_array,
                                               x_row_elements,
                                               p_txn_header_id,
                                               p_ssqr_operation,
                                               p_last_update_date
                                              );

Line: 227

	ROLLBACK TO insert_row_pub;

Line: 235

	ROLLBACK TO insert_row_pub;

Line: 243

	ROLLBACK TO insert_row_pub;

Line: 256

END insert_row;

Line: 268

PROCEDURE update_row (
    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,
    p_plan_id               	IN  	NUMBER,
    p_spec_id               	IN  	NUMBER DEFAULT NULL,
    p_org_id                	IN  	NUMBER,
    p_transaction_number    	IN  	NUMBER DEFAULT NULL,
    p_transaction_id        	IN  	NUMBER DEFAULT NULL,
    p_who_last_updated_by   	IN  	NUMBER := fnd_global.user_id,
    p_who_created_by        	IN  	NUMBER := fnd_global.user_id,
    p_who_last_update_login 	IN  	NUMBER := fnd_global.user_id,
    p_enabled_flag	      	IN  	NUMBER,
    p_collection_id         	IN      NUMBER,
    p_occurrence            	IN 	NUMBER,
    x_row_elements          	IN OUT 	NOCOPY qa_validation_api.ElementsArray,
    x_return_status		OUT	NOCOPY VARCHAR2,
    x_msg_count			OUT	NOCOPY NUMBER,
    x_msg_data			OUT	NOCOPY VARCHAR2,
    x_action_result		OUT 	NOCOPY VARCHAR2,
    x_message_array 		OUT 	NOCOPY qa_validation_api.MessageArray,
    x_error_array 		OUT 	NOCOPY qa_validation_api.ErrorArray,
    p_txn_header_id             IN      NUMBER DEFAULT NULL,
    p_ssqr_operation            IN      NUMBER DEFAULT NULL,
    p_last_update_date          IN      DATE   DEFAULT SYSDATE) IS

    l_api_name			CONSTANT VARCHAR2(30)	:= 'update_row';

Line: 305

    SAVEPOINT	update_row_pub;

Line: 330

    x_error_array := qa_results_api.update_row(p_plan_id,
                                               p_spec_id,
                                               p_org_id,
                                               p_transaction_number,
                                               p_transaction_id,
                                               p_collection_id,
                                               p_who_last_updated_by,
                                               p_who_created_by,
                                               p_who_last_update_login,
                                               p_enabled_flag,
                                               FND_API.To_Boolean(p_commit),
                                               l_error_found,
                                               p_occurrence,
                                               l_action_return,
                                               x_message_array,
                                               x_row_elements,
                                               p_txn_header_id,
                                               p_ssqr_operation,
                                               p_last_update_date
                                              );

Line: 365

	ROLLBACK TO update_row_pub;

Line: 373

	ROLLBACK TO update_row_pub;

Line: 381

	ROLLBACK TO update_row_pub;

Line: 394

END update_row;