The following lines contain the word 'select', 'insert', 'update' or 'delete':
g_list_header_deleted BOOLEAN := false;
IF (l_action = 'DELETE') THEN
FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,
p_name => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).name,
p_action => l_action,
p_line_number => p_line_number+i+1,
x_error_msg => x_error_msg,
x_status => x_status );
g_list_header_deleted := true;
ELSIF (l_action = 'UPDATE') THEN
FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,
p_name => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).name,
p_action => l_action,
p_line_number => p_line_number+i+1,
x_error_msg => x_error_msg,
x_status => x_status );
FTE_LANE_PKG.UPDATE_LANE_RATE_CHART(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,
p_start_date => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).start_date_active,
p_end_date => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).end_date_active,
x_status => x_status,
x_error_msg => x_error_msg);
IF (g_list_header_deleted) THEN
FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
IF (g_list_header_deleted) THEN
FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
IF (g_list_header_deleted) THEN
FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
IF (l_action = 'DELETE') THEN
FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,
p_name => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).name,
p_action => l_action,
p_line_number => p_line_number+i+1,
x_error_msg => x_error_msg,
x_status => x_status );
g_list_header_deleted := true;
ELSIF (l_action = 'UPDATE') THEN
FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,
p_name => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).name,
p_action => l_action,
p_line_number => p_line_number+i+1,
x_error_msg => x_error_msg,
x_status => x_status );
IF (g_list_header_deleted) THEN
FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
IF (g_list_header_deleted) THEN
FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
IF (g_list_header_deleted) THEN
FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
FTE_RATE_CHART_PKG.INSERT_QP_INTERFACE_TABLES(p_qp_list_header_tbl => g_qp_list_header_tbl,
p_qp_list_line_tbl => g_qp_list_line_tbl,
p_qp_qualifier_tbl => g_qp_qualifier_tbl,
p_qp_pricing_attrib_tbl => g_qp_pricing_attrib_tbl,
p_qp_call => p_qp_call,
x_status => x_status,
x_error_msg => x_error_msg);
g_qp_list_header_tbl.DELETE;
g_qp_list_line_tbl.DELETE;
g_qp_qualifier_tbl.DELETE;
g_qp_pricing_attrib_tbl.DELETE;