insert_new_COA_gncoa

Parameters

Name	Type
table_name	VARCHAR(50)
ind	INT
supaccount	VARCHAR(50)
level	INT
code_of_account	VARCHAR(50)
account_description	VARCHAR(50)
total_cost	INT
review_status	VARCHAR(50)
prn	VARCHAR(50)
gncoa	VARCHAR(50)
gn_level	INT
gn_supaccount	VARCHAR(50)
gn_ind	INT

SQL Definition

CREATE PROCEDURE `insert_new_COA_gncoa`(IN table_name VARCHAR(50), IN ind INT, IN supaccount VARCHAR(50), IN level INT, IN code_of_account VARCHAR(50), IN account_description VARCHAR(50), IN total_cost INT, IN review_status VARCHAR(50), IN prn VARCHAR(50), IN gncoa VARCHAR(50), IN gn_level INT, IN gn_supaccount VARCHAR(50), IN gn_ind INT)
BEGIN
    SET @stmt = CONCAT('INSERT INTO ', table_name,
    						' (ind, supaccount, level, code_of_account, account_description, 
    							total_cost, review_status, prn, 
                                gncoa, gn_level, gn_supaccount, gn_ind) 
    							VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)');
    PREPARE stmt FROM @stmt;
    SET @ind = ind;
    SET @supaccount = supaccount;
    SET @level = level;
    SET @code_of_account = code_of_account;
    SET @account_description = account_description;
    SET @total_cost = total_cost;
    SET @review_status = review_status;
    SET @prn = prn;
    SET @gncoa = gncoa; 
    SET @gn_level = gn_level; 
    SET @gn_supaccount = gn_supaccount;
    SET @gn_ind = gn_ind;

    EXECUTE stmt USING @ind, @supaccount, @level, @code_of_account, @account_description,
    @total_cost, @review_status, @prn, @gncoa, @gn_level, @gn_supaccount, @gn_ind;
    DEALLOCATE PREPARE stmt;
END;;