1538: WHERE std_rate_tmpl_id = p_srtb_rec.std_rate_tmpl_id;
1539: l_api_version CONSTANT NUMBER := 1;
1540: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1541: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1542: l_object_version_number okl_fe_resi_cat_all_b.object_version_number%TYPE;
1543: lc_object_version_number okl_fe_resi_cat_all_b.object_version_number%TYPE;
1544: l_row_notfound BOOLEAN := false;
1545: lc_row_notfound BOOLEAN := false;
1546:
1539: l_api_version CONSTANT NUMBER := 1;
1540: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1541: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1542: l_object_version_number okl_fe_resi_cat_all_b.object_version_number%TYPE;
1543: lc_object_version_number okl_fe_resi_cat_all_b.object_version_number%TYPE;
1544: l_row_notfound BOOLEAN := false;
1545: lc_row_notfound BOOLEAN := false;
1546:
1547: BEGIN